NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
Cases, newest first
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 CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.NTSB CHI07CA210Accident · No injuriesData collectionFinal reportBoeing A-75N1 · Oelwein, IAThe pilot's failure to maintain directional control of the airplane during a landing roll. Factors associated with the accident was the gusty crosswind condition and the corn crop.NTSB MIA07CA118Accident · No injuriesData collectionFinal reportPiper PA-20-135 · State College, PAThe failure of the pilot to maintain directional control of the airplane.NTSB LAX07CA207Accident · Minor injuriesData collectionFinal reportCessna 170 · Spanaway, WAThe pilot's failure to maintain directional control during an aborted takeoff from a short and narrow runway.NTSB NYC07CA158Accident · No injuriesData collectionFinal reportCessna 195 · Warrenton, VAThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and impact with terrain.NTSB LAX07CA203Accident · Serious injuriesData collectionFinal reportRajhamsa Xair · Pima, AZThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional airplane control during landing rollout.NTSB CHI07LA203Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Belle Plaine, IAThe pilot's failure to maintain directional control during landing rollout.NTSB LAX07CA199Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbara, CAthe pilot's failure to maintain directional control.NTSB DEN07CA111Accident · No injuriesData collectionFinal reportCessna 180A · Loveland, COThe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA07CA192Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Palm Springs, CAThe pilot's failure to maintain directional control during landing which resulted in an inadvertent ground loop.NTSB ATL07CA099Accident · No injuriesData collectionFinal reportCessna 172P · Perry, GAThe student pilot's failure to maintain directional control on landing roll out resulting in the airplane departing the runway and collision with a ditch.NTSB SEA07LA187Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fresno, CAThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB CHI07CA186Accident · No injuriesData collectionFinal reportPiper J3F-65 · Grand Ledge, MIThe pilot's failure to maintain directional control during takeoff resulting in a ground loop.NTSB ATL07CA097Accident · Minor injuriesData collectionFinal reportSherman John, H Nieuport II · Binghamton, NYThe failure of the main gear spring during landing, which resulted in a loss of directional control, and a nose over.NTSB LAX07CA193Accident · No injuriesData collectionFinal reportCessna 172S · Jacksonville, FLthe student pilot's failure to maintain directional control.NTSB ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.NTSB ANC07CA053Accident · No injuriesData collectionFinal reportGrumman G21A · Dutch Harbor, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a loss of directional control and a nose over.NTSB DFW07CA145Accident · No injuriesData collectionFinal reportEvektor sportstar · Grand Prairie, TXLoss of control due to an unexpected crosswind gust. *This report was modified on May 23, 2008.*NTSB CHI07CA175Accident · Minor injuriesData collectionFinal reportLuscombe 8A · London, OHThe pilot's failure to maintain directional control of the airplane and the pilot's inadequate compensation for the crosswind which resulted in a ground loop and subsequent collision with a taxiway sign. Factors contributing to the accident include the…NTSB LAX07CA192Accident · No injuriesData collectionFinal reportWaco UPF-7 · Reno, NVThe pilot's failure to maintain directional control.NTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.NTSB CHI07CA172Accident · No injuriesData collectionFinal reportCessna 195 · Battle Creek, MIThe pilot's failure to maintain directional control of the aircraft during the landing roll which resulted in a ground loop.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.NTSB LAX07LA195Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORThe pilot's failure to maintain directional control during the landing roll.NTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.NTSB CHI07CA171Accident · No injuriesData collectionFinal reportLuscombe 8A · Columbia, ILThe pilot's failure to maintain directional control of the airplane, causing a ground loop, subsequent runway excursion, and left main gear collapse. Factors in the accident include the ground loop encountered and the depression.NTSB SEA07CA157Accident · Minor injuriesData collectionFinal reportCessna 210M · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll. Wind gusts and a quartering tailwind were factors.NTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.NTSB ANC07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Koyukuk, AKThe pilot's inadequate compensation for a gusting tailwind during the landing roll, which resulted in a loss of control and a nose over. Factors contributing to the accident were the tailwind and wind gust.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB NYC07CA135Accident · No injuriesData collectionFinal reportCessna C-170A · Trenton, GAThe pilot's failure to maintain directional control during the landing roll which resulted in an impact with trees. Factors in the accident were the uneven narrow runway, and a wind gust.NTSB DEN07CA099Accident · No injuriesData collectionFinal reportAeronca 7AC · Erie, COThe student pilot's failure to maintain direction control during the landing roll.NTSB SEA07CA169Accident · No injuriesData collectionFinal reportBoeing Stearman A75N1 · Coeur d'Alene, IDThe pilot's failure to maintain directional control during landing. The crosswind condition was a contributing factor.NTSB SEA07CA146Accident · No injuriesData collectionFinal reportCessna T210N · Bakersfield, CAThe pilot's improper flare, which resulted in a loss of directional control. Factors included the crosswind and gusty wind condition.NTSB CHI07CA163Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · Walnut Ridge, ARThe pilot's failure to maintain directional control of the airplane upon landing, which resulted in the airplane impacting a rice levee. The rice levee and the tailwind condition were contributing factors to the accident.NTSB LAX07CA185Accident · Minor injuriesData collectionFinal reportCessna 172S · Wendover, UTThe pilot's failure to maintain directional control during the landing roll.NTSB MIA07CA104Accident · No injuriesData collectionFinal reportCessna 170B · Pahokee, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.NTSB SEA07CA136Accident · Minor injuriesData collectionFinal reportLidgard 4-1200 · Spartanburg, SCThe pilot lost directional control of the airplane during takeoff. A contributing factor was the pilot's lack of experience in the accident airplane make/model.NTSB DFW07CA117Accident · Minor injuriesData collectionFinal reportCessna A188B · Fabens, TXThe pilot's failure to compensate for the existing wind conditions during takeoff. A contributing factor was the crosswind.NTSB SEA07CA127Accident · No injuriesData collectionFinal reportCessna A185F · Renton, WAThe pilot's loss of aircraft control during a landing attempt, which resulted in an inadvertent ground loop.NTSB CHI07CA149Accident · Minor injuriesData collectionFinal reportPiper J3C · Waterford, MIThe pilot's failure to maintain control of the airplane, causing a water loop. A factor in the accident was the water loop encountered.NTSB NYC07CA120Accident · Serious injuriesData collectionFinal reportMaule MXT-7-180A · St Petersburg, FLThe pilot's failure to obtain the proper climb rate to clear an obstacle after aborting the landing. Factors in the accident were the pilot's failure to maintain directional control during landing, which prompted the aborted landing, and a wind gust.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB LAX07CA170Accident · No injuriesData collectionFinal reportCessna 172S · Carson City, NVThe loss of directional control for undetermined reasons.NTSB LAX07CA169Accident · No injuriesData collectionFinal reportCessna 172M · St. George, UTthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX07CA161Accident · No injuriesData collectionFinal reportAeronca 11AC · Glendale, AZThe private pilot's unstabilized approach and failure to maintain directional control during the landing roll, which resulted in a ground loop. Also causal was the instructor's inadequate supervision and failure to take remedial action.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB CHI07CA142Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard MK IV · Peachtree City, GAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and subsequent left main gear collapse.