A pilot like him will never crash like this by a simple misjudgement. I can only see three scenarios:
G induced Loss of Consciousness (however, extremely unlikely for a Red)
A medical condition (can happen to any of us, any time)
Technical malfunction with flight controls
The Red has always been my favourite group. The tight formations kept in view of the crowd is poetry in the air.
RIP