Skip to content

Static F1 database table

races_red_flags

The races_red_flags table contains 98 Formula 1 records across 7 columns. Column types include BIGINT, VARCHAR.

Download Parquet
Rows
98
Columns
7
Parquet size
6.59 KB
Updated
2026-07-31

Schema for races_red_flags

ColumnTypeNullableDescription
raceIdBIGINTnoThe identifier of the race.
yearBIGINTnoThe year of the season.
roundBIGINTnoThe round number of the race in the season.
lapBIGINTyesThe lap number on which the red flag occurred.
resumedVARCHARyesStatus of race resumption (e.g. Y, N, R, S).
incidentVARCHARyesDescription of the incident causing the red flag.
excludedVARCHARyesDrivers excluded during the red flag period.
races_red_flags · 98 rows loaded
319503138NRain.
20719711064NMist.
229197392YCrash involving Jody Scheckter, Jean-Pierre Beltoise, George Follmer, Mike Hailwood, Carlos Pace, Jochen Mass, Jackie Oliver, Roger Williamson and Andrea de Adamich.Jody Scheckter, Jean-Pierre Beltoise, George Follmer, Mike Hailwood, Carlos Pace, Jochen Mass, Jackie Oliver, Roger Williamson and Andrea de Adamich (crash) Graham McRae (throttle) and David Purley (spun off).
2371974232NRain.
2541975429NCrash of Rolf Stommelen which killed five spectators. Half points were awarded.
26019751056NRain and crashes involving Wilson Fittipaldi, Jochen Mass, John Watson, Carlos Pace, Jody Scheckter, James Hunt and Mark Donohue.
26219751229NRain. Half points were awarded.
273197691YCrash at the start involving Clay Regazzoni, James Hunt, Jacques Laffite and Niki Lauda.None, although Clay Regazzoni and Jacques Laffite illegally used their spare cars at the restart, and were subsequently disqualified.
2741976102YCrash involving Niki Lauda, Brett Lunger and Harald Ertl.Niki Lauda (crashed, injured), Brett Lunger and Harald Ertl (crashed), Chris Amon (withdrawn), Hans-Joachim Stuck (clutch) and Jacques Laffite (gearbox)
3091978127RRain. The race was decided by combining the time from the first 7 laps with the time from the restarted 47.Mario Andretti, Jody Scheckter, Nelson Piquet, Héctor Rebaque, Harald Ertl, Riccardo Patrese, Alan Jones and James Hunt.
3111978141SCrash involving Ronnie Peterson, Riccardo Patrese, James Hunt, Vittorio Brambilla, Hans-Joachim Stuck, Patrick Depailler, Didier Pironi, Derek Daly, Clay Regazzoni and Brett Lunger. The race was shortened to 40 laps from the scheduled 52 due to the concerns over darkness.Ronnie Peterson (fatal crash), Vittorio Brambilla (injured), Hans-Joachim Stuck, Didier Pironi and Brett Lunger.
314197911YA huge crash involving Jody Scheckter, Arturo Merzario, Didier Pironi, Nelson Piquet, John Watson, Patrick Tambay and Mario Andretti.Jody Scheckter, Arturo Merzario, Didier Pironi, Nelson Piquet and Patrick Tambay.
316197932RRain.
3411980131YCrash involving Jean-Pierre Jarier, Derek Daly, Emerson Fittipaldi, Keke Rosberg, Mario Andretti, Gilles Villeneuve and Jochen Mass.Derek Daly (crashed) and Mike Thackwell (lending his car to Jean-Pierre Jarier after Jarier crashed his car before the restart).
347198152RStart crash that involved Riccardo Patrese and teammate Siegfried Stohr, injuring Patrese's mechanic.Riccardo Patrese and Siegfried Stohr
3471981554NRain.
3501981858RRain. The race was decided by combining the time from the first 58 laps with the time from the restarted 22.
364198277SCrash involving Elio de Angelis, Roberto Guerrero, and Riccardo Patrese. The race was decided by combining the time from the first 6 laps with the time from the restarted 64, shortened to 56 due to the two-hour time limit.Riccardo Patrese and Roberto Guerrero
365198281YDidier Pironi stalled his car at the start, causing Riccardo Paletti to crash fatally into the back of Pironi's car. Geoff Lees, Raul Boesel and Eliseo Salazar were also involved in separate crashes at the start.Riccardo Paletti (fatal crash), Geoff Lees (crashed) and Jean-Pierre Jarier (withdrawn after teammate Paletti died).
3941984631NRain. Half points were awarded.
396198481YCrash at the start involving Nelson Piquet, Ayrton Senna, Michele Alboreto and Marc SurerMarc Surer
39819841011SCrash of Jonathan Palmer. The race was restarted for 60 laps, rather than the original 64.
4001984121YImproper start procedure.
4141985101YCrash at the start involving Teo Fabi, Elio de Angelis, Michele Alboreto and Gerhard Berger.Piercarlo Ghinzani
429198691YNigel Mansell suffered a driveshaft failure at the start, resulting in a crash involving a number of cars which included Thierry Boutsen, Jacques Laffite, Christian Danner, Piercarlo Ghinzani, Allen Berg and Jonathan Palmer.Jacques Laffite (crash, injured), Christian Danner, Piercarlo Ghinzani and Allen Berg.
439198732YCrash involving Jonathan Palmer and Philippe Streiff.Jonathan Palmer
4461987101YThe first race start ended quickly after Martin Brundle crashed, then Jonathan Palmer, Philippe Streiff and Piercarlo Ghinzani collided.
7 cols · 0ms
TracingInsights Logo

Your one-stop home for unparalleled F1 insights

Connect on Socials

TracingInsights and this website are unofficial and are not associated in any way with the Formula 1 companies. F1, FORMULA ONE, FORMULA 1, FIA FORMULA ONE WORLD CHAMPIONSHIP, GRAND PRIX and related marks are trade marks of Formula One Licensing B.V. All product and company names are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Any product names, logos, brands, and other trademarks or images featured or referred to within the app are the property of their respective trademark holders. These trademark holders are not affiliated with TracingInsights or its contributors. They do not sponsor or endorse TracingInsights or any of our products.

© 2026 TracingInsights ·