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

## Cases, newest first

- [NTSB DEN02LA082](https://openairdocs.org/ntsb/DEN02LA082.md): Piper PA-24-250 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Jul 26, 2002 · N6887F · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of leaking fuel caps. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB NYC02LA147](https://openairdocs.org/ntsb/NYC02LA147.md): Bell 206B · Newfield, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 2002 · C-GMLS · Substantial damage
  > The pilot's failure to verify the amount of fuel onboard prior to departure, which resulted in a power loss due to fuel exhaustion, and subsequent hard landing. A factor was the lack of a suitable landing area under the helicopter when the power loss occurred.
- [NTSB FTW02LA217](https://openairdocs.org/ntsb/FTW02LA217.md): Bell 206L-3 · Eugene Is 192 · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 2002 · N3174Y · Substantial damage
  > The loss of tail rotor control due to an in-flight collision with an object.
- [NTSB CHI02LA212](https://openairdocs.org/ntsb/CHI02LA212.md): Grumman G-164 · Central City, NE · Accident · No injuries · Limited investigation · Final report · Jul 25, 2002 · N5296 · Substantial damage
  > The pilot was not able to maintain clearance with the trees when the airplane encountered a downdraft at a low altitude. An additional cause was the pilot's inadequate evaluation of the approaching weather conditions. Factors associated with the accident were…
- [NTSB CHI02FA215](https://openairdocs.org/ntsb/CHI02FA215.md): Piper PA-30 · Marble Hill, MO · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2002 · N8563Y · Destroyed
  > The solid fuel system contamination resulting in a loss of engine power. The inadequate emergency procedures, and the airspeed not maintained by the pilot were additional causes.
- [NTSB SEA02LA137](https://openairdocs.org/ntsb/SEA02LA137.md): Bell 206B · Elsie, OR · Accident · No injuries · Limited investigation · Final report · Jul 24, 2002 · N60PH · Substantial damage
  > The shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).
- [NTSB MIA02LA139](https://openairdocs.org/ntsb/MIA02LA139.md): Interavia E-3 · Santa Rosa Bch, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2002 · N1535G · Substantial damage
  > The separation of the canopy for undetermined reasons.
- [NTSB CHI02LA213](https://openairdocs.org/ntsb/CHI02LA213.md): Weatherly 201C · Malta, IL · Accident · No injuries · Limited investigation · Final report · Jul 24, 2002 · N1296W · Substantial damage
  > The inflight fire and loss of engine power due to undetermined reasons. Factors associated with the accident were the lack of suitable terrain on which to land and the corn crop which was contacted during the landing.
- [NTSB SEA02LA135](https://openairdocs.org/ntsb/SEA02LA135.md): McDonnell Douglas 369D · Medford, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2002 · N58295 · Substantial damage
  > Power loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.
- [NTSB SEA02LA133](https://openairdocs.org/ntsb/SEA02LA133.md): Cessna 150J · Pe Ell, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 2002 · N51286 · Substantial damage
  > The fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.
- [NTSB CHI02LA195](https://openairdocs.org/ntsb/CHI02LA195.md): Meyers OTW-145 · Waupun, WI · Accident · No injuries · Limited investigation · Final report · Jul 20, 2002 · N34321 · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the fuel pump failure. Contributing to the accident was the wheat field.
- [NTSB CHI02FA234](https://openairdocs.org/ntsb/CHI02FA234.md): Piper PA-28-180 · Macomb, MI · Accident · No injuries · Field investigation · Final report · Jul 20, 2002 · N16319 · Substantial damage
  > The cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.
- [NTSB ATL02LA144](https://openairdocs.org/ntsb/ATL02LA144.md): Piper PA-32RT-300 · Atlantic Ocean, Bahamas · Accident · 5 fatal · Limited investigation · Final report · Jul 20, 2002 · N9738C · Destroyed
  > The pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.
- [NTSB NYC02FA142](https://openairdocs.org/ntsb/NYC02FA142.md): Beech C24R · Grindstone, PA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 2002 · N18860 · Destroyed
  > The pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.
- [NTSB FTW02LA216](https://openairdocs.org/ntsb/FTW02LA216.md): Bell TH-13T · New Iberia, LA · Accident · No injuries · Limited investigation · Final report · Jul 18, 2002 · N99628 · Substantial damage
  > The loss of engine power for undetermined reasons. High vegetation was a factor.
- [NTSB CHI02FA193](https://openairdocs.org/ntsb/CHI02FA193.md): Piper PA-28-180 · Lee's Summit, MO · Accident · 2 fatal · Field investigation · Final report · Jul 18, 2002 · N5164L · Destroyed
  > The inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…
- [NTSB ANC02LA080](https://openairdocs.org/ntsb/ANC02LA080.md): Luscombe 8A · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 2002 · N45796 · Substantial damage
  > The pilot's selection of an unsuitable runway for takeoff, which precipitated an in-flight loss of control and subsequent collision with terrain.
- [NTSB MIA02LA136](https://openairdocs.org/ntsb/MIA02LA136.md): Yakovlev Yak 52 · Parrish, FL · Accident · No injuries · Limited investigation · Final report · Jul 17, 2002 · N2183F · Substantial damage
  > The in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.
- [NTSB ATL02FA143](https://openairdocs.org/ntsb/ATL02FA143.md): Cessna 150G · Duncanville, AL · Accident · 2 fatal · Field investigation · Final report · Jul 17, 2002 · N3400J · Destroyed
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.
- [NTSB SEA02LA132](https://openairdocs.org/ntsb/SEA02LA132.md): Piper PA-28 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Jul 16, 2002 · N1248H · Substantial damage
  > The pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…
- [NTSB LAX02LA228](https://openairdocs.org/ntsb/LAX02LA228.md): Schweizer 269C-1 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Jul 15, 2002 · N20256 · Substantial damage
  > The main rotor mast support tube failure as a result of fatigue.
- [NTSB SEA02LA134](https://openairdocs.org/ntsb/SEA02LA134.md): Champion 7ECA · Kittitas, WA · Accident · No injuries · Limited investigation · Final report · Jul 14, 2002 · N9542S · Substantial damage
  > The pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.
- [NTSB FTW02LA205](https://openairdocs.org/ntsb/FTW02LA205.md): Piper PA-28-161 · Purcell, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 2002 · N96PF · Destroyed
  > The in-flight cabin fire as result of non-compliance with an AD and a Service Bulletin. A contributing factor to the accident was night conditions.
- [NTSB DEN02LA073](https://openairdocs.org/ntsb/DEN02LA073.md): Piper PA-28-140 · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Jul 14, 2002 · N4690R · Substantial damage
  > the pilot-in-command failure to obtain/maintain proper rate of climb, resulting in a collision with terrain. Contributing factors were the high density altitude and exceeding the airplane's forward center of gravity limit.
- [NTSB ATL02LA139](https://openairdocs.org/ntsb/ATL02LA139.md): Piper PA-31-325 · Weaverville, NC · Accident · No injuries · Limited investigation · Final report · Jul 14, 2002 · N27626 · Substantial damage
  > The pilot's inadequate preflight and in-flight planning of fuel to complete the flight that resulted in the exhaustion of the fuel supply.
- [NTSB NYC02LA139](https://openairdocs.org/ntsb/NYC02LA139.md): Micket Avid Aerobat · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Jul 13, 2002 · N11BV · Substantial damage
  > A total loss of engine power due to a seized cylinder, and the pilot's improper decision to conduct the flight with a known deficiency to the engine.
- [NTSB DEN02LA075](https://openairdocs.org/ntsb/DEN02LA075.md): American General AA5B · Worland, WY · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 2002 · N28717 · Destroyed
  > the pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.
- [NTSB SEA02LA130](https://openairdocs.org/ntsb/SEA02LA130.md): Thurmond Moni · Laurel, MT · Accident · No injuries · Limited investigation · Final report · Jul 12, 2002 · N9104S · Substantial damage
  > Undertorqued mounting bolts which resulted in fatigue to the wooden propeller blade and subsequent in flight separation of one of the blades while in cruise flight. An improper installation of the propeller assembly and soft terrain encountered during the…
- [NTSB MIA02FA131](https://openairdocs.org/ntsb/MIA02FA131.md): American General AA-5 · Boca Raton, FL · Accident · 2 fatal · Field investigation · Final report · Jul 12, 2002 · N6024L · Minor damage
  > The owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.
- [NTSB SEA02LA126](https://openairdocs.org/ntsb/SEA02LA126.md): Cosmos Phase II · Deer Park, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2002 · UNREG · Substantial damage
  > Loss of control for undetermined reasons.
- [NTSB CHI02LA187](https://openairdocs.org/ntsb/CHI02LA187.md): Cessna 152 · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Jul 10, 2002 · N621AF · Substantial damage
  > An improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…
- [NTSB CHI02LA186](https://openairdocs.org/ntsb/CHI02LA186.md): Cessna 175 · Kaiser/Lake Oza, MO · Accident · No injuries · Limited investigation · Final report · Jul 9, 2002 · N175HL · Substantial damage
  > The pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…
- [NTSB NYC02LA133](https://openairdocs.org/ntsb/NYC02LA133.md): Piper J3-C65 · Andover, NJ · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2002 · N9264 · Substantial damage
  > The flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.
- [NTSB LAX02LA218](https://openairdocs.org/ntsb/LAX02LA218.md): Bell 47G-2 · Compton, CA · Accident · No injuries · Limited investigation · Final report · Jul 7, 2002 · N2483B · Substantial damage
  > the failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.
- [NTSB SEA02FA125](https://openairdocs.org/ntsb/SEA02FA125.md): Cessna 172N · Otis, OR · Accident · 2 fatal · Field investigation · Final report · Jul 6, 2002 · N738QT · Destroyed
  > The pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.
- [NTSB NYC02LA132](https://openairdocs.org/ntsb/NYC02LA132.md): Beech C23 · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · Jul 6, 2002 · N823DA · Substantial damage
  > A power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.
- [NTSB LAX02LA220](https://openairdocs.org/ntsb/LAX02LA220.md): Bushby Mustang M-11 · Pahrump, NV · Accident · No injuries · Limited investigation · Final report · Jul 5, 2002 · N30430 · Substantial damage
  > the failure and separation of a propeller blade for undetermined reasons.
- [NTSB SEA02FA119](https://openairdocs.org/ntsb/SEA02FA119.md): Cessna 335 · Tensed, ID · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2002 · N27069 · Substantial damage
  > Aircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.
- [NTSB NYC02LA130](https://openairdocs.org/ntsb/NYC02LA130.md): Wheeler Volksplane VP-2 · Collins, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2002 · N21267 · Substantial damage
  > The separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.
- [NTSB NYC02LA129](https://openairdocs.org/ntsb/NYC02LA129.md): Pank KitFox · Sprakers, NY · Accident · 1 fatal · Limited investigation · Final report · Jul 3, 2002 · UNREG · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in category of aircraft.
- [NTSB MIA02LA126](https://openairdocs.org/ntsb/MIA02LA126.md): Rockwell International 112TC · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jul 3, 2002 · N4561W · Destroyed
  > The pilot's improper planning/decision and insufficient refueling which resulted in the loss of engine power due to fuel exhaustion and the aircraft being ditched in the ocean.
- [NTSB SEA02LA117](https://openairdocs.org/ntsb/SEA02LA117.md): Cessna 172 E · Battle Ground, WA · Accident · No injuries · Limited investigation · Final report · Jul 2, 2002 · N37065 · Substantial damage
  > Improper maintenance procedures by maintenance personnel, which resulted in an engine oil leak while in flight. A factor was the pilot's misjudgment of distance during the precautionary landing which led to a runway overrun.
- [NTSB MIA02LA124](https://openairdocs.org/ntsb/MIA02LA124.md): Mckean Varieze · Covington, TN · Accident · No injuries · Limited investigation · Final report · Jul 2, 2002 · N57EZ · Substantial damage
  > The pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.
- [NTSB MIA02LA123](https://openairdocs.org/ntsb/MIA02LA123.md): Cessna CE-182-A · Siler City, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 2002 · N9996B · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB FTW02FA195](https://openairdocs.org/ntsb/FTW02FA195.md): Beech H-18 · Tatum, NM · Accident · 1 fatal · Field investigation · Final report · Jul 1, 2002 · N835K · Destroyed
  > The failure of the pilot to maintain clearance.
- [NTSB LAX02FA210](https://openairdocs.org/ntsb/LAX02FA210.md): Beech C35 · Chambers, AZ · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2002 · N5856C · Destroyed
  > The pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.
- [NTSB FTW02FA192](https://openairdocs.org/ntsb/FTW02FA192.md): Piper PA-24-260 · Gorman, TX · Accident · 4 fatal · Field investigation · Final report · Jun 30, 2002 · N8681P · Destroyed
  > The pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.
- [NTSB CHI02LA179](https://openairdocs.org/ntsb/CHI02LA179.md): Waltz RV-8 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Jun 30, 2002 · N877TC · Substantial damage
  > A loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.
- [NTSB DEN02LA066](https://openairdocs.org/ntsb/DEN02LA066.md): Cessna 172M · Hite, UT · Accident · No injuries · Limited investigation · Final report · Jun 29, 2002 · N725EC · Substantial damage
  > the pilot's improper in-flight planning resulting in fuel exhaustion. A factor relating to the accident was the unsuitable terrain encountered during the forced landing attempt.
- [NTSB FTW02LA197](https://openairdocs.org/ntsb/FTW02LA197.md): Robinson R44 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 28, 2002 · N144WT · Substantial damage
  > The pilot's loss of control after encountering dynamic rollover during takeoff. A contributing factor was the pilot's inadequate preflight inspection.

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

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

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