The only thing that scares me to the pit of my stomach is the whole spiritual paranormal.
When I was younger, I'd pray to God that He wouldn't send an angle to me because I was deeply afraid of what that would look like to me-especially in a dark room by myself. Seriously, imagine you're just falling asleep and BAM!! This huge bright angel with wings is standing before you going "don't be afraid". Too late buddy, I just peed my pants.
Not only angles, but the whole thought that there's this spiritual war going on that we don't see. The paranormal I suppose you could call it. I have a deep fear of it... thats why I don't watch movies like The Exorcist or anything that deals with demons, the paranormal, or anything else frighteningly spiritual in those terms.
Other than that, I've never been afraid of something so bad that I haven't been able to over come it.