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.

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.Jul 19, 2009 · N425BC · Substantial damageNTSB WPR09LA354Accident · Serious injuriesLimited investigationFinal reportLeider T-18 · Carson City, NVThe pilot’s failure to maintain directional control during landing.Jul 18, 2009 · N37GL · Substantial damageNTSB 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.Jul 18, 2009 · N2991D · Substantial damageNTSB 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.Jul 16, 2009 · N4UA · Substantial damageNTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.Jul 14, 2009 · N7418W · Substantial damageNTSB CEN09CA436Accident · No injuriesData collectionFinal reportTaylorcraft BC-D · Joplin, MOThe pilot's failure to maintain directional control during the landing roll.Jul 14, 2009 · N96660 · Substantial damageNTSB CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.Jul 13, 2009 · N79908 · Substantial damageNTSB 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.Jul 12, 2009 · N408RA · Substantial damageNTSB CEN09CA433Accident · No injuriesData collectionFinal reportAero Commander 680-F · Angel Fire, NMThe pilot's failure to maintain directional control during the initial takeoff.Jul 11, 2009 · N70QT · Substantial damageNTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.Jul 10, 2009 · N199CT · Substantial damageNTSB 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.Jul 8, 2009 · N18BT · Substantial damageNTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.Jul 5, 2009 · N3198D · Substantial damageNTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.Jul 5, 2009 · N1431C · Substantial damageNTSB 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.Jul 4, 2009 · N32132 · Substantial damageNTSB ERA09CA386Accident · No injuriesData collectionFinal reportChampion 7AC · Westminster, MDThe pilot's failure to properly set the throttle for start.Jul 3, 2009 · N1397E · Substantial damageNTSB CEN09IA438Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Put-In-Bay, OHThe pilot's failure to maintain directional control while landing with a crosswind.Jul 3, 2009 · N708RW · Minor damageNTSB CEN09CA411Accident · No injuriesData collectionFinal reportCessna 172N · Benton, ARThe student pilot's failure to maintain directional control during takeoff.Jul 2, 2009 · N5238E · Substantial damageNTSB ERA09CA374Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Quinton, VAA loss of directional control on landing for undetermined reasons.Jun 29, 2009 · N38978 · Substantial damageNTSB CEN09CA395Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Pittsburg, KSThe pilot's loss of directional control resulting in a ground-loop.Jun 27, 2009 · N702KB · Substantial damageNTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.Jun 24, 2009 · N67797 · Substantial damageNTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.Jun 24, 2009 · N1736 · DestroyedNTSB CEN09CA420Accident · No injuriesData collectionFinal reportAviat Husky · Greenfield, INThe pilot failed to maintain directional control of the airplane during the takeoff roll.Jun 23, 2009 · N263AL · Substantial damageNTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · Substantial damageNTSB 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.Jun 22, 2009 · N5824D · Substantial damageNTSB 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.Jun 22, 2009 · N734EN · Substantial damageNTSB 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.Jun 19, 2009 · N773JM · Substantial damageNTSB 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.Jun 18, 2009 · N95144 · Substantial damageNTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.Jun 15, 2009 · N9010R · Substantial damageNTSB CEN09CA362Accident · No injuriesData collectionFinal reportAirborne Windsports PTY XT-912 · Alamogordo, NMThe failure of the pilot to maintain directional control while landing with gusting winds.Jun 15, 2009 · N594VZ · Substantial damageNTSB 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.Jun 15, 2009 · N2162Z · Substantial damageNTSB 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.Jun 14, 2009 · N7544E · Substantial damageNTSB ERA09CA350Accident · No injuriesData collectionFinal reportBeech C17B · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jun 14, 2009 · N47024 · Substantial damageNTSB 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.Jun 12, 2009 · N5504E · Substantial damageNTSB 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.Jun 11, 2009 · N2783D · Substantial damageNTSB 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.Jun 9, 2009 · N55EC · Substantial damageNTSB ERA09LA330Accident · No injuriesLimited investigationFinal reportYakovlev/Day YAK-11 · Culpeper, VAThe pilot’s failure to maintain directional control during landing.Jun 8, 2009 · N7YK · Substantial damageNTSB CEN09CA346Accident · No injuriesData collectionFinal reportMeyers OTW · Haskell, TXThe pilot's failure to maintain directional control while landing in a crosswind.Jun 8, 2009 · N34335 · Substantial damageNTSB WPR09CA278Accident · No injuriesData collectionFinal reportCessna 180J · Bellingham, WAThe pilot's failure to maintain directional control during landing.Jun 7, 2009 · N5101Y · Substantial damageNTSB ANC09CA050Accident · No injuriesData collectionFinal reportDe Havilland DHC-2 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff.Jun 7, 2009 · N915RC · Substantial damageNTSB ERA09CA327Accident · No injuriesData collectionFinal reportMeuer Mark SA900 V ST · Winchester, TNThe malfunction of the right brake during landing rollout.Jun 6, 2009 · N675MM · Substantial damageNTSB ANC09CA055Accident · No injuriesData collectionFinal reportChampion 7ECA · Nome, AKThe pilot's failure to maintain directional control during an off- airport landing.Jun 3, 2009 · N2532F · Substantial damageNTSB WPR09CA275Accident · No injuriesData collectionFinal reportCessna 172S · Tooele, UTThe pilot's failure to maintain directional control during landing.Jun 2, 2009 · N5262Y · Substantial damageNTSB 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.May 31, 2009 · N9955J · Substantial damageNTSB ERA09CA321Accident · No injuriesData collectionFinal reportCessna 150M · Zebulon, NCThe pilot’s failure to maintain directional control of the airplane during landing.May 30, 2009 · N7614U · Substantial damageNTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.May 24, 2009 · N55MF · Substantial damageNTSB 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.May 24, 2009 · N685J · Substantial damageNTSB 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.May 23, 2009 · N3094L · Substantial damageNTSB CEN09CA310Accident · No injuriesData collectionFinal reportLuscombe 8E · Ozona, TXThe pilot's failure to maintain directional control of the airplane during landing.May 21, 2009 · N2450K · Substantial damageNTSB 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.May 20, 2009 · N1591A · Substantial damageNTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.May 18, 2009 · N70083 · Substantial damage