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

## Cases, newest first

- [NTSB MIA03LA020](https://openairdocs.org/ntsb/MIA03LA020.md): Cessna 150L · Powells Point, NC · Accident · No injuries · Limited investigation · Final report · Nov 28, 2002 · N10905 · Substantial damage
  > a loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.
- [NTSB NYC03LA026](https://openairdocs.org/ntsb/NYC03LA026.md): Cessna TR182 · Willoughby, OH · Accident · No injuries · Limited investigation · Final report · Nov 27, 2002 · N4929S · Substantial damage
  > The pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun.
- [NTSB LAX03LA041](https://openairdocs.org/ntsb/LAX03LA041.md): Clyde K Carrier Team 1400Z · Woodland, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2002 · N9190U · Substantial damage
  > the builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss…
- [NTSB FTW03FA051](https://openairdocs.org/ntsb/FTW03FA051.md): Piper PA-34-220T · McAlester, OK · Accident · 5 fatal · Field investigation · Final report · Nov 27, 2002 · N699WG · Destroyed
  > The pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…
- [NTSB DEN03LA021](https://openairdocs.org/ntsb/DEN03LA021.md): Piper PA-28-180 · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2002 · N9020J · Substantial damage
  > the pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.
- [NTSB SEA03FA013](https://openairdocs.org/ntsb/SEA03FA013.md): Cessna 172P · Malaga, WA · Accident · 2 fatal · Field investigation · Final report · Nov 26, 2002 · N65564 · Destroyed
  > The pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…
- [NTSB FTW03FA048](https://openairdocs.org/ntsb/FTW03FA048.md): Beech A36 · Salem, UT · Accident · 2 fatal · Field investigation · Final report · Nov 25, 2002 · N367T · Destroyed
  > The pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…
- [NTSB SEA03LA011](https://openairdocs.org/ntsb/SEA03LA011.md): Peterson Dragonfly · Mulino, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 2002 · N2448 · Substantial damage
  > Fuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.
- [NTSB NYC03LA023](https://openairdocs.org/ntsb/NYC03LA023.md): Cessna 172K · Prestonsburg, KY · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N7192G · Substantial damage
  > The loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.
- [NTSB CHI03LA029](https://openairdocs.org/ntsb/CHI03LA029.md): Piper PA-23-250 · Stalwart, MI · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N5985Y · Substantial damage
  > The pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…
- [NTSB CHI03LA028](https://openairdocs.org/ntsb/CHI03LA028.md): Woods Velocity · Claflin, KS · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N241KW · Substantial damage
  > The total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing.
- [NTSB LAX03LA036](https://openairdocs.org/ntsb/LAX03LA036.md): Asmus Exec 162F · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Nov 21, 2002 · N162LC · Substantial damage
  > The loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.
- [NTSB NYC03FA024](https://openairdocs.org/ntsb/NYC03FA024.md): Socata TB-20 · Massena, NY · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2002 · N57TB · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.
- [NTSB LAX03LA034](https://openairdocs.org/ntsb/LAX03LA034.md): Cessna T210 L · Williams, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2002 · N59132 · Destroyed
  > An in-flight fire for undetermined reasons.
- [NTSB FTW03FA044](https://openairdocs.org/ntsb/FTW03FA044.md): Cessna 210L · Kentwood, LA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2002 · N93770 · Destroyed
  > The failure of the #1 and #2 connecting rods during climb to cruise due to overheating, resulting from oil starvation. A contributing factor was the low cloud conditions limiting the pilot's visibility during the ensuing emergency landing.
- [NTSB CHI03FA025](https://openairdocs.org/ntsb/CHI03FA025.md): Robinson R22 · St. Jacob, IL · Accident · No injuries · Field investigation · Final report · Nov 20, 2002 · N559DD · Substantial damage
  > Fatigue fracture of the clutch assembly fan shaft and the resulting complete loss of power to the rotor drive system. A contributing factor was the loss of tail rotor authority due to the secondary failure of the control tube assembly.
- [NTSB MIA03LA019](https://openairdocs.org/ntsb/MIA03LA019.md): John H. Heiring Express · Moncks Corner, SC · Accident · 3 fatal · Limited investigation · Final report · Nov 19, 2002 · N297JH · Destroyed
  > The pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.
- [NTSB NYC03IA027](https://openairdocs.org/ntsb/NYC03IA027.md): Canadair CL-600-2B19 · Rockville, VA · Incident · No injuries · Incident investigation · Final report · Nov 17, 2002 · N868CA · No damage
  > The PIC's inadvertent encounter with turbulence while operating in an area of forecast occasional severe turbulence.
- [NTSB NYC03FA022](https://openairdocs.org/ntsb/NYC03FA022.md): Cessna 182D · NewPhiladelphia, OH · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2002 · N9964T · Destroyed
  > The pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing…
- [NTSB FTW03LA041](https://openairdocs.org/ntsb/FTW03LA041.md): Cessna 152 · Houston, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 17, 2002 · N4794P · No damage
  > The dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.
- [NTSB LAX03LA032](https://openairdocs.org/ntsb/LAX03LA032.md): Bellanca 14-19 · Napa, CA · Accident · No injuries · Limited investigation · Final report · Nov 16, 2002 · N501A · Substantial damage
  > the pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.
- [NTSB ANC03LA015](https://openairdocs.org/ntsb/ANC03LA015.md): Bell 206B · Kingman, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 15, 2002 · N16962 · Substantial damage
  > The pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.
- [NTSB ATL03LA016](https://openairdocs.org/ntsb/ATL03LA016.md): Chance Vought F4U-4 · Columbia, SC · Accident · 1 fatal · Limited investigation · Final report · Nov 10, 2002 · N713JT · Destroyed
  > An in-flight engine fire for undetermined reasons
- [NTSB IAD03LA012](https://openairdocs.org/ntsb/IAD03LA012.md): Westland Helicopters Gazelle AH-MK1 · East Hampton, NY · Accident · 1 fatal · Limited investigation · Final report · Nov 9, 2002 · N911XW · Destroyed
  > The pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with water. Factors included the pilot's decision to fly over water on a moonless night, his lack of experience in that environment, and the dark night lighting…
- [NTSB LAX03FA025](https://openairdocs.org/ntsb/LAX03FA025.md): Cessna 150E · Anaheim Hills, CA · Accident · 1 fatal · Field investigation · Final report · Nov 8, 2002 · N6236T · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.
- [NTSB DEN03FA012](https://openairdocs.org/ntsb/DEN03FA012.md): Cessna 208B · Parks, AZ · Accident · 4 fatal · Field investigation · Final report · Nov 8, 2002 · N514DB · Destroyed
  > the pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…
- [NTSB FTW03LA046](https://openairdocs.org/ntsb/FTW03LA046.md): Piper PA-31-350 · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Nov 6, 2002 · N698VW · Substantial damage
  > The propeller shaft seal leak resulting in an in-flight fire.
- [NTSB DEN03LA014](https://openairdocs.org/ntsb/DEN03LA014.md): Piper PA-28RT · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Nov 6, 2002 · N2904C · Substantial damage
  > the collapse of the left main landing gear during landing roll resulting in loss of control/ground loop/swerve and subsequent impact with a sign. Contributing factors include, the airplane's total loss of electrical power due to an alternator failure and the…
- [NTSB ATL03LA014](https://openairdocs.org/ntsb/ATL03LA014.md): McDonnell Douglas MD-82 · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2002 · N479AA · No damage
  > The airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.
- [NTSB FTW03LA034](https://openairdocs.org/ntsb/FTW03LA034.md): Rockwell 690B · New Braunfels, TX · Accident · No injuries · Limited investigation · Final report · Nov 1, 2002 · N77UA · Substantial damage
  > The in-flight separation of the top of the rudder assembly for undetermined reasons.
- [NTSB FTW03LA030](https://openairdocs.org/ntsb/FTW03LA030.md): Cessna 172G · Fort Stockton, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2002 · N6072R · Substantial damage
  > The pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.
- [NTSB FTW03FA028](https://openairdocs.org/ntsb/FTW03FA028.md): Hughes 269A · Fort Gibson, OK · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2002 · N8885F · Destroyed
  > The in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.
- [NTSB NYC03FA015](https://openairdocs.org/ntsb/NYC03FA015.md): Cessna 182S · Accident, MD · Accident · 1 fatal · Field investigation · Final report · Oct 31, 2002 · N7099L · Substantial damage
  > The pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.
- [NTSB FTW03LA026](https://openairdocs.org/ntsb/FTW03LA026.md): Cessna 177RG · Marshall, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 2002 · N35866 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL03LA012](https://openairdocs.org/ntsb/ATL03LA012.md): Beech F33A · Fernandina Bch, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 31, 2002 · N3122K · Destroyed
  > Water contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.
- [NTSB ATL03LA011](https://openairdocs.org/ntsb/ATL03LA011.md): Piper PA-28R-200 · Laurel Bloomery, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 2002 · N15704 · Destroyed
  > The pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…
- [NTSB ANC03LA007](https://openairdocs.org/ntsb/ANC03LA007.md): Cessna 207 · Marshall, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 2002 · N91090 · Substantial damage
  > The pilot's failure to maintain clearance from terrain, which resulted in an in-flight collision with a ridgeline. Factors contributing to the accident were the high terrain, the pilot's inadequate preflight planning, and the dark night light conditions.
- [NTSB MIA03FA007](https://openairdocs.org/ntsb/MIA03FA007.md): Cessna 172M · Coral Springs, FL · Accident · 2 fatal · Field investigation · Final report · Oct 27, 2002 · N9840V · 2 aircraft · Destroyed
  > The failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.
- [NTSB IAD03LA010](https://openairdocs.org/ntsb/IAD03LA010.md): Cessna 152 · Springfield, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 2002 · N49422 · Substantial damage
  > Inadequate installation of the number 3 cylinder.
- [NTSB NYC03LA012](https://openairdocs.org/ntsb/NYC03LA012.md): Piper PA-28-161 · Lakewood, NJ · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2002 · N40059 · Substantial damage
  > The pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.
- [NTSB ATL03FA009](https://openairdocs.org/ntsb/ATL03FA009.md): Beechcraft A60 · Jesup, GA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 2002 · N73CR · Destroyed
  > The loss of power in one engine and the loss of control for undetermined reasons.
- [NTSB ATL03FA008](https://openairdocs.org/ntsb/ATL03FA008.md): Cessna 208B · Spanish Fort, AL · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2002 · N76U · Destroyed
  > the pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.
- [NTSB FTW03LA018](https://openairdocs.org/ntsb/FTW03LA018.md): Carriere RW-152 Scorpion II · Opelousas, LA · Accident · No injuries · Limited investigation · Final report · Oct 19, 2002 · N838MC · Substantial damage
  > The pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.
- [NTSB ATL03LA007](https://openairdocs.org/ntsb/ATL03LA007.md): Bell 47G3B1 · Highfalls, GA · Accident · No injuries · Limited investigation · Final report · Oct 19, 2002 · N4002G · Substantial damage
  > The pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…
- [NTSB NYC03LA009](https://openairdocs.org/ntsb/NYC03LA009.md): Cessna 182B · Hartwood, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2002 · N2718G · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion.
- [NTSB NYC03IA011](https://openairdocs.org/ntsb/NYC03IA011.md): Piper PA-28-236 · Altoona, PA · Incident · No injuries · Incident investigation · Final report · Oct 18, 2002 · N4295R · Minor damage
  > A failure of the fuel selector for an undetermined reason.
- [NTSB DEN03LA009](https://openairdocs.org/ntsb/DEN03LA009.md): Piper PA-28-180 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Oct 18, 2002 · N33170 · Substantial damage
  > fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.
- [NTSB FTW03LA013](https://openairdocs.org/ntsb/FTW03LA013.md): Schweizer 269C-1 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Oct 16, 2002 · N61463 · Substantial damage
  > the flight instructor's failure to refuel at an available airport when a low fuel status was identified. Factors were the flight instructor's inadequate preflight flight planning, which included improper fuel consumption calculations, the night light…
- [NTSB NYC03LA004](https://openairdocs.org/ntsb/NYC03LA004.md): de Havilland DHC-8-102 · Albany, NY · Accident · No injuries · Limited investigation · Final report · Oct 15, 2002 · N847EX · Substantial damage
  > An in-flight collision with birds. A factor was the night conditions.
- [NTSB NYC03LA005](https://openairdocs.org/ntsb/NYC03LA005.md): Piper PA-28-181 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2002 · N5675V · Substantial damage
  > The pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.

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

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

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