# Fatal NTSB investigations: Uncontrolled descent

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 37 · 1,831 cases

## Latest cases

- [NTSB WPR26FA108](https://openairdocs.org/ntsb/WPR26FA108.md): Vans RV-8 · Hurricane, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 28, 2026 · N80AR · Substantial damage
  > On February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…
- [NTSB WPR25FA147](https://openairdocs.org/ntsb/WPR25FA147.md): Paul Berkovitz Vans RV-10 · Simi Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 3, 2025 · N626PB · Destroyed
  > On May 3, 2025, about 1350 Pacific daylight time, an experimental amateur-built Van’s RV-10, N626PB, was destroyed when it was involved in an accident near Simi Valley, California. The pilot and passenger were fatally injured. The airplane was operated as a…
- [NTSB ERA25FA179](https://openairdocs.org/ntsb/ERA25FA179.md): Cessna 180 · Trilla, IL · Accident · 4 fatal · Class 3 · Field · Preliminary report · Apr 19, 2025 · N4679U · Destroyed
  > On April 19, 2025, at 1016 central daylight time, a Cessna 180G, N4679U, was destroyed when it was involved in an accident near Trilla, Illinois. The private pilot and three passengers were fatally injured. The airplane was operated under Title 14 Code of…
- [NTSB GAA25WA176](https://openairdocs.org/ntsb/GAA25WA176.md): Socata TB 20 · Vaduleni, Moldova · Accident · 1 fatal · Class 5 · Foreign · Oct 27, 2024 · D-EMRT · Destroyed
- [NTSB GAA24WA250](https://openairdocs.org/ntsb/GAA24WA250.md): Beech 95A55 · Birigui, Brazil · Accident · 3 fatal · Class 5 · Foreign · Aug 3, 2024 · PS-RCM · Destroyed
- [NTSB ERA22FA262](https://openairdocs.org/ntsb/ERA22FA262.md): Enstrom F28 · Greenville, OH · Accident · 2 fatal · Class 3 · Field · Final report · Jun 7, 2022 · N600TA · Substantial damage
  > An impact with terrain for undetermined reasons.
- [NTSB ERA16FA194](https://openairdocs.org/ntsb/ERA16FA194.md): Jihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VA · Accident · 2 fatal · Field investigation · Final report · May 24, 2016 · N440JM · Destroyed
  > The pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…
- [NTSB ERA16FA001](https://openairdocs.org/ntsb/ERA16FA001.md): Piper PA32R · Westminster, SC · Accident · 4 fatal · Field investigation · Final report · Oct 2, 2015 · N782TM · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB CEN15WA152](https://openairdocs.org/ntsb/CEN15WA152.md): Avions Robin Robin DR 400/140 B · Yverdon LSGY, Switzerland · Accident · 2 fatal · Foreign investigation · Feb 23, 2015 · HB-KDD · Destroyed
- [NTSB CEN15FA141](https://openairdocs.org/ntsb/CEN15FA141.md): Richard Lacourse Wheeler Express · Kersey, CO · Accident · 2 fatal · Field investigation · Final report · Feb 11, 2015 · N564ER · Destroyed
  > The pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…
- [NTSB WPR13FA116](https://openairdocs.org/ntsb/WPR13FA116.md): Cessna 172S · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2013 · N328SP · Destroyed
  > The pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.
- [NTSB ERA13FA101](https://openairdocs.org/ntsb/ERA13FA101.md): Piper PA-30 · Jasper, AL · Accident · 3 fatal · Field investigation · Final report · Jan 2, 2013 · N7700Y · Destroyed
  > The student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.
- [NTSB CEN12FA251](https://openairdocs.org/ntsb/CEN12FA251.md): Cirrus Design SR22 · Newcomerstown, OH · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2012 · N110EB · Substantial damage
  > The pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.
- [NTSB CEN12FA108](https://openairdocs.org/ntsb/CEN12FA108.md): Piper PA-32-260 · Bryan, TX · Accident · 5 fatal · Field investigation · Final report · Dec 20, 2011 · N3590T · Substantial damage
  > The pilot’s inadvertent encounter with severe weather, which resulted in the airplane’s left wing failing in positive overload. Contributing to the accident was the pilot’s reliance on outdated weather information that he received on his in-cockpit…
- [NTSB WPR12FA044](https://openairdocs.org/ntsb/WPR12FA044.md): Mooney M20M · Pomona, CA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2011 · N741SB · Substantial damage
  > The pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.
- [NTSB WPR11FA155](https://openairdocs.org/ntsb/WPR11FA155.md): Muse KR2 · Newberry Springs, CA · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2011 · N122B · Substantial damage
  > The airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.
- [NTSB ERA10WA116](https://openairdocs.org/ntsb/ERA10WA116.md): Piper PA-32-300 · Bimini, Bahamas, Bahamas · Accident · 3 fatal · Foreign investigation · Jan 17, 2010 · N4219R · Destroyed
  > On January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…
- [NTSB ERA09WA166](https://openairdocs.org/ntsb/ERA09WA166.md): Embraer EMB110 · Coari, Brazil · Accident · 24 fatal · Foreign investigation · Feb 7, 2009 · PR-SAE · Destroyed
  > On February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…
- [NTSB WPR09LA032](https://openairdocs.org/ntsb/WPR09LA032.md): Universal Globe · Wallace, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2008 · N80715 · Destroyed
  > The pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.
- [NTSB NYC08LA224](https://openairdocs.org/ntsb/NYC08LA224.md): Aero Vodochody Aero. Works L-29 Delfin · Millville, NJ · Accident · 2 fatal · Limited investigation · Final report · Jun 22, 2008 · N29DJ · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a clogged fuel filter that was not identified due to the pilot's inadequate preflight inspection.
- [NTSB SEA08LA072](https://openairdocs.org/ntsb/SEA08LA072.md): Wooters Lancair ES · Albany, OR · Accident · 3 fatal · Limited investigation · Final report · Feb 8, 2008 · N329BW · Substantial damage
  > The pilot-in-command's failure to maintain aircraft control while in cruise flight. Contributing to the accident were inadequate planning/decision, icing conditions, and continued flight into known icing conditions.
- [NTSB LAX08FA047](https://openairdocs.org/ntsb/LAX08FA047.md): Beechcraft V35B · Selma, CA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 2008 · N4662M · Substantial damage
  > The pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.
- [NTSB CHI07LA086](https://openairdocs.org/ntsb/CHI07LA086.md): Camair 480 · East Liberty, OH · Accident · 1 fatal · Limited investigation · Final report · Mar 8, 2007 · N209 · Destroyed
  > The uncontrolled descent for undetermined reasons.
- [NTSB CHI07FA046](https://openairdocs.org/ntsb/CHI07FA046.md): Rockwell International 114 · Jasper, TN · Accident · 2 fatal · Field investigation · Final report · Dec 26, 2006 · N55MB · Substantial damage
  > The pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…
- [NTSB SEA07FA035](https://openairdocs.org/ntsb/SEA07FA035.md): Beech D95A · Gilroy, CA · Accident · 3 fatal · Field investigation · Final report · Dec 18, 2006 · N144PG · Destroyed
  > The certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.
- [NTSB ATL03FA104](https://openairdocs.org/ntsb/ATL03FA104.md): Piper PA-44-180 · Battleboro, NC · Accident · 3 fatal · Field investigation · Final report · Jun 8, 2003 · N578TP · Substantial damage
  > The certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.
- [NTSB ATL03FA041](https://openairdocs.org/ntsb/ATL03FA041.md): Piper PA-24-250 · Florence, SC · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2003 · N5587P · Destroyed
  > The pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.
- [NTSB FTW03FA064](https://openairdocs.org/ntsb/FTW03FA064.md): Beech BE-58 · Egypt, AR · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2002 · N5TV · Destroyed
  > The pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.
- [NTSB DEN02LA109](https://openairdocs.org/ntsb/DEN02LA109.md): Sabian Rans S-12XL · Mexican Hat, UT · Accident · 2 fatal · Limited investigation · Final report · Sep 22, 2002 · N725ST · Destroyed
  > the pilot's inadequate in-flight planning and decision making (flying up a canyon with insufficient altitude) which resulted in an inadvertent stall/mush, and the pilot's failure to follow the proper emergency procedures for activating his Ballistic Recovery…
- [NTSB CHI02FA172](https://openairdocs.org/ntsb/CHI02FA172.md): Cessna 182A · Foster City, MI · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2002 · N5034D · Destroyed
  > The incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.
- [NTSB CHI02LA121](https://openairdocs.org/ntsb/CHI02LA121.md): Yoder GP-4 · Mount Pleasant, MI · Accident · 2 fatal · Limited investigation · Final report · May 5, 2002 · N59JY · Destroyed
  > The inadvertent stall/spin by the pilot-in-command.
- [NTSB IAD01FA097](https://openairdocs.org/ntsb/IAD01FA097.md): Cessna 150 · Mcgaheysville, VA · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2001 · N63351 · Substantial damage
  > The flight instructor's failure to recover from a spin for undetermined reasons.
- [NTSB MIA01LA181](https://openairdocs.org/ntsb/MIA01LA181.md): Floback Lancair 4 · Kissimmee, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 11, 2001 · N720BF · Destroyed
  > the failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.
- [NTSB NYC01FA089](https://openairdocs.org/ntsb/NYC01FA089.md): Cessna 182Q · Dixon, KY · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2001 · N4752N · Destroyed
  > The pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.
- [NTSB DCA01MA017](https://openairdocs.org/ntsb/DCA01MA017.md): Beech 200 · Strasburg, CO · Accident · 10 fatal · Class 1 · Major · Final report · Jan 27, 2001 · N81PF · Destroyed
  > The pilot’s spatial disorientation resulting from his failure to maintain positive manual control of the airplane with the available flight instrumentation. Contributing to the cause of the accident was the loss of a.c. electrical power during instrument…
- [NTSB LAX01FA036](https://openairdocs.org/ntsb/LAX01FA036.md): Piper PA28-200 · Teec Nos Pos, AZ · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2000 · N3032R · Destroyed
  > In-flight loss of control resulting in airframe structural failure. Contributing to the accident was the pilot's inadvertant visual flight into instrument meteorological conditions.
- [NTSB MIA00FA118](https://openairdocs.org/ntsb/MIA00FA118.md): Piper PA-24-260 · Panama City, FL · Accident · 1 fatal · Field investigation · Final report · Mar 27, 2000 · N9204P · Destroyed
  > The pilot experiencing spatial disorientation while reversing course during a dark night while over water which resul;ted in an in-flight collision with water. A factor was the dark night lighting conditions.
- [NTSB LAX00LA141](https://openairdocs.org/ntsb/LAX00LA141.md): Birx Vans RV-6 · Taft, CA · Accident · 2 fatal · Limited investigation · Final report · Mar 27, 2000 · N986DB · Destroyed
  > The in-flight collision with the ground for undetermined reasons.
- [NTSB MIA00FA043](https://openairdocs.org/ntsb/MIA00FA043.md): Piper PA-32RT-300T · Pelham, AL · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1999 · N39696 · Destroyed
  > The student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.
- [NTSB MIA99FA095](https://openairdocs.org/ntsb/MIA99FA095.md): Beech AT11/18 · Tampa, FL · Accident · 2 fatal · Field investigation · Final report · Feb 27, 1999 · N65860 · Destroyed
  > the pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to allow for recovery.
- [NTSB SEA98FA081](https://openairdocs.org/ntsb/SEA98FA081.md): Cessna P206C · Dubois, ID · Accident · 3 fatal · Field investigation · Final report · May 21, 1998 · N8669Z · Substantial damage
  > Attempted VFR flight into IMC and a loss of aircraft control. An inadequate weather evaluation and drug impairment were factors.
- [NTSB FTW98LA098](https://openairdocs.org/ntsb/FTW98LA098.md): Poling Keleher Lark KR1B · Georgetown, TX · Accident · 1 fatal · Limited investigation · Final report · Jan 14, 1998 · N82BP · Substantial damage
  > The pilot's failure to maintain aircraft control. A contributing factor was the pilot's physical impairment due to drugs.
- [NTSB SEA95LA070](https://openairdocs.org/ntsb/SEA95LA070.md): Quicksilver MXL2 · Hildale, UT · Accident · 2 fatal · Limited investigation · Final report · Mar 13, 1995 · UNREG · Destroyed
  > The pilot's failure to maintain adequate airspeed while banking the airplane. This led to an unrecoverable aerodynamic stall in close proximity to the ground. Factors contributing to the accident are the pilot exceeding the airplane's weight and balance…
- [NTSB BFO94LA097](https://openairdocs.org/ntsb/BFO94LA097.md): Falen Commander 503 · Georgetown, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 12, 1994 · UNREG · Destroyed
  > The gyroplane's uncontrolled descent into terrain due to undetermined reasons.
- [NTSB LAX94LA098](https://openairdocs.org/ntsb/LAX94LA098.md): Piper PA-28-180 · Borrego Springs, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 18, 1994 · N56811 · Destroyed
  > The pilot's intentional decision to abandon the airplane and allow it to fly unattended.
- [NTSB FTW93FA137](https://openairdocs.org/ntsb/FTW93FA137.md): Bell 206B III · Austin, TX · Accident · 2 fatal · Field investigation · Final report · Apr 23, 1993 · N2205X · Destroyed
  > Aircraft control not maintained by pilot in command. Factors were unfavorable winds and pilot's lack of recent experience.
- [NTSB LAX92LA153](https://openairdocs.org/ntsb/LAX92LA153.md): Beech F33A · Payson, AZ · Accident · 2 fatal · Limited investigation · Final report · Mar 27, 1992 · N8000J · Destroyed
  > The pilot's poor preflight planning/preparation by intentionally flying into known adverse weather and his poor in-flight decision by not flying to an alternate airport when the airplane began to encounter icing. Contributing to this accident was the icing…
- [NTSB LAX91LA391](https://openairdocs.org/ntsb/LAX91LA391.md): Schweizer 269C · Kahului, HI · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1991 · N6128Q · Destroyed
  > The student pilot entry into an uncontrolled descent while attempting to perform an autorotation. The student pilot's lack of total experience was a factor in the accident.
- [NTSB CHI91FA266](https://openairdocs.org/ntsb/CHI91FA266.md): Bellanca 17-30A · Boyne City, MI · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1991 · N6704V · Substantial damage
  > The pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..
- [NTSB FTW91FA144](https://openairdocs.org/ntsb/FTW91FA144.md): Piper PA-28RT-201T · Midland, TX · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1991 · N8144J · Destroyed
  > The pilot's inability to control the airplane due to his physiological incaapacitation. A factor was the pilot's impairment due to the usage of pain medications.

Next page: https://openairdocs.org/ntsb-phases/650/cases.md?fatal=1&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 650)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/650/cases?fatal=1

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.