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 ANC09CA070Accident · No injuriesData collectionFinal reportDressen Donald L Back Count · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop and substantial damage to the airplane.NTSB WPR09LA354Accident · Serious injuriesLimited investigationFinal reportLeider T-18 · Carson City, NVThe pilot’s failure to maintain directional control during landing.NTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.NTSB ANC09TA068Accident · No injuriesFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain directional control while landing in a crosswind, which resulted in a ground-loop.NTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN09CA436Accident · No injuriesData collectionFinal reportTaylorcraft BC-D · Joplin, MOThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA432Accident · No injuriesData collectionFinal reportRemos Remos G-3/ · Erie, COThe student pilot's improper recovery from a bounced landing and the flight instructor's delayed reaction to take control and recover.NTSB CEN09CA433Accident · No injuriesData collectionFinal reportAero Commander 680-F · Angel Fire, NMThe pilot's failure to maintain directional control during the initial takeoff.NTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09CA421Accident · No injuriesData collectionFinal reportPitts S-2A · Springfield, ILThe pilot's inability to maintain directional control while landing due to the unintentional obstruction of the rudder by the passenger.NTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.NTSB ERA09CA375Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Manteo, NCThe pilot's improper decision to exit the airplane, with the engine operating. Contributing to the accident was the inadvertent throttle movement by the passenger.NTSB ERA09CA386Accident · No injuriesData collectionFinal reportChampion 7AC · Westminster, MDThe pilot's failure to properly set the throttle for start.NTSB CEN09IA438Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Put-In-Bay, OHThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN09CA411Accident · No injuriesData collectionFinal reportCessna 172N · Benton, ARThe student pilot's failure to maintain directional control during takeoff.NTSB ERA09CA374Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Quinton, VAA loss of directional control on landing for undetermined reasons.NTSB CEN09CA395Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Pittsburg, KSThe pilot's loss of directional control resulting in a ground-loop.NTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.NTSB CEN09CA420Accident · No injuriesData collectionFinal reportAviat Husky · Greenfield, INThe pilot failed to maintain directional control of the airplane during the takeoff roll.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.NTSB CEN09CA373Accident · Serious injuriesData collectionFinal reportCessna 172N · Marysville, OHThe pilot's inability to maintain directional control of the airplane during the landing roll for undetermined reasons.NTSB WPR09LA298Accident · No injuriesLimited investigationFinal reportSimmons Vans RV-8A · Cameron Park, CAThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.NTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.NTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.NTSB CEN09CA362Accident · No injuriesData collectionFinal reportAirborne Windsports PTY XT-912 · Alamogordo, NMThe failure of the pilot to maintain directional control while landing with gusting winds.NTSB ANC09CA057Accident · No injuriesData collectionFinal reportCessna 180F · King Salmon, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB ERA09LA348Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Fairmont, WVThe pilot’s failure to maintain control of the airplane during takeoff. Contributing to the accident was the pilot's inadequate use of the checklist.NTSB ERA09CA350Accident · No injuriesData collectionFinal reportBeech C17B · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR09CA289Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB ANC09LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe flight instructor's decision to land with a tailwind, and his failure to maintain directional control during landing, resulting in a ground-loop and nose-over.NTSB ERA09CA333Accident · No injuriesData collectionFinal reportChatham Robert M RV6-A · Gilbert, SCThe pilot’s failure to maintain directional control of the airplane during landing roll. Contributing to the accident was the airspeed indicator that became inoperative during the landing approach.NTSB ERA09LA330Accident · No injuriesLimited investigationFinal reportYakovlev/Day YAK-11 · Culpeper, VAThe pilot’s failure to maintain directional control during landing.NTSB CEN09CA346Accident · No injuriesData collectionFinal reportMeyers OTW · Haskell, TXThe pilot's failure to maintain directional control while landing in a crosswind.NTSB WPR09CA278Accident · No injuriesData collectionFinal reportCessna 180J · Bellingham, WAThe pilot's failure to maintain directional control during landing.NTSB ANC09CA050Accident · No injuriesData collectionFinal reportDe Havilland DHC-2 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff.NTSB ERA09CA327Accident · No injuriesData collectionFinal reportMeuer Mark SA900 V ST · Winchester, TNThe malfunction of the right brake during landing rollout.NTSB ANC09CA055Accident · No injuriesData collectionFinal reportChampion 7ECA · Nome, AKThe pilot's failure to maintain directional control during an off- airport landing.NTSB WPR09CA275Accident · No injuriesData collectionFinal reportCessna 172S · Tooele, UTThe pilot's failure to maintain directional control during landing.NTSB WPR09LA281Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe pilot's decision to attempt to takeoff in crosswind conditions that exceeded the airplane’s demonstrated crosswind capability.NTSB ERA09CA321Accident · No injuriesData collectionFinal reportCessna 150M · Zebulon, NCThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.NTSB CEN09CA314Accident · No injuriesData collectionFinal reportJabiru J230-SP · Delavan, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB WPR09CA267Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Robbins, CAThe pilot's failure to maintain directional control during the takeoff roll on a rough runway surface.NTSB CEN09CA310Accident · No injuriesData collectionFinal reportLuscombe 8E · Ozona, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR09CA257Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control on the landing roll out.NTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.