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

## Cases, newest first

- [NTSB NYC96FA052](https://openairdocs.org/ntsb/NYC96FA052.md): Piper PA-28-140 · Harwich, MA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1996 · N5934U · Destroyed
  > the pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…
- [NTSB MIA96LA095](https://openairdocs.org/ntsb/MIA96LA095.md): Rotor Flight Dynamics Dominator · Quincy, FL · Accident · No injuries · Limited investigation · Final report · Jan 18, 1996 · UNREG · Substantial damage
  > a partial loss of engine power due to fuel contamination, and the pilot-in-command's improper decision to land with a tailwind.
- [NTSB FTW96FA091](https://openairdocs.org/ntsb/FTW96FA091.md): Mooney M20K · Laredo, TX · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1996 · N231GS · Destroyed
  > The pilot's loss of aircraft control. A factor was the dark night conditions.
- [NTSB MIA96FA064](https://openairdocs.org/ntsb/MIA96FA064.md): Airbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Field investigation · Final report · Jan 17, 1996 · N7076A · Minor damage
  > the turbulence and failure of the passengers to have their seat belts fastened. A factor relating to this accident was: the failure of the aircraft operator to advise the flight crew of forecast active intensifying thunderstorm conditions in the area of the…
- [NTSB CHI96FA113](https://openairdocs.org/ntsb/CHI96FA113.md): Piper PA-32 · Milwaukee, WI · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1996 · N3326Q · Destroyed
  > Inadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.
- [NTSB SEA96MA043](https://openairdocs.org/ntsb/SEA96MA043.md): Mitsubishi MU-2B-36 · Malad City, ID · Accident · 8 fatal · Major investigation · Final report · Jan 15, 1996 · N693PA · Destroyed
  > continued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…
- [NTSB CHI96LA072](https://openairdocs.org/ntsb/CHI96LA072.md): Cessna 150M · Mount Pleasant, MI · Accident · No injuries · Limited investigation · Final report · Jan 15, 1996 · N8375U · Substantial damage
  > the student pilot's inadequate preflight and the loose oil filler cap, which resulted in oil starvation and failure of the #1 cylinder connecting rod. A factor relating to this accident was the snow covered terrain.
- [NTSB CHI96FA073](https://openairdocs.org/ntsb/CHI96FA073.md): Piper PA-28-140 · Hallam, NE · Accident · 3 fatal · Field investigation · Final report · Jan 14, 1996 · N98254 · Destroyed
  > improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.
- [NTSB BFO96LA038](https://openairdocs.org/ntsb/BFO96LA038.md): Ercoupe 415-C · Hurlock, MD · Accident · No injuries · Limited investigation · Final report · Jan 14, 1996 · N87424 · Substantial damage
  > inadequate inspection by maintenance personnel which failed to detect a fatigue crack, and resulted in an in-flight crankshaft fracture and propeller assembly separation. A related factor was the deep snow encountered during the subsequent forced landing.
- [NTSB ATL96LA034](https://openairdocs.org/ntsb/ATL96LA034.md): Cessna 150L · Sun City, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1996 · N18181 · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion. Darkness was a related factor.
- [NTSB FTW96LA094](https://openairdocs.org/ntsb/FTW96LA094.md): Cessna A188B · Enid, OK · Accident · No injuries · Limited investigation · Final report · Jan 12, 1996 · N4744Q · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during the forced landing and to jettison the aircraft's load for a forced landing. A factor was the engine's failure due to a disconnected fuel line which was the result of improper maintenance.
- [NTSB FTW96FA119](https://openairdocs.org/ntsb/FTW96FA119.md): Beech 35 · Allenspark, CO · Accident · 2 fatal · Field investigation · Final report · Jan 11, 1996 · N3052V · Destroyed
  > Aircraft control not maintained by the pilot in command for reasons undetermined.
- [NTSB LAX96FA091](https://openairdocs.org/ntsb/LAX96FA091.md): Partenavia AF68TP Spartacus · El Segundo, CA · Accident · 1 fatal · Field investigation · Final report · Jan 9, 1996 · N3116C · Destroyed
  > loss of control for undetermined reasons.
- [NTSB MIA96LA060](https://openairdocs.org/ntsb/MIA96LA060.md): Cessna 172N · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1996 · N800PB · Substantial damage
  > Loss of engine power for an undetermined reason, while over water, which resulted in a forced landing/ditching at sea.
- [NTSB FTW96FA085](https://openairdocs.org/ntsb/FTW96FA085.md): Semple Smyth Sidewinder · Oklahoma City, OK · Accident · 1 fatal · Field investigation · Final report · Jan 8, 1996 · N86S · Destroyed
  > The pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…
- [NTSB LAX96LA085](https://openairdocs.org/ntsb/LAX96LA085.md): Klingberg Miniplane DSA-1 · El Cajon, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 7, 1996 · N66TD · Destroyed
  > the pilot's intentional operation of the aircraft with known mechanical deficiencies in the engine, and his failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall/spin.
- [NTSB IAD96LA109](https://openairdocs.org/ntsb/IAD96LA109.md): Mooney M20F · Cape Charles, VA · Accident · 1 fatal · Limited investigation · Final report · Jan 7, 1996 · N9199V · Destroyed
  > The pilot's improper in-flight planning/decision making by continuing flight into known adverse weather conditions. Related factors were the dark night and the winter storm (snow and fog).
- [NTSB LAX96IA087](https://openairdocs.org/ntsb/LAX96IA087.md): Boeing 747-251B · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Jan 5, 1996 · N628US · Minor damage
  > The fatigue fracture of the number 4 bearing oil pressure tube due to an improper maintenance cleaning procedure by company maintenance personnel.
- [NTSB SEA96FA036](https://openairdocs.org/ntsb/SEA96FA036.md): Piper PA-28-235 · Lehi, UT · Accident · 1 fatal · Field investigation · Final report · Jan 2, 1996 · N8870W · Destroyed
  > continued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: darkness, low ceiling, and snow.
- [NTSB NYC96LA048](https://openairdocs.org/ntsb/NYC96LA048.md): Piper PA-23-150 · Silver Spring, PA · Accident · No injuries · Limited investigation · Final report · Jan 1, 1996 · N1082P · Substantial damage
  > A loss of engine power as a result of fuel exhaustion.
- [NTSB MIA96LA052](https://openairdocs.org/ntsb/MIA96LA052.md): Mooney M20 · Eastover, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 1995 · N3750H · Substantial damage
  > inadequate overhaul procedures by maintenance personnel resulting in an oil pump failure and subsequent loss of engine power.
- [NTSB LAX96LA090](https://openairdocs.org/ntsb/LAX96LA090.md): ATR ATR 42-300 · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Dec 30, 1995 · N4202G · No damage
  > the flight attendant's decision to leave her seat in an area of forecast and known moderate turbulence. The turbulence was a related factor.
- [NTSB BFO96LA035](https://openairdocs.org/ntsb/BFO96LA035.md): Cessna 152 · Hudson, OH · Accident · No injuries · Limited investigation · Final report · Dec 30, 1995 · N47316 · Substantial damage
  > the pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and a loss of engine power due to an inadequate supply of fuel. Factors relating to the accident were: false fuel quantity indication from the left fuel quantity gauge,…
- [NTSB NYC96LA044](https://openairdocs.org/ntsb/NYC96LA044.md): Cessna 182E · Pymatuning, PA · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 1995 · N3290Y · Destroyed
  > the pilot's intentional suicide.
- [NTSB FTW96LA081](https://openairdocs.org/ntsb/FTW96LA081.md): Republic RC 3 · Whitewright, TX · Accident · No injuries · Limited investigation · Final report · Dec 28, 1995 · N6127K · Substantial damage
  > The separation of a spark plug and 4 other spark plugs being 'finger' tight as a result of undertorquing by maintenance personnel when they were reinstalled following inspection. A factor was a lack of suitable terrain for the forced landing.
- [NTSB MIA96FA049](https://openairdocs.org/ntsb/MIA96FA049.md): Piper PA-46-310P · Ocala, FL · Accident · Serious injuries · Field investigation · Final report · Dec 27, 1995 · N800SJ · Substantial damage
  > oil starvation resulting in connecting rod failure in three of the six cylinders due to lack of lubrication. Contributing to the accident was the failure of the pilot to adhere to a ATC vector toward the nearest airport following engine failure which resulted…
- [NTSB LAX96FA082](https://openairdocs.org/ntsb/LAX96FA082.md): Cessna 152 · Long Beach, CA · Accident · No injuries · Field investigation · Final report · Dec 27, 1995 · N53321 · Substantial damage
  > a partial power loss due to carburetor icing resulting from existing environmental conditions and the pilot's failure to apply carburetor heat during descent.
- [NTSB FTW96LA078](https://openairdocs.org/ntsb/FTW96LA078.md): Piper PA-24-250 · Kaufman, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1995 · N5221P · Substantial damage
  > The loss of engine power due to a bent push rod and the resultant loss of oil. Factors were the cockpit smoke and the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA076](https://openairdocs.org/ntsb/FTW96LA076.md): Cessna 150M · Round Rock, TX · Accident · No injuries · Limited investigation · Final report · Dec 24, 1995 · N19LV · Substantial damage
  > The pilot's improper planning/decision, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for the forced landing.
- [NTSB LAX96FA249](https://openairdocs.org/ntsb/LAX96FA249.md): Piper PA-24-250 · Death Valley, CA · Accident · 1 fatal · Field investigation · Final report · Dec 23, 1995 · N7304P · Destroyed
  > the non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions.
- [NTSB FTW96FA073](https://openairdocs.org/ntsb/FTW96FA073.md): Cessna 421C · Cleveland, OK · Accident · 6 fatal · Field investigation · Final report · Dec 21, 1995 · N421EP · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…
- [NTSB CHI96LA060](https://openairdocs.org/ntsb/CHI96LA060.md): Cessna T210N · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Dec 21, 1995 · N5083C · Substantial damage
  > the failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.
- [NTSB BFO96FA032](https://openairdocs.org/ntsb/BFO96FA032.md): Cessna 310R · Bellville, OH · Accident · 3 fatal · Field investigation · Final report · Dec 21, 1995 · N1269G · Destroyed
  > the pilot's in-flight loss of aircraft control for undetermined reason(s), which resulted in the airplane exceeding its design stress limitations and an in-flight breakup.
- [NTSB SEA96FA031](https://openairdocs.org/ntsb/SEA96FA031.md): Cessna T210M · Netarts, OR · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1995 · N732TA · Destroyed
  > a loss of control for undetermined reasons.
- [NTSB MIA96LA044](https://openairdocs.org/ntsb/MIA96LA044.md): Cessna 172N · Bryceville, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1995 · N75938 · Substantial damage
  > The pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.
- [NTSB NYC96LA041](https://openairdocs.org/ntsb/NYC96LA041.md): Cessna U206G · Bangor, ME · Accident · No injuries · Limited investigation · Final report · Dec 16, 1995 · N6250X · Substantial damage
  > the pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…
- [NTSB MIA96LA045](https://openairdocs.org/ntsb/MIA96LA045.md): Let L-23 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 16, 1995 · N254BA · Substantial damage
  > The pilot's failure to properly plan the flight.
- [NTSB SEA96FA029](https://openairdocs.org/ntsb/SEA96FA029.md): Cessna 340A · Mead, WA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1995 · N5GM · Destroyed
  > the pilot's failure to maintain terrain clearance in mountainous terrain. Factors contributing to the accident were: dark night conditions, mountainous terrain, and instrument meteorological conditions.
- [NTSB CHI96LA051](https://openairdocs.org/ntsb/CHI96LA051.md): Cessna 182 · Tamms, IL · Accident · No injuries · Limited investigation · Final report · Dec 14, 1995 · N2465Q · Substantial damage
  > fuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.
- [NTSB ATL96FA022](https://openairdocs.org/ntsb/ATL96FA022.md): Piper PA-46-310P · Greenwood, SC · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1995 · N9102V · Substantial damage
  > the loss of engine power for undetermined reason.
- [NTSB ATL96FA021](https://openairdocs.org/ntsb/ATL96FA021.md): Mooney M20J · Bay Minette, AL · Accident · 2 fatal · Field investigation · Final report · Dec 14, 1995 · N3874H · Destroyed
  > failure of the alternate air door, which resulted in blockage of air through the induction system. A factor relating to the accident was: failure to comply with Safety Bulletin SB-M20-253.
- [NTSB CHI96FA052](https://openairdocs.org/ntsb/CHI96FA052.md): Piper PA-23-250 · Steuben, WI · Accident · Serious injuries · Field investigation · Final report · Dec 12, 1995 · N54791 · Destroyed
  > failure of the pilot to select alternate air. Darkness and snowy weather conditions were related factors.
- [NTSB CHI96FA049](https://openairdocs.org/ntsb/CHI96FA049.md): Piper PA-32R-301T · Parker, KS · Accident · 1 fatal · Field investigation · Final report · Dec 12, 1995 · N14BA · Destroyed
  > the pilot's impairment of judgment and performance due to a drug (cocaine); his improper in-flight decision to continue flight over an overcast condition and then to descend into instrument meteorological conditions (IMC); his failure to maintain control of…
- [NTSB FTW96FA063](https://openairdocs.org/ntsb/FTW96FA063.md): Balloon Works Firefly 7-15 · Oklahoma City, OK · Accident · 2 fatal · Field investigation · Final report · Dec 9, 1995 · N25756 · Destroyed
  > The pilot's failure to maintain obstacle clearance during low altitude straight and level flight.
- [NTSB CHI96FA048](https://openairdocs.org/ntsb/CHI96FA048.md): Piper PA-23-250 · Laupahoehoe, HI · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1995 · N6687Y · Destroyed
  > the pilot falling asleep at the controls due to fatigue. Factors were: the pilot's inadequate preflight preparation and the dark night.
- [NTSB FTW96FA062](https://openairdocs.org/ntsb/FTW96FA062.md): Cessna 182G · Caddo Mills, TX · Accident · 3 fatal · Field investigation · Final report · Dec 6, 1995 · N3222S · 2 aircraft · Destroyed
  > The failure of the pilot-in-command in each airplane to see-and-avoid conflicting traffic (inadequate visual lookout). The localized haze and smoke were related factors.
- [NTSB ATL96LA019](https://openairdocs.org/ntsb/ATL96LA019.md): Piper PA-28-180 · Athens, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1995 · N180KH · Substantial damage
  > The mechanic's failure to adequately inspect and repair the engine, which resulted in engine oil contamination, and the subsequent loss of engine power. A factor was the low ceiling.
- [NTSB BFO96LA029](https://openairdocs.org/ntsb/BFO96LA029.md): Cessna 150K · Seville, OH · Accident · 1 fatal · Limited investigation · Final report · Dec 4, 1995 · N5900G · Destroyed
  > pilot suicide (intentional in-flight collision with terrain).
- [NTSB NYC96LA034](https://openairdocs.org/ntsb/NYC96LA034.md): Piper PA-28-140 · Somerset, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 1995 · N1945H · Substantial damage
  > the pilot's improper planning/decision and use of unsuitable terrain for a precautionary landing, which resulted in a collision with an embankment and subsequent nose over of the airplane. Factors relating to the accident were: the adverse weather conditions,…
- [NTSB FTW96LA061](https://openairdocs.org/ntsb/FTW96LA061.md): Cessna 182Q · Eads, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1995 · N735JN · Substantial damage
  > Failure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).

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

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

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