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

## Cases, newest first

- [NTSB CHI00IA152](https://openairdocs.org/ntsb/CHI00IA152.md): Boeing 767-222 · Lafayette, IN · Incident · No injuries · Incident investigation · Final report · Jun 7, 2000 · N603UA · No damage
  > The blocked drain lines in the canted pressure deck and the frozen aileron cable.
- [NTSB FTW00LA178](https://openairdocs.org/ntsb/FTW00LA178.md): Gulfstream-Schweizer G-164D · Welsh, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2000 · N8337K · Substantial damage
  > The excessive wear of the reduction gearbox's 1st stage sungear, which resulted in its subsequent fatigue fracture and failure. Factors were the operator not performing the recommended overhaul of the engine, and a lack of suitable terrain for the forced…
- [NTSB DEN00FA104](https://openairdocs.org/ntsb/DEN00FA104.md): Cessna P206 · Howard, CO · Accident · 2 fatal · Field investigation · Final report · Jun 5, 2000 · N2577X · Destroyed
  > The pilot's failure to maintain aircraft control. A factor was a thunderstorm.
- [NTSB CHI00LA153](https://openairdocs.org/ntsb/CHI00LA153.md): Eaton Acro Sport I · Malden, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 2000 · N6GE · Substantial damage
  > the water contamination of the fuel system and the inadequate preflight of the airplane by the pilot. The inoperative fuel system drain was a contributing factor. The wheat was a contributing factor.
- [NTSB SEA00LA098](https://openairdocs.org/ntsb/SEA00LA098.md): Piper PA-20 · Quinault, WA · Accident · No injuries · Limited investigation · Final report · Jun 4, 2000 · N7737K · Substantial damage
  > Fuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…
- [NTSB FTW00LA168](https://openairdocs.org/ntsb/FTW00LA168.md): Air Tractor AT-301 · Garwood, TX · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2000 · N8886S · Substantial damage
  > the loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX00FA213](https://openairdocs.org/ntsb/LAX00FA213.md): Cessna 414A · Prescott Valley, AZ · Accident · No injuries · Field investigation · Final report · Jun 1, 2000 · N414PS · Substantial damage
  > The pilot's physical impairment due to the cumulative effects of carbon monoxide from engine exhaust by-products, carbon monoxide from heavy tobacco use, and the loss of an undetermined amount of cabin pressurization. A factor in the loss of pressurization…
- [NTSB ANC00IA063](https://openairdocs.org/ntsb/ANC00IA063.md): Piper PA-31-350 · Tanana, AK · Incident · No injuries · Incident investigation · Final report · Jun 1, 2000 · N3536B · Minor damage
  > An in-flight oil leak due to the deterioration of oil filter adapter plate gasket material, and the supplier's distribution of inadequate material. A factor associated with the accident was the engine manufacturer's inadequate quality control.
- [NTSB SEA00FA095](https://openairdocs.org/ntsb/SEA00FA095.md): Cessna 414 · Monarch, MT · Accident · 3 fatal · Field investigation · Final report · May 31, 2000 · N5113G · Destroyed
  > The failure of the pilot-in-command to ensure adequate airspeed for flight during a forced descent due to airframe icing, resulting in a stall. Factors included: freezing rain conditions, airframe icing, an improper decision by the pilot-in-command to turn…
- [NTSB DEN00LA099](https://openairdocs.org/ntsb/DEN00LA099.md): Cessna TR182 · Milford, UT · Accident · Minor injuries · Limited investigation · Final report · May 31, 2000 · N738FN · Substantial damage
  > The failure of the turbocharger scavenging pump resulting in the total failure of the engine, and the pilot's failure to compensate for wind conditions that led him to over fly the runway during his forced landing. Factors were the pilot's diverted attention…
- [NTSB NYC00LA146](https://openairdocs.org/ntsb/NYC00LA146.md): Piper PA-28-161 · Williamstown, NJ · Accident · Minor injuries · Limited investigation · Final report · May 30, 2000 · N4319U · Substantial damage
  > improper installation of a quick drain plug by the airplane owner/mechanic which resulted in a loss of engine oil and forced landing.
- [NTSB SEA00LA096](https://openairdocs.org/ntsb/SEA00LA096.md): AS+ AS-4 · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · May 29, 2000 · N1995M · Substantial damage
  > The pilot's improper in-flight decision by not immediately seeking a safe landing site upon encountering the sink. A factor was the high vegetation (sagebrush).
- [NTSB SEA00LA093](https://openairdocs.org/ntsb/SEA00LA093.md): Cessna 172 · Johnson Creek, ID · Accident · Minor injuries · Limited investigation · Final report · May 28, 2000 · N7902B · Substantial damage
  > The pilot's failure to maintain clearance from the rising terrain. Factors include his poor decision to depart without assurance that he could clear the surrounding terrain under the ambient conditions, his failure to adhere to the accepted procedure of…
- [NTSB FTW00LA160](https://openairdocs.org/ntsb/FTW00LA160.md): Cessna 195 · Kaufman, TX · Accident · Minor injuries · Limited investigation · Final report · May 28, 2000 · N9876A · Substantial damage
  > The failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.
- [NTSB MIA00LA173](https://openairdocs.org/ntsb/MIA00LA173.md): Rawdon T1 · North Miami Bch, FL · Accident · No injuries · Limited investigation · Final report · May 27, 2000 · N2706D · Substantial damage
  > The failure of the pilot to change the fuel selector position after experiencing surging of the engine. Contributing to the accident was the partial loss of engine power due to fuel starvation and the incorrect reading of the left fuel gauge.
- [NTSB SEA00LA092](https://openairdocs.org/ntsb/SEA00LA092.md): Sikorsky S-58 · Buhl, ID · Accident · Serious injuries · Limited investigation · Final report · May 25, 2000 · N2253A · Destroyed
  > The pilot's inadequate visual lookout, and his failure to maintain adequate clearance from the power lines. The pilot's diverted attention, a dirty windshield, power lines, and light rain were factors.
- [NTSB SEA00LA091](https://openairdocs.org/ntsb/SEA00LA091.md): Cessna 310R · Wolf Point, MT · Accident · Serious injuries · Limited investigation · Final report · May 25, 2000 · N30RA · Destroyed
  > In flight collision with birds.
- [NTSB LAX00LA203](https://openairdocs.org/ntsb/LAX00LA203.md): Beech B200 · Pacific Ocean (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · May 24, 2000 · N24CV · Destroyed
  > Physical incapacitation of the pilot from improper handling of a pesticide.
- [NTSB FTW00LA153](https://openairdocs.org/ntsb/FTW00LA153.md): Eurocopter AS350B2 · Patterson, LA · Accident · Minor injuries · Limited investigation · Final report · May 24, 2000 · N350JG · Substantial damage
  > the failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.
- [NTSB MIA00FA166](https://openairdocs.org/ntsb/MIA00FA166.md): Beech 95-A55 · Aliceville, AL · Accident · 1 fatal · Field investigation · Final report · May 23, 2000 · N711MS · Destroyed
  > The in-flight collision with trees then terrain while descending for undetermined reasons.
- [NTSB DEN00IA093](https://openairdocs.org/ntsb/DEN00IA093.md): Piper PA-32R-300 · Erie, CO · Incident · No injuries · Incident investigation · Final report · May 22, 2000 · N424TP · Minor damage
  > Improper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.
- [NTSB LAX00LA202](https://openairdocs.org/ntsb/LAX00LA202.md): Beech 35-B33 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · May 21, 2000 · N9591Y · Substantial damage
  > The fracture and separation of the oil pressure line fitting, which resulted in a loss of oil and an oil starvation failure of the engine.
- [NTSB MIA00IA164](https://openairdocs.org/ntsb/MIA00IA164.md): Beech 1900C · Fort Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · May 19, 2000 · N154GA · Minor damage
  > The failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…
- [NTSB SEA00LA087](https://openairdocs.org/ntsb/SEA00LA087.md): Cessna 150G · Middleton, ID · Accident · Minor injuries · Limited investigation · Final report · May 18, 2000 · N3054S · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB MIA00LA162](https://openairdocs.org/ntsb/MIA00LA162.md): Cessna A150M · Gainesville, GA · Accident · No injuries · Limited investigation · Final report · May 18, 2000 · N9834J · Substantial damage
  > The pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…
- [NTSB DEN00LA090](https://openairdocs.org/ntsb/DEN00LA090.md): Eagle DW-1 · Boulder, UT · Accident · No injuries · Limited investigation · Final report · May 18, 2000 · N8803H · Substantial damage
  > The pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.
- [NTSB SEA00LA100](https://openairdocs.org/ntsb/SEA00LA100.md): Cessna 172N · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · May 17, 2000 · N738VZ · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB NYC00LA137](https://openairdocs.org/ntsb/NYC00LA137.md): Anderson MA-18 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · May 17, 2000 · N218MA · Substantial damage
  > The pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…
- [NTSB MIA00LA158](https://openairdocs.org/ntsb/MIA00LA158.md): Piper J-3 · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · May 14, 2000 · N70546 · Substantial damage
  > a loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.
- [NTSB MIA00LA157](https://openairdocs.org/ntsb/MIA00LA157.md): Navion L-17B · Sharpsburg, GA · Accident · Serious injuries · Limited investigation · Final report · May 14, 2000 · N4903E · Substantial damage
  > Total loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.
- [NTSB MIA00LA156](https://openairdocs.org/ntsb/MIA00LA156.md): Asselyn CH701 · Wake Forrest, NC · Accident · No injuries · Limited investigation · Final report · May 14, 2000 · N942PS · Substantial damage
  > The pilot's improper fuel management during a cross country flight resulting in a loss of engine power due to fuel exhaustion, and his failure to achieve the proper touchdown point during a forced landing. This resulted in the pilot forcing the airplane onto…
- [NTSB MIA00LA154](https://openairdocs.org/ntsb/MIA00LA154.md): Piper PA-22-150 · Highlands, NC · Accident · No injuries · Limited investigation · Final report · May 14, 2000 · N6860B · Substantial damage
  > Total loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.
- [NTSB NYC00LA134](https://openairdocs.org/ntsb/NYC00LA134.md): Hing FLY Baby 1A · Keymar, MD · Accident · 1 fatal · Limited investigation · Final report · May 13, 2000 · N2685 · Destroyed
  > An overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).
- [NTSB DEN00LA088](https://openairdocs.org/ntsb/DEN00LA088.md): Beech V35B · Erie, CO · Accident · No injuries · Limited investigation · Final report · May 13, 2000 · N6643Q · Substantial damage
  > Inadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.
- [NTSB CHI00LA135](https://openairdocs.org/ntsb/CHI00LA135.md): Rotorway Exec 162F · Ithaca, MI · Accident · 1 fatal · Limited investigation · Final report · May 13, 2000 · N962WM · Destroyed
  > the door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.
- [NTSB MIA00LA152](https://openairdocs.org/ntsb/MIA00LA152.md): Piper PA-18-150 · Fernandina Bch, FL · Accident · Serious injuries · Limited investigation · Final report · May 12, 2000 · N760WB · Substantial damage
  > The loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.
- [NTSB MIA00LA150](https://openairdocs.org/ntsb/MIA00LA150.md): Cessna 172H · Picayune, MS · Accident · No injuries · Limited investigation · Final report · May 11, 2000 · N5107G · Destroyed
  > An in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.
- [NTSB NYC00IA131](https://openairdocs.org/ntsb/NYC00IA131.md): Beech BE-58 · Windsor Locks, CT · Incident · No injuries · Incident investigation · Final report · May 9, 2000 · N9044V · Minor damage
  > Inadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…
- [NTSB ANC00FA056](https://openairdocs.org/ntsb/ANC00FA056.md): Beech B24R · Anchorage, AK · Accident · No injuries · Field investigation · Final report · May 9, 2000 · N6951R · Substantial damage
  > A fatigue failure of the crankcase through bolt, the separation of number 3 cylinder assembly, and the inadequate maintenance/service of the airplane by company maintenance personnel.
- [NTSB FTW00FA144](https://openairdocs.org/ntsb/FTW00FA144.md): Cessna 210L · Mack, CO · Accident · 2 fatal · Field investigation · Final report · May 8, 2000 · N732ER · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors were the mountain obscuration and the rising terrain.
- [NTSB ANC00LA054](https://openairdocs.org/ntsb/ANC00LA054.md): Cessna 170B · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · May 8, 2000 · N992EZ · Substantial damage
  > A loss of engine power due to an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB MIA00FA146](https://openairdocs.org/ntsb/MIA00FA146.md): Beech F35 · Jackson, MS · Accident · No injuries · Field investigation · Final report · May 7, 2000 · N35WK · Substantial damage
  > improper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.
- [NTSB NYC00LA129](https://openairdocs.org/ntsb/NYC00LA129.md): Cessna 120 · Beaumont, PA · Accident · No injuries · Limited investigation · Final report · May 6, 2000 · N2842N · Substantial damage
  > A crack in the crankcase which resulted in a partial power loss.
- [NTSB FTW00LA138](https://openairdocs.org/ntsb/FTW00LA138.md): Noteman RV6-A · Kanab, UT · Accident · Minor injuries · Limited investigation · Final report · May 6, 2000 · N456TP · Substantial damage
  > The partial loss of engine power as result of the failure of an exhaust valve. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX00GA185](https://openairdocs.org/ntsb/LAX00GA185.md): Beech 65-90 · China Lake, CA · Accident · Serious injuries · Final report · May 5, 2000 · N32229 · Substantial damage
  > the inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line..
- [NTSB SEA00LA082](https://openairdocs.org/ntsb/SEA00LA082.md): Gulfstream-Schweizer G-164B · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · May 4, 2000 · N8130K · Substantial damage
  > Loss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.
- [NTSB DEN00LA083](https://openairdocs.org/ntsb/DEN00LA083.md): Hughes 269C · Loveland, CO · Accident · No injuries · Limited investigation · Final report · May 3, 2000 · N1098B · Substantial damage
  > The pilot misjudged the run on landing during a full autorotation. Factors were a total loss of power for unknown reasons and soft terrain.
- [NTSB DEN00IA080](https://openairdocs.org/ntsb/DEN00IA080.md): British Aerospace BAE 146-200 · Denver, CO · Incident · No injuries · Incident investigation · Final report · May 1, 2000 · CFBAO · No damage
  > The accumulation of ice on the supercharger exit guide vanes that reduced core engine airflow, resulting in a loss of power. Factors were the clouds and icing conditions.
- [NTSB ANC00FA052](https://openairdocs.org/ntsb/ANC00FA052.md): Piper PA-18 · Kotzebue, AK · Accident · 1 fatal · Field investigation · Final report · May 1, 2000 · N3935Z · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in the accident were weather conditions consisting of low ceilings, fog, a whiteout, and the…
- [NTSB NYC00LA125](https://openairdocs.org/ntsb/NYC00LA125.md): Beech A36 · Nassawadox, VA · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2000 · N28JP · Substantial damage
  > A loss of engine power caused by detonation of the #2 piston.

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

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

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