NTSB investigations
3,846 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 GAA18CA285Accident · No injuriesData collectionFinal reportCessna 182 · Wickenburg, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.NTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB GAA18CA282Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · LaGrange, GAThe student pilot’s failure to maintain lateral control during a soft-field takeoff.NTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.NTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.NTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…NTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.NTSB ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.NTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.NTSB ANC18LA033Accident · Serious injuriesLimited investigationFinal reportNorth Wing Uum Sport X2-N · Pahrump, NVThe pilot's improper landing flare, which resulted in a fractured engine mount sway bar and subsequent difficulty controlling the airplane, and his inadvertent application of throttle pedal during landing, which resulted in a loss of control.NTSB GAA18CA225Accident · No injuriesData collectionFinal reportRepublic RC 3 · Pelion, SCThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA245Accident · No injuriesData collectionFinal reportAyres S2R · Weipee, IDThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA18CA219Accident · No injuriesData collectionFinal reportStone James R Daytona Cubs Replica · Orlando, FLThe pilot’s failure to maintain lateral control during landing in crosswind conditions.NTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.NTSB GAA18CA217Accident · No injuriesData collectionFinal reportSmith Dennis P Magni M24 · La Grange, TXThe pilot’s failure to maintain lateral control while taxiing onto the runway in gusting wind conditions.NTSB GAA18CA213Accident · Minor injuriesData collectionFinal reportHawley Richard A1B · Lincoln, CAThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA210Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Franklin, CAThe pilot receiving instruction’s abrupt cyclic control input during the touch-down autorotation.NTSB GAA18CA206Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Edgewood, NMThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA18CA209Accident · No injuriesData collectionFinal reportCessna Ector 305A · South Lake Tahoe, CAThe pilot receiving instruction’s failure to maintain directional control during the landing roll.NTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingNTSB GAA18CA196Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Seldovia, AKThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA18CA192Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Prescott, AZThe student pilot’s failure to maintain directional control during landing after touching down with the left brake engaged. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA190Accident · No injuriesData collectionFinal reportCessna 180 · Salina, CAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA183Accident · No injuriesData collectionFinal reportGlobe GC 1B · Fullerton, CAThe pilot’s failure to maintain directional control during the takeoff roll resulting impact with PAPI lighting.NTSB GAA18CA179Accident · No injuriesData collectionFinal reportLynn Perry Cavalon · Haverhill, NHThe pilot's failure to maintain directional control during a rejected takeoff. Contributing to the accident was the binding of the control stick, for an undetermined reason, which precipitated the rejected takeoff.NTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.NTSB GAA18CA178Accident · No injuriesData collectionFinal reportFlightworks Capella XS FW2C80TD · Hartselle, ALThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.NTSB GAA18CA170Accident · No injuriesData collectionFinal reportCessna 172 · Vernon, TXThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.NTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.NTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.NTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.NTSB WPR18LA109Accident · Minor injuriesClass 3 · LimitedFinal reportLyons Robert Navajo HKS · Arlington, WAThe pilot's loss of directional control during landing. Contributing to the accident was the pilot's failure to attain a proper touchdown point, which required his use of heavy braking to stop on the remaining runway and exacerbated the uneven braking…NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.