It is narrated from an orphan female Companion (may Allah be pleased with her) of Thaqif, who used to live with the Messenger of Allah (peace and blessings be upon him), that she told Safiyyah bint Abi Ubayd (may Allah have mercy on her) that the Messenger of Allah (peace and blessings be upon him) said: "Whoever among you is able to die in Madinah, let him die there, for whoever dies there, I will be a witness or an intercessor for him on the Day of Resurrection."
Hadith Referenceالمعجم الكبير للطبراني / مسند النساء / 21920