It is narrated from Sayyiduna Abdullah bin Abbas (may Allah be pleased with them both) that when the Messenger of Allah (peace and blessings be upon him) returned from the Battle of Tabuk and performed Umrah, and descended from the pass (thaniyyah) of Usfan, he ordered his Companions to stay by al-Aqabah "until I return to you." So he (peace and blessings be upon him) went and stopped at the grave of his mother and spoke privately with his Lord for a long time. Then he (peace and blessings be upon him) wept, and his weeping became intense, and these people also wept because of his (peace and blessings be upon him) weeping, and said: The Messenger of Allah (peace and blessings be upon him) would not weep in this place unless something had happened in his (peace and blessings be upon him) Ummah that they cannot bear. When these people wept, he (peace and blessings be upon him) stood up, came back to them and said: "What makes you weep?" They said: O Prophet of Allah! We wept because of your weeping; we thought that perhaps something had happened in your Ummah that they cannot bear. He (peace and blessings be upon him) said: "No, though some of it has happened. But I stopped at my mother's grave and asked Allah to permit me to intercede for her on the Day of Resurrection, and Allah refused to permit me. So I felt pity for her, as she is my mother, and I wept. Then Jibril (peace be upon him) came to me and said: 'And Ibrahim's asking forgiveness for his father was only because of a promise he had made to him; but when it became clear to him that he was an enemy of Allah, he dissociated himself from him' [Surah al-Tawbah: 114]. So dissociate yourself from your mother just as Ibrahim (peace be upon him) dissociated himself from his father. So I felt pity for her, as she is my mother. And I asked my Lord to lift four things from my Ummah; He lifted two of them and refused to lift two. I asked my Lord to lift from them stoning from the sky and drowning from the earth, and that He not divide them into sects, and that He not make some of them taste the violence of others. So Allah lifted from them stoning from the sky and drowning from the earth, but Allah refused to lift two things: killing, and turmoil (harj)." He (peace and blessings be upon him) turned aside to his mother's grave only because she was buried below such-and-such a place, and that (that is, Usfan) was their people's territory.
Hadith Referenceالمعجم الكبير للطبراني / باب العين / 11997