NTSB investigations
4,592 cases where the sequence of events included Loss of control on ground.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA19CA316Accident · No injuriesData collectionFinal reportCessna 170 · Dillingham, AKThe pilot's improper landing flare, which resulted in a long landing and subsequent loss of directional control, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.NTSB GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.NTSB ERA19TA185Accident · Minor injuriesClass 3Final reportCessna 182 · Robertsdale, ALThe pilot's failure to obtain the proper touchdown point while landing on a wet turf runway, which resulted in a runway overrun.NTSB GAA19CA302Accident · No injuriesData collectionFinal reportDale Berkbigler CCX-2000 · Gunnison, COThe pilot's excessive brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.NTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB GAA19CA422Accident · No injuriesData collectionFinal reportDaryl Baker Bush Sport · Willimantic, CTThe pilot's failure to maintain directional control during taxi operations, which resulted in a collision with a fuel pump enclosure.NTSB GAA19CA353Accident · No injuriesData collectionFinal reportCessna 177 · Festus, MOThe pilot's improper landing flare and failure to maintain pitch control with a crosswind, which resulted in a hard landing and a tail strike.NTSB GAA19CA298Accident · No injuriesData collectionFinal reportPiper PA18 · Sparta, ILThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB CEN19WA203Incident · No injuriesForeign investigationCessna 560 · Elche, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 560XL airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB GAA19CA289Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Fisher, ARThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with a ditch.NTSB ERA19TA182Accident · No injuriesClass 3Final reportAeronca 7AC · Concord, GAThe pilot's inability to maintain directional control during landing for reasons that could not be determined because postaccident examination of the airplane brake assemblies revealed no anomalies that would have caused the right brake to lock, which…NTSB GAA19CA288Accident · No injuriesData collectionFinal reportLuscombe 8 · Carbondale, ILThe pilot's inadvertent left heel brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA286Accident · No injuriesData collectionFinal reportCessna 180 · Takotna, AKThe pilot's failure to maintain directional control during the takeoff, which resulted in impact with vegetation.NTSB GAA19CA285Accident · No injuriesData collectionFinal reportPiper PA18 · Cody, WYThe student pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent loss of airplane control after overcorrecting with rudder. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.NTSB ERA19TA192Accident · No injuriesClass 3Final reportCessna 172 · Stafford, VAThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB WPR19LA153Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Socorro, NMThe pilot's failure to maintain airplane control while landing with a quartering tailwind.NTSB GAA19CA276Accident · No injuriesData collectionFinal reportPiper J3C · Louisa, VAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the landing gear collapsing.NTSB ANC19FA019Accident · 2 fatalClass 2 · FieldFinal reportDe Havilland DHC 2 · Metlakatla, AKThe pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…NTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.NTSB GAA19CA267Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.NTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA266Accident · No injuriesData collectionFinal reportRyan John Steffey Subsonex · Latrobe, PAThe pilot's failure to maintain pitch control while attempting to secure the canopy, which opened shortly after takeoff and resulted in the airplane impacting the ground and the main landing gear collapsing. Contributing to the accident was the pilot's…NTSB GAA19CA261Accident · No injuriesData collectionFinal reportSiai-Marchetti SM · Belgrade, MTThe pilot receiving instruction's overapplication of rudder during the landing roll and his subsequent failure to maintain directional control, which resulted in a ground loop.NTSB GAA19CA259Accident · No injuriesData collectionFinal reportCessna 182 · Crossett, ARThe pilot's failure to maintain the runway centerline and his subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA260Accident · No injuriesData collectionFinal reportCessna A185 · Northway, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and subsequent nose-over.NTSB GAA19CA256Accident · No injuriesData collectionFinal reportJordan Valley CCX-2000 · Logandale, NVThe pilot's failure to maintain directional control during landing and during a subsequent attempted go-around, which resulted in the airplane cartwheeling.NTSB GAA19CA255Accident · No injuriesData collectionFinal reportElmwood Christavia MK I · Roseburg, ORThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA280Accident · No injuriesData collectionFinal reportPiper PA28 · Charlotte, NCThe student pilot's improper attempted go-around and the flight instructor's delayed remedial action, which resulted in an aerodynamic stall followed by a hard landing, runway excursion, and impact with vegetation.NTSB GAA19CA293Accident · No injuriesData collectionFinal reportPiper PA 20 · Canandaigua, NYThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR19LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Reno, NVThe pilot’s inability to maintain directional control during landing in gusty crosswind conditions for reasons that could not be determined based on available evidence.NTSB WPR19LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Kalispell, MTThe loss of directional control during landing for reasons that could not be determined based on available evidence.NTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.NTSB GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.NTSB GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.NTSB ERA19TA166Accident · Minor injuriesClass 3Final reportCessna 172 · New Bern, NCThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB GAA19CA228Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Lincoln, CAThe pilot receiving instruction's failure to maintain directional control during landing, which resulted in an attempted go-around and collision with a trench, and the flight instructor's delayed remedial action during the landing.NTSB GAA19CA235Accident · No injuriesData collectionFinal reportBakeng Bakeng Deuce · Winston Salem, NCThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA227Accident · No injuriesData collectionFinal reportMaule M7 · Roosevelt, UTThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a runway excursion and collision with a culvert.NTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA226Accident · No injuriesData collectionFinal reportGuimbal Cabri · McMinnville, ORThe pilot's improper landing flare during a turning, full-down autorotation, which resulted in a lower-than-normal rotor rpm, a faster-than-normal ground run speed, and the subsequent loss of directional control, a runway excursion, and a roll-over.…NTSB GAA19CA219Accident · No injuriesData collectionFinal reportCessna 180 · Morgan, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and an attempted aborted landing and impact with bushes and terrain.NTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.NTSB WPR19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Prineville, ORThe pilot’s failure to maintain directional control during takeoff with a crosswind.NTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.NTSB GAA19CA218Accident · No injuriesData collectionFinal reportCessna 180 · Reedsburg, WIThe pilot's loss of directional control and subsequent improper brake application during the landing roll, which resulted in a nose-over.NTSB WPR19LA117Accident · Minor injuriesClass 3 · LimitedFinal reportNanchang CJ 6 · Grass Valley, CAA loss of brake control due to fatigue fracture of the brake control cable, which resulted in the separation of the cable from the brake handle.NTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.