# NTSB investigations: Enroute

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 199 of 718 · 35,885 cases

## Cases, newest first

- [NTSB ANC97LA129](https://openairdocs.org/ntsb/ANC97LA129.md): Piper PA-32-300 · Bethel, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1997 · N4170R · Substantial damage
  > the pilot's improper selection of a fuel tank that did not contain fuel, which resulted in subsequent fuel starvation and loss of engine power. A factor relating to the accident was: the inability to reach suitable terrain for a forced landing.
- [NTSB MIA97FA239](https://openairdocs.org/ntsb/MIA97FA239.md): Beech 95-B55 · Brownsville, TN · Accident · 1 fatal · Field investigation · Final report · Aug 23, 1997 · N5678K · Destroyed
  > the pilot's inadequate preflight, and his improper in-flight planning/decision, which led to fuel exhaustion and a forced landing at night on unprepared terrain. Factors relating to the accident were: darkness, and the lack of a suitable area for an emergency…
- [NTSB FTW97LA324](https://openairdocs.org/ntsb/FTW97LA324.md): Cessna 182A · Delta, CO · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N4930D · Substantial damage
  > Failure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.
- [NTSB CHI97LA267](https://openairdocs.org/ntsb/CHI97LA267.md): Wsk Pzl Mielec M-18A · Coopersville, MI · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N178RA · Substantial damage
  > the pilot inadequate fuel system management which led to a fuel starvation.
- [NTSB LAX97LA299](https://openairdocs.org/ntsb/LAX97LA299.md): Cessna 210E · Oxnard, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 1997 · N1808F · Destroyed
  > The failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.
- [NTSB NYC97LA168](https://openairdocs.org/ntsb/NYC97LA168.md): Piper PA-28-161 · Blairsville, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1997 · N47900 · Substantial damage
  > the pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.
- [NTSB MIA97IA237](https://openairdocs.org/ntsb/MIA97IA237.md): Boeing 737-300 · Tampa, FL · Incident · Minor injuries · Incident investigation · Final report · Aug 21, 1997 · N602SW · Minor damage
  > in-flight collision with a bird.
- [NTSB SEA97LA193](https://openairdocs.org/ntsb/SEA97LA193.md): Cessna TU206G · Edwall, WA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1997 · N6620Z · Substantial damage
  > A fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.
- [NTSB FTW97LA316](https://openairdocs.org/ntsb/FTW97LA316.md): Piper PA-24-250 · Caldwell, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1997 · N6667P · Substantial damage
  > The loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.
- [NTSB NYC97LA166](https://openairdocs.org/ntsb/NYC97LA166.md): Cessna 425 · Perkasie, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1997 · N1224S · Substantial damage
  > the pilot's inadequate preflight, by failing to verify the fuel supply, which led to subsequent fuel exhaustion and loss of engine power. A related factor was: the inaccurate fuel quantity gauge.
- [NTSB LAX97FA291](https://openairdocs.org/ntsb/LAX97FA291.md): Hefner Pitts S1S · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1997 · N10HJ · Destroyed
  > the operation of the propeller beyond the design rpm limitations and the resultant gyroscopic loads from aerobatics. Contributing to the accident was the lack of a required instrument panel rpm restriction for the propeller mandated by an airworthiness…
- [NTSB CHI97LA260](https://openairdocs.org/ntsb/CHI97LA260.md): Cessna 182 · Derby, KS · Accident · No injuries · Limited investigation · Final report · Aug 17, 1997 · N9952T · Destroyed
  > the Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.
- [NTSB MIA97LA234](https://openairdocs.org/ntsb/MIA97LA234.md): Ercoupe 415-C · Siler City, NC · Accident · No injuries · Limited investigation · Final report · Aug 16, 1997 · N2237H · Substantial damage
  > Failure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.
- [NTSB MIA97LA233](https://openairdocs.org/ntsb/MIA97LA233.md): Air Tractor AT-301 · Waynesboro, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1997 · N4411S · Substantial damage
  > The obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.
- [NTSB LAX97FA288](https://openairdocs.org/ntsb/LAX97FA288.md): Taylorcraft BC12-D · Corcoran, CA · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1997 · N96294 · Destroyed
  > The pilot's failure to maintain separation from ground obstacles.
- [NTSB ATL97LA116](https://openairdocs.org/ntsb/ATL97LA116.md): Piper PA-28-140 · Milan, TN · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1997 · N7294F · Substantial damage
  > The loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.
- [NTSB ATL97FA115](https://openairdocs.org/ntsb/ATL97FA115.md): Mooney M20F · Tallahassee, FL · Accident · 2 fatal · Field investigation · Final report · Aug 11, 1997 · N3455X · Destroyed
  > fatigue failure of the crankshaft for undetermined reasons. Related factors were: darkness, and obstructions (trees) in the emergency landing area.
- [NTSB LAX97LA280](https://openairdocs.org/ntsb/LAX97LA280.md): North American Navion B · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1997 · N512AK · Destroyed
  > The separation of the number 3 cylinder due to improper overhaul procedures, and the failure to adequately torque the cylinder hold down nuts and through bolts to specification.
- [NTSB IAD97LA107](https://openairdocs.org/ntsb/IAD97LA107.md): Diamond Aircraft Industries DA 20-A1 · Slatington, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1997 · N278PL · Substantial damage
  > The pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.
- [NTSB CHI97FAMS3](https://openairdocs.org/ntsb/CHI97FAMS3.md): Grumman American AA-5 · Lower Brule, SD · Accident · 1 fatal · Missing aircraft · Final report · Aug 10, 1997 · N7148L · Destroyed
  > undetermined due to the accident airplane not being available for examination.
- [NTSB ATL97LA120](https://openairdocs.org/ntsb/ATL97LA120.md): Cessna 152 · Dunlap, TN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1997 · N6270H · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB LAX97LA278](https://openairdocs.org/ntsb/LAX97LA278.md): Cessna 150G · Palos Verdes, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1997 · N3084S · Substantial damage
  > Loss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.
- [NTSB LAX97LA275](https://openairdocs.org/ntsb/LAX97LA275.md): Grumman American AA-5 · Monterey, CA · Accident · 2 fatal · Limited investigation · Final report · Aug 8, 1997 · N6086L · Destroyed
  > the pilot's failure to maintain adequate clearance from surrounding terrain.
- [NTSB SEA97LA186](https://openairdocs.org/ntsb/SEA97LA186.md): Cessna 172M · Langley, WA · Accident · No injuries · Limited investigation · Final report · Aug 5, 1997 · N73158 · Substantial damage
  > A failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing..
- [NTSB FTW97LA294](https://openairdocs.org/ntsb/FTW97LA294.md): Beech C24R · Pollock, LA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1997 · N24PS · Substantial damage
  > The loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.
- [NTSB CHI97FA245](https://openairdocs.org/ntsb/CHI97FA245.md): Peck Osprey 2 · Poygen, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1997 · N4442C · Destroyed
  > A loss of control in flight for undetermined reasons.
- [NTSB NYC97LA158](https://openairdocs.org/ntsb/NYC97LA158.md): Cessna 172 RG · Quinton, VA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N9647B · Substantial damage
  > The pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.
- [NTSB FTW97LA298](https://openairdocs.org/ntsb/FTW97LA298.md): Piper J3C-65 · Castle Rock, CO · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N5985V · Substantial damage
  > A partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.
- [NTSB FTW97LA297](https://openairdocs.org/ntsb/FTW97LA297.md): Beech F33A · Creede, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1997 · N179DD · Destroyed
  > The pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.
- [NTSB CHI97LA251](https://openairdocs.org/ntsb/CHI97LA251.md): Larsen T-BIRD II · Oshkosh, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1997 · N41873 · Substantial damage
  > the pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.
- [NTSB CHI97LA241](https://openairdocs.org/ntsb/CHI97LA241.md): Bellanca 17-30A · Eagle, MI · Accident · No injuries · Limited investigation · Final report · Aug 2, 1997 · N8237R · Substantial damage
  > the pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.
- [NTSB CHI97LA239](https://openairdocs.org/ntsb/CHI97LA239.md): Briegleb BG-12A · Superior, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 2, 1997 · N5516V · Destroyed
  > the separation of the wing from the glider for undetermined reasons.
- [NTSB MIA97LA224](https://openairdocs.org/ntsb/MIA97LA224.md): Cessna 152 · Cape Coral, FL · Accident · No injuries · Limited investigation · Final report · Aug 1, 1997 · N93011 · Destroyed
  > Loss of engine power for undetermined reasons resulting in a forced landing to unsuitable terrain.
- [NTSB LAX97LA266](https://openairdocs.org/ntsb/LAX97LA266.md): Piper PA-28R-180 · Buckeye, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1997 · N4667J · Substantial damage
  > The total oil exhaustion of the engine due to the inadequate maintenance installation of the oil cooler lines by the owner/mechanic.
- [NTSB FTW97FA295](https://openairdocs.org/ntsb/FTW97FA295.md): Lancair 320 · Dillon, CO · Accident · 2 fatal · Field investigation · Final report · Jul 31, 1997 · N360GB · Destroyed
  > the pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…
- [NTSB CHI97LA240](https://openairdocs.org/ntsb/CHI97LA240.md): Cessna A188B · Satanta, KS · Accident · No injuries · Limited investigation · Final report · Jul 31, 1997 · N8960G · Substantial damage
  > the pilot's decision to perform a precautionary landing in a corn field due to an undetermined event in the cockpit. Factors relating to the accident were: the pilot's inadvertent actuation of the 'smoker' switch, his unfamiliarity with the 'smoke' equipment…
- [NTSB MIA97LA222](https://openairdocs.org/ntsb/MIA97LA222.md): Waco YMF5 · Lake Buena Vist, FL · Accident · No injuries · Limited investigation · Final report · Jul 28, 1997 · N14128 · Substantial damage
  > failure of maintenance personnel to follow installation procedures pertaining to the torque of the propeller retention nut, which resulted in a loose propeller retention nut, subsequent fatigue failure of the crankshaft, and loss of engine power. The lack of…
- [NTSB FTW97FA292](https://openairdocs.org/ntsb/FTW97FA292.md): Beech F35 · Richards, MO · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1997 · N3835B · Destroyed
  > The pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.
- [NTSB FTW97FA286](https://openairdocs.org/ntsb/FTW97FA286.md): Durbin Glasair R · Chama, NM · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1997 · N57JD · Substantial damage
  > flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the low ceiling, rain, fog, and high/mountainous terrain.
- [NTSB FTW97FA285](https://openairdocs.org/ntsb/FTW97FA285.md): Ayres S2R-T15 · Oakridge, LA · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1997 · N3096K · Destroyed
  > The pilot's failure to maintain clearance for undetermined reasons.
- [NTSB LAX97LA261](https://openairdocs.org/ntsb/LAX97LA261.md): Classic Waco YMF · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Jul 26, 1997 · N369BP · Substantial damage
  > A partial loss of engine power due to a loose rocker arm adjustment nut on the number 6 cylinder. The loose adjustment nut was due to inadequate maintenance adjustment performed by the engine manufacturer.
- [NTSB FTW97LA284](https://openairdocs.org/ntsb/FTW97LA284.md): Piper PA-32-300 · Pine Bluff, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1997 · N38800 · Substantial damage
  > loss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.
- [NTSB CHI97LA229](https://openairdocs.org/ntsb/CHI97LA229.md): Piper PA-28-140 · Mapleton, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1997 · N1690J · Substantial damage
  > the loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.
- [NTSB CHI97LA226](https://openairdocs.org/ntsb/CHI97LA226.md): Beech D50A · Mitchell, NE · Accident · No injuries · Limited investigation · Final report · Jul 26, 1997 · N3BE · Substantial damage
  > the pilot's improper fuel selector position and the fuel starvation. Factors contributing to the accident were: the pilot's inattentiveness of the refueling, inadequate aircraft preflight, and the rough terrain/ditch.
- [NTSB ANC97LA112](https://openairdocs.org/ntsb/ANC97LA112.md): Cessna 206 · Palmer, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1997 · N9412Z · Substantial damage
  > A fatigue failure of the engine crankshaft, and an inadequate engine cylinder replacement by maintenance personnel. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB NYC97LA155](https://openairdocs.org/ntsb/NYC97LA155.md): McDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1997 · N831LA · No damage
  > Failure of the aft flight attendant to secure her seat belt. Related factors were turbulence in clouds, and the flight attendant not receiving the crew briefing.
- [NTSB LAX97LA260](https://openairdocs.org/ntsb/LAX97LA260.md): Robinson R22 Beta · Chandler, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1997 · N4008D · Destroyed
  > The CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.
- [NTSB MIA97LA215](https://openairdocs.org/ntsb/MIA97LA215.md): Beech 65 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jul 24, 1997 · N816Q · Destroyed
  > Failure of the aircraft to maintain altitude for undetermined reasons following loss of power in one engine.
- [NTSB NYC97LA151](https://openairdocs.org/ntsb/NYC97LA151.md): de Havilland DHC-6-200 · Sussex, NJ · Accident · No injuries · Limited investigation · Final report · Jul 23, 1997 · N491AL · Substantial damage
  > the pilot's improper management of the fuel supply. A related factor was the inoperative low fuel quantity light for the rear tank.
- [NTSB LAX97LA254](https://openairdocs.org/ntsb/LAX97LA254.md): Beech 77 · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1997 · N1848F · Substantial damage
  > carburetor ice, and the failure of both pilot's to use (or properly use) carburetor heat. Factors relating to the accident were: the weather (carburetor icing) conditions, and obstructions in the forced landing area (grape vineyard).

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=200

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=199

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