Red Arrows pilot dies in air festival crash