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

## Cases, newest first

- [NTSB FTW96LA271](https://openairdocs.org/ntsb/FTW96LA271.md): Boeing 737-201 · Granite, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1996 · N207AU · No damage
  > An encounter with clear air turbulence.
- [NTSB SEA96FA134](https://openairdocs.org/ntsb/SEA96FA134.md): Cessna 150B · Hailey, ID · Accident · 2 fatal · Field investigation · Final report · Jun 21, 1996 · N1236Y · Destroyed
  > the pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…
- [NTSB FTW96LA269](https://openairdocs.org/ntsb/FTW96LA269.md): Airbus Industrie A-340-200 · Dfw Airport, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1996 · DAIBE · No damage
  > The flightcrew's abrupt maneuver/descent in response to a TCAS RA. Factors were the company assignment of the captain to the crew position with a lack of captain training.
- [NTSB FTW96LA266](https://openairdocs.org/ntsb/FTW96LA266.md): Piper PA-28-151 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Jun 21, 1996 · N40954 · Substantial damage
  > fuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…
- [NTSB FTW96FA267](https://openairdocs.org/ntsb/FTW96FA267.md): Beech 58 · Castle Rock, CO · Accident · 4 fatal · Field investigation · Final report · Jun 21, 1996 · N94ZR · Destroyed
  > failure of the pilot to maintain sufficient altitude and/or clearance from terrain, while reversing course to exit adverse weather conditions. Factors relating to the accident were: the adverse weather conditions (thunderstorm, low ceiling and reduced…
- [NTSB FTW96FA265](https://openairdocs.org/ntsb/FTW96FA265.md): Mbb BO-105 · Sabine Pass, TX · Accident · 4 fatal · Field investigation · Final report · Jun 21, 1996 · N2906T · Destroyed
  > The failure of the sun gear within the main transmission resulting in the main rotor system not being driven.
- [NTSB CHI96LA212](https://openairdocs.org/ntsb/CHI96LA212.md): Beech C23 · Ainsworth, NE · Accident · No injuries · Limited investigation · Final report · Jun 21, 1996 · N6014F · Substantial damage
  > the pilot's inadequate fuel consumption calculations which led to fuel exhaustion and the pilot's selection of an unsuitable landing area for the forced landing.
- [NTSB FTW96LA263](https://openairdocs.org/ntsb/FTW96LA263.md): Wsk Pzl Mielec AN-2 · Weir, TX · Accident · No injuries · Limited investigation · Final report · Jun 20, 1996 · N67AN · Substantial damage
  > engine seizure for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA208](https://openairdocs.org/ntsb/CHI96LA208.md): Aerotechnik L-13 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Jun 20, 1996 · N21400 · Substantial damage
  > the pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.
- [NTSB SEA96LA126](https://openairdocs.org/ntsb/SEA96LA126.md): Price Berkut · Jackson, WY · Accident · No injuries · Limited investigation · Final report · Jun 19, 1996 · N538AJ · Substantial damage
  > failure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.
- [NTSB SEA96FA130](https://openairdocs.org/ntsb/SEA96FA130.md): Hughes 269C · Eldon, WA · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1996 · N7400F · Destroyed
  > fatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.
- [NTSB LAX96FA236](https://openairdocs.org/ntsb/LAX96FA236.md): Beech C23 · Los Angeles, CA · Accident · 3 fatal · Field investigation · Final report · Jun 19, 1996 · N66343 · Destroyed
  > company maintenance personnel's inadequate service of the magneto system, and their failure of to replace the electric fuel boost pump, which led to a malfunctioning right magneto and an inoperative fuel boost pump. The inoperative fuel boost pump made it…
- [NTSB IAD96IA098](https://openairdocs.org/ntsb/IAD96IA098.md): Boeing 747-136 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Jun 18, 1996 · N606FF · Minor damage
  > failure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.
- [NTSB LAX96LA232](https://openairdocs.org/ntsb/LAX96LA232.md): Moore Goshawk 350 · Livermore, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1996 · N345RM · Destroyed
  > an overstress failure of the left rudder cable.
- [NTSB LAX96FA244](https://openairdocs.org/ntsb/LAX96FA244.md): Cessna 152 · Carmel, CA · Accident · 2 fatal · Field investigation · Final report · Jun 17, 1996 · N6198P · Destroyed
  > The pilot becoming lost and disoriented during a night VFR flight in marginal weather conditions. Factors in the accident were: the pilot's lack of night flying experience, his failure to obtain a preflight weather briefing, low ceilings, and his failure to…
- [NTSB IAD96LA097](https://openairdocs.org/ntsb/IAD96LA097.md): Piper J-3 · Ashton, MD · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1996 · N58379 · Substantial damage
  > the pilot's inadequate fuel supply which resulted in a fuel exhaustion and a loss of engine power. A related factor was the pilot's inadequate fuel consumption calculations.
- [NTSB FTW96LA257](https://openairdocs.org/ntsb/FTW96LA257.md): Owens/Smyth Sidewinder · Minden, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1996 · N177TJ · Destroyed
  > The pilot's improper fuel consumption calculations resulting in fuel exhaustion. A factor was the unsuitable terrain for the forced landing.
- [NTSB FTW96LA255](https://openairdocs.org/ntsb/FTW96LA255.md): Cessna 152 · Hobart, OK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1996 · N93139 · Substantial damage
  > the pilot became lost/disoriented, and failed to properly use information that was provided by ATC, which resulted in fuel exhaustion and an encounter with soft terrain during an emergency landing. A factor relating to the accident was: the lack of suitable…
- [NTSB ATL96LA093](https://openairdocs.org/ntsb/ATL96LA093.md): Cessna 177RG · Lake Placid, FL · Accident · No injuries · Limited investigation · Final report · Jun 16, 1996 · N2186Q · Substantial damage
  > maintenance personnel's failure to properly torque the cylinder installation bolts.
- [NTSB LAX96LA233](https://openairdocs.org/ntsb/LAX96LA233.md): Van Horn Velocity · Goodyear, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 15, 1996 · N444BG · Destroyed
  > an engine compartment fire, which originated in flight from loose fuel and/or oil lines near the engine's firewall.
- [NTSB CHI96LA205](https://openairdocs.org/ntsb/CHI96LA205.md): Enstrom 280C · Lambertville, MI · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N557H · Substantial damage
  > a total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight, and the pilot's misjudged distance/altitude during the subsequent autorotation. A factor was inadequate maintenance and inspection.
- [NTSB ATL96LA092](https://openairdocs.org/ntsb/ATL96LA092.md): Cessna 411 · Rome, GA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N3203R · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.
- [NTSB ANC96LA088](https://openairdocs.org/ntsb/ANC96LA088.md): Piper PA-32-300 · Gustavus, AK · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N8956N · Substantial damage
  > A loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.
- [NTSB CHI96IA200](https://openairdocs.org/ntsb/CHI96IA200.md): Boeing 727-30C · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 14, 1996 · N906UP · No damage
  > low pressure in the fuel lines caused when the crossfeed valve was closed and the boost pumps to the effected fuel tank were turned off, a fuel pressure surge (spike) accompanied by a rapid drop in high pressure pump output and burner line pressures, when…
- [NTSB CHI96LA198](https://openairdocs.org/ntsb/CHI96LA198.md): Piper J-3 · Princeton, MN · Accident · No injuries · Limited investigation · Final report · Jun 12, 1996 · N35505 · Substantial damage
  > Loss of engine power for an undetermined reason.
- [NTSB FTW96IA248](https://openairdocs.org/ntsb/FTW96IA248.md): Fairchild SA227-DC · Enid, OK · Incident · No injuries · Incident investigation · Final report · Jun 11, 1996 · N850LS · No damage
  > failure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.
- [NTSB CHI96LA218](https://openairdocs.org/ntsb/CHI96LA218.md): Piper PA-25-235 · Waterville, KS · Accident · No injuries · Limited investigation · Final report · Jun 11, 1996 · N7289Z · Substantial damage
  > the pilot's inadequate preflight procedure. Factors were fuel exhaustion, a leak in the fuel filtering system, and high vegetation.
- [NTSB NYC96FA123](https://openairdocs.org/ntsb/NYC96FA123.md): Beech E90 · Woolwich, ME · Accident · 2 fatal · Field investigation · Final report · Jun 10, 1996 · N916PA · Destroyed
  > failure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…
- [NTSB IAD96LA094](https://openairdocs.org/ntsb/IAD96LA094.md): Rotorway Exec 152 · Gretna, VA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1996 · N7182Z · Destroyed
  > failure of the bearing assembly shaft insert inside the main rotor shaft. Related factors are the jammed rotorcraft flight control which restricted the pilot's ability to control the helicopter and resulted in a hard touchdown.
- [NTSB MIA96LA154](https://openairdocs.org/ntsb/MIA96LA154.md): Piper PA-28-180 · Jasper, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1996 · N9640J · Substantial damage
  > the pilot's inaccurate fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the unsuitable terrain encountered during the forced landing.
- [NTSB CHI96LA195](https://openairdocs.org/ntsb/CHI96LA195.md): Cessna 150M · Red Wing, MN · Accident · No injuries · Limited investigation · Final report · Jun 9, 1996 · N9132U · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.
- [NTSB FTW96IA240](https://openairdocs.org/ntsb/FTW96IA240.md): Lockheed L-1011-385-1 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jun 8, 1996 · N11004 · No damage
  > physical impairment of the captain due to a probable cardiac event.
- [NTSB IAD96LA092](https://openairdocs.org/ntsb/IAD96LA092.md): Beech V35B · Westminster, MD · Accident · No injuries · Limited investigation · Final report · Jun 7, 1996 · N369JR · Substantial damage
  > The fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.
- [NTSB SEA96LA113](https://openairdocs.org/ntsb/SEA96LA113.md): Ayres S2R · Aberdeen, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1996 · N5686X · Substantial damage
  > pilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…
- [NTSB CHI96IA191](https://openairdocs.org/ntsb/CHI96IA191.md): Beech 1900 · Lansing, MI · Incident · No injuries · Incident investigation · Final report · Jun 6, 1996 · N81538 · Minor damage
  > the short in the windshield anti-ice low power braided copper lead wire caused a fire that had resulted from the manufacturer's inadequate design.
- [NTSB ATL96FA090](https://openairdocs.org/ntsb/ATL96FA090.md): Piper PA-28-180 · Lawrenceville, GA · Accident · 1 fatal · Field investigation · Final report · Jun 6, 1996 · N8818J · Substantial damage
  > The pilot's inadequate fuel consumption calculations that resulted in fuel exhaustion. A factor was the pilot's failure to follow the emergency procedure for a forced landing, in that the flaps were not extended.
- [NTSB IAD96FA090](https://openairdocs.org/ntsb/IAD96FA090.md): Cessna 320C · Winslow, ME · Accident · 1 fatal · Field investigation · Final report · Jun 3, 1996 · N78KA · Destroyed
  > the pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.
- [NTSB FTW96IA235](https://openairdocs.org/ntsb/FTW96IA235.md): McDonnell Douglas MD-82 · Childress, TX · Incident · Minor injuries · Incident investigation · Final report · Jun 3, 1996 · N493AA · No damage
  > The aircraft's encounter with unforcasted and unreported severe turbulence.
- [NTSB LAX96LA215](https://openairdocs.org/ntsb/LAX96LA215.md): Beech A36TC · Sonora, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1996 · N214MS · Destroyed
  > failure of the number 1 connecting rod due to oil starvation caused by inadequate bearing crush.
- [NTSB CHI96FA184](https://openairdocs.org/ntsb/CHI96FA184.md): Piper PA-46-310P · Aitkin, MN · Accident · 4 fatal · Field investigation · Final report · Jun 2, 1996 · N9114Q · Destroyed
  > the pilot's continued flight into known adverse weather conditions and the pilot exceeding the design stress limits of the airplane. Factors contributing to this accident were: the thunderstorms, hail, and wind gusts, and the airplane's over maximum gross…
- [NTSB NYC96LA118](https://openairdocs.org/ntsb/NYC96LA118.md): Piper PA-32R · Williamstown, NJ · Accident · No injuries · Limited investigation · Final report · Jun 1, 1996 · N8186G · Substantial damage
  > inadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.
- [NTSB SEA96LA106](https://openairdocs.org/ntsb/SEA96LA106.md): Hughes 369HS · Arock, OR · Accident · No injuries · Limited investigation · Final report · May 31, 1996 · N444GJ · Substantial damage
  > the pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.
- [NTSB IAD96LA087](https://openairdocs.org/ntsb/IAD96LA087.md): Bellanca 17-30A · New Market, VA · Accident · Minor injuries · Limited investigation · Final report · May 31, 1996 · N14765 · Substantial damage
  > a loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.
- [NTSB CHI96FA179](https://openairdocs.org/ntsb/CHI96FA179.md): Dotson Seabird · Geneseo, IL · Accident · 1 fatal · Field investigation · Final report · May 30, 1996 · N92LL · Substantial damage
  > a loos of power due to a blocked fuel line and the pilot's failure to maintain airspeed.
- [NTSB SEA96IA104](https://openairdocs.org/ntsb/SEA96IA104.md): Dornier 328 · Billings, MT · Incident · No injuries · Incident investigation · Final report · May 29, 1996 · N336PH · No damage
  > paint overspray on the elevator trim actuator push rods, which damaged the actuator quad rings during normal operation and allowed water to enter the actuators; and the resultant freezing of the actuators. Factors relating to the incident included the…
- [NTSB NYC96LA117](https://openairdocs.org/ntsb/NYC96LA117.md): Cessna 177B · Chatham, MA · Accident · Minor injuries · Limited investigation · Final report · May 28, 1996 · N19708 · Substantial damage
  > failure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…
- [NTSB NYC96IA116](https://openairdocs.org/ntsb/NYC96IA116.md): Boeing 767-31AER · Boston, MA · Incident · No injuries · Incident investigation · Final report · May 28, 1996 · PHMCH · Minor damage
  > Numerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.
- [NTSB SEA96LA100](https://openairdocs.org/ntsb/SEA96LA100.md): Hiller UH-12 · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · May 27, 1996 · N174HA · Substantial damage
  > the pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…
- [NTSB CHI96IA173](https://openairdocs.org/ntsb/CHI96IA173.md): British Aerospace BAE 146 · Des Moines, IA · Incident · No injuries · Incident investigation · Final report · May 27, 1996 · N608AW · No damage
  > failure of the flight crew to follow proper procedures, which resulted in an accumulation of ice and subsequent loss of engine power. Factors relating to the incident were: thunderstorms, turbulence, icing conditions, and the inaccurate method that was…
- [NTSB CHI96LA187](https://openairdocs.org/ntsb/CHI96LA187.md): Cessna P206 · Goshen, IN · Accident · No injuries · Limited investigation · Final report · May 26, 1996 · N2625X · Substantial damage
  > the parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.

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

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

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