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

## Cases, newest first

- [NTSB DEN05FA011](https://openairdocs.org/ntsb/DEN05FA011.md): Cessna 182R · Idaho Springs, CO · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2004 · N9437H · Destroyed
  > the pilot's failure to maintain clearance from terrain, and his inadequate planning and decision making resulting in VFR flight into IMC. Contributing factors include the pilot's self-induced pressure to arrive at his destination, the low ceiling and the fog.
- [NTSB MIA05LA003](https://openairdocs.org/ntsb/MIA05LA003.md): de Havilland DH-82C · Cross City, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 2004 · N819DH · Substantial damage
  > A loss of engine power for undetermined reasons, which resulted in a forced landing.
- [NTSB NYC05FA005](https://openairdocs.org/ntsb/NYC05FA005.md): Piper PA-28-161 · Madison, CT · Accident · 2 fatal · Field investigation · Final report · Oct 11, 2004 · N233PA · Substantial damage
  > A loss of engine power due to separation of the propeller due to under-torqued retention bolts.
- [NTSB NYC05FA001](https://openairdocs.org/ntsb/NYC05FA001.md): Cessna 172N · Germantown, NY · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2004 · N2771J · Substantial damage
  > The pilot's inadequate in-flight planning/decision which led to VFR flight into IMC and his loss of aircraft control. Factors were night and cloud conditions.
- [NTSB DEN05LA008](https://openairdocs.org/ntsb/DEN05LA008.md): Cessna 210M · Salida, CO · Accident · No injuries · Limited investigation · Final report · Oct 10, 2004 · N732TE · Substantial damage
  > The pilot's inadequate preflight planning which failed to determine the fuel supply was inadequate resulting in fuel exhaustion and the loss of engine power.
- [NTSB DEN05CA006](https://openairdocs.org/ntsb/DEN05CA006.md): Aerostar SP-1 · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Oct 10, 2004 · N87SB · Destroyed
  > the pilot's failure to maintain clearance with the radio tower. Contributing factors were the pilot's improper compensation for the variable wind conditions.
- [NTSB NYC05CA003](https://openairdocs.org/ntsb/NYC05CA003.md): Cessna 172M · Eliot, ME · Accident · No injuries · Data collection · Final report · Oct 9, 2004 · N80657 · Substantial damage
  > The pilot's inadequate in-flight planning decision, which resulted a loss of engine power due to fuel exhaustion.
- [NTSB DEN05CA009](https://openairdocs.org/ntsb/DEN05CA009.md): Thunder and Colt 180A · Albuquerque, NM · Accident · Serious injuries · Data collection · Final report · Oct 9, 2004 · N784TC · No damage
  > the balloon pilot's improper in-flight planning and failure to maintain aircraft control during descent into high winds resulting in a hard landing and subsequent serious injury to a passenger. Factors contributing to the accident were the high winds and…
- [NTSB ANC05LA003](https://openairdocs.org/ntsb/ANC05LA003.md): Scan 30 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 9, 2004 · N701Q · Substantial damage
  > An in-flight fire during cruise flight for an undetermined reason.
- [NTSB FTW05CA001](https://openairdocs.org/ntsb/FTW05CA001.md): Aerostar S-60A · Austin, TX · Accident · Minor injuries · Data collection · Final report · Oct 4, 2004 · N70466 · Substantial damage
  > The pilot's excessive descent rate during the execution of a high wind landing, resulting in a hard landing. A factor was the high wind.
- [NTSB DEN05LA004](https://openairdocs.org/ntsb/DEN05LA004.md): Worner Balloon Works NL-1000 · Chama, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2004 · DOYES · Destroyed
  > the lightning strike and subsequent failure of the balloon's envelope, resulting in an uncontrolled descent and impact with terrain.
- [NTSB SEA05LA008](https://openairdocs.org/ntsb/SEA05LA008.md): Higgins Acro-Sport II · Coeur d'Alene, ID · Accident · No injuries · Limited investigation · Final report · Oct 2, 2004 · N214JH · Substantial damage
  > The airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.
- [NTSB LAX05LA002](https://openairdocs.org/ntsb/LAX05LA002.md): Classic Waco YMF · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Oct 2, 2004 · N43064 · Substantial damage
  > a loss of engine power due to the fatigue fracture of the number 7 cylinder exhaust rocker arm as a result of a grinding operation during manufacture.
- [NTSB ATL05LA001](https://openairdocs.org/ntsb/ATL05LA001.md): Stinson 108 · Ashland, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2004 · N40129 · Substantial damage
  > A total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.
- [NTSB MIA05LA001](https://openairdocs.org/ntsb/MIA05LA001.md): Rotorway 162F · New Smyrna Beac, FL · Accident · No injuries · Limited investigation · Final report · Oct 1, 2004 · N7059F · Substantial damage
  > A loss of engine power due to undetermined reasons, which resulted in the pilot entering autorotation and affecting a forced landing to the water.
- [NTSB MIA04LA134](https://openairdocs.org/ntsb/MIA04LA134.md): Boeing 767-232 · Caribbean Sea · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2004 · N109DL · No damage
  > An inadvertent encounter with severe turbulence during cruise, which resulted in a flight attendant being injured.
- [NTSB MIA04LA133](https://openairdocs.org/ntsb/MIA04LA133.md): Britten-Norman BN-2A-27 · Vega Baja, PR · Accident · 1 fatal · Limited investigation · Final report · Sep 29, 2004 · N902GD · Destroyed
  > The pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.
- [NTSB NYC04LA218](https://openairdocs.org/ntsb/NYC04LA218.md): Cessna 152 · Dayton, OH · Accident · No injuries · Limited investigation · Final report · Sep 26, 2004 · N67520 · Substantial damage
  > The student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.
- [NTSB ATL04CA193](https://openairdocs.org/ntsb/ATL04CA193.md): Cessna 177 · Anderson, SC · Accident · No injuries · Data collection · Final report · Sep 26, 2004 · N29650 · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB MIA04LA129](https://openairdocs.org/ntsb/MIA04LA129.md): Bell 206B3 · Starkville, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 2004 · N96PH · Substantial damage
  > The operator's inadequate maintenance inspections and the pilot's inadequate preflight inspection, which resulted in the helicopter being operated with a contaminated fuel system, that resulted in fuel starvation, and the loss of engine power.
- [NTSB FTW04FA243](https://openairdocs.org/ntsb/FTW04FA243.md): Cessna 421C · Bee Caves, TX · Accident · 2 fatal · Field investigation · Final report · Sep 23, 2004 · N729DM · Destroyed
  > The pilot's improper positioning of the fuel selector valves, which resulted in a loss of power to the left engine due to fuel exhaustion. After the power loss, the pilot failed to follow checklist procedures and did not secure (feather) the left propeller,…
- [NTSB ATL04CA191](https://openairdocs.org/ntsb/ATL04CA191.md): Pinkham Challenger II · Lancaster, SC · Accident · Serious injuries · Data collection · Final report · Sep 22, 2004 · N2079S · Substantial damage
  > A partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…
- [NTSB FTW04CA242](https://openairdocs.org/ntsb/FTW04CA242.md): Piper PA-28-181 · Haskell, TX · Accident · Minor injuries · Data collection · Final report · Sep 21, 2004 · N282HP · Substantial damage
  > The pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA04GA192](https://openairdocs.org/ntsb/SEA04GA192.md): Cessna U206G · Essex, MT · Accident · 3 fatal · Final report · Sep 20, 2004 · N206SM · Destroyed
  > The pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…
- [NTSB LAX04CA326](https://openairdocs.org/ntsb/LAX04CA326.md): Iar Sa Brasov 823 · Denair, CA · Accident · No injuries · Data collection · Final report · Sep 20, 2004 · N823WT · Substantial damage
  > the pilot's failure to verify the fuel quantity on board prior to departure, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.
- [NTSB NYC04LA214](https://openairdocs.org/ntsb/NYC04LA214.md): Ryan ST3KR · Bealeton, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2004 · N57015 · Substantial damage
  > The improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.
- [NTSB LAX04LA324](https://openairdocs.org/ntsb/LAX04LA324.md): Cirrus SR-22 · Peters, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 2004 · N931CD · Substantial damage
  > The pilot's decision to continue flight into adverse weather and the subsequent encounter with the outer boundaries of a level 5 thunderstorm, which resulted in his loss of control of the airplane.
- [NTSB MIA04CA130](https://openairdocs.org/ntsb/MIA04CA130.md): Lemuel May Leza-Lockwood Aircam · Ashland, MS · Accident · No injuries · Data collection · Final report · Sep 18, 2004 · N9074W · Substantial damage
  > The pilot's inadequate preflight planning/preparation for his failure to assure that the fuel shutoff valves located in both engine compartments were turned on and also the failure of the pilot to have a checklist to outline preflight items.
- [NTSB CHI04LA283](https://openairdocs.org/ntsb/CHI04LA283.md): Cessna 172M · Houstonia, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2004 · N80237 · Substantial damage
  > The fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.
- [NTSB FTW04CA239](https://openairdocs.org/ntsb/FTW04CA239.md): Cessna 150L · Mountain Home, TX · Accident · No injuries · Data collection · Final report · Sep 17, 2004 · N11418 · Substantial damage
  > The pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI04IA260](https://openairdocs.org/ntsb/CHI04IA260.md): McDonnell Douglas DC-9-82 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 16, 2004 · N253AA · Minor damage
  > An in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.
- [NTSB ATL04CA186](https://openairdocs.org/ntsb/ATL04CA186.md): Cessna 172RG · Montgomery, AL · Accident · No injuries · Data collection · Final report · Sep 15, 2004 · N948SM · Substantial damage
  > The separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.
- [NTSB ATL04CA185](https://openairdocs.org/ntsb/ATL04CA185.md): Air Tractor AT-502B · Belle Glade, FL · Accident · No injuries · Data collection · Final report · Sep 15, 2004 · N90375 · Substantial damage
  > The pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.
- [NTSB FTW04LA238](https://openairdocs.org/ntsb/FTW04LA238.md): Piper PA-31-350 · Sweeny, TX · Accident · No injuries · Limited investigation · Final report · Sep 14, 2004 · N555MC · Substantial damage
  > The fracture failure of the left engine crankshaft for undetermined reasons.
- [NTSB SEA04LA189](https://openairdocs.org/ntsb/SEA04LA189.md): Cessna P206A · Clearwater, ID · Accident · No injuries · Limited investigation · Final report · Sep 13, 2004 · N4661F · Substantial damage
  > A loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.
- [NTSB NYC04LA210](https://openairdocs.org/ntsb/NYC04LA210.md): Cessna 172B · Wiscasset, ME · Accident · No injuries · Limited investigation · Final report · Sep 12, 2004 · N7422X · Substantial damage
  > The failure of the oil filter adapter seal, which resulted in a loss of oil pressure, and subsequent catastrophic engine failure, and forced landing.
- [NTSB CHI04LA256](https://openairdocs.org/ntsb/CHI04LA256.md): Claxton S-12 · Oconomowoc, WI · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 2004 · UNREG · Destroyed
  > The loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.
- [NTSB ATL04CA179](https://openairdocs.org/ntsb/ATL04CA179.md): Cessna 152 · Inverness, FL · Accident · Minor injuries · Data collection · Final report · Sep 11, 2004 · N35FD · Substantial damage
  > The pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.
- [NTSB CHI04LA254](https://openairdocs.org/ntsb/CHI04LA254.md): Cessna 150F · Ancona, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2004 · N6544F · Substantial damage
  > The pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.
- [NTSB FTW04FA235](https://openairdocs.org/ntsb/FTW04FA235.md): Piper PA-32R-300 · Rachel, TX · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2004 · N6209J · Destroyed
  > The total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…
- [NTSB DEN04LA136](https://openairdocs.org/ntsb/DEN04LA136.md): Cessna 182 · Gillette, WY · Accident · No injuries · Limited investigation · Final report · Sep 6, 2004 · N2725G · Substantial damage
  > improper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB SEA04LA182](https://openairdocs.org/ntsb/SEA04LA182.md): Cessna 172E · Port Angeles, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 2004 · N5788T · Substantial damage
  > The pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.
- [NTSB MIA04LA127](https://openairdocs.org/ntsb/MIA04LA127.md): Mooney M20F · Brandon, MS · Accident · No injuries · Limited investigation · Final report · Sep 5, 2004 · N9708M · Substantial damage
  > A loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.
- [NTSB SEA04LA181](https://openairdocs.org/ntsb/SEA04LA181.md): Hughes 369D · Cottage Grove, OR · Accident · No injuries · Limited investigation · Final report · Sep 4, 2004 · N505ST · Substantial damage
  > In-flight loss of engine power during cruise for undetermined reasons.
- [NTSB CHI04CA252](https://openairdocs.org/ntsb/CHI04CA252.md): Cessna T310R · Marshall, MN · Accident · No injuries · Data collection · Final report · Sep 4, 2004 · N5005J · Substantial damage
  > The pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…
- [NTSB ANC04LA104](https://openairdocs.org/ntsb/ANC04LA104.md): Piper PA-18-150 · Cantwell, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2004 · N9796P · Destroyed
  > An in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.
- [NTSB NYC04CA202](https://openairdocs.org/ntsb/NYC04CA202.md): Cessna 305A · Lawrence, MA · Accident · Minor injuries · Data collection · Final report · Sep 3, 2004 · N5208G · Substantial damage
  > The pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.
- [NTSB MIA04LA126](https://openairdocs.org/ntsb/MIA04LA126.md): Maule MX-7-235 · Greenville, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 2004 · N660HB · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.
- [NTSB NYC04LA201](https://openairdocs.org/ntsb/NYC04LA201.md): PZL 101 · Chazy, NY · Accident · No injuries · Limited investigation · Final report · Aug 31, 2004 · N123LZ · Substantial damage
  > The total loss of engine power due to the fractured crankshaft.
- [NTSB LAX04IA311](https://openairdocs.org/ntsb/LAX04IA311.md): Sikorsky S-70A · Pacoima, CA · Incident · No injuries · Incident investigation · Final report · Aug 30, 2004 · N160LA · Minor damage
  > the failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…

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

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

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