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 ERA23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Factoryville, PAThe pilot's failure to maintain directional control while practicing a soft-field takeoff maneuver, which resulted in a runway excursion and impact with a hangar.NTSB WPR23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Evanston, WYThe pilot’s failure to maintain directional control during takeoff, resulting in a runway excursion and ground loopNTSB WPR23LA023Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Marble Canyon, AZThe pilot’s loss of directional control during a takeoff from a rough, narrow runway, resulting in an aborted takeoff and subsequent runway excursion.NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.NTSB WPR23LA014Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Petaluma, CAThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB ERA23LA015Accident · Minor injuriesClass 4 · LimitedFinal reportST Clair David L Tango 2 · Yulee, FLThe pilot’s improper landing flare which resulted in a hard, bounced landing that damaged the nose landing gear, resulting in an inability to maintain directional control and subsequent runway excursion.NTSB WPR23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Monument Valley, UTThe pilot’s loss of airplane control during the landing flare in gusting wind and subsequent loss of directional control during the landing roll.NTSB CEN23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Navasota, TXThe pilot’s loss of control while landing resulting in a runway excursion and ground loop.NTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.NTSB WPR23LA020Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters FX-3 · Hot Springs, MTThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyNTSB CEN23LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Burnet, TXThe pilot’s failure to maintain directional control during the landing roll with an unexpected quartering tailwind.NTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.NTSB WPR23LA005Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Reno, NVThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR22LA366Accident · No injuriesClass 4 · LimitedFinal reportArter Warren Carbon CUB CCK-1865 · Willard, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA437Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · San Antonio, TXThe student pilot’s failure to maintain control of the airplane during the landing.NTSB WPR22LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Hermiston, ORThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.NTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.NTSB WPR22LA346Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Las Vegas, NVThe pilot’s failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN22LA420Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe student pilot’s incorrect application of rudder during landing and the flight instructor’s delayed response to the student pilot’s action.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB WPR22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Scappoose, ORThe pilot's failure to maintain airplane control while taxing in gusty wind conditions.NTSB CEN22LA410Accident · Minor injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Coldwater, MIThe pilot receiving instruction’s improper flare during landing and the flight instructor’s inadequate remedial action, which resulted in the airplane exceeding its critical angle-of-attach and experiencing an aerodynamic stall.NTSB WPR22LA372Accident · Minor injuriesClass 4 · LimitedFinal reportCessna P210N · Weston, ORThe pilot’s improper landing flare which resulted in a bounced landing and runway excursion.NTSB ERA22LA400Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Marysville, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaNTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB ANC22LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and impact with terrain.NTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.NTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB CEN22LA399Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Sullivan, INThe pilot’s failure to maintain directional control during landing.NTSB ERA22LA374Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Westfield, MAThe pilot’s loss of directional control while taxiing for takeoff.NTSB CEN22LA388Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28 · Lucedale, MSThe pilot’s failure to maintain directional control while landing on the wet turf runway with a higher speed.NTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB ANC22LA065Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R172K · Fairbanks, AKThe pilot’s failure to maintain control of the airplane during landing.NTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.NTSB ANC22LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain directional control of the airplane during the takeoff roll following a hard landing.NTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.NTSB CEN22LA368Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Midland, TXThe student pilot’s failure to maintain control of the airplane while landing with gusting wind.NTSB ERA22LA355Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Cranberry Township, PAThe pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…