Fatal NTSB investigations

12 cases where NTSB found Conditions/weather/phenomena, general.

Cases per year

20082026
Fatal NTSB investigations per year, 2008–2026: 12 cases
20081
20091
20101
20112
20161
20191
20202
20212
20241

Latest cases

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030300'))
  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 ERA24FA110Accident · 2 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Naples, FLCorrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…Feb 9, 2024 · N823KD · DestroyedNTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.Dec 31, 2021 · N6796N · Substantial damageNTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.Nov 17, 2021 · N802NZ · Substantial damageNTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…Mar 3, 2020 · N43368 · DestroyedNTSB ANC20FA017Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32R · Tuntutuliak, AKThe pilot's continued visual flight rules flight into reduced visibility, including likely flat light and/or white out conditions, which resulted in a controlled flight into terrain. Contributing to the accident were the operator’s inadequate operational…Feb 6, 2020 · N7632C · Substantial damageNTSB WPR19FA183Accident · 2 fatalClass 3 · FieldFinal reportSchempp Hirth Arcus · Ephraim, UTThe pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.Jul 1, 2019 · N215MM · DestroyedNTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…Jan 14, 2016 · N2025D · DestroyedNTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.Apr 22, 2011 · N580EA · DestroyedNTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.Mar 20, 2011 · N50MC · Substantial damageNTSB WPR10LA356Accident · 1 fatalLimited investigationFinal reportParker RS-15 Sailplane · Marysvale, UTThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.Jul 17, 2010 · N15LQ · Substantial damageNTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…Feb 13, 2009 · N200WQ · DestroyedNTSB DEN08FA092Accident · 1 fatalField investigationFinal reportMcDonnell Douglas Helicopter C MD 500E · Sunrise Beach, MOThe loss of tail rotor effectiveness and the pilot's failure to regain aircraft control. Contributing to the accident was the pilot's decision to fly in known adverse weather conditions and the gusty winds generated from convective outflow. Contributing to…May 26, 2008 · N686F · Substantial damage