Fatal NTSB investigations

70 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.\"highestInjuryLevel\" = 'Fatal'
    AND 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.

NTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.Sep 1, 2012 · N221DV · Substantial damageNTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.Jul 11, 2012 · N206VR · Substantial damageNTSB CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.Mar 28, 2012 · N34WC · Substantial damageNTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.Mar 15, 2012 · N7700T · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB ANC11FA037Accident · 5 fatalField investigationFinal reportCessna 180 · Chugiak, AKThe pilot's loss of control of the airplane during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in make and model, his lack of currency in FAA required takeoffs and landings, and his…May 27, 2011 · N4955A · Substantial damageNTSB ERA11LA263Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass Aquilla · Starke, FLThe pilot's loss of airplane control while taxiing, which resulted in the weight-shift-controlled airplane becoming inadvertently airborne and subsequently impacting the ground. Contributing to the accident was the pilot's lack of experience in the make and…Apr 23, 2011 · N94370 · Substantial damageNTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.Sep 20, 2010 · N56078 · Substantial damageNTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…Jul 24, 2010 · N7812K · Substantial damageNTSB ERA10LA365Accident · 1 fatalLimited investigationFinal reportTexas Air Ventures Comp AIR 8 · Mount Pleasant, SCThe pilot's failure to retrim the airplane and maintain aircraft control during an aborted landing, which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.Jul 19, 2010 · N882X · Substantial damageNTSB WPR10LA354Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe pilot's loss of directional control while attempting to move the helicopter laterally without first lifting it fully off its landing platform.Jul 16, 2010 · N944DW · Substantial damageNTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.Jul 12, 2010 · N527MJ · Substantial damageNTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damageNTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.Aug 23, 2009 · N352JB · Substantial damageNTSB CEN09LA444Accident · 1 fatalLimited investigationFinal reportBeech TC-45J · Verdel, NEThe pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…Jul 19, 2009 · N6688 · DestroyedNTSB ERA09LA258Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pinehurst, GAThe pilot's failure to maintain aircraft control for undetermined reasons.Apr 23, 2009 · N4789Q · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB WPR09LA057Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · Santa Clarita, CAThe helicopter's encounter with a gusty crosswind condition during engine start that exceeded the helicopter's demonstrated wind envelope.Dec 17, 2008 · N267KA · Substantial damageNTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.Oct 20, 2008 · N201EN · DestroyedNTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.Jul 9, 2008 · N4450E · Substantial damage