But I really hope there will be a scientific answer and it is not very scary...:p
I think about this kinda thing also. I just wonder 'what's on the other side' so to speak.
Your life will just end.
The electrical currents in your brain will stop working, your mind will no longer exist.
You won't know that you are dead, and you will definitely not be floating around in black nothingness, or something like that.
There is nothing to be scared of, life and death are a natural cycle.