# Fatal NTSB investigations: Emergency 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 2 · 86 cases

## Latest cases

- [NTSB GAA26WA016](https://openairdocs.org/ntsb/GAA26WA016.md): Robinson R44 · Bentley, United Kingdom · Accident · 1 fatal · Class 5 · Foreign · Oct 30, 2025 · G-CFNF · Destroyed
- [NTSB ERA24FA365](https://openairdocs.org/ntsb/ERA24FA365.md): Grumman American Avn. AA-5 · Rockmart, GA · Accident · 2 fatal · Class 3 · Field · Final report · Sep 4, 2024 · N9659L · Substantial damage
  > A total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…
- [NTSB GAA24WA145](https://openairdocs.org/ntsb/GAA24WA145.md): Bell 206 · Meico City, Mexico · Accident · 3 fatal · Class 5 · Foreign · Apr 14, 2024 · XP-PIP · Destroyed
- [NTSB ERA24FA102](https://openairdocs.org/ntsb/ERA24FA102.md): Piper PA-24 · Eufaula, AL · Accident · 1 fatal · Class 3 · Field · Final report · Jan 31, 2024 · N5520P · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot’s inadequate fuel planning/management.
- [NTSB GAA23WA140](https://openairdocs.org/ntsb/GAA23WA140.md): Cessna 206 · Chiribiquete National Park, Colombia · Accident · 7 fatal · Class 3 · Foreign · May 1, 2023 · HK2803 · Destroyed
- [NTSB ERA22FA279](https://openairdocs.org/ntsb/ERA22FA279.md): Bell UH-1B · Amherstdale, WV · Accident · 6 fatal · Class 1 · Field · Final report · Jun 22, 2022 · N98F · Destroyed
  > the operator’s failure to adequately inspect the former military turbine powered helicopter, which allowed an engine issue to progress and result in a loss of engine power and a subsequent loss of control after the helicopter struck powerlines during a forced…
- [NTSB GAA22WA050](https://openairdocs.org/ntsb/GAA22WA050.md): Gulfstream GIV · Santo Domingo, Dominican Republic · Accident · 9 fatal · Class 5 · Foreign · Dec 15, 2021 · HI-1050 · Destroyed
- [NTSB WPR22LA061](https://openairdocs.org/ntsb/WPR22LA061.md): Moul Willis RV-3 · Bermuda Dunes, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 11, 2021 · N9YY · Substantial damage
  > The pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.
- [NTSB ERA20LA309](https://openairdocs.org/ntsb/ERA20LA309.md): Piper PA28 · McMinnville, TN · Accident · 3 fatal · Class 3 · Limited · Final report · Sep 8, 2020 · N4166Z · Substantial damage
  > A total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.
- [NTSB WPR20LA131](https://openairdocs.org/ntsb/WPR20LA131.md): Beech 35 · Currie, NV · Accident · 3 fatal · Class 3 · Limited · Final report · Apr 24, 2020 · N8743A · Destroyed
  > The pilot’s failure to maintain airplane control during a forced landing which resulted in a hard landing for reasons that could not be determined based on available evidence.
- [NTSB CEN19WA285](https://openairdocs.org/ntsb/CEN19WA285.md): Rotorway Exec 162F · Herisau, Switzerland · Accident · 1 fatal · Foreign investigation · Aug 24, 2019 · HB-YKJ · Substantial damage
  > On August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…
- [NTSB WPR19FA178](https://openairdocs.org/ntsb/WPR19FA178.md): Maule M7-235B · Sunriver, OR · Accident · 1 fatal · Class 2 · Field · Final report · Jun 22, 2019 · N118G · Substantial damage
  > A partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.
- [NTSB ERA19WA293](https://openairdocs.org/ntsb/ERA19WA293.md): Bell 505 · Kazbegi, Georgia · Accident · 3 fatal · Class 3 · Foreign · Jun 6, 2019 · 4L-ADJ · Destroyed
- [NTSB ANC18LA057](https://openairdocs.org/ntsb/ANC18LA057.md): Aeros Venture 2000 · Bad Axe, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 2018 · N43865 · Substantial damage
  > The pilot's loss of aircraft control for reasons that could not be determined based on the available information.
- [NTSB DCA18WA106](https://openairdocs.org/ntsb/DCA18WA106.md): Canadair CL600 2B16 · Shahr-e Kurd, Iran · Accident · 11 fatal · Foreign investigation · Mar 11, 2018 · TC-TRB · Destroyed
  > The Transportation Safety Board of Canada has informed the NTSB of an accident involving a Challenger 604, which occurred on March 11, 2018, in the Islamic Republic of Iran. All investigative information will be released by the government of Iran.
- [NTSB ERA18WA090](https://openairdocs.org/ntsb/ERA18WA090.md): Neiva EMB-720D · Manaus City, Brazil · Accident · 4 fatal · Foreign investigation · Feb 22, 2018 · PT-VKR · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a NEIVA EMB-720D airplane that occurred on February 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB ERA17FA317](https://openairdocs.org/ntsb/ERA17FA317.md): Schweizer 269C · Medford, NJ · Accident · 2 fatal · Field investigation · Final report · Sep 8, 2017 · N204HF · Substantial damage
  > The pilot's early entry into and failure to maintain rotor rpm during a forced landing autorotation after performing an engine shutdown in flight, which resulted in an uncontrolled descent. Contributing to the accident was the failure of maintenance personnel…
- [NTSB WPR17FA166](https://openairdocs.org/ntsb/WPR17FA166.md): Beech A36TC · Ogden, UT · Accident · 4 fatal · Field investigation · Final report · Jul 26, 2017 · N60WB · Substantial damage
  > A loss of control during takeoff for reasons that could not be determined.
- [NTSB ERA16FA329](https://openairdocs.org/ntsb/ERA16FA329.md): Cessna 172 · Laytonsville, MD · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2016 · N52126 · Destroyed
  > The pilot/mechanic's failure to maintain airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the pilot/mechanic's failure to service the engine…
- [NTSB CEN16FA315](https://openairdocs.org/ntsb/CEN16FA315.md): Hughes 269C · Howe, TX · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2016 · N9277R · Substantial damage
  > The improper execution of an autorotation following the loss of engine power, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor's lack of remedial action during the autorotation.
- [NTSB CEN16FA214](https://openairdocs.org/ntsb/CEN16FA214.md): Cirrus Design SR22 · Marion, IL · Accident · 1 fatal · Field investigation · Final report · Jun 10, 2016 · N508AJ · Destroyed
  > The pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.
- [NTSB ERA16FA150](https://openairdocs.org/ntsb/ERA16FA150.md): Mooney M20K · Ocala, FL · Accident · 1 fatal · Field investigation · Final report · Apr 9, 2016 · N96398 · Substantial damage
  > The pilot's failure to maintain sufficient airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's inadvertent placement of the…
- [NTSB CEN15FA126](https://openairdocs.org/ntsb/CEN15FA126.md): Enstrom 280FX · Erie, CO · Accident · 2 fatal · Field investigation · Final report · Jan 26, 2015 · N86235 · Destroyed
  > An in-flight failure of the helicopter's #2 main rotor spindle due to undetected fatigue cracking, which resulted in an in-flight breakup. Contributing to failure were the nonconforming thread root radius of the spindle and the manufacturer's failure to…
- [NTSB ERA14FA313](https://openairdocs.org/ntsb/ERA14FA313.md): Cessna 182 · Littleton, NC · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2014 · N182PE · Substantial damage
  > Maintenance 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.
- [NTSB CEN14LA202](https://openairdocs.org/ntsb/CEN14LA202.md): Nanchang CJ6 - A · Flushing, MI · Accident · 2 fatal · Limited investigation · Final report · Apr 19, 2014 · N594T · Substantial damage
  > The 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…
- [NTSB CEN14FA173](https://openairdocs.org/ntsb/CEN14FA173.md): Worthington Donald Wayne Sonerai II LT · Highlands Ranch, CO · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2014 · N63917 · Destroyed
  > The pilot’s loss of control during a forced landing following a loss of engine power for reasons that could not be determined due to postimpact fire damage.
- [NTSB CEN14FA035](https://openairdocs.org/ntsb/CEN14FA035.md): Beech C90 · Springdale, AR · Accident · 2 fatal · Field investigation · Final report · Nov 1, 2013 · N269JG · Destroyed
  > A total loss of power to both engines due to fuel exhaustion. Also causal were the pilot’s reliance on the fuel totalizer rather than the fuel quantity gauges to determine the fuel on board and his improper fuel planning.
- [NTSB ERA13FA256](https://openairdocs.org/ntsb/ERA13FA256.md): Piper PA-32R-300 · Macon, GA · Accident · 2 fatal · Field investigation · Final report · May 27, 2013 · N4489F · Destroyed
  > A total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.
- [NTSB CEN13FA075](https://openairdocs.org/ntsb/CEN13FA075.md): Hughes 369 · Childress, TX · Accident · 1 fatal · Field investigation · Final report · Nov 27, 2012 · N28MP · Substantial damage
  > The improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…
- [NTSB CEN13FA044](https://openairdocs.org/ntsb/CEN13FA044.md): Cessna 310 · Stotts City, MO · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2012 · N6BS · Substantial damage
  > The pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…
- [NTSB CEN12FA621](https://openairdocs.org/ntsb/CEN12FA621.md): Robinson Helicopter R22 Beta · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Sep 10, 2012 · N281RG · Substantial damage
  > The pilot's failure to maintain control of the helicopter after a loss of engine power. The reason for the loss of engine power could not be determined because examination did not reveal any anomalies that would have precluded operation.
- [NTSB WPR12FA349](https://openairdocs.org/ntsb/WPR12FA349.md): Cessna P210N · Santa Monica, CA · Accident · 1 fatal · Field investigation · Final report · Aug 11, 2012 · N41KA · Substantial damage
  > The pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…
- [NTSB ERA11WA472](https://openairdocs.org/ntsb/ERA11WA472.md): Agusta AW139 · Brazil · Accident · 4 fatal · Foreign investigation · Aug 19, 2011 · PR-SEK · Substantial damage
  > On August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…
- [NTSB CEN11FA528](https://openairdocs.org/ntsb/CEN11FA528.md): Wright B Flyer Wright B Flyer · Springfield, OH · Accident · 2 fatal · Field investigation · Final report · Jul 30, 2011 · N453WB · Substantial damage
  > The flight crew’s failure to maintain airplane control following a partial loss of engine thrust during cruise flight. Contributing to the accident was the failed weld as a result of incomplete welding on the left propeller shaft, which led to the partial…
- [NTSB ERA11FA414](https://openairdocs.org/ntsb/ERA11FA414.md): Cirrus Design SR22 · Palm Bay, FL · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2011 · N122HB · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…
- [NTSB CEN11FA285](https://openairdocs.org/ntsb/CEN11FA285.md): Hawker-Beechcraft E-55 · De Queen, AR · Accident · 1 fatal · Field investigation · Final report · Apr 15, 2011 · N3959W · Substantial damage
  > The pilot’s loss of control during takeoff for undetermined reasons.
- [NTSB CEN11FA029](https://openairdocs.org/ntsb/CEN11FA029.md): American Champion 8KCAB · Sebewaing, MI · Accident · 2 fatal · Field investigation · Final report · Oct 18, 2010 · N105AC · Substantial damage
  > The pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.
- [NTSB ERA10FA138](https://openairdocs.org/ntsb/ERA10FA138.md): Beech 65 · Lawrenceville, GA · Accident · 1 fatal · Field investigation · Final report · Feb 8, 2010 · N130SP · Substantial damage
  > The failure of both engines for undetermined reasons.
- [NTSB ERA10LA086](https://openairdocs.org/ntsb/ERA10LA086.md): Cox Busby Mustang · Plant City, FL · Accident · 2 fatal · Limited investigation · Final report · Nov 29, 2009 · N72PC · Substantial damage
  > The pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.
- [NTSB WPR09FA459](https://openairdocs.org/ntsb/WPR09FA459.md): Robinson Helicopter R22 Beta · Forest Grove, OR · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2009 · N956SH · Substantial damage
  > The flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.
- [NTSB CEN09WA524](https://openairdocs.org/ntsb/CEN09WA524.md): Beech 99 · Évora, Portugal · Accident · 2 fatal · Foreign investigation · Aug 14, 2009 · F-BTME · Destroyed
  > Under the jurisdiction and control of the Portuguese government.
- [NTSB ERA09FA414](https://openairdocs.org/ntsb/ERA09FA414.md): Hughes 369 · Franklin, PA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2009 · N61735 · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.
- [NTSB ERA09LA356](https://openairdocs.org/ntsb/ERA09LA356.md): Chris Mitchell Titan Tornado · Chadbourn, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 18, 2009 · N259CM · Substantial damage
  > The pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.
- [NTSB ERA09LA263](https://openairdocs.org/ntsb/ERA09LA263.md): Keeley/Tidd MK-1 · Demopolis, AL · Accident · 1 fatal · Limited investigation · Final report · Apr 24, 2009 · N91MK · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a complete loss of engine power resulting in a stall while maneuvering to land. The reason for the loss of engine power was undetermined.
- [NTSB ERA09WA211](https://openairdocs.org/ntsb/ERA09WA211.md): Piper PA-28R · Santo Antonio do Leverger, Brazil · Accident · 3 fatal · Foreign investigation · Feb 1, 2009 · PT-DJA · Destroyed
  > None.
- [NTSB CEN09LA128](https://openairdocs.org/ntsb/CEN09LA128.md): Probst Baby Ace D · Kilgore, TX · Accident · 1 fatal · Limited investigation · Final report · Jan 12, 2009 · N610DD · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning. Contributing to the accident was the pilot's failure to maintain situational awareness, resulting in him being lost.
- [NTSB ERA09LA131](https://openairdocs.org/ntsb/ERA09LA131.md): Piper PA-25-235 · Pensacola, FL · Accident · 1 fatal · Limited investigation · Final report · Jan 6, 2009 · N7160Z · Substantial damage
  > The pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.
- [NTSB ANC09FA001](https://openairdocs.org/ntsb/ANC09FA001.md): Cessna U206C · Anchorage, AK · Accident · 2 fatal · Field investigation · Final report · Oct 1, 2008 · N29109 · Destroyed
  > A loss of engine power during takeoff/initial climb for an undetermined reason, and the pilot's decision to make an abrupt and steep low altitude turn toward an intersecting runway, resulting in an aerodynamic stall and loss of aircraft control.
- [NTSB LAX06FA222](https://openairdocs.org/ntsb/LAX06FA222.md): Raytheon A36 · Somis, CA · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2006 · N615M · Destroyed
  > a ground collision during an emergency landing for undetermined reasons.
- [NTSB ATL05FA135](https://openairdocs.org/ntsb/ATL05FA135.md): Beech V35B · Rock Hill, SC · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2005 · N9JQ · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation and subsequent loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/600/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 = 600)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/600/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.