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

## Cases, newest first

- [NTSB FTW02LA226](https://openairdocs.org/ntsb/FTW02LA226.md): Cessna 150L · Manvel, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2002 · N10935 · Substantial damage
  > The loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW02LA218](https://openairdocs.org/ntsb/FTW02LA218.md): Cessna 182Q · Mc Allen, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 2002 · N4896N · Substantial damage
  > The pilot's failure to refuel the airplane resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX02LA213](https://openairdocs.org/ntsb/LAX02LA213.md): Robinson R22 Beta · Chatsworth, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 2002 · N4072T · Substantial damage
  > The pilot's inadequate flare resulting in rotor blade contact with the ground. Contributing factors were the high altitude and the airframe vibration for an undetermined reason.
- [NTSB ATL02LA136](https://openairdocs.org/ntsb/ATL02LA136.md): Piper PA-28-140 · Clearwater, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2002 · N2935Q · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB SEA02LA115](https://openairdocs.org/ntsb/SEA02LA115.md): Seattle Aerotech Helipower 2500 · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jun 27, 2002 · N13RM · Destroyed
  > Aircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.
- [NTSB ATL02LA124](https://openairdocs.org/ntsb/ATL02LA124.md): Cessna 152 · Greenville, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2002 · N68437 · Substantial damage
  > The pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.
- [NTSB IAD02LA036](https://openairdocs.org/ntsb/IAD02LA036.md): Schweizer SGS 1-26A · Strausburg, VA · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 2002 · N3878A · Substantial damage
  > The pilot's inadequate evaluation of weather resulted in a loss of thermal lift, which resulted in an impact with trees.
- [NTSB NYC02LA046](https://openairdocs.org/ntsb/NYC02LA046.md): Let L-23 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Jan 1, 2002 · N117BB · Substantial damage
  > The student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…
- [NTSB CHI01LA293](https://openairdocs.org/ntsb/CHI01LA293.md): Hughes 269B · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Aug 26, 2001 · N9390F · Substantial damage
  > the checklist not compiled with by the operator and not verified by the operator’s pilot and the operator's flight instructor. An additional cause was the improper autorotation by the pilot in command. The out of calibration engine idle speed was a…
- [NTSB IAD01LA080](https://openairdocs.org/ntsb/IAD01LA080.md): Aerostar International RXS-8 · Flemington, NJ · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 2001 · N7106F · No damage
  > pilot's continued flight into known adverse weather conditions, which resulted in a hard landing. A factor was the downdrafts.
- [NTSB CHI01FA128](https://openairdocs.org/ntsb/CHI01FA128.md): Cessna 210L · Farmington, MO · Accident · 2 fatal · Field investigation · Final report · Apr 24, 2001 · N5060V · Substantial damage
  > The fracture of the crankshaft due to fatigue, the propeller separating from the airplane while in-flight, which resulted in the propeller striking the empennage structure and flight controls, yielding the airplane uncontrollable. Contributing factors to the…
- [NTSB IAD01LA033](https://openairdocs.org/ntsb/IAD01LA033.md): Mooney M20C · Peckville, PA · Accident · No injuries · Limited investigation · Final report · Feb 6, 2001 · N1914Y · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB ATL01LA026](https://openairdocs.org/ntsb/ATL01LA026.md): Cessna 172 F · Greenwood, MS · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 2001 · N7882U · Destroyed
  > An in-flight fire for undetermined reasons. Finding: A factor is the maintenance modification was performed by company personnel prior to the flight.
- [NTSB LAX01LA038](https://openairdocs.org/ntsb/LAX01LA038.md): Schweizer SGS 1-36 · Lake Elsinore, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 2000 · N3621R · Substantial damage
  > The pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.
- [NTSB IAD01LA002](https://openairdocs.org/ntsb/IAD01LA002.md): American AA-1A · Philadelphia, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 2000 · N9394L · Substantial damage
  > A hole in the #4 piston for undetermined reasons which resulted in engine oil starvation and engine stoppage.
- [NTSB SEA01LA004](https://openairdocs.org/ntsb/SEA01LA004.md): Mooney M20K · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2000 · N52202 · Substantial damage
  > Oil Pump drive gear shaft separated in shear. A collision with a tree stump during the landing roll was a factor.
- [NTSB LAX00LA280](https://openairdocs.org/ntsb/LAX00LA280.md): Bell 47G-5 · King City, CA · Accident · No injuries · Limited investigation · Final report · Jul 28, 2000 · N7885S · Substantial damage
  > The pilot's intentional flight into adverse weather which resulted in loss of visual reference and flight into power transmission wires and terrain.
- [NTSB ATL00FA061](https://openairdocs.org/ntsb/ATL00FA061.md): Cessna 150G · Oxford, MS · Accident · 2 fatal · Field investigation · Final report · Jun 8, 2000 · N3711J · Substantial damage
  > The certified flight instructor's failure to maintain airspeed during climbout.
- [NTSB DEN00FA028](https://openairdocs.org/ntsb/DEN00FA028.md): Hughes 369D · Peyton, CO · Accident · No injuries · Field investigation · Final report · Dec 15, 1999 · N5190C · Substantial damage
  > an uncontrolled touchdown following entry into a "out-of-ground effect" hover. Factors were loss of tail rotor effectiveness, and the pilot's lack of recent experience in kind of aircraft and total experience in type of aircraft.
- [NTSB MIA99FA230](https://openairdocs.org/ntsb/MIA99FA230.md): Cessna 210L · Tampa, FL · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1999 · N640AJ · Destroyed
  > The failure of the pilot to follow procedures and directives established by the operator for his failure to fuel the airplane after landing following the first leg. Contributing to the accident was the total loss of engine power due to fuel exhaustion.…
- [NTSB DEN99LA146](https://openairdocs.org/ntsb/DEN99LA146.md): Piper PA-32-260 · Aspen, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1999 · N991RC · Destroyed
  > The pilot's inadequate in flight planning. Factors were the high density altitude, the lack of suitable terrain for a forced landing, and the sign post that the right wing impacted.
- [NTSB DEN99LA058](https://openairdocs.org/ntsb/DEN99LA058.md): Robinson R22 Beta · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Mar 25, 1999 · N8354Z · Substantial damage
  > The flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.
- [NTSB DEN99LA055](https://openairdocs.org/ntsb/DEN99LA055.md): Cessna 310L · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Mar 14, 1999 · N2230F · Substantial damage
  > The pilot's exceeding the airplane's weight and balance limitations. A factor was the high density altitude weather condition.
- [NTSB CHI99IA096](https://openairdocs.org/ntsb/CHI99IA096.md): Cessna T210R · Tinley Park, IL · Incident · No injuries · Incident investigation · Final report · Feb 20, 1999 · N7687U · Minor damage
  > the improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.
- [NTSB FTW99LA017](https://openairdocs.org/ntsb/FTW99LA017.md): Grumman American AA-5A · Scott, AR · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 1998 · N9956U · Substantial damage
  > The disengagement of the crankshaft gear due to the maintenance personnel not installing the gear lockplate at the last engine overhaul, resulting in the loosening of the gear retaining bolt, and the subsequent fracture of the gear alignment dowel. A factor…
- [NTSB FTW98LA347](https://openairdocs.org/ntsb/FTW98LA347.md): Cessna 152 · Hayes, LA · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1998 · N69269 · Substantial damage
  > The forced landing for undetermined reasons. A factor was no suitable terrain for the forced landing.
- [NTSB FTW98LA357](https://openairdocs.org/ntsb/FTW98LA357.md): Cessna 150J · Belen, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1998 · N60564 · Substantial damage
  > The pilot's improper preflight in that he failed to drain the water from the fuel sumps. Factors were water contamination in the fuel tank and a sand bar.
- [NTSB CHI98LA303](https://openairdocs.org/ntsb/CHI98LA303.md): Cook Teenie TWO · Stevensville, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1998 · N40512 · Substantial damage
  > The pilot's inadequate preflight planning and preparation which resulted in fuel exhaustion and subsequent loss of engine power.
- [NTSB LAX98LA230](https://openairdocs.org/ntsb/LAX98LA230.md): Piper PA-18-150 · Hyampom, CA · Accident · No injuries · Limited investigation · Final report · Jul 12, 1998 · N6248R · Substantial damage
  > Inadequate annual inspection that resulted in a partial loss of engine power due to a missing bolt, nut, and cotter pin from the throttle/carburetor assembly.
- [NTSB FTW98FA157](https://openairdocs.org/ntsb/FTW98FA157.md): Cessna T207A · Monument Valley, UT · Accident · Serious injuries · Field investigation · Final report · Mar 24, 1998 · N73780 · Substantial damage
  > The engine's total power loss due to the induction air ducting separating because of inadequate maintenance by company personnel. Factors were the failure of the manufacturer to provide non-standard operating procedures in their airplane's information manual,…
- [NTSB FTW98LA154](https://openairdocs.org/ntsb/FTW98LA154.md): Grumman American AA-1B · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1998 · N9940L · Substantial damage
  > The complete loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC98LA068](https://openairdocs.org/ntsb/NYC98LA068.md): Zwart KIT FOX Vixen · Weyers Cave, VA · Accident · No injuries · Limited investigation · Final report · Feb 22, 1998 · N955F · Substantial damage
  > The failure of the propeller drive train after the pilot/builder installed an improper drive belt.
- [NTSB FTW98LA081](https://openairdocs.org/ntsb/FTW98LA081.md): Cessna 310R · Grants, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 1997 · N87358 · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…
- [NTSB FTW98LA064](https://openairdocs.org/ntsb/FTW98LA064.md): Adams A55S · Gallup, NM · Accident · 1 fatal · Limited investigation · Final report · Dec 6, 1997 · N1063V · No damage
  > failure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.
- [NTSB MIA97LA096](https://openairdocs.org/ntsb/MIA97LA096.md): Cessna 182E · Huntsville, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 1997 · N3392Y · Substantial damage
  > Total loss of engine power due to fuel exhaustion for undetermined reasons.
- [NTSB MIA97LA046](https://openairdocs.org/ntsb/MIA97LA046.md): Let Blanik L-13 · Mulberry, FL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1996 · N48052 · Substantial damage
  > The pilot's failure to check that the spoiler handle was locked in the retracted position prior to takeoff.
- [NTSB LAX96LA234](https://openairdocs.org/ntsb/LAX96LA234.md): Burkhart Grob G102 · Mesquite, NV · Accident · 1 fatal · Limited investigation · Final report · Jun 16, 1996 · N154SS · Destroyed
  > improper in-flight planning/decision by the pilot, which resulted in his being forced to land in an area with unsuitable terrain. Factors relating to the accident were: the lack of available (thermal) lift, downdraft(s), and the resultant lack of suitable…
- [NTSB FTW96FA120](https://openairdocs.org/ntsb/FTW96FA120.md): Beech A36 · Katy, TX · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1996 · N2TC · Substantial damage
  > a loss of control due to pilot incapacitation for undetermined reasons. A factor related to the pilot's injuries was the lack of shoulder harness restraint.
- [NTSB NYC96LA029](https://openairdocs.org/ntsb/NYC96LA029.md): Bellanca 8-KCAB · Sheffield, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1995 · N53835 · Destroyed
  > the pilot's inadequate preflight and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel.
- [NTSB MIA96LA006](https://openairdocs.org/ntsb/MIA96LA006.md): Cessna 152 · Eastman, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1995 · N33LU · Destroyed
  > The failure of the pilot-in-command to perform fuel consumption calculations, and the decision not to refuel. Contributing to the accident was fuel exhaustion, and the pilot- in-command's decision to operate the airplane with the fuel gauges inoperative.
- [NTSB CHI95LA104](https://openairdocs.org/ntsb/CHI95LA104.md): Piper PA-28-181 · Ann Arbor, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1995 · N4385M · Substantial damage
  > the failure of the mechanic to close the drain valve after changing oil, resulting in complete loss of engine oil. A factor was the soft terrain, which resulted in the nose wheel digging in and the airplane nosing over.
- [NTSB LAX94FA372](https://openairdocs.org/ntsb/LAX94FA372.md): Hughes 369D · Genoa, NV · Accident · Minor injuries · Field investigation · Final report · Sep 22, 1994 · N58352 · Substantial damage
  > The pilot/operator's operation of the helicopter with a disconnected throttle on the right collective; the FAA inspector's inadequate preflight/pretakeoff checks of the flight control/throttle systems; and the pilot/operator's failure to adequately inform the…
- [NTSB LAX94LA380](https://openairdocs.org/ntsb/LAX94LA380.md): Singer Kitfox IV · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1994 · N93CM · Substantial damage
  > fuel exhaustion due to the pilot's failure to refuel prior to departure, and his inaccurate en route fuel consumption calculations.
- [NTSB ANC94FA109](https://openairdocs.org/ntsb/ANC94FA109.md): Cessna 172 · Big Lake, AK · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1994 · N5198A · Destroyed
  > The pilot's failure to maintain airspeed. Factors in the accident were the fog, and the pilot becoming lost/disoriented.
- [NTSB FTW94MA236](https://openairdocs.org/ntsb/FTW94MA236.md): Aerospatiale AS350B · Kalaupapa, HI · Accident · Serious injuries · Major investigation · Final report · Jul 15, 1994 · N350MH · Substantial damage
  > The pilot's failure to properly monitor power required versus power available to maintain rotor revolutions per minute (RPM), resulting in rotor RPM decay and a forced landing. Factors related to the accident were: the pilot's change of the tour route without…
- [NTSB LAX94FA198](https://openairdocs.org/ntsb/LAX94FA198.md): Piper PA-32R-301T · Santa Monica, CA · Accident · 1 fatal · Field investigation · Final report · Apr 20, 1994 · N8171G · Destroyed
  > fuel starvation resulting from the failure of the pilot to select a tank containing fuel, and his failure to maintain adequate airspeed while maneuvering for a forced landing which resulted in an inadvertent stall.
- [NTSB ANC93LA181](https://openairdocs.org/ntsb/ANC93LA181.md): Piper PA-12 · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Sep 19, 1993 · N3680M · Substantial damage
  > Total loss of engine power due to fuel exhaustion and the pilot's improper fuel consumption calculations. Factor was the unsuitable terrain.
- [NTSB BFO93LA122](https://openairdocs.org/ntsb/BFO93LA122.md): Schultz/Bowers FLY Baby 1A · Conneaut, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1993 · N4295X · Destroyed
  > Operational failure of the left magneto's high tension wiring due to grease/corrosion, which resulted in a progressive power loss and subsequent forced landing.
- [NTSB DEN93FA054](https://openairdocs.org/ntsb/DEN93FA054.md): Witts & Church Worloch · Lucerne, CO · Accident · 1 fatal · Field investigation · Final report · May 6, 1993 · N3201K · Destroyed
  > Loss of control in flight. A factor was: the pilot's lack of experience in the airplane.
- [NTSB FTW93LA146](https://openairdocs.org/ntsb/FTW93LA146.md): Pzl-Mielec PZL-M-18 · De Witt, AR · Accident · Minor injuries · Limited investigation · Final report · May 1, 1993 · N28587 · Destroyed
  > Compensation for wind improper by pilot. Factors were tailwind and downdraft

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

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

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