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

## Cases, newest first

- [NTSB NYC04LA079](https://openairdocs.org/ntsb/NYC04LA079.md): Geoffrion Rotorway Exec 162 · Medina, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 29, 2004 · N198BG · Substantial damage
  > A failure of the helicopter's tail rotor drive system for undetermined reasons.
- [NTSB LAX04LA141](https://openairdocs.org/ntsb/LAX04LA141.md): Vogt KR2S · Lompoc, CA · Accident · No injuries · Limited investigation · Final report · Feb 29, 2004 · N4027Y · Substantial damage
  > a failure of the fuel pump, which induced a total loss of engine power.
- [NTSB LAX04LA140](https://openairdocs.org/ntsb/LAX04LA140.md): Alan Wilson Tandum Air Bike · Elko, NV · Accident · No injuries · Limited investigation · Final report · Feb 29, 2004 · N240JC · Substantial damage
  > A total loss of engine power during cruise flight due to the failure of an ignition system component.
- [NTSB ANC04LA033](https://openairdocs.org/ntsb/ANC04LA033.md): Piper PA-15 · Big Lake, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2004 · N4492H · Substantial damage
  > An in-flight loss of control for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.
- [NTSB LAX04FA139](https://openairdocs.org/ntsb/LAX04FA139.md): Piper PA-28R-180 · Pine Mtn Club, CA · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2004 · N7687J · Destroyed
  > The pilot's continued visual flight into adverse weather conditions at night, which resulted in an in-flight collision with mountainous terrain. The pilot's failure to obtain preflight weather information for the route of flight was also causal.
- [NTSB IAD04LA013](https://openairdocs.org/ntsb/IAD04LA013.md): Schweizer 269C · Media, PA · Accident · No injuries · Limited investigation · Final report · Feb 28, 2004 · N75070 · Substantial damage
  > A lack of previous lubrication to the tail rotor drive shaft forward fitting teeth, which resulted in their gradual wear, the eventual slippage of the shaft, and the subsequent loss of tailrotor thrust and forced landing.
- [NTSB FTW04CA084](https://openairdocs.org/ntsb/FTW04CA084.md): Cessna T210M · Grape Creek, TX · Accident · Minor injuries · Data collection · Final report · Feb 28, 2004 · N50MC · Substantial damage
  > The pilot's improper in-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain available for the forced landing.
- [NTSB CHI04LA082](https://openairdocs.org/ntsb/CHI04LA082.md): Alon A2 Ercoupe · Hawley, MN · Accident · No injuries · Limited investigation · Final report · Feb 28, 2004 · N825DC · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the fence post.
- [NTSB NYC04FA077](https://openairdocs.org/ntsb/NYC04FA077.md): Piper PA-28-181 · Corry, PA · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2004 · N4166P · Substantial damage
  > The loss of partial engine power for undetermined reasons, and the pilot's lost of control after performing an evasive maneuver to avoid trees during a forced landing at night. Factors related to the accident were a rough running engine and the pilot's…
- [NTSB CHI04LA078](https://openairdocs.org/ntsb/CHI04LA078.md): Cessna R182 · Elberfeld, IN · Accident · No injuries · Limited investigation · Final report · Feb 25, 2004 · N5450T · Destroyed
  > The in-flight and on-ground fires in the cabin and engine compartment for undetermined reasons during the flight's cruise and emergency landing.
- [NTSB NYC04LA075](https://openairdocs.org/ntsb/NYC04LA075.md): Cessna 152 · Spencer, MA · Accident · No injuries · Limited investigation · Final report · Feb 24, 2004 · N4669L · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL04FA077](https://openairdocs.org/ntsb/ATL04FA077.md): Piper PA-46-310P · Arlington, AL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2004 · N9103Z · Destroyed
  > The pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.
- [NTSB FTW04FA079](https://openairdocs.org/ntsb/FTW04FA079.md): Cessna 210N · Valley Spring, TX · Accident · 1 fatal · Field investigation · Final report · Feb 22, 2004 · N6175Y · Destroyed
  > The pilot's continued flight into known adverse weather and failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation.
- [NTSB ANC04LA027](https://openairdocs.org/ntsb/ANC04LA027.md): Hiller UH-12B · Bradenton, FL · Accident · No injuries · Limited investigation · Final report · Feb 22, 2004 · N5304V · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.
- [NTSB LAX04LA132](https://openairdocs.org/ntsb/LAX04LA132.md): Gillespie Sport Copter Vortex · Yuba City, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 21, 2004 · N96XV · Substantial damage
  > a loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…
- [NTSB ANC04FA026](https://openairdocs.org/ntsb/ANC04FA026.md): Gates Learjet 25B · Ft. Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · Feb 21, 2004 · N24RZ · Substantial damage
  > The pilot in command's misjudged distance/speed while landing, and the flightcrew's failure to follow prescribed emergency procedures, which resulted in a runway overrun and subsequent collision with a building. Factors associated with the accident are the…
- [NTSB LAX04IA133](https://openairdocs.org/ntsb/LAX04IA133.md): Eurocopter AS 350B · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Feb 20, 2004 · N358NT · Minor damage
  > the tail rotor pitch change lever failed in fatigue due to improper installation by company maintenance personnel.
- [NTSB FTW04GA076](https://openairdocs.org/ntsb/FTW04GA076.md): Schweizer 269D · San Antonio, TX · Accident · Minor injuries · Final report · Feb 19, 2004 · N255TP · Substantial damage
  > The loss of engine power due to the axial movement of the compressor rotor blades contacting the compressor vanes resulting in a subsequent compressor stall. A contributing factor was the improper assembly of the compressor section during the engine overhaul…
- [NTSB LAX04LA127](https://openairdocs.org/ntsb/LAX04LA127.md): Piper PA-31 · Kahului, HI · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2004 · C-GPTE · Substantial damage
  > the pilot's failure to maintain an adequate airspeed while maneuvering for landing on one engine, which resulted in an inadvertent stall. The loss of power in one engine for undetermined reasons was a factor.
- [NTSB LAX04LA126](https://openairdocs.org/ntsb/LAX04LA126.md): Grumman-Schweizer G-164B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Feb 17, 2004 · N6774K · Substantial damage
  > A loss of engine power for undetermined reasons during cruise flight.
- [NTSB CHI04FA069](https://openairdocs.org/ntsb/CHI04FA069.md): Piper PA-28-180 · Rich Hill, MO · Accident · 2 fatal · Field investigation · Final report · Feb 17, 2004 · N7876W · Destroyed
  > Spatial disorientation experienced by the non-instrument rated pilot due to a lack of visual references and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's intentional flight into adverse weather conditions,…
- [NTSB CHI04FA066](https://openairdocs.org/ntsb/CHI04FA066.md): Beech B90 · Dodge City, KS · Accident · 3 fatal · Field investigation · Final report · Feb 17, 2004 · N777KU · Destroyed
  > The pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).
- [NTSB NYC04FA223](https://openairdocs.org/ntsb/NYC04FA223.md): Aero Commander 112 · Vieques, PR · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2004 · N1261J · Substantial damage
  > The pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…
- [NTSB CHI04FA071](https://openairdocs.org/ntsb/CHI04FA071.md): Cessna 182Q · Rozel, KS · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2004 · N735RD · Destroyed
  > The inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…
- [NTSB DEN04LA045](https://openairdocs.org/ntsb/DEN04LA045.md): Cessna 172N · Parowan, UT · Accident · No injuries · Limited investigation · Final report · Feb 13, 2004 · N9892J · Substantial damage
  > the pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.
- [NTSB NYC04LA065](https://openairdocs.org/ntsb/NYC04LA065.md): Cessna 150F · Suffolk, VA · Accident · No injuries · Limited investigation · Final report · Feb 7, 2004 · N8745S · Substantial damage
  > The failure of the number four cylinder barrel due to fatigue which originated from a corrosion pit at the base of a cooling fin.
- [NTSB LAX04CA117](https://openairdocs.org/ntsb/LAX04CA117.md): Cessna A185F · Fowler, CA · Accident · No injuries · Data collection · Final report · Feb 7, 2004 · N8702Z · Substantial damage
  > the pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply. A factor in the accident was the pilot's lack of familiarity with the airplane.
- [NTSB DEN04FA043](https://openairdocs.org/ntsb/DEN04FA043.md): Cessna T206H · Walcott, WY · Accident · 1 fatal · Field investigation · Final report · Feb 6, 2004 · N51192 · Destroyed
  > The pilot not following proper IFR procedures for tracking a VOR radial while on an IFR flight plan in IMC conditions, and not maintaining clearance with terrain during cruise flight. Contributing factors were the mountain, and the cloudy weather condition.
- [NTSB MIA04LA050](https://openairdocs.org/ntsb/MIA04LA050.md): Mooney M20K · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2004 · N252WF · Substantial damage
  > A loss of engine power due to the airplane mechanic's improper maintenance/installation and failure to ensure that the B-nut on the inlet side of the fuel manifold was properly tightened, which resulted in a fuel leak, and fuel starvation.
- [NTSB ATL04IA073](https://openairdocs.org/ntsb/ATL04IA073.md): Cessna 208B · Auburn, AL · Incident · No injuries · Incident investigation · Final report · Feb 3, 2004 · N125AR · No damage
  > The fatigue fracture of the wire rope portion on the rudder control cable assembly due to improper installation and inadequate procedures by the aircraft manufacturer.
- [NTSB LAX04LA112](https://openairdocs.org/ntsb/LAX04LA112.md): Piper PA-28-181 · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · Feb 2, 2004 · N4861F · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB MIA04FA049](https://openairdocs.org/ntsb/MIA04FA049.md): Beech C90 · Homestead, FL · Accident · 2 fatal · Field investigation · Final report · Jan 31, 2004 · N75GC · Destroyed
  > The pilot's inadequate in-flight planning/decision which resulted in an encounter with rain showers and turbulence, a loss of aircraft control, and overstress of the airframe.
- [NTSB LAX04LA110](https://openairdocs.org/ntsb/LAX04LA110.md): Tailwind W-8 · San Pedro, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 31, 2004 · N192S · Destroyed
  > The pilot's incapacitation during descent, which resulted in a loss of control and an in-flight collision with water.
- [NTSB LAX04FA113](https://openairdocs.org/ntsb/LAX04FA113.md): Cessna 414A · Laupahoehoe, HI · Accident · 3 fatal · Field investigation · Final report · Jan 31, 2004 · N5637C · Destroyed
  > the pilot's disregard for an in-flight weather advisory, his likely encounter with marginal VFR or IMC weather conditions, his decision to continue flight into those conditions, and failure to maintain an adequate terrain clearance altitude resulting in an…
- [NTSB FTW04LA067](https://openairdocs.org/ntsb/FTW04LA067.md): Bell 206-L4 · Patterson, LA · Accident · No injuries · Limited investigation · Final report · Jan 28, 2004 · N207RT · Substantial damage
  > The in-flight separation of the helicopter's left winglet due to pre-existing cracks resulting in the winglet striking the tail rotor in-flight, and subsequent loss of directional control.
- [NTSB FTW04LA065](https://openairdocs.org/ntsb/FTW04LA065.md): Cessna 120 · Lonoke, AR · Accident · No injuries · Limited investigation · Final report · Jan 26, 2004 · N1961V · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.
- [NTSB MIA04FA047](https://openairdocs.org/ntsb/MIA04FA047.md): Piper PA-23-160 · Lake Worth, FL · Accident · 2 fatal · Field investigation · Final report · Jan 22, 2004 · N4293P · Destroyed
  > The pilot's inadequate control of the aircraft by his use of an excessive bank angle, and his failure to maintain airspeed which resulted in a stall and a loss of control following a loss of power in one engine. The reason for the loss of the engine power was…
- [NTSB FTW04LA064](https://openairdocs.org/ntsb/FTW04LA064.md): Cessna 182R · Ringgold, TX · Accident · No injuries · Limited investigation · Final report · Jan 22, 2004 · N9374H · Substantial damage
  > The pilots failure to maintain clearance from the support wire while on a pipeline patrol flight. A contributing factor was the haze restricting the pilots forward visibility, and low altitude flight.
- [NTSB LAX04FA102](https://openairdocs.org/ntsb/LAX04FA102.md): Piper PA-32R-300 · Big Pine, CA · Accident · 1 fatal · Field investigation · Final report · Jan 21, 2004 · N8701E · Destroyed
  > failure of the pilot to maintain clearance with mountainous terrain for undetermined reasons.
- [NTSB LAX04CA098](https://openairdocs.org/ntsb/LAX04CA098.md): Cessna 172P · Granada Hills, CA · Accident · No injuries · Data collection · Final report · Jan 20, 2004 · N5364K · Substantial damage
  > the pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.
- [NTSB LAX04LA108](https://openairdocs.org/ntsb/LAX04LA108.md): Cessna P210N · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jan 18, 2004 · N4873K · Substantial damage
  > the failure of the electrical charging system and pilot's failure to verify that the gear was down-and-locked prior to the complete electrical system failure.
- [NTSB LAX04LA101](https://openairdocs.org/ntsb/LAX04LA101.md): Scott RV-8A · Lihue, HI · Accident · No injuries · Limited investigation · Final report · Jan 18, 2004 · N809RS · Destroyed
  > the engine lost partial power for undetermined reasons.
- [NTSB LAX04LA109](https://openairdocs.org/ntsb/LAX04LA109.md): Piper PA 22-160 · Carefree, AZ · Accident · No injuries · Limited investigation · Final report · Jan 17, 2004 · N8718D · Substantial damage
  > The pilot's inadequate fuel management by his failure to switch the fuel tank selector position, which resulted in fuel starvation, a loss of engine power.
- [NTSB LAX04LA100](https://openairdocs.org/ntsb/LAX04LA100.md): Cessna 170B · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Jan 17, 2004 · N2502C · Substantial damage
  > the failure of the number 2 cylinder barrel due to fatigue. The lack of suitable landing terrain was a factor in the accident.
- [NTSB CHI04LA057](https://openairdocs.org/ntsb/CHI04LA057.md): Cessna 150L · Corydon, IN · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 2004 · N17254 · Substantial damage
  > The student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…
- [NTSB LAX04FA095](https://openairdocs.org/ntsb/LAX04FA095.md): Cessna 180K · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2004 · N61691 · 2 aircraft · Destroyed
  > The pilot's inadequate visual lookout during climb, and the pilot of the other airplane's inadequate visual lookout during cruise.
- [NTSB LAX04LA092](https://openairdocs.org/ntsb/LAX04LA092.md): Cessna 140 · Vacaville, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 2004 · N77S · Substantial damage
  > the pilot's failure to either obtain a preflight weather report and forecast for the destination or to add additional fuel, which ultimately resulted in fuel exhaustion and collision with trees.
- [NTSB CHI04FA055](https://openairdocs.org/ntsb/CHI04FA055.md): Cessna 182P · Baudette, MN · Accident · 2 fatal · Field investigation · Final report · Jan 11, 2004 · N5787J · Destroyed
  > The pilot's intentional flight into adverse weather conditions, and his failure to maintain adequate terrain clearance. Contributing factors were the pilot's lack of an instrument rating, low ceiling, low altitude, and the dark night conditions.
- [NTSB IAD04LA007](https://openairdocs.org/ntsb/IAD04LA007.md): Piper PA-25-180 · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · Jan 10, 2004 · N242JG · Substantial damage
  > A loss of engine power for undetermined reasons. Factors included a low ambient temperature and a lack of suitable terrain for the forced landing.
- [NTSB CHI04LA053](https://openairdocs.org/ntsb/CHI04LA053.md): Beech E-90 · Galesburg, IL · Accident · No injuries · Limited investigation · Final report · Jan 8, 2004 · N48TA · Substantial damage
  > The pilot's inadequate preflight by not complying with the airplane's before takeoff checklist to verify that the cabin door was secured leading to its in-flight separation from the airplane. A factor was that the door was not secured.

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

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

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