Not so much a "scary" moment, but similar to you; when I was 5 years old I jumped off the garage roof thinking I was Superman and I could fly....
I remember the jump, and I remember being carried into the Hospital from the car by my mother, but nothing in between; or after the doctor visit...