# 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 2 of 11 · 506 cases

## Cases, newest first

- [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 GAA22WA114](https://openairdocs.org/ntsb/GAA22WA114.md): Robinson R22 · Canals, Argentina · Accident · No injuries · Class 5 · Foreign · Feb 27, 2022 · LV-KBQ · Substantial damage
- [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 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 GAA21WA245](https://openairdocs.org/ntsb/GAA21WA245.md): Hélicoptères Guimbal Cabri G2 · Ägerten, Switzerland · Accident · No injuries · Class 5 · Foreign · Sep 30, 2021 · HB-ZVK · Substantial damage
- [NTSB GAA21WA246](https://openairdocs.org/ntsb/GAA21WA246.md): Partenavia P68 · Bush Bay Beach, Co. Wexford, Ireland · Accident · Serious injuries · Class 5 · Foreign · Sep 23, 2021 · F-HIRD · Destroyed
- [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 GAA21WA059](https://openairdocs.org/ntsb/GAA21WA059.md): Beech 200 · Nairobi, Kenya · Accident · No injuries · Class 4 · Foreign · Mar 26, 2021 · 5Y-NJS · Destroyed
- [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 CEN21WA059](https://openairdocs.org/ntsb/CEN21WA059.md): Piper PA46 · Villingen-Schwenningen, Germany · Accident · No injuries · Class 4 · Foreign · Oct 10, 2020 · N369ST · Substantial damage
- [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.
- [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 WPR20CA140](https://openairdocs.org/ntsb/WPR20CA140.md): Robinson R22 · Caldwell, ID · Accident · No injuries · Data collection · Final report · Apr 22, 2020 · N6703S · Substantial damage
  > The flight instructor's failure to set the proper rotor rpm during a practice autorotation, which led to his failure to maintain a proper descent rate and resulted in a hard, bounced landing.
- [NTSB ANC20LA043](https://openairdocs.org/ntsb/ANC20LA043.md): Cessna A185E · Eagle River, AK · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 12, 2020 · N185RN · Substantial damage
  > The pilot’s failure to ensure adequate fuel onboard prior to the planned flight, resulting in a total loss of engine power due to fuel exhaustion and an aerodynamic stall during the subsequent emergency landing. Contributing to the accident was the pilot’s…
- [NTSB WPR20LA096](https://openairdocs.org/ntsb/WPR20LA096.md): Lightning Avion Eab Arion Lightning · Jerome, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 26, 2020 · N1XF · Substantial damage
  > The pilot’s mismanagement of fuel, which resulted in fuel starvation and the pilot’s loss of airplane control during an emergency descent, which resulted in a stall and subsequent impact with terrain.
- [NTSB ERA20CA106](https://openairdocs.org/ntsb/ERA20CA106.md): Aerospatiale AS350 · Tampa, FL · Accident · No injuries · Data collection · Final report · Feb 18, 2020 · N188FS · Substantial damage
  > The flight instructor's inadvertent throttle reduction below idle, which resulted in a total loss of engine power and subsequent impact with terrain following a power-off autorotation.
- [NTSB GAA19CA514](https://openairdocs.org/ntsb/GAA19CA514.md): Hughes 269A · Shamokin, PA · Accident · No injuries · Data collection · Final report · Aug 25, 2019 · N653CH · Substantial damage
  > The pilot's improper landing flare during an autorotation, which resulted in a hard landing. Contributing to the accident was a loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of any…
- [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 WPR19LA168](https://openairdocs.org/ntsb/WPR19LA168.md): Sikorsky UH19 · Brewster, WA · Accident · Minor injuries · Class 3 · Limited · Final report · May 29, 2019 · N955TC · Substantial damage
  > A reported mechanical malfunction and a hard landing for reasons that could not be determined based on available evidence.
- [NTSB WPR19LA019](https://openairdocs.org/ntsb/WPR19LA019.md): Bell 47G · Wichita Falls, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 2, 2018 · N1159W · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA19WA288](https://openairdocs.org/ntsb/ERA19WA288.md): Embraer EMB-202 · Miranda, Brazil · Accident · No injuries · Foreign investigation · Oct 30, 2018 · PT-UJI · No damage
  > The government of Brazil has notified the NTSB of an accident involving a Embraer EMB-202 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB WPR18LA252](https://openairdocs.org/ntsb/WPR18LA252.md): Guimbal Cabri · Santa Ana, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2018 · N401SH · Substantial damage
  > The flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.
- [NTSB WPR18LA226](https://openairdocs.org/ntsb/WPR18LA226.md): Hughes 369 · Riverside, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 17, 2018 · N105JL · Substantial damage
  > The instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.
- [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 WPR18LA183](https://openairdocs.org/ntsb/WPR18LA183.md): Cessna 182 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jun 23, 2018 · N5682B · Substantial damage
  > A total loss of engine power for reasons that could not be determined due to insufficient evidence.
- [NTSB WPR18LA127](https://openairdocs.org/ntsb/WPR18LA127.md): Yakovlev YAK 52 · Hillsboro, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 26, 2018 · N2YK · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was…
- [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 GAA18CA159](https://openairdocs.org/ntsb/GAA18CA159.md): Hughes 269 · Jacksonville, FL · Accident · No injuries · Data collection · Final report · Mar 10, 2018 · N9020M · Substantial damage
  > The pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.
- [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 ERA18LA075](https://openairdocs.org/ntsb/ERA18LA075.md): Bell OH 58C · Zebulon, GA · Accident · No injuries · Limited investigation · Final report · Jan 29, 2018 · N942SC · Substantial damage
  > The pilot's failure to fully open the throttle before initiating the power recovery in response to a simulated engine failure.
- [NTSB WPR18LA041](https://openairdocs.org/ntsb/WPR18LA041.md): Robinson Helicopter R22 · Truckee, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 30, 2017 · N47WH · Substantial damage
  > The flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.
- [NTSB WPR18LA030](https://openairdocs.org/ntsb/WPR18LA030.md): Vanderark RV-10 · Sun Lakes, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 2017 · N917VA · Substantial damage
  > The fatigue fractures of the upper and lower alternator attachment bolts, which decreased the common drive belt tension and resulted in the subsequent in-flight separation of an alternator drive belt, the overheating of the engine, and the subsequent total…
- [NTSB GAA18CA030](https://openairdocs.org/ntsb/GAA18CA030.md): Robinson Helicopter R22 Beta · Las Vegas, NV · Accident · No injuries · Data collection · Final report · Oct 6, 2017 · N878MC · Substantial damage
  > The student pilot’s tension on the flight control at a low level during an autorotation, which did not allow sufficient time for the flight instructor to correct and recover control before the hard landing.
- [NTSB CEN18LA010](https://openairdocs.org/ntsb/CEN18LA010.md): Bellanca 17-30A · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Oct 6, 2017 · N8234R · Substantial damage
  > The loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.
- [NTSB WPR17LA211](https://openairdocs.org/ntsb/WPR17LA211.md): Robinson Helicopter R22 · Long Beach, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2017 · N7514S · Substantial damage
  > The student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…
- [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 WPR17IA198](https://openairdocs.org/ntsb/WPR17IA198.md): Enstrom F 28F · Glendale, AZ · Incident · No injuries · Incident investigation · Final report · Aug 22, 2017 · N52PD · No damage
  > An internal failure of the turbo-compressor, which resulted in oil leaking into the turbo-compressor’s exhaust.

Next page: https://openairdocs.org/ntsb-phases/600/cases.md?page=3

## 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."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?page=2

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