Kind of a loaded topic, huh? When I ask that question - do you fear failure - I mean as a player. When you grab the dice, and the chips are down in the game, do you worry the dice won't come up with a success? Do you take steps to try to mitigate the failure? Do you have that moment of nervousness?
If your answer to that was yes, my question to you - to me, as I feel these things too - is why?
This past Saturday in my housemate's L5R game we had several spectacular failures in the game, and every single one of them made the session a lot more fun and interesting. One PC messed up a roll and launched 5 of us, in a van, off a cliff and behind enemy lines where we didn't want to be. Another PC messed up rolls that kept him out of the fight for half the battle. A third PC messed up on a different roll and escalated what should have been a small skirmish into a multi-army battle that even some gods showed up to interfere with.
What is it about failure for your character that bothers you as the player?
Good RP needs bad roles to happen. I can't think of a story that doesn't feature the protagonists/heroes failing on occasion. Failure creates opportunities for even more amazing things to happen.
So why worry? Why not just cut loose and let it happen?