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 GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.NTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.NTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.NTSB GAA18CA033Accident · No injuriesData collectionFinal reportEvolution Revo · Berlin, NHThe pilot’s failure to center the ground steering before landing, which resulted in a loss of directional control.NTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.NTSB GAA18CA026Accident · No injuriesData collectionFinal reportJohn A Brewer ELA Aviacion 10 Ecli · Bristol, TNThe pilot’s failure to maintain lateral control during the landing roll.NTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.NTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA18CA027Accident · No injuriesData collectionFinal reportCessna 120 · New Bern, NCThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA18CA025Accident · No injuriesData collectionFinal reportChampion 7GC · Gerlach, NVThe pilot's incorrect pitch control during the landing roll in shifting wind conditions, which resulted in a nose-over.NTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA014Accident · No injuriesData collectionFinal reportHimsl Vincent S Vans RV-8 · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll in crosswind conditions.NTSB GAA18CA011Accident · No injuriesData collectionFinal reportDehavilland DHC 1 · Cedartown, GAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN18WA029Accident · Minor injuriesForeign investigationRobinson R44 · Namur, BelgiumNTSB GAA18CA001Accident · No injuriesData collectionFinal reportPiper J3C · Yakima, WAThe flight instructor's failure to maintain directional control during the takeoff roll.NTSB GAA18CA021Accident · Minor injuriesData collectionFinal reportPiper PA32R · Block Island, RIThe pilot's use of an incorrect airspeed during landing, which resulted in a runway overrun.NTSB GAA17CA575Accident · No injuriesData collectionFinal reportSilvaire 8 · Texarkana, ARThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA572Accident · No injuriesData collectionFinal reportCub Crafters CC19-180 · Kalispell, MTThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.NTSB GAA17CA569Accident · No injuriesData collectionFinal reportPiper PA 18 · Beluga, AKThe pilot’s inability to maintain pitch control due to an encounter with a tailwind gust after the airplane had stopped, which resulted in a nose-over.NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.NTSB GAA17CA550Accident · No injuriesData collectionFinal reportCessna 180 · Danbury, CTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA547Accident · No injuriesData collectionFinal reportCessna 180 · Albuquerque, NMThe pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions.NTSB GAA17CA539Accident · No injuriesData collectionFinal reportCessna A185 · Talkeetna, AKThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB CEN17LA367Accident · Serious injuriesLimited investigationFinal reportMiller Steven M RV6 A · Elbert, COThe pilot’s improper landing flare in strong gusting wind conditions, which resulted in a bounced landing, and his loss of directional control during an attempted go-around, which resulted in a runway excursion and impact with objects.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB GAA17CA523Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Redgranite, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA527Accident · No injuriesData collectionFinal reportPiper PA 12 · Kotzebue, AKThe pilot’s failure to maintain directional control while landing on an unimproved airstrip in gusting wind conditions.NTSB GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA525Accident · No injuriesData collectionFinal reportCessna 182 · Lockwood, MOThe pilot’s unstabilized approach and failure to go around, which resulted in a runway overrun on a wet, grass runway.NTSB GAA17CA517Accident · No injuriesData collectionFinal reportJeff Jardine Kitfox S7 Supersport · Kanab, UTThe pilot's failure to maintain directional control during landing and the airplane’s subsequent failure to attain a climb rate during an attempted go-around in high-density altitude conditions.NTSB ANC17LA053Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AK***This probable cause was modified on November 27, 2018. Please see the docket for this accident to view the original probable cause.*** The pilot's improper decision to takeoff in an area of rough water and ocean swells, which resulted in a failure of the…NTSB GAA17CA515Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Winnemucca, NVThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent loss of airplane control during an attempted aborted landing.NTSB WPR17LA193Accident · No injuriesLimited investigationFinal reportCessna 140 · Empire, NVThe pilot's failure to maintain directional control during an off-airport precautionary landing on a dirt road with an uphill gradient.NTSB GAA17CA576Accident · Minor injuriesData collectionFinal reportHunter George RV 6 · Montgomery, NYThe pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights.NTSB GAA17CA512Accident · No injuriesData collectionFinal reportAviat A 1 · Cody, WYThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.NTSB GAA17CA508Accident · No injuriesData collectionFinal reportCessna 182 · North Platte, NEThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.NTSB ERA17LA293Accident · No injuriesLimited investigationFinal reportCessna 172 · Guntersville, ALThe pilot's failure to maintain directional control on takeoff.NTSB CEN17LA326Accident · No injuriesLimited investigationFinal reportCessna 182 · Booneville, MOThe pilot’s failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion.