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

## Cases, newest first

- [NTSB MIA04LA013](https://openairdocs.org/ntsb/MIA04LA013.md): Mooney M20J · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2003 · N4103H · Substantial damage
  > loss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.
- [NTSB FTW04LA015](https://openairdocs.org/ntsb/FTW04LA015.md): Piper PA-28-161 · Henryetta, OK · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N8090E · Substantial damage
  > A loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.
- [NTSB CHI04LA021](https://openairdocs.org/ntsb/CHI04LA021.md): Schweizer 269C · Ann Arbor, MI · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N191GC · Substantial damage
  > The loss of engine power due to carburetor ice. Weather conditions conducive to the formation of carburetor ice and a roadway were contributing factors.
- [NTSB LAX04CA024](https://openairdocs.org/ntsb/LAX04CA024.md): Cessna 172N · Fresno, CA · Accident · No injuries · Data collection · Final report · Oct 25, 2003 · N738YL · Substantial damage
  > the pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power. Also causal was the pilot's failure to follow engine out emergency procedures as defined by the pilot operating handbook.
- [NTSB ATL04LA025](https://openairdocs.org/ntsb/ATL04LA025.md): Cessna U206F · Edgefield, SC · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2003 · N3007R · Substantial damage
  > The pilot's failure to follow the checklist to ensure the fuel filler cap was secured resulting in fuel starvation and subsequent loss of engine power.
- [NTSB DEN04IA014](https://openairdocs.org/ntsb/DEN04IA014.md): Learjet 45 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Oct 22, 2003 · N420FX · No damage
  > the failure of the airplane's spoiler system when used as speed brakes due to high resistances in the spoilers' actuator coils.
- [NTSB FTW04LA013](https://openairdocs.org/ntsb/FTW04LA013.md): Prill RV-6 · Snyder, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2003 · N3XS · Substantial damage
  > The failure of the propeller blade for undetermined reason. A contributing factor was the lack of suitable terrain.
- [NTSB FTW04LA011](https://openairdocs.org/ntsb/FTW04LA011.md): Beech 65-A90 · Fentress, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2003 · N511BF · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB LAX04LA016](https://openairdocs.org/ntsb/LAX04LA016.md): Beech A36 · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Oct 16, 2003 · N700TT · Substantial damage
  > A loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.
- [NTSB DEN04LA011](https://openairdocs.org/ntsb/DEN04LA011.md): Cessna 177 · Nageezi, NM · Accident · No injuries · Limited investigation · Final report · Oct 16, 2003 · N2246Y · Substantial damage
  > the pilot's inadequate preflight planning, inadequate fuel consumption calculations, and improper fuel management. Contributing factors include fuel exhaustion resulting in the loss of power, the lack of suitable terrain for a forced landing and the tree.
- [NTSB CHI04LA019](https://openairdocs.org/ntsb/CHI04LA019.md): Beech A36 · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Oct 16, 2003 · N25496 · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…
- [NTSB CHI04LA023](https://openairdocs.org/ntsb/CHI04LA023.md): Cessna A185E · Cedarville, MI · Accident · No injuries · Limited investigation · Final report · Oct 14, 2003 · N3399L · Substantial damage
  > A loss of engine power for undetermined reasons. A factor associated with the accident was the rough terrain on which the airplane was landed.
- [NTSB CHI04LA009](https://openairdocs.org/ntsb/CHI04LA009.md): Beech A33 · Grandview, MO · Accident · No injuries · Limited investigation · Final report · Oct 14, 2003 · N471T · Substantial damage
  > Separation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.
- [NTSB ATL04LA029](https://openairdocs.org/ntsb/ATL04LA029.md): Yakovlev YAK55M · Troy, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 2003 · N55YA · Substantial damage
  > A loss of engine power due to a fractured connecting rod for undetermined reasons.
- [NTSB CHI04LA011](https://openairdocs.org/ntsb/CHI04LA011.md): Domeier RV-7A · Augusta, MO · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2003 · N707DD · Substantial damage
  > The failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…
- [NTSB ATL04LA017](https://openairdocs.org/ntsb/ATL04LA017.md): Mooney M20K · Carrollton, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2003 · N4085H · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL04FA016](https://openairdocs.org/ntsb/ATL04FA016.md): Piper PA-23-250 · Cordesville, SC · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2003 · N63942 · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent uncontrolled descent into trees and the ground. A factor was physical impairment.
- [NTSB LAX04LA011](https://openairdocs.org/ntsb/LAX04LA011.md): Cessna 172RG · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 2003 · N6543V · Substantial damage
  > The fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.
- [NTSB ANC04LA003](https://openairdocs.org/ntsb/ANC04LA003.md): Fairchild 42 · Wasilla, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 2003 · N106M · Substantial damage
  > The inadequate inspection of the carburetor by the aircraft mechanic who had recently worked on the carburetor, which failed to detect a cracked float, resulting in a total loss of engine power during cruise flight. A factor associated with the accident was…
- [NTSB SEA04LA004](https://openairdocs.org/ntsb/SEA04LA004.md): Seabase Magnum · Olney, MT · Accident · No injuries · Limited investigation · Final report · Oct 9, 2003 · N1966G · Substantial damage
  > The pilot's failure to adequately preflight the aircraft to verify the fuel quantity, resulting in fuel exhaustion and the loss of engine power during cruise flight. Contributing factors were the pilot's failure to refuel the aircraft and the soft terrain.
- [NTSB SEA04FA003](https://openairdocs.org/ntsb/SEA04FA003.md): Cessna 177B · Chinook, MT · Accident · 2 fatal · Field investigation · Final report · Oct 9, 2003 · N30921 · Destroyed
  > The total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…
- [NTSB LAX04LA005](https://openairdocs.org/ntsb/LAX04LA005.md): Cessna 182A · Jean, NV · Accident · No injuries · Limited investigation · Final report · Oct 7, 2003 · N3904D · Substantial damage
  > the pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB CHI04LA005](https://openairdocs.org/ntsb/CHI04LA005.md): Waco CTO · Greenfield, IN · Accident · No injuries · Limited investigation · Final report · Oct 7, 2003 · N9577H · Destroyed
  > The loss of engine power during cruise and subsequent fire for undetermined reasons.
- [NTSB ATL04TA012](https://openairdocs.org/ntsb/ATL04TA012.md): Cessna 210L · Tallahassee, FL · Accident · No injuries · Final report · Oct 7, 2003 · N59063 · Substantial damage
  > Loss of engine power due to crankshaft counterweight failure.
- [NTSB FTW04LA004](https://openairdocs.org/ntsb/FTW04LA004.md): Colliander RV-8 · Van, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 6, 2003 · N27JW · Destroyed
  > The pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors were the low ceilings, rain, and fog.
- [NTSB ATL04LA009](https://openairdocs.org/ntsb/ATL04LA009.md): Cessna 150G · Jeykll Island, GA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2003 · N4662X · Substantial damage
  > The pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.
- [NTSB DEN04LA005](https://openairdocs.org/ntsb/DEN04LA005.md): Lindstrand Balloons LBL · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2003 · N994AF · No damage
  > the inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.
- [NTSB DCA04IA002](https://openairdocs.org/ntsb/DCA04IA002.md): Airbus Industrie A330 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Oct 5, 2003 · HB-IQZ · Minor damage
  > an uncontained engine failure that resulted from the coking (carbon build-up) in a vent tube which led to a fire and the subsequent liberation of the IP turbine blades. Contributing to the cause of the uncontained engine failure was the absence of measures to…
- [NTSB ATL04LA008](https://openairdocs.org/ntsb/ATL04LA008.md): Cessna 182H · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Oct 5, 2003 · N1919X · Substantial damage
  > The pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.
- [NTSB FTW04CA002](https://openairdocs.org/ntsb/FTW04CA002.md): Price Cuby Acro Trainer · Canutillo, TX · Accident · No injuries · Data collection · Final report · Oct 4, 2003 · N300HS · Substantial damage
  > The pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.
- [NTSB NYC04CA001](https://openairdocs.org/ntsb/NYC04CA001.md): Williams RV-4 · Metz, WV · Accident · No injuries · Data collection · Final report · Oct 3, 2003 · N475F · Substantial damage
  > The pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landing
- [NTSB DEN04FA002](https://openairdocs.org/ntsb/DEN04FA002.md): Piper PA-28-180 · Teasdale, UT · Accident · 2 fatal · Field investigation · Final report · Oct 3, 2003 · N7357W · Destroyed
  > The student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…
- [NTSB CHI04LA002](https://openairdocs.org/ntsb/CHI04LA002.md): Goldman Dragonfly · Peoria, IL · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2003 · N222TH · Substantial damage
  > The loss of power for undetermined reasons and the inadvertent stall of the canard by the pilot on the turn to final during the forced landing, as well as the excessive descent rate causing the aircraft to "pancake" into the ground.
- [NTSB CHI04LA001](https://openairdocs.org/ntsb/CHI04LA001.md): Cessna 182A · Shenandoah, IA · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2003 · N3772D · Substantial damage
  > Loss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.
- [NTSB SEA04IA010](https://openairdocs.org/ntsb/SEA04IA010.md): Boeing 747-100 · Lyon, France · Incident · No injuries · Incident investigation · Final report · Oct 2, 2003 · N479EV · Minor damage
  > An undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.
- [NTSB FTW04LA001](https://openairdocs.org/ntsb/FTW04LA001.md): Bratton Experimental Homebuilt Swearingen SX300 · Floresville, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2003 · N301SX · Substantial damage
  > The separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB LAX04FA001](https://openairdocs.org/ntsb/LAX04FA001.md): Piper PA-32R-301T · Corona, CA · Accident · 2 fatal · Field investigation · Final report · Oct 1, 2003 · N481CA · Destroyed
  > failure of the turbocharger exhaust clamp due to a pre-existing weld crack, which allowed the release of high temperature exhaust gasses in the engine compartment, causing an in-flight fire.
- [NTSB DEN04LA001](https://openairdocs.org/ntsb/DEN04LA001.md): Elliott Mustang II · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Oct 1, 2003 · N9XQ · Substantial damage
  > The pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power.
- [NTSB ATL03LA151](https://openairdocs.org/ntsb/ATL03LA151.md): Sheppard S-2 · Obion, TN · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2003 · N39S · Substantial damage
  > The failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.
- [NTSB SEA03LA197](https://openairdocs.org/ntsb/SEA03LA197.md): Thompson Avid Flyer · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Sep 28, 2003 · N6611 · Substantial damage
  > A complete loss of power due to fuel starvation for undetermined reason(s).
- [NTSB LAX03LA300](https://openairdocs.org/ntsb/LAX03LA300.md): McClanahan Stits Playmate SA-11 · Fontana, CA · Accident · 2 fatal · Limited investigation · Final report · Sep 27, 2003 · N9YC · Destroyed
  > a loss of engine power due to oil starvation that was the result of misaligned main bearing halves that obstructed the oil galley passages. Since the history of the engine could not be reconstructed, the person or entity responsible for the bearing…
- [NTSB CHI03LA322](https://openairdocs.org/ntsb/CHI03LA322.md): Stinson 108-3 · Lincoln, NE · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 2003 · N6624M · Substantial damage
  > The total loss of engine power due to the fatigue fracture of the engine accessory gear drive. A factor was the concrete marker.
- [NTSB ATL03FA147](https://openairdocs.org/ntsb/ATL03FA147.md): Grumman HU-16C · Fort Pierce, FL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2003 · N70258 · Destroyed
  > A loss of engine power due to the pilot placing the fuel selector in the off position which resulted in fuel starvation to the left engine, after the pilot intentionally shut down the right engine.
- [NTSB ANC03LA123](https://openairdocs.org/ntsb/ANC03LA123.md): Piper PA-18 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Sep 24, 2003 · N330T · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.
- [NTSB CHI03LA315](https://openairdocs.org/ntsb/CHI03LA315.md): Piper PA-24-250 · Chanute, KS · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2003 · N122CC · Substantial damage
  > The pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…
- [NTSB CHI03LA314](https://openairdocs.org/ntsb/CHI03LA314.md): Cessna 182S · Joliet, IL · Accident · No injuries · Limited investigation · Final report · Sep 21, 2003 · N775WB · Substantial damage
  > The pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…
- [NTSB ATL03LA143](https://openairdocs.org/ntsb/ATL03LA143.md): Globe GC-1B · Summerville, SC · Accident · No injuries · Limited investigation · Final report · Sep 20, 2003 · N3721K · Substantial damage
  > A loss of engine power due to the failure of the engine # 6 connecting rod bearing. A factor was the collision with a gate.
- [NTSB MIA03LA186](https://openairdocs.org/ntsb/MIA03LA186.md): S. FL. Ultralights Capella Classic · Port Charlotte, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 2003 · N82536 · Substantial damage
  > The loss of engine power for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced landing resulting in the airplane cart wheeling and subsequent substantial damage.
- [NTSB MIA03LA185](https://openairdocs.org/ntsb/MIA03LA185.md): Cessna 172K · Ocean Springs, MS · Accident · No injuries · Limited investigation · Final report · Sep 19, 2003 · N79491 · Substantial damage
  > The failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.
- [NTSB FTW03LA230](https://openairdocs.org/ntsb/FTW03LA230.md): Piper PA-12 · Wayne, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 2003 · N3336M · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. Factors were the lack of suitable terrain for the forced landing.

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

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

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