RPGs that celebrate failure / mistakes?

My son has a really hard time dealing with failure / making mistakes. He adores playing D&D and Dread (a kid friendly version of course.) I am wondering if anyone knows of a game or adventure out there where there is a theme or mechanic of learning to appreciate failure or turning it into something positive?