no it's not.
if you don't exist then you don't know that you don't exist... because you don't exist. so there's nothing to be afraid of.
it was just like that time before you were born. remember that? remember how scary it was? of course you don't. exactly.
when you die, I would have to say that it's about 99% likely nothing happens.
you just sleep and never wake up. the brain is dead because the oxygen no longer supplies it. the brain = the mind, and the mind = the person.
dead mind, dead person, the end. the lights turn off, the curtains close, the show goes on without you.
you can believe that you'll have this magical transportation to a place populated by your dead relatives and dead cats and dead dogs where you can all be together and dance in the clouds for eternity, but that's wishful thinking at best.