# 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 4 of 11 · 505 cases

## Cases, newest first

- [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 CEN14LA197](https://openairdocs.org/ntsb/CEN14LA197.md): Robinson R44 - II · Menard, TX · Accident · No injuries · Limited investigation · Final report · Mar 23, 2014 · N44MD · Substantial damage
  > The pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.
- [NTSB ERA14TA113](https://openairdocs.org/ntsb/ERA14TA113.md): Hughes 369 · Naples, FL · Accident · No injuries · Final report · Feb 3, 2014 · N8618F · Substantial damage
  > The pilot's inadequate flare during the termination of a practice 180-degree autorotation and the flight instructor's delayed remedial action, which resulted in the tail rotor contacting the ground.
- [NTSB WPR14LA084](https://openairdocs.org/ntsb/WPR14LA084.md): Eurocopter EC 130 B4 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Jan 1, 2014 · N133GC · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the noncertificated maintenance technician’s failure to properly tighten and safety wire a B-nut fitting. Contributing to the accident was the maintenance technician’s failure to follow the…
- [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 WPR14CA013](https://openairdocs.org/ntsb/WPR14CA013.md): Piper PA 28-180 · Cody, WY · Accident · Serious injuries · Data collection · Final report · Oct 11, 2013 · N31BA · Substantial damage
  > A loss of engine power during climb to cruise for reasons that could not be determined due to no postaccident examination.
- [NTSB ERA13LA429](https://openairdocs.org/ntsb/ERA13LA429.md): De Havilland DH 82A · Rhinebeck, NY · Accident · No injuries · Limited investigation · Final report · Sep 22, 2013 · N9410 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation, which resulted in a forced landing into trees.
- [NTSB CEN13CA575](https://openairdocs.org/ntsb/CEN13CA575.md): Robinson Helicopter R22 Mariner · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · Aug 18, 2013 · N8316D · Substantial damage
  > The student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.
- [NTSB WPR13CA337](https://openairdocs.org/ntsb/WPR13CA337.md): Hughes 269B · Lewiston, ID · Accident · No injuries · Data collection · Final report · Jul 23, 2013 · N9484F · Substantial damage
  > The pilot's incorrect application of the cyclic control during the landing.
- [NTSB WPR13CA329](https://openairdocs.org/ntsb/WPR13CA329.md): Bell Helicopter Textron 206L-1 · Inyokern, CA · Accident · No injuries · Data collection · Final report · Jul 13, 2013 · N123HP · Substantial damage
  > The failure of the pilot to maintain aircraft control during a practice autorotation maneuver and the pilot providing training's delayed remedial action which resulted in a hard landing. Contributing to the accident was the lack of communication between the…
- [NTSB WPR13LA266](https://openairdocs.org/ntsb/WPR13LA266.md): Eurocopter EC 130 B4 · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Jun 8, 2013 · N130PH · Substantial damage
  > A loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…
- [NTSB CEN13CA312](https://openairdocs.org/ntsb/CEN13CA312.md): Robinson Helicopter R22 Beta · Lansing, IL · Accident · No injuries · Data collection · Final report · Jun 3, 2013 · N2318X · Substantial damage
  > Improper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.
- [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 ERA13LA254](https://openairdocs.org/ntsb/ERA13LA254.md): Fleming Eldridge E Sonex · Naples, FL · Accident · Serious injuries · Limited investigation · Final report · May 26, 2013 · N634SX · Substantial damage
  > The pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…
- [NTSB CEN13CA276](https://openairdocs.org/ntsb/CEN13CA276.md): Bell 206-L4 · Fort Worth, TX · Accident · No injuries · Data collection · Final report · May 10, 2013 · N2036F · Substantial damage
  > The flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing.
- [NTSB CEN13LA164](https://openairdocs.org/ntsb/CEN13LA164.md): Bellanca 17-30A · Morris, IL · Accident · No injuries · Limited investigation · Final report · Feb 16, 2013 · N93747 · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR13CA107](https://openairdocs.org/ntsb/WPR13CA107.md): Robinson R22 · Kona, HI · Accident · No injuries · Data collection · Final report · Jan 30, 2013 · N333PJ · Substantial damage
  > The pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.
- [NTSB WPR13LA099](https://openairdocs.org/ntsb/WPR13LA099.md): Goetz Helicycle · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jan 22, 2013 · N143PG · Substantial damage
  > The pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.
- [NTSB ERA13LA116](https://openairdocs.org/ntsb/ERA13LA116.md): Robinson Helicopter R22 Beta · Ellington, CT · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 2013 · N26NE · Substantial damage
  > The separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…
- [NTSB ERA13LA104](https://openairdocs.org/ntsb/ERA13LA104.md): Robinson Helicopter R22 Beta · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Jan 2, 2013 · N345VH · Substantial damage
  > The student pilot’s delayed throttle application during the practice autorotation and the flight instructor’s lack of immediate remedial action, which resulted in a hard landing.
- [NTSB WPR13CA068](https://openairdocs.org/ntsb/WPR13CA068.md): Robinson R22 · Logan, UT · Accident · No injuries · Data collection · Final report · Dec 15, 2012 · N393LE · Substantial damage
  > The flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.
- [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 CEN13LA056](https://openairdocs.org/ntsb/CEN13LA056.md): Cessna 210L · La Grange, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2012 · N732BL · Substantial damage
  > The total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.
- [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 ERA13LA045](https://openairdocs.org/ntsb/ERA13LA045.md): Robinson Helicopter R22 · Alexander City, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 2012 · N231TM · Substantial damage
  > The pilot’s delayed decision to initiate an autorotation and her subsequent improper conduct of the autorotation, which resulted in a hard landing, after the helicopter started vibrating for reasons that could not be determined because postaccident…
- [NTSB ANC12CA111](https://openairdocs.org/ntsb/ANC12CA111.md): Robinson Helicopter R22 Beta II · Anchorage, AK · Accident · No injuries · Data collection · Final report · Sep 26, 2012 · N4171J · Substantial damage
  > The flight instructor's inadequate supervision of the student pilot during a hovering autorotation, which resulted in a dynamic rollover.
- [NTSB WPR12TA436](https://openairdocs.org/ntsb/WPR12TA436.md): Mcdonnell Douglas Heli 369FF · Las Vegas, NV · Accident · Minor injuries · Final report · Sep 24, 2012 · N911BL · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed while performing a 270-degree practice autorotation with a gusting tailwind at a high-density altitude.
- [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 WPR12LA408](https://openairdocs.org/ntsb/WPR12LA408.md): Bell Helicopter Textron 206L-1 · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Sep 9, 2012 · N5745Y · Substantial damage
  > A total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal 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 CEN12WA640](https://openairdocs.org/ntsb/CEN12WA640.md): Piaggio P149 · Hoogeveen, Netherlands · Accident · Serious injuries · Foreign investigation · Aug 4, 2012 · D-EGIT · Substantial damage
  > On August 4, 2012, at 0945 coordinated universal time, a Piaggio P149D, Dutch registration D-EGIT, owned by a private individual and operated by the pilot, received substantial damage when it impacted terrain under unknown circumstances near Hoogeveen Airport…
- [NTSB WPR12LA267](https://openairdocs.org/ntsb/WPR12LA267.md): Robinson Helicopter R44 II · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2012 · N808WH · Substantial damage
  > The flight instructor’s failure to maintain adequate rotor rpm during a practice autorotation, which resulted in a loss of helicopter control and subsequent hard landing.
- [NTSB ERA12CA375](https://openairdocs.org/ntsb/ERA12CA375.md): Schweizer 269C-1 · Titusville, FL · Accident · No injuries · Data collection · Final report · May 31, 2012 · N1803R · Substantial damage
  > The flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.
- [NTSB WPR12LA195](https://openairdocs.org/ntsb/WPR12LA195.md): Robinson R22 · Kailua-Kona, HI · Accident · Serious injuries · Limited investigation · Final report · May 3, 2012 · N209KR · Substantial damage
  > A loss of engine power while maneuvering for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12TA120](https://openairdocs.org/ntsb/WPR12TA120.md): Eurocopter AS 350 B3 · Napa, CA · Accident · No injuries · Final report · Mar 1, 2012 · N341HP · Substantial damage
  > The flight instructor’s improper use of the collective control during a practice hovering autorotation, which resulted in a hard landing.
- [NTSB ERA12CA199](https://openairdocs.org/ntsb/ERA12CA199.md): Bell OH-58A · Eufaula, AL · Accident · No injuries · Data collection · Final report · Mar 1, 2012 · N38FA · Substantial damage
  > The pilot's inadequate compensation for the gusting wind, which resulted in an excessive descent rate and hard landing.
- [NTSB WPR12LA111](https://openairdocs.org/ntsb/WPR12LA111.md): Enstrom F28 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Feb 20, 2012 · N51727 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA12CA179](https://openairdocs.org/ntsb/ERA12CA179.md): Robinson Helicopter R44 · N. Charleston, SC · Accident · No injuries · Data collection · Final report · Feb 13, 2012 · N5511L · Substantial damage
  > The flight instructor’s failure to apply power during a practice autorotation in order to arrest a high rate of descent, which resulted in an in-flight collision with terrain.
- [NTSB ERA12LA112](https://openairdocs.org/ntsb/ERA12LA112.md): Piper PA-38-112 · Merry Hill, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 2011 · N9279T · Substantial damage
  > Operation of the airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s failure to maintain airspeed while making a forced landing following a total loss of engine power at low altitude, which resulted in an…
- [NTSB ERA12CA095](https://openairdocs.org/ntsb/ERA12CA095.md): Bell 206L-3 · Wingate, NC · Accident · No injuries · Data collection · Final report · Dec 1, 2011 · N216TV · Substantial damage
  > The certified flight instructor did not select an adequate landing site for the practice autorotation.
- [NTSB WPR12LA029](https://openairdocs.org/ntsb/WPR12LA029.md): Bell 47D1 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Nov 8, 2011 · N4251A · Substantial damage
  > The flight instructor's inadequate supervision of the student pilot during a simulated autorotation and the pilots’ failure to use carburetor heat while operating at reduced engine power while in carburetor icing conditions, which resulted in a loss of engine…
- [NTSB WPR11LA462](https://openairdocs.org/ntsb/WPR11LA462.md): Hughes 269C · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 2011 · N1088Y · Substantial damage
  > The flight instructor’s failure to follow the proper procedure while demonstrating a practice autorotation, which resulted in a total loss of engine power and subsequent hard landing.
- [NTSB CEN11LA688](https://openairdocs.org/ntsb/CEN11LA688.md): Taylorcraft BC12-D · Berryville, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 2011 · N8617 · Substantial damage
  > The pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.
- [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 WPR11TA274](https://openairdocs.org/ntsb/WPR11TA274.md): Bell 206B · Franklin, CA · Accident · No injuries · Final report · Jun 21, 2011 · N38EA · Substantial damage
  > The student pilot's failure to maintain rotor rpm during the practice autorotation.
- [NTSB CEN11LA397](https://openairdocs.org/ntsb/CEN11LA397.md): Schweizer 269C · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Jun 15, 2011 · N2077E · Substantial damage
  > The student pilot's inadequate recovery from an autorotation and the CFI's delayed remedial action.
- [NTSB WPR11CA243](https://openairdocs.org/ntsb/WPR11CA243.md): Bell 206B3 · Glendale, AZ · Accident · No injuries · Data collection · Final report · May 27, 2011 · N59383 · Substantial damage
  > The certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.
- [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.

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

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

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