John Sonmez who runs SimpleProgrammer.com has posted a YouTube Video titled "Do You Suffer From Fear Of Failure".
John does a great job with these videos which are aimed at helping developers understand themselves, their motivations and their challenges. I highly recommend the series in general and this video in particular.
In this one he talks about his own fear of failure and relates a recent experience engaging in a contest with friends.