NTSB investigations
4,590 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 ERA21LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Groton, CTThe pilot’s failure to maintain directional control of the airplane during landing, resulting in a runway excursion and collision with an airport sign.NTSB WPR21LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fields, ORThe pilot’s failure to maintain directional control during landing on a highway, which resulted in an impact with terrain and subsequent nose over.NTSB WPR21LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Miles City, MTThe pilot’s failure to maintain directional control during takeoff which resulted in a ground loop and collision with terrain.NTSB WPR21LA282Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J230-SP · Oceano, CAThe pilot’s failure to maintain directional control after landing fast and hard which damaged the right main landing gear wheel pant which lodged under the wheel.NTSB ERA21LA251Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Monticello, NYThe pilot’s inadequate preflight inspection which resulted in a failure of the right main landing gear tire on landing rollout, a subsequent loss of directional control, and landing gear collapse.NTSB ERA21LA244Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Sanford, METhe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB ERA21LA243Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J250-SP · Marietta, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB WPR21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Carlsbad, CAThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.NTSB WPR21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R182 · Minden, NVThe pilot receiving instruction’s failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.NTSB ENG21WA049Accident · No injuriesClass 5 · ForeignATR ATR72 · Democritus, GreeceNTSB WPR21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Fields, ORThe pilot’s failure to maintain directional control during landingNTSB CEN21FA239Accident · 1 fatalClass 3 · FieldFinal reportPZL Warszawa-Okecie PZL-104 · Pearland, TXThe pilot’s loss of directional control during landing. Contributing to the severity of the accident was the presence of a drainage ditch between the runway and taxiway.NTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.NTSB ANC21LA042Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Birchwood, AKThe pilot's use of excessive braking during the landing roll, which resulted in a nose-over.NTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.NTSB CEN21LA236Accident · No injuriesClass 4 · LimitedFinal reportBerry TX-11C · Longmont, COThe pilot’s loss of directional control when his foot became stuck on a protruding bolt in the airplane’s floorboard.NTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.NTSB WPR21LA207Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Phoenix, AZThe pilot's failure to maintain directional control after an encounter with a windshear during the landing roll, which resulted in a runway excursion.NTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.NTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.NTSB WPR21LA197Accident · No injuriesClass 4 · LimitedFinal reportStearman 4E · Porterville, CAThe pilot’s loss of directional control while landing, which resulted in a landing gear collapse.NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB WPR21LA221Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Truckee, CAThe pilot’s improper flare during a landing attempt in crosswind conditions, which resulted in a bounced landing and impact with the ground.NTSB CEN21LA227Accident · No injuriesClass 4 · LimitedFinal reportVarner David L Vans RV-8 · Watkins, COThe pilot’s failure to maintain control of the airplane during landing.NTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB WPR21LA187Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions which resulted in a runway excursion and collision with terrain.NTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.NTSB WPR21LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Arlington, WAThe pilot’s failure to maintain directional control during landing, with a crosswind, which resulted in a runway excursion and subsequent impact with terrain.NTSB ANC21LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cold Bay, AKThe pilot’s failure to maintain directional control during takeoff in a gusty crosswind condition.NTSB WPR21LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Buffalo, WYThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop and collision with terrain.NTSB ANC21LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Willow, AKThe pilots over application of the brakes while landing on a wet grass runway, which resulted in a loss of control and nose-over.NTSB WPR21LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Lewiston, IDThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in a taxiway excursion and collision with a fence.NTSB WPR21LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175B · Royal City, WAThe pilot’s failure to maintain airplane control during a landing with a tailwind which resulted in excessive ground speed, runway over run and subsequent nose over.NTSB ERA21LA204Accident · Minor injuriesClass 4 · LimitedFinal reportJabiru Aircraft PTY J170-D · Winchester, VAThe pilot’s loss of directional control on landing. Contributing to the outcome was the pilot’s decision to continue the aborted landing after the airplane had departed the runway surface.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB ANC21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172P · Lanai City, HIThe solo student pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and a nose-over.NTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB CEN21LA196Accident · No injuriesClass 4 · LimitedFinal reportMobi-light CCX-2300 · Loveland, COThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop, and the failure of both pilots to establish who was in control of the airplane.NTSB GAA21WA119Accident · No injuriesClass 5 · ForeignSpitfire MK26 · Breighton, UK, United KingdomNTSB WPR21LA168Accident · No injuriesClass 4 · LimitedFinal reportDavis Donald M Bushby Mustang II · Maricopa, AZThe pilot’s failure to maintain airplane control during takeoff with a quartering right tailwind.NTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.NTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.