NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.NTSB MIA08CA045Accident · No injuriesData collectionFinal reportCessna 172P · Northampton, MAThe student pilot's failure to maintain directional control of the airplane during the takeoff roll and inadequate supervision by the CFI.NTSB LAX08CA041Accident · Minor injuriesData collectionFinal reportFound Acft FBA-2C2 · Holbrook, AZThe pilot's failure to maintain directional control during landing rollout, which resulted in an inadvertent ground loop.NTSB DFW08CA049Accident · No injuriesData collectionFinal reportCessna 182 · Austin, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the gusting winds.NTSB NYC08CA066Accident · No injuriesData collectionFinal reportPiper PA28-180 · Blue Bell, PAThe student pilot's failure to maintain directional control while landing.NTSB ANC08TA028Accident · Minor injuriesFinal reportDouglas DC-3T · McMurdo Station, AYThe captain's decision to lift off before attaining a proper airspeed, resulting in a loss of control during takeoff.NTSB MIA08CA030Accident · No injuriesData collectionFinal reportCessna 172N · Talladega, ALThe pilot's failure to maintain directional control of the airplane.NTSB SEA08CA047Accident · No injuriesData collectionFinal reportCessna 172S · El Cajon, CAThe excessive speed while turning off of the runway which resulted in a loss of aircraft control. The ditch was a factor.NTSB CHI08CA047Accident · No injuriesData collectionFinal reportCessna Skyhawk 172 · Wausau, WIThe pilot failed to maintain directional control during the landing roll. Factors that contributed to the accident included the snow on the runway and the snowbank.NTSB LAX08CA036Accident · No injuriesData collectionFinal reportPiaggio Aero Industries Avanti P-180 · Battle Mountain, NVThe flight crew's failure to follow published procedures/directives in the Pilot's Operating Handbook during landing.NTSB SEA08LA041Accident · No injuriesLimited investigationFinal reportCessna 551 · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during landing roll out. Contributing to the accident was the slush contaminated runway and the crosswind weather conditions.NTSB MIA08LA024Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Hendersonville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control.NTSB DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.NTSB DEN08CA034Accident · No injuriesData collectionFinal reportGodwin, David P Sorrell SNJ-7 · Belen, NMthe pilot's loss of directional control during landing resulting in a ground loop.NTSB SEA08CA034Accident · No injuriesData collectionFinal reportAyres S2R-G1 · Calexico, CAThe pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.NTSB DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB SEA08CA030Accident · Minor injuriesData collectionFinal reportCessna 172N · Atwater, CAThe failure of the student pilot to maintain directional control during the landing roll. Factors contributing to the accident included the sign and the ditch.NTSB DEN08LA031Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot's failure to maintain directional control during landing. Contributing factors were the delayed remedial action and inadequate supervision by the flight instructor, and the ditch.NTSB LAX08CA030Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Overgaard, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB DFW08LA029Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Midland, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the prevailing tailwind and an airport sign.NTSB DFW08CA023Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arcola, TXThe loss of control as result of the pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the gusty crosswind.NTSB DFW08CA022Accident · No injuriesData collectionFinal reportAeronca 7AC · Fort Worth, TXThe pilot's failure to maintain direction control. A contributing factor was the tailwind.NTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.NTSB CHI08CA023Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Morrison, MOLoss of control on the ground due to aircraft control not being maintained by the pilot. Contributing factors were the gusting winds and the uneven ground.NTSB LAX08CA011Accident · No injuriesData collectionFinal reportMaule M-5-235-C · Mesa, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB MIA08LA009Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Atlanta, GAA misalignment of the nose landing gear wheel assembly during landing for undetermined reasons.NTSB SEA08CA009Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Townsend, MTThe private pilot/student failed to maintain directional control during the landing roll, and remedial action was not possible by the flight instructor which resulted in an inadvertent ground loop.NTSB NYC08CA010Accident · No injuriesData collectionFinal reportCessna 150M · Palmyra, PAThe student pilot's improper recovery from a bounced landing, and the CFI's failure to take remedial action.NTSB DFW08CA005Accident · No injuriesData collectionFinal reportStinson 108-2 · Indianola, MSThe pilot's failure to compensate for the existing wind conditions while landing. A contributing factor was the crosswind.NTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.NTSB CHI08CA010Accident · No injuriesData collectionFinal reportBeech N35 · Elyra, OHThe directional control not maintained by the dual student and the inadequate supervision by the certified flight instructor during takeoff roll. Contributing factors were the precision approach path indicator and the ditch.NTSB NYC08CA003Accident · No injuriesData collectionFinal reportCessna 170A · Wadesboro, NCThe pilot's improper recovery from a bounced landing.NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB SEA07CA274Accident · No injuriesData collectionFinal reportCessna A185F · Lexington, ORThe pilot's failure to maintain directional control during the landing roll which resulted in an inadvertent ground loop/swerve.NTSB SEA07CA271Accident · Minor injuriesData collectionFinal reportLangley Tri-Quickie · Chino, CAThe premature rotation of the airplane on the takeoff roll as a result of the pilot failing the verify the elevator trim position, resulting in a loss of control and subsequent impact with terrain during an aborted takeoff.NTSB NYC07CA236Accident · No injuriesData collectionFinal reportRobinson R44 II · Nashville, TNThe pilot's failure to maintain control of the helicopter.NTSB CHI07CA303Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Bloomington, ILThe pilot's failure to maintain directional control during takeoff roll which resulted in a ground loop.NTSB SEA07CA272Accident · No injuriesData collectionFinal reportJeffrey Wilson Escapade · La Grande, ORThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and substantial damage to the airplane's left wing. A contributing factor was the flight instructor's delayed remedial action.NTSB NYC07CA238Accident · No injuriesData collectionFinal reportCessna 190 · Yulee, FLThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB CHI07CA314Accident · No injuriesData collectionFinal reportAeronca 7AC · Kent, OHThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gusts, and ditch.NTSB NYC07LA227Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · West Chester, PAThe total failure of the left brake disc due to corrosion.NTSB SEA07CA261Accident · No injuriesData collectionFinal reportAviat A-1B · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a ditch located between the runway and the taxiway.