It's very rare to see such a thing. In fact, these days, everything is edited before broadcast even if it appears to have been recorded live. Nothing we watch on the screen is real anymore, creating unrealistic expectations for amateur musicians.
Here's a video of Phil Collins walking out on a stage with a towel, water bottle, and sheet music like any student doing a recital... and he makes a mistake! While Phil isn't known for his piano skills, I enjoyed watching this very much, and his singing was studio flawless.
You won't have to wait long for the mistake, it's right after the 1 minute mark... and you can see he suffers just as bad as the rest of us. 😃
Anyone else come across famous musicians making obvious mistakes at the piano?