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

## Cases, newest first

- [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 GAA17CA434](https://openairdocs.org/ntsb/GAA17CA434.md): Robinson Helicopter R22 · Bozeman, MT · Accident · No injuries · Data collection · Final report · Jul 21, 2017 · N28VH · Substantial damage
  > The flight instructor’s unstabilized autorotation, which resulted in a hard landing.
- [NTSB WPR17LA156](https://openairdocs.org/ntsb/WPR17LA156.md): Simmons Gary F Stol CH 701 · Kenwood, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2017 · N422ES · Substantial damage
  > Failure of the flywheel drive assembly, which resulted in a loss of engine power and subsequent forced landing to uneven terrain.
- [NTSB CEN17WA245](https://openairdocs.org/ntsb/CEN17WA245.md): Bell 204 · Alpbach, Austria · Accident · No injuries · Foreign investigation · Jun 22, 2017 · OE-XRK · Substantial damage
- [NTSB WPR17LA099](https://openairdocs.org/ntsb/WPR17LA099.md): Diamond Aircraft Ind DA 40 NG · Goodyear, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 20, 2017 · N154BY · Substantial damage
  > Loss of engine power due to the installation of an improper air induction hose, which failed and prevented sufficient air intake to the turbocharger.
- [NTSB GAA17CA218](https://openairdocs.org/ntsb/GAA17CA218.md): Bell 206 · La Verne, CA · Accident · No injuries · Data collection · Final report · Apr 6, 2017 · N206SA · Substantial damage
  > The pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.
- [NTSB ERA17LA126](https://openairdocs.org/ntsb/ERA17LA126.md): Eurocopter AS 350 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Feb 21, 2017 · N413LP · Substantial damage
  > The flight instructor's incorrect manipulations of the twist grip throttle control during a practice autorotation, which resulted in an engine overspeed and subsequent fire.
- [NTSB CEN17WA056](https://openairdocs.org/ntsb/CEN17WA056.md): Robinson R22 · Cannes, France · Accident · No injuries · Foreign investigation · Dec 12, 2016 · F-HALD · Destroyed
  > On December 12, 2016, at 1300 Coordinated Universal Time (UTC), a Robinson R-22 helicopter, French registration F-HALD, was destroyed following impact with terrain during a practice autorotation near Cannes-Mandelieu Airport (LFMD), France. The two occupants…
- [NTSB ERA17CA056](https://openairdocs.org/ntsb/ERA17CA056.md): Bell OH 58A · Ponce, PR · Accident · No injuries · Data collection · Final report · Oct 25, 2016 · N161PD · Substantial damage
  > The helicopter flight instructor's inadequate demonstration of a simulated engine failure, which resulted in a hard landing.
- [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 ERA16LA326](https://openairdocs.org/ntsb/ERA16LA326.md): Hughes 269B · Ozark, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2016 · N269BS · Substantial damage
  > A total loss of engine power for reasons that could not be determined following a successful postaccident engine run on the accident helicopter.
- [NTSB CEN16WA345](https://openairdocs.org/ntsb/CEN16WA345.md): Robinson R44 · Plasy, Czechia · Accident · No injuries · Foreign investigation · Aug 16, 2016 · OK-GES · Substantial damage
- [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 WPR16LA156](https://openairdocs.org/ntsb/WPR16LA156.md): Robinson R22 · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2016 · N22UH · Substantial damage
  > The flight instructor’s delayed remedial action to address a low rotor rpm condition, which resulted in an excessive descent rate and a subsequent hard landing.
- [NTSB GAA16CA408](https://openairdocs.org/ntsb/GAA16CA408.md): Bell Helicopter Textron 206 · Modesto, CA · Accident · No injuries · Data collection · Final report · Jul 30, 2016 · N206LW · Substantial damage
  > The pilot's failure to maintain pitch control during an autorotation, which resulted in abnormal ground contact and main rotor contact with the tail boom. Contributing to the accident was the low fuel level which resulted in fuel starvation and a loss of…
- [NTSB GAA16CA377](https://openairdocs.org/ntsb/GAA16CA377.md): Piper PA 44 · Keene, NH · Accident · No injuries · Data collection · Final report · Jul 7, 2016 · N190ND · Substantial damage
  > The flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.
- [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 GAA16CA258](https://openairdocs.org/ntsb/GAA16CA258.md): Bell OH 58 · Waitsburg, WA · Accident · No injuries · Data collection · Final report · May 21, 2016 · N543SD · Substantial damage
  > The pilot's failure to maintain clearance from the power line during low reconnaissance flight, which resulted in a power line strike, loss of control, and a subsequent hard landing.
- [NTSB ERA16LA167](https://openairdocs.org/ntsb/ERA16LA167.md): Bell 47D1 · Myerstown, PA · Accident · No injuries · Limited investigation · Final report · Apr 20, 2016 · N202CH · Substantial damage
  > A total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.
- [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 ERA16LA151](https://openairdocs.org/ntsb/ERA16LA151.md): Granger Michael D Sonex · Jesup, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 2016 · N97GR · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB GAA16CA168](https://openairdocs.org/ntsb/GAA16CA168.md): Hughes 369 · Jamestown, ND · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N721RP · Substantial damage
  > The pilot's excessive descent rate while flaring during a practice autorotation with a power recovery, which resulted in an impact with terrain.
- [NTSB ERA16LA059](https://openairdocs.org/ntsb/ERA16LA059.md): Pacific Aerospace 750XL · Raeford, NC · Accident · No injuries · Limited investigation · Final report · Dec 3, 2015 · N216PK · Substantial damage
  > The pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…
- [NTSB ERA16LA055](https://openairdocs.org/ntsb/ERA16LA055.md): Robinson R22 · Venice, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2015 · N8560M · Substantial damage
  > The flight instructor's failure to maintain control of the helicopter during an autorotation, which resulted in a hard landing.
- [NTSB GAA16CA055](https://openairdocs.org/ntsb/GAA16CA055.md): Bell 47G · Searchlight, NV · Accident · No injuries · Data collection · Final report · Oct 18, 2015 · N73224 · Substantial damage
  > The pilot's failure to maintain adequate clearance from a tree during hover flight.
- [NTSB CEN15WA447](https://openairdocs.org/ntsb/CEN15WA447.md): Bell 407 · San Agustine Guatemala, Guatemala · Accident · No injuries · Foreign investigation · Sep 24, 2015 · TG-PDF · Substantial damage
  > The Direccion General de Aeronutica Civil (DGAC) of Guatemala has notified the NTSB of a non-fatal accident involving a Bell 407GX Helicopter, registration TG-PDF, that occurred on September 24, 2015. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB WPR15LA245](https://openairdocs.org/ntsb/WPR15LA245.md): Schweizer 269C · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2015 · N17YS · Substantial damage
  > A total loss of engine power during a practice autorotation for reasons that could not be determined.
- [NTSB CEN15LA322](https://openairdocs.org/ntsb/CEN15LA322.md): Bell 47G 4A · Gilbert, IA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2015 · N1396X · Substantial damage
  > The total loss of engine power due to fuel starvation because the available fuel shifted within the tanks due to an abrupt nose-low maneuver to avoid an obstacle, which resulted in a hard forced landing.
- [NTSB GAA15CA181](https://openairdocs.org/ntsb/GAA15CA181.md): Robinson Helicopter R22 Beta · Caldwell, ID · Accident · No injuries · Data collection · Final report · Jul 13, 2015 · N184SH · Substantial damage
  > Abnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.
- [NTSB GAA15CA097](https://openairdocs.org/ntsb/GAA15CA097.md): Bell 47G 3B 1 · Fort Pierre, SD · Accident · No injuries · Data collection · Final report · May 28, 2015 · N112SH · Substantial damage
  > The pilot's inadequate preflight fuel planning that resulted in a total loss of engine power due to fuel exhaustion, and the pilot's failure to maintain control of the helicopter during the subsequent autorotation landing.
- [NTSB ANC15LA076](https://openairdocs.org/ntsb/ANC15LA076.md): Airbus AS-350 · Hamilton, MT · Accident · No injuries · Class 3 · Limited · Final report · May 4, 2015 · N504WD · Substantial damage
  > The pilot's excessive collective application during an autorotation. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.
- [NTSB ERA15WA211](https://openairdocs.org/ntsb/ERA15WA211.md): Bell 430 · Aydin, Türkiye · Accident · Minor injuries · Foreign investigation · Apr 26, 2015 · TC-HSZ · Substantial damage
  > On April 26, 2015, at 1322 coordinated universal time, a Bell 430, Turkish-registered TC-HSZ, was substantially damaged following a hard landing near Aydin, Turkey. The pilot and co-pilot were not injured. Two passengers sustained minor injuries, and three…
- [NTSB CEN15LA215](https://openairdocs.org/ntsb/CEN15LA215.md): Cessna 172 - H · Circleville, TX · Accident · No injuries · Limited investigation · Final report · Mar 24, 2015 · N8282L · Substantial damage
  > The failure of the engine to regain normal power after a simulated engine failure due to carburetor icing, which resulted in a forced landing on muddy terrain and a subsequent nose-over.
- [NTSB GAA15CA002](https://openairdocs.org/ntsb/GAA15CA002.md): Bell 407 · Justin, TX · Accident · No injuries · Data collection · Final report · Mar 5, 2015 · N41BH · Substantial damage
  > Abnormal ground contact during an autorotation demonstration, resulting in a severed tailrotor driveshaft.
- [NTSB WPR15LA106](https://openairdocs.org/ntsb/WPR15LA106.md): Grumman Acft ENG Cor-Schweizer G 164A · Alfalfa, OR · Accident · No injuries · Limited investigation · Final report · Feb 18, 2015 · N4863 · Substantial damage
  > A total loss of engine power after takeoff for reasons that could not be determined, because examination of the engine did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB CEN15WA142](https://openairdocs.org/ntsb/CEN15WA142.md): Robinson R66 · Bern, Switzerland · Incident · No injuries · Foreign investigation · Feb 7, 2015 · HB-ZOK · No damage
  > This is preliminary information, subject to change, and may contain errors. On February 7, 2015, between 1300-1400 UTC, a Robinson R66 helicopter, HB-ZOK, (s/n 0553) experienced a loss of engine power during recovery from an autorotation on a training flight.…
- [NTSB CEN15LA131](https://openairdocs.org/ntsb/CEN15LA131.md): Bell-Watson 47 G · North Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jan 29, 2015 · N43762 · Substantial damage
  > The flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.
- [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 WPR15CA043](https://openairdocs.org/ntsb/WPR15CA043.md): Robinson Helicopter R22 Beta · Prescott, AZ · Accident · Minor injuries · Data collection · Final report · Nov 15, 2014 · N32VH · Substantial damage
  > The certified flight instructor's failure to maintain helicopter control during the autorotation which resulted in a hard landing and subsequent roll over.
- [NTSB CEN15LA042](https://openairdocs.org/ntsb/CEN15LA042.md): Mosier Robert S Mosquito XET · Angleton, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2014 · N922RM · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees during a precautionary landing. Contributing to the accident was the pilot’s inadequate preflight inspection during which he failed to detect a loose drive belt, which resulted in an in-flight…
- [NTSB CEN14CA513](https://openairdocs.org/ntsb/CEN14CA513.md): Schweizer 269C · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Sep 22, 2014 · N1675U · Substantial damage
  > The flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a tail rotor strike.
- [NTSB CEN14LA517](https://openairdocs.org/ntsb/CEN14LA517.md): Robinson Helicopter R22 Beta · Cahokia, IL · Accident · No injuries · Limited investigation · Final report · Sep 19, 2014 · N115DD · Substantial damage
  > The pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…
- [NTSB ERA14LA433](https://openairdocs.org/ntsb/ERA14LA433.md): Piper J3C 65 · Carrol County, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2014 · N26105 · Substantial damage
  > The pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…
- [NTSB WPR14LA353](https://openairdocs.org/ntsb/WPR14LA353.md): Robinson Helicopter R44 II · Pahrump, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2014 · N4246Z · Substantial damage
  > A total loss of engine power during a practice autorotation for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN14CA409](https://openairdocs.org/ntsb/CEN14CA409.md): Glasflugel H 301 B Libelle · Brenham, TX · Accident · Minor injuries · Data collection · Final report · Aug 6, 2014 · N1615 · Substantial damage
  > The pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.
- [NTSB WPR14LA300](https://openairdocs.org/ntsb/WPR14LA300.md): Luscombe 8A · Rancho Cucamonga, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2014 · N77942 · Substantial damage
  > The loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.
- [NTSB CEN14CA367](https://openairdocs.org/ntsb/CEN14CA367.md): American Eurocopter AS350B3 · Grand Praire, TX · Accident · No injuries · Data collection · Final report · Jul 15, 2014 · N350GP · Substantial damage
  > The flight instructor's inadequate supervision during a practice autorotation. Contributing to the accident was the pilot's hard landing during a practice autorotation.
- [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 ERA14LA311](https://openairdocs.org/ntsb/ERA14LA311.md): Robinson Helicopter R44 II · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Jun 24, 2014 · N544BS · Substantial damage
  > The pilot’s failure to maintain rotor rpm during an autorotation after a perceived partial loss of power, which resulted in a hard landing. Contributing to the accident was radio frequency interference with the governor controller, which resulted in an…
- [NTSB CEN14LA313](https://openairdocs.org/ntsb/CEN14LA313.md): Robinson R22 - Beta · Moscow Mills, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 2014 · N784SH · Substantial damage
  > The flight instructor’s delayed remedial action to correct the student pilot’s use of an excessive descent rate during a practice autorotation, which resulted in a hard landing.

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

## 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=3

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