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

## Cases, newest first

- [NTSB LAX00FA130](https://openairdocs.org/ntsb/LAX00FA130.md): Bell 212 · Snelling, CA · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2000 · N415B · Destroyed
  > the in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.
- [NTSB CHI00FA090](https://openairdocs.org/ntsb/CHI00FA090.md): Piper PA-28-140 · Dighton, KS · Accident · 3 fatal · Field investigation · Final report · Mar 18, 2000 · N4494X · Destroyed
  > the inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.
- [NTSB MIA00LA111](https://openairdocs.org/ntsb/MIA00LA111.md): Hiller UH-12B · Sanford, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 2000 · N5304V · Substantial damage
  > The pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.
- [NTSB LAX00GA114](https://openairdocs.org/ntsb/LAX00GA114.md): Bell OH-58C · Compton, CA · Accident · Minor injuries · Final report · Mar 15, 2000 · N911JN · Destroyed
  > An undetermined electrical system voltage surge.
- [NTSB FTW00LA096](https://openairdocs.org/ntsb/FTW00LA096.md): Siai-Marchetti S.205/22R · Rayville, LA · Accident · No injuries · Limited investigation · Final report · Mar 14, 2000 · N2832W · Substantial damage
  > The loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.
- [NTSB FTW00LA097](https://openairdocs.org/ntsb/FTW00LA097.md): Grumman-Schweizer G-164A · Gillett, AR · Accident · No injuries · Limited investigation · Final report · Mar 13, 2000 · N9785 · Substantial damage
  > The cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.
- [NTSB FTW00LA092](https://openairdocs.org/ntsb/FTW00LA092.md): Cessna 150K · Davis, OK · Accident · No injuries · Limited investigation · Final report · Mar 11, 2000 · N8435M · Substantial damage
  > Fuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA00LA108](https://openairdocs.org/ntsb/MIA00LA108.md): Aerospatiale ATR-72-212 · Athens, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 2000 · N636AS · No damage
  > The flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.
- [NTSB LAX00FA123](https://openairdocs.org/ntsb/LAX00FA123.md): Boeing 369D · Rough And Ready, CA · Accident · Serious injuries · Field investigation · Final report · Mar 10, 2000 · N8351F · Substantial damage
  > a loss of engine power due to oil starvation. The oil starvation was due to the seizure and failure of the turbine element oil pump shaft, which was caused by debris from a failed bearing seizing the pump. A factor in the accident was the lack of a suitable…
- [NTSB ANC00LA035](https://openairdocs.org/ntsb/ANC00LA035.md): Cessna 207 · Delta Junction, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 2000 · N75703 · Substantial damage
  > The disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.
- [NTSB NYC00LA091](https://openairdocs.org/ntsb/NYC00LA091.md): Aeronca 7AC · Pawling, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 2000 · N474HH · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB NYC00LA088](https://openairdocs.org/ntsb/NYC00LA088.md): Piper PA-22 · Conesus, NY · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 2000 · N9040D · Destroyed
  > The contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.
- [NTSB LAX00LA116](https://openairdocs.org/ntsb/LAX00LA116.md): Bell 47G-4A · Wasco, CA · Accident · No injuries · Limited investigation · Final report · Mar 7, 2000 · N1354X · Substantial damage
  > The pilot's failure to use carburetor heat, which resulted in a loss of engine power. Factors included the ambient carburetor icing conditions and the lack of suitable terrain for the forced landing.
- [NTSB LAX00FA122](https://openairdocs.org/ntsb/LAX00FA122.md): Piper PA-12 · Cima, CA · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2000 · N7586H · Destroyed
  > In-flight collision with terrain for undetermined reasons.
- [NTSB ATL00LA037](https://openairdocs.org/ntsb/ATL00LA037.md): Titan Tornado · Springfield, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 2000 · NONE · Destroyed
  > The loss of engine power for undetermined reasons, and the unqualified person attempted to fly the airplane.
- [NTSB ATL00LA033](https://openairdocs.org/ntsb/ATL00LA033.md): Aero Comp COMP-AIR-6 · Indiantown, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2000 · N61520 · Substantial damage
  > The maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.
- [NTSB ANC00LA033](https://openairdocs.org/ntsb/ANC00LA033.md): Cessna 208B · Holy Cross, AK · Accident · No injuries · Limited investigation · Final report · Mar 4, 2000 · N407GV · Substantial damage
  > An in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.
- [NTSB LAX00LA112](https://openairdocs.org/ntsb/LAX00LA112.md): Piper PA-32R-301T · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Mar 2, 2000 · N8170S · Substantial damage
  > The failure of the landing gear for undetermined reasons to go into the locked position after the pilot conducted a manual and emergency gear extension. A factor in the accident was the undetermined failure of the electrical system.
- [NTSB DEN00LA055](https://openairdocs.org/ntsb/DEN00LA055.md): Cessna P210N · Gillette, WY · Accident · No injuries · Limited investigation · Final report · Mar 2, 2000 · N6489W · Substantial damage
  > The pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.
- [NTSB CHI00LA085](https://openairdocs.org/ntsb/CHI00LA085.md): Cessna 210 · Macomb, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 2000 · N9552T · Substantial damage
  > the inadequate maintenance inspection prior to the ferry flight by the pilot/mechanic rated passenger who endorsed the airplane as airworthy, the shift in the number two main bearing left half, and the fractured crankshaft. A factor was the rough/uneven…
- [NTSB ATL00LA030](https://openairdocs.org/ntsb/ATL00LA030.md): Burak Stanley A XF4 · Brooksville, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2000 · N9VY · Substantial damage
  > The owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.
- [NTSB NYC00LA085](https://openairdocs.org/ntsb/NYC00LA085.md): Boeing 747-236 · Providence, RI · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 2000 · GBDXL · No damage
  > Maintenance personnel's failure to reconnect the pitot connections to the elevator feel computer which resulted in an elevator control surface deflection which was outside of the normal autopilot elevator authority. The uncommanded autopilot input to the…
- [NTSB IAD00FA024](https://openairdocs.org/ntsb/IAD00FA024.md): Cessna 337 · Prnce Frederick, MD · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2000 · N53HS · Destroyed
  > was the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…
- [NTSB LAX00LA111](https://openairdocs.org/ntsb/LAX00LA111.md): Ercoupe 415-C · San Bernardino, CA · Accident · No injuries · Limited investigation · Final report · Feb 27, 2000 · N99590 · Substantial damage
  > the total failure of the engine number 1 cylinder exhaust valve.
- [NTSB CHI00LA079](https://openairdocs.org/ntsb/CHI00LA079.md): Beech BE-35V · Bloomington, IN · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 2000 · N6FN · Destroyed
  > the improper major overhaul of the engine by company maintenance personnel. The tree was a contributing factor.
- [NTSB DEN00FA053](https://openairdocs.org/ntsb/DEN00FA053.md): Cessna 182E · El Prado, NM · Accident · 1 fatal · Field investigation · Final report · Feb 25, 2000 · N2988Y · Destroyed
  > The pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…
- [NTSB MIA00LA094](https://openairdocs.org/ntsb/MIA00LA094.md): North American NA-64 · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Feb 24, 2000 · N64WP · Substantial damage
  > A total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.
- [NTSB LAX00LA108](https://openairdocs.org/ntsb/LAX00LA108.md): Beech 35 · Desert Center, CA · Accident · No injuries · Limited investigation · Final report · Feb 24, 2000 · N5127C · Substantial damage
  > The pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.
- [NTSB LAX00IA106](https://openairdocs.org/ntsb/LAX00IA106.md): Embraer 120 · Fresno, CA · Incident · No injuries · Incident investigation · Final report · Feb 21, 2000 · N566SW · No damage
  > Moisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperatures
- [NTSB SEA00LA045](https://openairdocs.org/ntsb/SEA00LA045.md): Cessna 150H · Spangle, WA · Accident · No injuries · Limited investigation · Final report · Feb 18, 2000 · N50348 · Substantial damage
  > Exhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…
- [NTSB LAX00LA105](https://openairdocs.org/ntsb/LAX00LA105.md): Ayres · Elko, NV · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2000 · N4011Y · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.
- [NTSB LAX00GA102](https://openairdocs.org/ntsb/LAX00GA102.md): Cessna T210M · Elfrida, AZ · Accident · No injuries · Final report · Feb 16, 2000 · N761KC · Substantial damage
  > The company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…
- [NTSB CHI00LA073](https://openairdocs.org/ntsb/CHI00LA073.md): Piper PA-23-250 · Amery, WI · Accident · No injuries · Limited investigation · Final report · Feb 15, 2000 · N106RS · Substantial damage
  > the pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.
- [NTSB NYC00FA079](https://openairdocs.org/ntsb/NYC00FA079.md): Beech 58 · Cynthiana, KY · Accident · 4 fatal · Field investigation · Final report · Feb 14, 2000 · N875JC · Destroyed
  > The pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.
- [NTSB LAX00LA103](https://openairdocs.org/ntsb/LAX00LA103.md): Hughes 369HS · Pacific Ocean (Pacific Ocean) · Accident · No injuries · Limited investigation · Final report · Feb 14, 2000 · N717ST · Destroyed
  > An unknown mechanical malfunction that resulted in a precautionary landing at sea and the subsequent sinking of the helicopter by an ocean swell.
- [NTSB LAX00LA098](https://openairdocs.org/ntsb/LAX00LA098.md): Fokker FK-28-4000 · Red Bluff, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 2000 · N493US · No damage
  > the failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.
- [NTSB LAX00FA099](https://openairdocs.org/ntsb/LAX00FA099.md): Cessna 182L · Coulterville, CA · Accident · 2 fatal · Field investigation · Final report · Feb 14, 2000 · N3324R · Destroyed
  > The pilot's attempted flight into known adverse weather after receiving hazardous weather advisories, which resulted in inadvertent flight into instrument meteorological conditions while attempting to maintain VFR conditions on top. The subsequent…
- [NTSB MIA00FA090](https://openairdocs.org/ntsb/MIA00FA090.md): Beech 35-P35 · Dayton, TN · Accident · 1 fatal · Field investigation · Final report · Feb 13, 2000 · N9796Y · Destroyed
  > the non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.
- [NTSB IAD00LA021](https://openairdocs.org/ntsb/IAD00LA021.md): Wood Seawind 3000 · Cumberland Gap, VA · Accident · 2 fatal · Limited investigation · Final report · Feb 11, 2000 · N94WB · Substantial damage
  > The pilot's continued flight from visual flight rules into instrument meteorological conditions.
- [NTSB CHI00LA064](https://openairdocs.org/ntsb/CHI00LA064.md): Piper PA-38-112 · Alma, MI · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 2000 · N4276E · Substantial damage
  > the pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.
- [NTSB LAX00FA090](https://openairdocs.org/ntsb/LAX00FA090.md): Cessna 150J · Redwood City, CA · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2000 · N63YZ · Destroyed
  > The pilot's inadequate weather evaluation and continued visual flight into instrument meteorological conditions. Factors were the pilot's improper remedial action and his self-induced pressure.
- [NTSB MIA00GA083](https://openairdocs.org/ntsb/MIA00GA083.md): Rockwell OV-10D · Larandia, Colombia · Accident · Serious injuries · Final report · Feb 6, 2000 · N474AW · Destroyed
  > A loss of power in the right engine due to undetermined reasons and the pilot's failure to maintain control of the airplane. Factors in this accident were; the pilot did not perform a weight and balance calculation, (airplane overweight at takeoff); the…
- [NTSB LAX00LA091](https://openairdocs.org/ntsb/LAX00LA091.md): Izatt Mitchell U2 · Jean, NV · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2000 · N3249Z · Substantial damage
  > The pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall and spin.
- [NTSB ANC00FA024](https://openairdocs.org/ntsb/ANC00FA024.md): Cessna U206G · Iliamna, AK · Accident · 6 fatal · Field investigation · Final report · Feb 5, 2000 · N756HG · Destroyed
  > The pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.
- [NTSB NYC00LA097](https://openairdocs.org/ntsb/NYC00LA097.md): Boeing 737-300 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 2000 · N397US · No damage
  > In flight encounter with turbulence.
- [NTSB ANC00LA023](https://openairdocs.org/ntsb/ANC00LA023.md): Stirling AIR CAM · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Feb 2, 2000 · N6381V · Substantial damage
  > The pilot's improper compensation for wind conditions during the single-engine landing. Factors associated with this accident were the pilot's intentional shut down of the left engine, the right crosswind, the icy runway, and the snow berms on the edge of the…
- [NTSB DCA00MA023](https://openairdocs.org/ntsb/DCA00MA023.md): Douglas MD-83 · Port Hueneme, CA · Accident · 88 fatal · Class 1 · Major · Final report · Feb 1, 2000 · N963AS · Destroyed
  > A loss of airplane pitch control resulting from the in-flight failure of the horizontal stabilizer trim system jackscrew assembly's acme nut threads. The thread failure was caused by excessive wear resulting from Alaska Airlines' insufficient lubrication of…
- [NTSB LAX00LA083](https://openairdocs.org/ntsb/LAX00LA083.md): Cessna 152 · Taft, CA · Accident · No injuries · Limited investigation · Final report · Jan 30, 2000 · N25573 · Substantial damage
  > The pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…
- [NTSB MIA00LA078](https://openairdocs.org/ntsb/MIA00LA078.md): Cessna 152 · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Jan 29, 2000 · N94999 · Substantial damage
  > The failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.
- [NTSB LAX00LA081](https://openairdocs.org/ntsb/LAX00LA081.md): Cessna 150F · Windsor, CA · Accident · No injuries · Limited investigation · Final report · Jan 29, 2000 · N8281F · Substantial damage
  > The pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.

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

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

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