I thought Marie Antoinette's last words were something to the effect of "excuse me" having just stepped on the executioner's foot.
Wasn't there already a thread asking the exact same question? I seem to remember posting in one. Anyway, do I fear death? No. Am I scared at the thought of death? No. With death comes the end of all things, so after it happens, what do I care? That's solipsistic thinking but, hey, it works. That doesn't mean I seek death out or hurry along to it, but I don't reject the fact that all will die.
I know many old and very old people, in fact a few of 'em kicked off this month. They did more than simply not fear death, they embraced it and welcomed its coming with open arms. From my experience, most people who live beyond a certain age or outlive the majority of their generation no longer want to go on. For them, death is certainly not a frightful prospect.
Looking back at my extended family, none of them grew terror-stricken when they neared death, either, save one of my grandfathers, who with all his heart believed that by building a church and funneling thousands upon thousands of dollars into he'd buy immortality from God. He died thoroughly confused and unaware of what was happening to him. Though I'm an atheist, I'm sure he now lives in Hell.
You just don't fear something until it happens to you.
Of course, being dead, there's not much left to worry about.