# Final 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 10 · 469 cases

## Latest cases

- [NTSB ERA26LA327](https://openairdocs.org/ntsb/ERA26LA327.md): Robinson Helicopter R22 Beta · McMinnville, TN · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 3, 2026 · N276SH · Substantial damage
  > The flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.
- [NTSB CEN26LA181](https://openairdocs.org/ntsb/CEN26LA181.md): Hughes 369HS · Durango, CO · Accident · No injuries · Class 4 · Limited · Final report · May 7, 2026 · N926ES · Substantial damage
  > The flight instructor’s inadequate supervision of the pilot receiving the instruction and the pilot’s improper recovery from a practice autorotation in shifting wind conditions, which resulted in a hard landing.
- [NTSB ERA26LA170](https://openairdocs.org/ntsb/ERA26LA170.md): Bell 407 · Jacksonville, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 11, 2026 · N314JP · Substantial damage
  > The pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.
- [NTSB ERA26LA026](https://openairdocs.org/ntsb/ERA26LA026.md): Eurocopter AS350 · Wetumpka, AL · Accident · No injuries · Class 4 · Limited · Final report · Oct 23, 2025 · N545HF · Substantial damage
  > The pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.
- [NTSB CEN26LA027](https://openairdocs.org/ntsb/CEN26LA027.md): Robinson Helicopter R22 · Springfield, MO · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 21, 2025 · N74583 · Substantial damage
  > The pilot’s failure to maintain directional control and the flight instructor’s lack of proper remedial action during the practice autorotation that resulted in the helicopter impacting terrain. Contributing to the accident was the presence of the gusting…
- [NTSB CEN25LA380](https://openairdocs.org/ntsb/CEN25LA380.md): Bell 407 · Decatur, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 16, 2025 · N407WA · Substantial damage
  > The instructor candidate’s erroneous operation of the throttle during an autorotation from altitude with power recovery, which resulted in a hard landing.
- [NTSB CEN25LA381](https://openairdocs.org/ntsb/CEN25LA381.md): Bell Helicopter Textron Canada 505 · Fort Worth, TX · Accident · No injuries · Class 4 · Limited · Final report · Aug 27, 2025 · N505GR · Substantial damage
  > The manufacturer flight instructor’s failure to maintain proper airspeed and a proper descent rate during a demonstrated hover out of ground effect (HOGE) autorotation, which resulted in a hard landing. Contributing to the accident was the manufacturer flight…
- [NTSB WPR25LA189](https://openairdocs.org/ntsb/WPR25LA189.md): American Eurocopter AS350B3 · San Luis, AZ · Accident · No injuries · Class 4 · Limited · Final report · Jun 25, 2025 · N3951A · Substantial damage
  > The pilot receiving instruction’s failure to properly recover the helicopter during an autorotative landing and the instructor pilot’s failure to intervene, which resulted in a hard landing.
- [NTSB WPR25LA101](https://openairdocs.org/ntsb/WPR25LA101.md): Hughes OH-6A · Santa Teresa, NM · Accident · No injuries · Class 3 · Limited · Final report · Feb 22, 2025 · N4191T · Substantial damage
  > The flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.
- [NTSB CEN25LA084](https://openairdocs.org/ntsb/CEN25LA084.md): Bell Helicopter Textron Canada 505 · Lago Vista, TX · Accident · No injuries · Class 4 · Limited · Final report · Nov 11, 2024 · N1243Y · Substantial damage
  > The flight instructor’s improper recovery from a practice autorotation which resulted in a hard landing.
- [NTSB CEN25LA003](https://openairdocs.org/ntsb/CEN25LA003.md): Schweizer 269C · Montrose, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2024 · N656RB · Substantial damage
  > A loss of engine power during a demonstrated autorotation due to an improperly adjusted air-fuel mixture or idle setting. Contributing to the accident was the pilot’s failure to perform the required idle check during previous flights in higher elevation areas.
- [NTSB CEN24LA377](https://openairdocs.org/ntsb/CEN24LA377.md): Mcdonnell Douglas Helicopter 369E · Manvel, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 30, 2024 · N8372F · Substantial damage
  > The pilot’s improper recovery from a practice autorotation which resulted in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.
- [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 ENG24LA028](https://openairdocs.org/ntsb/ENG24LA028.md): Bell 407 · Oktaha, OK · Incident · No injuries · Class 3 · Limited · Final report · Jul 26, 2024 · N793SF · Minor damage
  > The loss of engine power due to high cycle fatigue failure of a power turbine stage 3 turbine wheel blade. The resulting engine imbalance caused a decoupling of the gas producer stage 1 and stage 2 turbine wheels leading to a stage 1 turbine overspeed and…
- [NTSB WPR24LA241](https://openairdocs.org/ntsb/WPR24LA241.md): Robinson Helicopter R44 II · Herriman, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2024 · N6960 · Substantial damage
  > A hard landing following a total loss of engine power due to fuel starvation as a result of the improper idle setting of the helicopter’s engine. Contributing to the loss of engine power was the instructor’s reduction of engine power past that recommended by…
- [NTSB ANC24LA045](https://openairdocs.org/ntsb/ANC24LA045.md): Cessna 206 · King Salmon, AK · Accident · No injuries · Class 3 · Limited · Final report · Jun 7, 2024 · N756CL · Substantial damage
  > A partial loss of engine power due to detonation/preignition of the No. 1 cylinder for reasons that could not be determined.
- [NTSB WPR24LA183](https://openairdocs.org/ntsb/WPR24LA183.md): Robinson Helicopter R22 Beta · Maricopa, AZ · Accident · No injuries · Class 4 · Limited · Final report · Jun 6, 2024 · N7514V · Substantial damage
  > The flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.
- [NTSB ERA24LA215](https://openairdocs.org/ntsb/ERA24LA215.md): Hughes 369 · Crestview, FL · Accident · No injuries · Class 4 · Limited · Final report · May 10, 2024 · N969VS · Substantial damage
  > The pilot’s improper flare, which resulted in a hard landing and the main rotor blades contacting the tail boom.
- [NTSB ERA24LA201](https://openairdocs.org/ntsb/ERA24LA201.md): Stinson 108 · Beach City, OH · Accident · No injuries · Class 4 · Limited · Final report · Apr 25, 2024 · N97517 · Substantial damage
  > A total loss of engine power due to the due to the pilot’s delayed application of carburetor heat.
- [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 ERA24LA045](https://openairdocs.org/ntsb/ERA24LA045.md): Bell 407 · Chesterfield, VA · Accident · No injuries · Class 4 · Limited · Final report · Nov 16, 2023 · N26VA · Substantial damage
  > A hard landing, which resulted in a main rotor strike of the left vertical stablizer.
- [NTSB CEN24LA004](https://openairdocs.org/ntsb/CEN24LA004.md): Robinson Helicopter R44 · Hochatown, OK · Accident · No injuries · Class 3 · Limited · Final report · Oct 1, 2023 · N379SH · Substantial damage
  > A total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.
- [NTSB CEN23LA404](https://openairdocs.org/ntsb/CEN23LA404.md): Mcdonnell Douglas Helicopter 369E · Arcola, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2023 · N8372F · Substantial damage
  > The instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.
- [NTSB CEN23LA389](https://openairdocs.org/ntsb/CEN23LA389.md): Mcdonnell Douglas Heli 530FF · Liberty Hill, TX · Accident · No injuries · Class 4 · Limited · Final report · Aug 31, 2023 · N530JR · Substantial damage
  > The pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.
- [NTSB WPR23LA295](https://openairdocs.org/ntsb/WPR23LA295.md): Fish Larry W Lancair 360 · Renton, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 31, 2023 · N68XA · Substantial damage
  > A loss of electrical power due to low battery voltage, which resulted in an inflight shut down of the capacitor discharge ignition system and a loss of engine power. Contributing to the accident was the pilot’s failure to switch batteries after the electrical…
- [NTSB ERA23LA269](https://openairdocs.org/ntsb/ERA23LA269.md): Bell 206B · Orlando, FL · Accident · No injuries · Class 4 · Limited · Final report · Jun 5, 2023 · N27UK · Substantial damage
  > The pilot’s improper landing flare during a practice autorotation, which resulted in a hard landing.
- [NTSB CEN23LA199](https://openairdocs.org/ntsb/CEN23LA199.md): Bell Helicopter Textron Canada 407 · Abbeville, LA · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2023 · N451PH · Substantial damage
  > The pilot’s failure to maintain proper helicopter control during autorotation that resulted in an abnormal ground contact which caused the subsequent main rotor strike on the tail boom that severed the tail rotor driveshaft. Contributing to the accident was…
- [NTSB ANC23LA038](https://openairdocs.org/ntsb/ANC23LA038.md): Aerospatiale AS350B2 · Honolulu, HI · Accident · No injuries · Class 4 · Limited · Final report · May 22, 2023 · N745RH · Substantial damage
  > The instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.
- [NTSB WPR23LA191](https://openairdocs.org/ntsb/WPR23LA191.md): Robinson Helicopter R22 · Spanish Fork, UT · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2023 · N227WM · Substantial damage
  > The instructor pilot’s improper landing flare during a straight-in autorotation, which resulted in a hard landing.
- [NTSB CEN23FA164](https://openairdocs.org/ntsb/CEN23FA164.md): Maule MXT-7-180 · La Porte, TX · Accident · Serious injuries · Class 3 · Field · Final report · Apr 24, 2023 · N4008J · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for an emergency landing following a partial loss of engine power, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the…
- [NTSB ERA23LA146](https://openairdocs.org/ntsb/ERA23LA146.md): Hughes 269A · Titusville, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 9, 2023 · N8911F · Substantial damage
  > The pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing and subsequent rotor blade strike of the tail boom.
- [NTSB ERA23LA084](https://openairdocs.org/ntsb/ERA23LA084.md): Robinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NY · Accident · No injuries · Class 4 · Limited · Final report · Dec 11, 2022 · N14HT · Substantial damage
  > The flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.
- [NTSB CEN23LA048](https://openairdocs.org/ntsb/CEN23LA048.md): Hughes 369HS · Oxford, CO · Accident · No injuries · Class 4 · Limited · Final report · Nov 23, 2022 · N668M · Substantial damage
  > The designated pilot examiner’s failure to maintain a proper descent during a practice 180° autorotation which resulted in a hard landing.
- [NTSB WPR22LA359](https://openairdocs.org/ntsb/WPR22LA359.md): Robinson Helicopter R22 Beta · Mesa, AZ · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 26, 2022 · N252SC · Substantial damage
  > The flight instructor’s failure to maintain control of the helicopter’s rate of descent, resulting in a hard landing.
- [NTSB CEN22LA402](https://openairdocs.org/ntsb/CEN22LA402.md): MD Helicopters 369E · Pearland, TX · Accident · No injuries · Class 3 · Limited · Final report · Aug 30, 2022 · N1576F · Substantial damage
  > The pilot receiving instruction’s failure to maintain aircraft control, and the flight instructor’s delayed remedial action, which resulted in a hard landing.
- [NTSB CEN22LA400](https://openairdocs.org/ntsb/CEN22LA400.md): Robinson Helicopter R44 II · San Isidro, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 21, 2022 · N4447A · Substantial damage
  > The pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.
- [NTSB WPR22LA267](https://openairdocs.org/ntsb/WPR22LA267.md): Robinson Helicopter R44 II · Cedar City, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 25, 2022 · N497SU · Substantial damage
  > The student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.
- [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 CEN22LA078](https://openairdocs.org/ntsb/CEN22LA078.md): Bell Helicopter Textron Canada 407 · Bridgeport, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 14, 2021 · N862YB · Substantial damage
  > The pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.
- [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 ERA22LA016](https://openairdocs.org/ntsb/ERA22LA016.md): Kitfox IV · North Canaan, CT · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 14, 2021 · N9259M · Substantial damage
  > The pilot's mismanagement of the airplane's altitude, airspeed, and course during a forced landing following a partial loss of engine power, which resulted in collision with trees and terrain. Contributing was the pilot’s inadvertent omission of stowing the…
- [NTSB CEN21LA431](https://openairdocs.org/ntsb/CEN21LA431.md): Eurocopter AS350 · Romeo, MI · Accident · No injuries · Class 4 · Limited · Final report · Sep 15, 2021 · N632SD · Substantial damage
  > The flight instructor’s failure to reposition the fuel control to the flight detent during a practice autorotation, which resulted in insufficient engine power to arrest the helicopter’s decent and a hard landing.
- [NTSB WPR21LA313](https://openairdocs.org/ntsb/WPR21LA313.md): Cessna 425 · Helena, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 11, 2021 · N783MB · Substantial damage
  > A flameout of both engines due to fuel starvation for reasons that could not be determined due to the airplane’s damage.
- [NTSB WPR21LA299](https://openairdocs.org/ntsb/WPR21LA299.md): Schweizer G-164B · Tracy, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2021 · N3629F · Substantial damage
  > A loss of thrust during a low-level agricultural application flight, which resulted in a descent and impact with terrain. The reason for the loss of thrust could not be determined based on available information.
- [NTSB ERA21LA275](https://openairdocs.org/ntsb/ERA21LA275.md): Bell 206 · Rome, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 29, 2021 · N134VG · Substantial damage
  > The pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.
- [NTSB WPR21LA109](https://openairdocs.org/ntsb/WPR21LA109.md): MD Helicopter 369 · Mesa, AZ · Accident · No injuries · Class 4 · Limited · Final report · Feb 8, 2021 · N7032V · Substantial damage
  > The pilot’s improper pitch attitude for landing and the inadequate supervision of the flight instructor, resulted in the main rotor blades impacting the tail boom.
- [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 WPR20CA299](https://openairdocs.org/ntsb/WPR20CA299.md): Cessna 182 · Coeur d'Alene, ID · Accident · Minor injuries · Class 4 · Data collection · Final report · Sep 7, 2020 · N8885X · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion and a collision with trees and terrain.
- [NTSB CEN20LA187](https://openairdocs.org/ntsb/CEN20LA187.md): Bell OH-58A · West Branch, MI · Accident · No injuries · Class 3 · Limited · Final report · May 20, 2020 · N153SA · Substantial damage
  > The pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…
- [NTSB ERA20CA176](https://openairdocs.org/ntsb/ERA20CA176.md): Cessna 402 · Hampton, GA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 9, 2020 · N4661N · Substantial damage
  > A dual total loss of engine power as a result of fuel exhaustion.

Next page: https://openairdocs.org/ntsb-phases/600/cases.md?status=final&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."completionStatus" = 'Completed'
  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?status=final

---
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.