# 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 139 of 718 · 35,889 cases

## Cases, newest first

- [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…
- [NTSB LAX04CA306](https://openairdocs.org/ntsb/LAX04CA306.md): Quicksilver MXL II · Rio Vista, CA · Accident · No injuries · Data collection · Final report · Aug 29, 2004 · N4358Z · Substantial damage
  > the pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.
- [NTSB IAD04LA050](https://openairdocs.org/ntsb/IAD04LA050.md): Embraer EMB-135KL · Clyde, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 2004 · N810AE · No damage
  > An unexpected encounter with clear air turbulence.
- [NTSB FTW04CA224](https://openairdocs.org/ntsb/FTW04CA224.md): Cessna 172S · Leakey, TX · Accident · Minor injuries · Data collection · Final report · Aug 28, 2004 · N2477E · Substantial damage
  > The pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.
- [NTSB CHI04LA243](https://openairdocs.org/ntsb/CHI04LA243.md): Boeing A75 · Wisconsin Rapid, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 28, 2004 · N86600 · Substantial damage
  > The pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.
- [NTSB LAX04FA301](https://openairdocs.org/ntsb/LAX04FA301.md): Bellanca 7ECA · Malibu, CA · Accident · 3 fatal · Field investigation · Final report · Aug 23, 2004 · N53879 · 2 aircraft · Destroyed
  > The failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.
- [NTSB CHI04CA236](https://openairdocs.org/ntsb/CHI04CA236.md): Cessna 182 · Crystal Lake, IL · Accident · No injuries · Data collection · Final report · Aug 23, 2004 · N92848 · Substantial damage
  > Engine failure due to fuel exhaustion as a result of the pilot's failure to secure the left wing fuel cap during preflight. A factor was the trees.
- [NTSB SEA04MA167](https://openairdocs.org/ntsb/SEA04MA167.md): Bell 407 · Battle Mountain, NV · Accident · 5 fatal · Major investigation · Final report · Aug 22, 2004 · N2YN · Destroyed
  > The pilot's failure to maintain clearance from mountainous terrain. Contributing factors were the pilot's improper decision to take the direct route over mountainous terrain, the dark night conditions, and the pressure to complete the mission induced by the…
- [NTSB ATL04CA169](https://openairdocs.org/ntsb/ATL04CA169.md): Aeronca 7AC · Spring Hope, NC · Accident · No injuries · Data collection · Final report · Aug 22, 2004 · N84399 · Substantial damage
  > The binding of the right aileron control cable, which resulted in a loss in aileron control, and subsequent collision with trees and terrain.
- [NTSB IAD04FA040](https://openairdocs.org/ntsb/IAD04FA040.md): Piper PA-31P · Clarkson, NY · Accident · 1 fatal · Field investigation · Final report · Aug 20, 2004 · N57EF · Destroyed
  > The pilot's mismanagement of the fuel by his failure to select the proper fuel tank which resulted in starvation and subsequent loss of engine power in both engines.
- [NTSB DEN04LA128](https://openairdocs.org/ntsb/DEN04LA128.md): Beech 95-B55 · Roosevelt, UT · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2004 · N120F · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.
- [NTSB MIA04LA121](https://openairdocs.org/ntsb/MIA04LA121.md): McDonnell Douglas 369E · Ochopee, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 2004 · N42928 · Substantial damage
  > The pilot's loss of control in flight for undetermined reasons, which resulted in an uncontrolled descent, and subsequent impact with trees and the terrain.
- [NTSB FTW04IA217](https://openairdocs.org/ntsb/FTW04IA217.md): Bell 412 · South Pass 65 · Incident · No injuries · Incident investigation · Final report · Aug 19, 2004 · N22347 · Minor damage
  > The failure and separation of the tail rotor gearbox for undetermined reasons.
- [NTSB SEA04FA166](https://openairdocs.org/ntsb/SEA04FA166.md): Beech BE-99 · Neihart, MT · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2004 · N199GL · Destroyed
  > The pilot's failure to maintain adequate terrain clearance during cruise, which resulted in the in-flight collision with mountainous terrain. Dark night conditions and mountainous terrain were contributing factors.
- [NTSB LAX04LA292](https://openairdocs.org/ntsb/LAX04LA292.md): American Champion 7ECA · Manchester, CA · Accident · No injuries · Limited investigation · Final report · Aug 15, 2004 · N11037 · Substantial damage
  > maintenance personnel's failure to adequately torque the top spark plug on the number one cylinder, which resulted in a separation of that plug and a loss of engine power.
- [NTSB ANC04FA092](https://openairdocs.org/ntsb/ANC04FA092.md): Maule M-5-235C · Seward, AK · Accident · 2 fatal · Field investigation · Final report · Aug 15, 2004 · N6194M · Substantial damage
  > The failure of an aviation mechanic/inspector to adequately inspect the pilot/owner's work during the engine overhaul, which resulted in a loss of engine oil and engine power during cruise flight, and a subsequent ditching. Factors associated with the…
- [NTSB MIA04FA119](https://openairdocs.org/ntsb/MIA04FA119.md): Cessna U206B · Key West, FL · Accident · 1 fatal · Field investigation · Final report · Aug 14, 2004 · N3800G · Substantial damage
  > A loss of engine power for an undetermined reason during cruise flight, which resulted in the pilot ditching the airplane in ocean waters.
- [NTSB IAD04LA036](https://openairdocs.org/ntsb/IAD04LA036.md): Cessna 172M · Brownville Junc, ME · Accident · 1 fatal · Limited investigation · Final report · Aug 12, 2004 · N12959 · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.
- [NTSB FTW04LA211](https://openairdocs.org/ntsb/FTW04LA211.md): Cessna 152 · Abita Springs, LA · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2004 · N6326B · Substantial damage
  > The pilot's failure to maintain obstacle clearance. The pilot's inadequate evaluation of the weather and dark night conditions are contributing factors.
- [NTSB FTW04LA210](https://openairdocs.org/ntsb/FTW04LA210.md): Bellanca BL17-30 · Austin, TX · Accident · No injuries · Limited investigation · Final report · Aug 10, 2004 · N4700V · Substantial damage
  > The loss of engine power due to fuel starvation as result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC04FA185](https://openairdocs.org/ntsb/NYC04FA185.md): Cessna A150L · Kinnelon, NJ · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2004 · N6186F · 2 aircraft · Substantial damage
  > Both pilots inadequate visual lookout, which resulted in a midair collision.
- [NTSB FTW04FA208](https://openairdocs.org/ntsb/FTW04FA208.md): Piper PA-32-300 · Burnet, TX · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2004 · N927RP · Destroyed
  > The pilot's continued flight into known adverse weather, VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. A contributing factor was the cloudy weather.
- [NTSB CHI04FA215](https://openairdocs.org/ntsb/CHI04FA215.md): Jorgensen Velocity XL-RG · Belvidere, KS · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2004 · N190J · Destroyed
  > The non-instrument rated pilot's VFR flight into known instrument meteorological conditions and his failure to maintain aircraft control which resulted in an inverted flat spin, in-flight breakup, and explosion.
- [NTSB LAX04LA287](https://openairdocs.org/ntsb/LAX04LA287.md): Cessna TR182 · Torrance, CA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2004 · N4657S · Substantial damage
  > A wheels up landing due to the failure of the hydraulic hose leading to the nose gear actuator, which depleted the hydraulic system of pressurized fluid.
- [NTSB CHI04LA238](https://openairdocs.org/ntsb/CHI04LA238.md): American AA-1A · Eudora, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2004 · N9442L · Substantial damage
  > A loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.
- [NTSB SEA04FA154](https://openairdocs.org/ntsb/SEA04FA154.md): Cessna 182P · Port Angeles, WA · Accident · 1 fatal · Field investigation · Final report · Aug 4, 2004 · N79404 · Destroyed
  > The pilot's VFR flight into IMC and his failure to maintain clearance from trees. Trees, mountainous terrain, dark night conditions, clouds and VFR flight into IMC were factors.
- [NTSB FTW04CA205](https://openairdocs.org/ntsb/FTW04CA205.md): Cessna 172N · Cleveland, TX · Accident · No injuries · Data collection · Final report · Aug 4, 2004 · N4865G · Substantial damage
  > The student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.
- [NTSB CHI04LA213](https://openairdocs.org/ntsb/CHI04LA213.md): Cessna 208B · Big Rapids, MI · Accident · No injuries · Limited investigation · Final report · Aug 4, 2004 · N1037N · Substantial damage
  > The pilot's failure to verify that the cargo door was latched properly prior to flight and the subsequent in-flight opening of the door. A contributing factor was the box which departed the cargo compartment and struck the horizontal stabilizer.
- [NTSB MIA04FA115](https://openairdocs.org/ntsb/MIA04FA115.md): Robinson R22 Beta · Miami, FL · Accident · 1 fatal · Field investigation · Final report · Aug 2, 2004 · N2566W · Destroyed
  > The failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…
- [NTSB ATL04CA165](https://openairdocs.org/ntsb/ATL04CA165.md): Mooney M20F · Brewton, AL · Accident · No injuries · Data collection · Final report · Aug 2, 2004 · N9663M · Substantial damage
  > A loss of engine power (non-mechanical) for undetermined reasons. A factor was the collision with a fence during emergency landing.
- [NTSB FTW04LA199](https://openairdocs.org/ntsb/FTW04LA199.md): Drzymala RV-4 · Collinsville, TX · Accident · 2 fatal · Limited investigation · Final report · Aug 1, 2004 · N7XD · Substantial damage
  > The pilot's improper in-flight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CHI04FA203](https://openairdocs.org/ntsb/CHI04FA203.md): Knoepflein Lancair Legacy 2000 · Madison, WI · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2004 · N98SN · Destroyed
  > A loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…
- [NTSB DEN04LA113](https://openairdocs.org/ntsb/DEN04LA113.md): Bellanca 14-19-3A · Estes Park, CO · Accident · No injuries · Limited investigation · Final report · Jul 31, 2004 · N1251R · Substantial damage
  > the loss of engine power for undetermined reasons resulting in a forced landing. Factors contributing to the accident were the unsuitable terrain for landing and the mailbox posts.
- [NTSB CHI04CA206](https://openairdocs.org/ntsb/CHI04CA206.md): Tjerrild Rotorway Exec · Eureka, IL · Accident · No injuries · Data collection · Final report · Jul 31, 2004 · N777TJ · Substantial damage
  > The in-flight loss of engine power due to the disconnection of the high tension wire from its ignition coil during cruise flight and the unsuitable terrain the pilot encountered during his forced landing. A factor was the low altitude the helicopter was…
- [NTSB LAX04LA280](https://openairdocs.org/ntsb/LAX04LA280.md): Piper PA-32RT-300 · Ontario, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 2004 · N5GC · Substantial damage
  > a catastrophic engine failure due to the overheating of a connecting rod bearing, and the resulting failure of the rod, for undetermined reasons.
- [NTSB DCA04MA061](https://openairdocs.org/ntsb/DCA04MA061.md): Boeing 777 · Miami, FL · Accident · Serious injuries · Major investigation · Final report · Jul 25, 2004 · N797AN · No damage
  > the in-flight encounter with unforecasted clear air turbulence.
- [NTSB CHI04CA194](https://openairdocs.org/ntsb/CHI04CA194.md): Cessna 182A · Noblesville, IN · Accident · Minor injuries · Data collection · Final report · Jul 25, 2004 · N3708D · Substantial damage
  > The pilot's failure to select carburetor heat and his failure to maintain airspeed resulting in a stall. Factors were unstabilized approach the aircraft's low altitude, and the weather conditions conducive to carburetor icing.
- [NTSB CHI04CA191](https://openairdocs.org/ntsb/CHI04CA191.md): Aerostar RX-7 · Wausau, WI · Accident · Serious injuries · Data collection · Final report · Jul 25, 2004 · N7144Y · No damage
  > The pilot's inability to compensation for the turbulence and wind conditions. Contributing factors were the variable winds and the turbulence.
- [NTSB LAX04LA277](https://openairdocs.org/ntsb/LAX04LA277.md): Cessna 172RG · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2004 · N5167R · Substantial damage
  > The pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…
- [NTSB DEN04FA109](https://openairdocs.org/ntsb/DEN04FA109.md): Beech 58P · Fort Collins, CO · Accident · 3 fatal · Field investigation · Final report · Jul 24, 2004 · N69CL · Destroyed
  > the loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Clouds and the pilot's diverted attention were contributing factors.
- [NTSB DEN04CA121](https://openairdocs.org/ntsb/DEN04CA121.md): Piper PA-24-250 · Model, CO · Accident · Minor injuries · Data collection · Final report · Jul 22, 2004 · N7064P · Substantial damage
  > the pilot's improper in-flight planning and decision making resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the trees.
- [NTSB LAX04LA274](https://openairdocs.org/ntsb/LAX04LA274.md): Finke Rotorway Exec 162F · Cameron Park, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 21, 2004 · N103RW · Destroyed
  > The owner-builder's improper main rotor blade (MRB) maintenance/installation by under torquing the blade retaining nut.
- [NTSB FTW04LA197](https://openairdocs.org/ntsb/FTW04LA197.md): Bell 206B · East Cameron 13 · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 2004 · N133RT · Substantial damage
  > The loss of engine power due to fuel exhaustion. Contributing factors were the fuel quantity gauge's improper fuel level indication, missing instrument placard, company maintenance personnel's improper maintenance records, disregard for company procedures,…
- [NTSB DEN04LA107](https://openairdocs.org/ntsb/DEN04LA107.md): Cessna P210N · Douglas, WY · Accident · No injuries · Limited investigation · Final report · Jul 20, 2004 · N7736K · Substantial damage
  > the failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…
- [NTSB DEN04LA105](https://openairdocs.org/ntsb/DEN04LA105.md): Mooney M20C · Escalante, UT · Accident · No injuries · Limited investigation · Final report · Jul 18, 2004 · N6773U · Substantial damage
  > the improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…
- [NTSB ATL04FA159](https://openairdocs.org/ntsb/ATL04FA159.md): Beech 36TC · Sylvester, GA · Accident · 4 fatal · Field investigation · Final report · Jul 18, 2004 · N1525M · Destroyed
  > The pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.
- [NTSB NYC04LA168](https://openairdocs.org/ntsb/NYC04LA168.md): Airbus Industrie A319 · Flat Rock, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2004 · N812AW · No damage
  > An inadvertent encounter with turbulence in clouds during descent.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.