Three sons of Sayyiduna Sa'd (may Allah be pleased with him), all of them, narrate from their father that the Prophet (peace and blessings be upon him) came to him in Makkah to visit him, and he began to weep. He (peace and blessings be upon him) said: "What makes you weep?" He said: I fear that my death will occur in the land from which I emigrated, just as Sa'd bin Khawlah (may Allah be pleased with him) died in this same city. So he (peace and blessings be upon him) said: 'Allahumma ishfi Sa'dan, Allahumma ishfi Sa'dan' (O Allah, cure Sa'd; O Allah, cure Sa'd). He (peace and blessings be upon him) supplicated three times.
Hadith Referenceالسنن الكبرى للبيهقي / كتاب السير / 17784