Fatal NTSB investigations

225 cases where the sequence of events included Off-field or emergency landing.

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\" = '440' 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 ERA15FA254Accident · 3 fatalField investigationFinal reportBeech A36 · Plainville, MAThe total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.Jun 28, 2015 · N5626D · DestroyedNTSB WPR15FA181Accident · 1 fatalField investigationFinal reportBeech F35 · Everett, WAThe partial loss of engine power during takeoff due to debris within the fuel servo, which restricted fuel flow throughout the engine fuel system and resulted in a partial loss of engine power.Jun 10, 2015 · N4224B · Substantial damageNTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…May 23, 2015 · N42BR · DestroyedNTSB ERA15FA208Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Atlanta, GAA partial loss of engine power due to contamination in the fuel manifold, which resulted in a collision with terrain shortly after takeoff.May 8, 2015 · N5802V · DestroyedNTSB ERA15LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Fort Myers, FLThe pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.Mar 9, 2015 · N6514P · Substantial damageNTSB ERA15FA139Accident · 1 fatalField investigationFinal reportAdams Donald L DA1 · Sebring, FLA partial loss of engine power for reasons that could not be determined based on the available evidence.Mar 2, 2015 · N797A · Substantial damageNTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…Jan 9, 2015 · N7ZL · Substantial damageNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damageNTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.Oct 28, 2014 · N70PM · DestroyedNTSB CEN15LA028Accident · 1 fatalLimited investigationFinal reportHuebbe Sonex HB · Plainview, ILThe loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.Oct 26, 2014 · N244HB · Substantial damageNTSB ERA15FA003Accident · 1 fatalField investigationFinal reportMiller Raymond A Sonex Waiex · Palm Coast, FLA total loss of engine power during cruise flight for reasons that could not be determined due to the postaccident condition of the engine and its associated fuel and ignition systems.Oct 3, 2014 · N461MM · Substantial damageNTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.Sep 27, 2014 · N9679H · 2 aircraft · DestroyedNTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.Sep 3, 2014 · N541EM · Substantial damageNTSB CEN14FA468Accident · 2 fatalField investigationFinal reportSchafer Rick W Foxtrot 4 · Abilene, TXThe pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…Aug 31, 2014 · N729AR · Substantial damageNTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.Aug 23, 2014 · N334DF · DestroyedNTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasAug 18, 2014 · N340MM · DestroyedNTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…Jul 31, 2014 · N147MP · Substantial damageNTSB WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.Jul 28, 2014 · N29MM · Substantial damageNTSB ERA14LA362Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s…Jul 27, 2014 · N8826C · Substantial damageNTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…Jul 23, 2014 · N47149 · Substantial damageNTSB ERA14FA313Accident · 1 fatalField investigationFinal reportCessna 182 · Littleton, NCMaintenance personnel's application of sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in internal failure of the engine due to the loss of case bolt torque.Jun 27, 2014 · N182PE · Substantial damageNTSB WPR14FA226Accident · 2 fatalField investigationFinal reportNorth American AT 6C · Buckley, WAThe loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.Jun 4, 2014 · N13372 · Substantial damageNTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.May 23, 2014 · N8890L · Substantial damageNTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…May 17, 2014 · N40TC · Substantial damageNTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…Apr 19, 2014 · N594T · Substantial damageNTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.Apr 6, 2014 · N13HG · Substantial damageNTSB ERA14FA162Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Safety Harbor, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.Mar 22, 2014 · N8309L · Substantial damageNTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…Mar 21, 2014 · N717RR · Substantial damageNTSB ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…Dec 18, 2013 · N3705Z · Substantial damageNTSB ERA14FA066Accident · 1 fatalField investigationFinal reportTexas Helicopter M74L · Sebring, FLA partial loss of engine power as a result of contamination of the engine’s fuel supply, and the pilot’s impaired performance due to his use of diphenhydramine, which resulted in his inability to complete a forced or precautionary autorotative landing…Dec 6, 2013 · N1001N · DestroyedNTSB ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNov 10, 2013 · N432BC · DestroyedNTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.Jul 25, 2013 · N513GC · DestroyedNTSB WPR13FA294Accident · 1 fatalField investigationFinal reportCessna 172 · Birdseye, UT***This report was modified on August 18, 2015. Please see the docket for this accident to view the original report.*** The operator's improper installation of a supplemental electrical power supply, which caused a short circuit due to inadequate vibration…Jun 27, 2013 · N4459R · Substantial damageNTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…Apr 26, 2013 · PR-LJI · Substantial damageNTSB ERA13FA184Accident · 2 fatalField investigationFinal reportLancair LC42 - 550FG · Winston-Salem, NCThe pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…Mar 31, 2013 · N6506L · DestroyedNTSB WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…Mar 28, 2013 · N6018X · Substantial damageNTSB WPR13FA141Accident · 1 fatalField investigationFinal reportMaule M5 · Woodinville, WAThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.Mar 9, 2013 · N17PR · Substantial damageNTSB ERA13FA131Accident · 1 fatalField investigationFinal reportCessna T337C · New Smyrna Beach, FLMaintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…Feb 13, 2013 · N2576S · DestroyedNTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…Jan 13, 2013 · N4975S · Substantial damageNTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…Dec 24, 2012 · N78WM · Substantial damageNTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…Nov 18, 2012 · N4267R · Substantial damageNTSB CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.Nov 6, 2012 · N793FE · Substantial damageNTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.Oct 25, 2012 · N55620 · Substantial damageNTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…Oct 20, 2012 · N80823 · Substantial damageNTSB ERA12LA584Accident · 1 fatalLimited investigationFinal reportKeuthan Buccaneer II · Granite Quarry, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 30, 2012 · N710WP · Substantial damageNTSB ERA12FA526Accident · 1 fatalField investigationFinal reportBeech B24R · Dayton, VAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the noninstrument-rated pilot's decision to attempt a visual flight rules flight in instrument meteorological conditions…Aug 26, 2012 · N9200S · Substantial damageNTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.Aug 19, 2012 · N5542Z · Substantial damageNTSB ERA12FA508Accident · 2 fatalField investigationFinal reportBeech A36TC · Clifton Park, NYA total loss of engine power for reasons that could not be determined during the postaccident investigation and testing.Aug 15, 2012 · N678DR · Substantial damageNTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…Jul 6, 2012 · PT-ENG · DestroyedNTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…Jun 30, 2012 · N33CG · Substantial damage