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

## Cases, newest first

- [NTSB ANC03LA044](https://openairdocs.org/ntsb/ANC03LA044.md): Piper PA-32-300 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Apr 16, 2003 · N2863T · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with terrain during cruise flight. Factors associated with the accident were flat light conditions, and snow-covered terrain.
- [NTSB FTW03LA129](https://openairdocs.org/ntsb/FTW03LA129.md): Beech V35B · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2003 · N390BC · Substantial damage
  > A loss of engine power due to corrosion and contamination of the fuel system, and the partially blocked fuel lines and nozzles.
- [NTSB ANC03LA041](https://openairdocs.org/ntsb/ANC03LA041.md): Piper PA-18 · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Apr 14, 2003 · N339T · Substantial damage
  > The pilot's selection of an unsuitable landing area in deep snow, which resulted in the nose over of the airplane on touchdown. A factor associated with the accident was a snow-covered airstrip.
- [NTSB LAX03FA134](https://openairdocs.org/ntsb/LAX03FA134.md): Hughes 269B · Auburn, CA · Accident · 2 fatal · Field investigation · Final report · Apr 11, 2003 · N16133 · Destroyed
  > the misjudged flare maneuver by an unknown crewmember during a likely practice autorotation that resulted in an in-flight collision with terrain.
- [NTSB LAX03IA137](https://openairdocs.org/ntsb/LAX03IA137.md): Airbus Industrie A300F4-605R · Oakland, CA · Incident · No injuries · Incident investigation · Final report · Apr 10, 2003 · N676FE · No damage
  > the failure of the 1R evacuation slide to inflate because the transport-locking pin had not been removed from the regulator during the slide's installation on the 1R door. The cause of the cabin/cockpit smoke was contamination of the air conditioning packs.
- [NTSB CHI03LA101](https://openairdocs.org/ntsb/CHI03LA101.md): Beech K35 · Richmond, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 2003 · N614Q · Substantial damage
  > The pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.
- [NTSB ATL03FA077](https://openairdocs.org/ntsb/ATL03FA077.md): Cessna 414 · Waleska, GA · Accident · 1 fatal · Field investigation · Final report · Apr 10, 2003 · N822DB · Destroyed
  > The pilot's failure to maintain clearance from terrain.
- [NTSB ATL03FA075](https://openairdocs.org/ntsb/ATL03FA075.md): Cessna 180 · Oxford, AL · Accident · 2 fatal · Field investigation · Final report · Apr 10, 2003 · N3166D · Destroyed
  > The pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.
- [NTSB SEA03FA059](https://openairdocs.org/ntsb/SEA03FA059.md): Cessna T207 A · Merlin, OR · Accident · 2 fatal · Field investigation · Final report · Apr 9, 2003 · N9785M · Destroyed
  > The pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.
- [NTSB CHI03LA100](https://openairdocs.org/ntsb/CHI03LA100.md): Piper PA-22-108 · Rose Hill, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 2003 · N4860Z · Substantial damage
  > The loss of engine power due to the failure of the left magneto and the pilot's failure to identify the malfunctioning magneto. A factor to the accident was the soft terrain condition encountered during the forced landing.
- [NTSB LAX03LA132](https://openairdocs.org/ntsb/LAX03LA132.md): Deer/Reffalt BD · Greenfield, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 2003 · N4365K · Substantial damage
  > The loss of engine power during cruise flight for undetermined reasons.
- [NTSB LAX03LA130](https://openairdocs.org/ntsb/LAX03LA130.md): Piper PA-28-181 · Baker, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 2003 · N8465R · Substantial damage
  > the separation of a propeller blade tip due to fatigue cracking that resulted from improper maintenance repair procedures.
- [NTSB LAX03FA131](https://openairdocs.org/ntsb/LAX03FA131.md): Piper PA-28-140 · Big Bear Lake, CA · Accident · 2 fatal · Field investigation · Final report · Apr 6, 2003 · N8719N · Destroyed
  > the pilot's inadequate decision regarding a departure route and his failure to maintain clearance with rapidly rising mountainous terrain. A factor in the accident was the pilot's impairment by the effects of exposure to marijuana within the 10-hour period…
- [NTSB FTW03LA121](https://openairdocs.org/ntsb/FTW03LA121.md): Boeing 737-924 · Palestine, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 2003 · N71411 · No damage
  > The airplane's encounter with unforecasted clear air turbulence during cruise flight.
- [NTSB DEN03LA063](https://openairdocs.org/ntsb/DEN03LA063.md): Airbus Industrie A319-111 · Pueblo, CO · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 2003 · N917FR · No damage
  > in-flight encounter with turbulence.
- [NTSB LAX03LA128](https://openairdocs.org/ntsb/LAX03LA128.md): Cessna 172N · Anaheim, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 2003 · N6272D · Substantial damage
  > Failure of company maintenance personnel to correctly install and safety wire the oil drain plug, which led to a loss of engine oil and a catastrophic internal failure of the engine.
- [NTSB LAX03LA127](https://openairdocs.org/ntsb/LAX03LA127.md): Piper PA-28-181 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 2003 · N21175 · Substantial damage
  > The pilot's inadequate in-flight planning/decision resulting in fuel exhaustion which resulted in a total loss of engine power during cruise flight, and a subsequent on-ground collision with a pole and a fence during the ensuing emergency landing.
- [NTSB ANC03LA039](https://openairdocs.org/ntsb/ANC03LA039.md): Cessna 207 · Aniak, AK · Accident · No injuries · Limited investigation · Final report · Apr 5, 2003 · N207SE · Substantial damage
  > The pilot's improper fuel management, and subsequent fuel starvation during cruise flight. A factor contributing to the accident was unsuitable terrain for a forced landing.
- [NTSB LAX03LA123](https://openairdocs.org/ntsb/LAX03LA123.md): Robinson R-44 II · Willcox, AZ · Accident · No injuries · Limited investigation · Final report · Apr 2, 2003 · N233TR · Substantial damage
  > The failure of the alternator belt which resulted in the failure of the main drive belt.
- [NTSB MIA03LA090](https://openairdocs.org/ntsb/MIA03LA090.md): Piper PA-28R-180 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Apr 1, 2003 · N4952J · Substantial damage
  > A loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.
- [NTSB CHI03IA097](https://openairdocs.org/ntsb/CHI03IA097.md): Boeing 747-422 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Apr 1, 2003 · N175UA · No damage
  > Failure of company maintenance personnel to fully comply with published maintenance/inspection procedures, as well as the resulting inoperative drain heaters and restricted movement of the aileron control cables. Contributing factors were the impeded waste…
- [NTSB ATL03IA073](https://openairdocs.org/ntsb/ATL03IA073.md): Cessna 182P · Eufaula, AL · Incident · No injuries · Incident investigation · Final report · Apr 1, 2003 · N696SP · Minor damage
  > Fatigue failure of end rib for the left canard flap.
- [NTSB NYC03LA076](https://openairdocs.org/ntsb/NYC03LA076.md): Cessna 172P · Shenandoah, VA · Accident · No injuries · Limited investigation · Final report · Mar 31, 2003 · CGIKO · Substantial damage
  > The pilot's inadvertent encounter with snow showers. Factors were the snow and the unsuitable landing area.
- [NTSB NYC03LA075](https://openairdocs.org/ntsb/NYC03LA075.md): Beech B-60 · Bradford, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2003 · N215CQ · Destroyed
  > The pilot's improper decision to maneuver for a landing in a configuration that exceeded the capability of the airplane to maintain altitude, after he lost power on one engine for undetermined reason(s).
- [NTSB FTW03FA120](https://openairdocs.org/ntsb/FTW03FA120.md): Piper PA-32-300 · Broken Arrow, OK · Accident · 3 fatal · Field investigation · Final report · Mar 31, 2003 · N70NZ · Destroyed
  > Failure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…
- [NTSB CHI03LA095](https://openairdocs.org/ntsb/CHI03LA095.md): Air Tractor AT-401 · Knox, IN · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2003 · N45297 · Substantial damage
  > A loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.
- [NTSB CHI03FA094](https://openairdocs.org/ntsb/CHI03FA094.md): Beech A36 · New Vienna, IA · Accident · 3 fatal · Field investigation · Final report · Mar 28, 2003 · N1636W · Destroyed
  > The improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…
- [NTSB ATL03FA070](https://openairdocs.org/ntsb/ATL03FA070.md): Cessna 172R · Cherokee, NC · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2003 · N35255 · Destroyed
  > The pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.
- [NTSB IAD03LA041](https://openairdocs.org/ntsb/IAD03LA041.md): Aeronca CH-7A · Cumberland, MD · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2003 · N83519 · Substantial damage
  > The pilot/mechanic's failure to ensure the proper installation of the left wing's aft strut-to-spar attachment bolt, which resulted in a loss of control and a subsequent impact with terrain.
- [NTSB ATL03LA072](https://openairdocs.org/ntsb/ATL03LA072.md): Rotorway 162F · Greensboro, NC · Accident · No injuries · Limited investigation · Final report · Mar 27, 2003 · N92AL · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for flight which resulted in fuel exhaustion, and a complete loss of engine power followed by a forced landing, and a dynamic rollover during the autorotative touchdown.
- [NTSB ATL03FA068](https://openairdocs.org/ntsb/ATL03FA068.md): Rockwell 690B · Homerville, GA · Accident · 2 fatal · Field investigation · Final report · Mar 27, 2003 · N53LG · Destroyed
  > An in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.
- [NTSB FTW03FA117](https://openairdocs.org/ntsb/FTW03FA117.md): Bell 407 · Houma, LA · Accident · No injuries · Field investigation · Final report · Mar 24, 2003 · N501PH · Substantial damage
  > The loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.
- [NTSB DEN03LA055](https://openairdocs.org/ntsb/DEN03LA055.md): Mohr Starduster Too · Espanola, NM · Accident · No injuries · Limited investigation · Final report · Mar 23, 2003 · N3696 · Substantial damage
  > the pilot's improper inflight planning in that he failed to consult the airplane flight manual, his use of incorrect fuel consumption figures, and fuel exhaustion. Contributing factors were the loss of the en route chart, the unavailability of a nav/comm…
- [NTSB MIA03LA078](https://openairdocs.org/ntsb/MIA03LA078.md): Cessna 172P · Potts Camp, MS · Accident · No injuries · Limited investigation · Final report · Mar 21, 2003 · N89811 · Substantial damage
  > The pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.
- [NTSB CHI03IA096](https://openairdocs.org/ntsb/CHI03IA096.md): Cessna 208B · Saginaw, MI · Incident · Minor injuries · Incident investigation · Final report · Mar 19, 2003 · N1114N · Minor damage
  > Failure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.
- [NTSB ANC03LA032](https://openairdocs.org/ntsb/ANC03LA032.md): Rockwell 500-S · Chickaloon, AK · Accident · No injuries · Limited investigation · Final report · Mar 19, 2003 · N903AK · Substantial damage
  > The improper installation of an engine fuel line fitting by contracted maintenance personnel resulting in an in-flight engine fire. Contributing factors in the accident were an inadequate annual inspection by company maintenance personnel, and the lack of…
- [NTSB DEN03LA051](https://openairdocs.org/ntsb/DEN03LA051.md): Panzl PAN · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2003 · N11ZL · Substantial damage
  > the pilot's inadequate preflight preparation and his lack of familiarity with the airplane, which subsequently resulted in fuel starvation to the engine. Contributing factors were unfavorable wind conditions and the downdraft weather condition.
- [NTSB CHI03FA086](https://openairdocs.org/ntsb/CHI03FA086.md): Cessna 172N · Foley, MN · Accident · 3 fatal · Field investigation · Final report · Mar 16, 2003 · N5315D · Destroyed
  > The pilot's continued visual flight into instrument meteorological conditions which led to spatial disorientation and subsequent impact with the ground. Contributing factors was the pilot's lack of instrument rating, the pilot's disregard of the preflight…
- [NTSB SEA03FA045](https://openairdocs.org/ntsb/SEA03FA045.md): Cessna 501 · Carey, ID · Accident · 3 fatal · Field investigation · Final report · Mar 15, 2003 · N70FJ · Destroyed
  > Pilot incapacitation for unknown reasons.
- [NTSB FTW03LA109](https://openairdocs.org/ntsb/FTW03LA109.md): Cessna 150G · Hope, AR · Accident · No injuries · Limited investigation · Final report · Mar 15, 2003 · N493RA · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW03FA111](https://openairdocs.org/ntsb/FTW03FA111.md): Piper PA-38-112 · Prattsville, AR · Accident · 2 fatal · Field investigation · Final report · Mar 15, 2003 · N91594 · Destroyed
  > The pilot's execution of VFR flight into IMC and his failure to maintain obstacle clearance. Fog conditions and the pilot's lack of an instrument rating are contributing factors.
- [NTSB FTW03LA113](https://openairdocs.org/ntsb/FTW03LA113.md): Piper PA-28-180 · Bonham, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 2003 · N5264L · Substantial damage
  > The loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN03LA049](https://openairdocs.org/ntsb/DEN03LA049.md): Piper PA-24-250 · Belen, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 2003 · N6960P · Substantial damage
  > the pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…
- [NTSB ATL03FA061](https://openairdocs.org/ntsb/ATL03FA061.md): Cessna 177 · Old Fort, NC · Accident · 3 fatal · Field investigation · Final report · Mar 14, 2003 · N3275T · Destroyed
  > The pilot's decision to continue VFR flight into IMC and his failure to maintain terrain clearance which resulted in an in-flight collision with mountainous terrain.
- [NTSB NYC03IA066](https://openairdocs.org/ntsb/NYC03IA066.md): Dornier 328-300 · Wellman, OH · Incident · No injuries · Incident investigation · Final report · Mar 13, 2003 · N419FJ · Minor damage
  > An in-flight encounter with lightning.
- [NTSB DEN03LA050](https://openairdocs.org/ntsb/DEN03LA050.md): Piper PA-28R-200 · Delta, CO · Accident · No injuries · Limited investigation · Final report · Mar 13, 2003 · N16438 · Substantial damage
  > the loss of engine power due to company maintenance personnel's inadequate major engine overhaul (an oil pressure fitting in the engine accessory drive case had not been capped). Contributing factors were the loss of engine oil, and lack of suitable terrain…
- [NTSB CHI03FA080](https://openairdocs.org/ntsb/CHI03FA080.md): Mooney M20J · Tower, MI · Accident · 2 fatal · Field investigation · Final report · Mar 10, 2003 · N201ZM · Destroyed
  > The pilot's failure to maintain aircraft control during cruise flight. A factor to the accident was the clouds and night conditions.
- [NTSB LAX03LA110](https://openairdocs.org/ntsb/LAX03LA110.md): Kolb Firestar · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Mar 8, 2003 · N670JW · Substantial damage
  > propeller delamination due to the pilot's failure to properly secure the rear seat shoulder harness prior to flight. A contributing factor was the soft ground in which the airplane landed.
- [NTSB ATL03LA057](https://openairdocs.org/ntsb/ATL03LA057.md): Cessna 172 · Camden, SC · Accident · No injuries · Limited investigation · Final report · Mar 8, 2003 · N3287L · Substantial damage
  > The pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.
- [NTSB LAX03FA108](https://openairdocs.org/ntsb/LAX03FA108.md): Stinson 108-1 · Eloy, AZ · Accident · Minor injuries · Field investigation · Final report · Mar 7, 2003 · N8344K · Substantial damage
  > a loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.

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

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

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