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

## Cases, newest first

- [NTSB ATL96LA087](https://openairdocs.org/ntsb/ATL96LA087.md): Sky Star Kitfox #1 · Bridgeport, AL · Accident · Serious injuries · Limited investigation · Final report · May 26, 1996 · N7030G · Substantial damage
  > loss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.
- [NTSB CHI96LA178](https://openairdocs.org/ntsb/CHI96LA178.md): Dickinson Fisher Classic · Mooresville, IN · Accident · Minor injuries · Limited investigation · Final report · May 25, 1996 · N6292B · Substantial damage
  > the pilot failed to maintain adequate altitude and clearance from the trees, and had made an improper in-flight decision when he got to far from a suitable landing area. The reason for the loss of power failure was undetermined.
- [NTSB FTW96LA226](https://openairdocs.org/ntsb/FTW96LA226.md): Navion NA1 · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · May 24, 1996 · N2530T · Substantial damage
  > The total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96IA170](https://openairdocs.org/ntsb/CHI96IA170.md): Beech 1900D · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · May 24, 1996 · N148SK · Minor damage
  > failure of a forward cabin ventilation blower motor bearing, which resulted in binding of the blower motor; and inadequate design of the electrical system, which allowed overheating of the electrical circuit and smoke in the cabin of the aircraft.
- [NTSB FTW96LA224](https://openairdocs.org/ntsb/FTW96LA224.md): Cessna 310C · Los Lunas, NM · Accident · No injuries · Limited investigation · Final report · May 22, 1996 · N1813H · Substantial damage
  > loss of total engine power due to fuel exhaustion for undetermined reason(s). The lack of suitable terrain for the forced landing was a related factor. The worn and leaking fuel system components and inadequate maintenance by unknown personnel were possible…
- [NTSB ANC96LA076](https://openairdocs.org/ntsb/ANC96LA076.md): Beech 99C · Barrow, AK · Accident · Minor injuries · Limited investigation · Final report · May 21, 1996 · N216CS · Substantial damage
  > an in-flight collision with a bird.
- [NTSB MIA96LA142](https://openairdocs.org/ntsb/MIA96LA142.md): Piper PA-32 · Jacksonville, FL · Accident · Serious injuries · Limited investigation · Final report · May 20, 1996 · N9164B · Substantial damage
  > The pilot's failure to maintain airspeed (VSO) while maneuvering during a go-around, resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's failure to achieve the proper touchdown point…
- [NTSB IAD96LA079](https://openairdocs.org/ntsb/IAD96LA079.md): Cessna P210N · Carrollton, OH · Accident · Minor injuries · Limited investigation · Final report · May 20, 1996 · N731NC · Substantial damage
  > The pilot's inadequate fuel management. Factors in this accident were the pilot's reliance on a fuel data computer and his untimely reaction to a known fuel quantity discrepancy.
- [NTSB CHI96FA171](https://openairdocs.org/ntsb/CHI96FA171.md): Cessna 401 · Great Bend, KS · Accident · No injuries · Field investigation · Final report · May 20, 1996 · N701CJ · Substantial damage
  > the failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.
- [NTSB NYC96LA111](https://openairdocs.org/ntsb/NYC96LA111.md): Schweizer SGS-2-33A · Bloomingburg, NY · Accident · Serious injuries · Limited investigation · Final report · May 19, 1996 · N65847 · Minor damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall spin and collision with trees.
- [NTSB LAX96IA199](https://openairdocs.org/ntsb/LAX96IA199.md): Boeing 747-273C · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · May 19, 1996 · N470EV · Minor damage
  > the operator's failure to adopt a manufacturer's stipulated ultrasonic inspection procedure, which led to the in-flight separation of the wing panel.
- [NTSB LAX96FA200](https://openairdocs.org/ntsb/LAX96FA200.md): Cessna 414 · Kernville, CA · Accident · 1 fatal · Field investigation · Final report · May 19, 1996 · N111AH · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from rising/mountainous terrain. Factors relating to the accident were: the terrain and weather conditions.
- [NTSB NYC96LA109](https://openairdocs.org/ntsb/NYC96LA109.md): McCall WATCHA-MCCALL-IT · Steamburg, NY · Accident · Minor injuries · Limited investigation · Final report · May 18, 1996 · N111MC · Substantial damage
  > the pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…
- [NTSB LAX96LA197](https://openairdocs.org/ntsb/LAX96LA197.md): Cessna 152 · Sylmar, CA · Accident · Minor injuries · Limited investigation · Final report · May 18, 1996 · N69180 · Destroyed
  > fuel exhaustion due to the inexperienced student pilot's inadequately performed preflight inspection and her failure to refuel prior to takeoff.
- [NTSB IAD96LA081](https://openairdocs.org/ntsb/IAD96LA081.md): Cessna 205A · Sommerville, VA · Accident · No injuries · Limited investigation · Final report · May 18, 1996 · N5261G · Substantial damage
  > the loss of engine power for undetermined reasons during banner towing operations.
- [NTSB CHI96LA163](https://openairdocs.org/ntsb/CHI96LA163.md): Johnson Avid Flyer · Rockford, MI · Accident · No injuries · Limited investigation · Final report · May 18, 1996 · N4274A · Substantial damage
  > engine overtemperature which occurred for an undetermined reason. A factor was the excessive descent rate.
- [NTSB MIA96LA141](https://openairdocs.org/ntsb/MIA96LA141.md): Piper PA-28-161 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · May 16, 1996 · N9239B · Substantial damage
  > the pilot's mismanagement of fuel, by failing to reposition the fuel selector to the left tank after fuel was used from the right tank, which resulted in fuel starvation, loss of engine power, and a forced landing. A factor relating to the accident was: the…
- [NTSB SEA96FA094](https://openairdocs.org/ntsb/SEA96FA094.md): Cessna 320A · Provo, UT · Accident · 2 fatal · Field investigation · Final report · May 15, 1996 · N600JR · Destroyed
  > A fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…
- [NTSB CHI96IA157](https://openairdocs.org/ntsb/CHI96IA157.md): Boeing 727-290 · Indianapolis, IN · Incident · Minor injuries · Incident investigation · Final report · May 13, 1996 · N775AT · No damage
  > the failure of the captain and flight engineer to utilize a checklist to troubleshoot a pressurization system problem, and the flight engineer's improper control of the pressurization system which resulted in an inadvertent opening of the outflow valve and…
- [NTSB IAD96LA083](https://openairdocs.org/ntsb/IAD96LA083.md): Lithuanian Factory of LAK-12 · Woodbine, MD · Accident · No injuries · Limited investigation · Final report · May 11, 1996 · N112LK · Substantial damage
  > The pilot's decision to fly with inadequate research of forecast weather.
- [NTSB DCA96MA054](https://openairdocs.org/ntsb/DCA96MA054.md): Douglas DC-9-32 · Miami, FL · Accident · 110 fatal · Class 1 · Major · Final report · May 11, 1996 · N904VJ · Destroyed
  > which resulted from a fire in the airplane's class D cargo compartment that was initiated by the actuation of one or more oxygen generators being improperly carried as cargo, were (1) the failure of SabreTech to properly prepare, package, and identify…
- [NTSB FTW96LA206](https://openairdocs.org/ntsb/FTW96LA206.md): Piper PA-28-140 · Claude, TX · Accident · Minor injuries · Limited investigation · Final report · May 10, 1996 · N7426R · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft terrain was a related factor concerning nose over in the emergency landing area.
- [NTSB CHI96GA154](https://openairdocs.org/ntsb/CHI96GA154.md): Beech 200 · Peoria, IL · Incident · No injuries · Final report · May 8, 1996 · N961LL · Minor damage
  > the pilot's intentional flight into known adverse weather conditions and the lightning strike.
- [NTSB IAD96LA072](https://openairdocs.org/ntsb/IAD96LA072.md): Piper PA-60-600 · Syracuse, NY · Accident · Serious injuries · Limited investigation · Final report · May 7, 1996 · N222KD · Minor damage
  > the pilot's failure to ensure that his hand would remain clear of the propeller, while attempting to take remedial action to secure the clam shell door. The unlatching and separation of the clam shell door from the aircraft were related factors.
- [NTSB NYC96FA101](https://openairdocs.org/ntsb/NYC96FA101.md): Cessna P210N · Ridgefield, CT · Accident · 2 fatal · Field investigation · Final report · May 6, 1996 · N450T · Destroyed
  > improper planning/decision by the pilot, which led to flight into icing conditions; and his failure to use all anti-ice and deicing equipment, as specified by the airplane operator's manual for inadvertent flight into icing conditions. This resulted in loss…
- [NTSB FTW96LA202](https://openairdocs.org/ntsb/FTW96LA202.md): Stinson 108-2 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · May 6, 1996 · N427C · Substantial damage
  > the pilot's improper inflight planning/decision, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: the unfavorable en route wind.
- [NTSB MIA96LA137](https://openairdocs.org/ntsb/MIA96LA137.md): Cessna U206G · Gulf Of Mexico · Accident · No injuries · Limited investigation · Final report · May 5, 1996 · N9702Z · Substantial damage
  > Loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.
- [NTSB ANC96LA069](https://openairdocs.org/ntsb/ANC96LA069.md): Gillespie Challenger 2 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · May 5, 1996 · N1591G · Substantial damage
  > The pilot's failure to properly use the mixture control to enrich the fuel mixture, and the seizure of the piston in the cylinder.
- [NTSB MIA96LA136](https://openairdocs.org/ntsb/MIA96LA136.md): Beech UC45J · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1996 · N64819 · Substantial damage
  > inadequate inspection of the fuel line connector by company maintenance personnel, and failure of a connector resulting in a fuel leak and fire.
- [NTSB MIA96FA134](https://openairdocs.org/ntsb/MIA96FA134.md): Beech V35 · Powelton, GA · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1996 · N102A · Destroyed
  > the pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…
- [NTSB CHI96FA146](https://openairdocs.org/ntsb/CHI96FA146.md): Cessna 421 · Bernard, IA · Accident · 3 fatal · Field investigation · Final report · Apr 29, 1996 · N341DA · Destroyed
  > the pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…
- [NTSB CHI96IA145](https://openairdocs.org/ntsb/CHI96IA145.md): Boeing 727-222A · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Apr 28, 1996 · N7443U · No damage
  > a passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.
- [NTSB ANC96FA059](https://openairdocs.org/ntsb/ANC96FA059.md): Cessna 150 · Palmer, AK · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1996 · N8115U · Destroyed
  > loss of engine power due to a malfunction of the airplane's magneto ignition system, and the pilot's failure to have an annual inspection performed. Factors relating to the accident were: the pilot's lack of recent experience and inadequate in-flight planning…
- [NTSB FTW96FA183](https://openairdocs.org/ntsb/FTW96FA183.md): Piper PA-28-151 · Vera, OK · Accident · 4 fatal · Field investigation · Final report · Apr 27, 1996 · N7845C · Destroyed
  > improper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.
- [NTSB MIA96LA131](https://openairdocs.org/ntsb/MIA96LA131.md): Cessna 210M · Meridian, MS · Accident · No injuries · Limited investigation · Final report · Apr 26, 1996 · N722PD · Substantial damage
  > previous engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…
- [NTSB IAD96LA067](https://openairdocs.org/ntsb/IAD96LA067.md): Bell 206B · Logan, WV · Accident · No injuries · Limited investigation · Final report · Apr 26, 1996 · N111PM · Substantial damage
  > the pilot's failure to maintain an adequate fuel supply for the flight which resulted in a loss of engine power due to fuel exhaustion, and the loss of rotor rpm during the autorotation. The downhill sloping terrain was a related factor.
- [NTSB FTW96LA193](https://openairdocs.org/ntsb/FTW96LA193.md): Piper PA-28RT-201T · Columbus, TX · Accident · No injuries · Limited investigation · Final report · Apr 26, 1996 · N2194Y · Substantial damage
  > the pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…
- [NTSB SEA96LA082](https://openairdocs.org/ntsb/SEA96LA082.md): Cessna 150 · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1996 · N8873S · Substantial damage
  > the student pilot's inadequate preflight planning/preparation, by failuring to properly calculate the fuel consumption of the airplane, which led to fuel exhaustion and loss of power during cruise flight, due to an inadequate supply of fuel. A factor relating…
- [NTSB ANC96LA053](https://openairdocs.org/ntsb/ANC96LA053.md): Maule M-5-210C · Grayling, AK · Accident · No injuries · Limited investigation · Final report · Apr 21, 1996 · N9704N · Destroyed
  > disintegration of the alternator drive coupling, jamming of the accessory drive gear, shearing of the oil pump drive, oil starvation, and failure of the number 6 cylinder connecting rod. Non-compliance with a manufacturer's service bulletin and soft snow were…
- [NTSB MIA96LA123](https://openairdocs.org/ntsb/MIA96LA123.md): Vernon L. Cox COX-HAWK · Mebane, NC · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1996 · N7VC · Destroyed
  > The pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…
- [NTSB CHI96FA139](https://openairdocs.org/ntsb/CHI96FA139.md): Cessna 150F · Mackinac Island, MI · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1996 · N6824F · Destroyed
  > the student pilot iniating VFR flight into instrument meteorological conditions which led to a loss of aircraft control. A factor was the fog.
- [NTSB NYC96FA085](https://openairdocs.org/ntsb/NYC96FA085.md): Piper PA-28-181 · Granville, OH · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1996 · N8276Y · Destroyed
  > the pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…
- [NTSB IAD96LA063](https://openairdocs.org/ntsb/IAD96LA063.md): Glasair GL20 · Rocky Mount, VA · Accident · 2 fatal · Limited investigation · Final report · Apr 16, 1996 · N518EC · Destroyed
  > the pilot's continued flight into adverse weather conditions which led to airframe ice and a loss of control. Related factors were: the failure of the FSS briefer to advise the pilot of a valid AIRMET regarding icing conditions, the icing conditions, and…
- [NTSB LAX96LA170](https://openairdocs.org/ntsb/LAX96LA170.md): Piper PA-24-250 · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1996 · N6415P · Substantial damage
  > fuel starvation due to the pilot's failure to monitor fuel tank quantities and to assure that the fuel tank selector was positioned to a tank containing adequate fuel.
- [NTSB LAX96LA168](https://openairdocs.org/ntsb/LAX96LA168.md): Hughes 369D · Yerington, NV · Accident · No injuries · Limited investigation · Final report · Apr 14, 1996 · N519BH · Substantial damage
  > the partial loss of engine power and the pilot's misjudged flare during an autorotation landing in soft dirt with excessive forward speed. The power loss resulted from flight operations in an environment which debris contaminated the engine's nozzle port and…
- [NTSB LAX96LA167](https://openairdocs.org/ntsb/LAX96LA167.md): Maule M-5-235C · Lake Havasu Cty, AZ · Accident · No injuries · Limited investigation · Final report · Apr 14, 1996 · N9177E · Substantial damage
  > the pilot-owner's inadequate engine maintenance which resulted in a progressive ignition failure. Factors which contributed to the accident were the dark nighttime light condition and the presence of hidden obstructions in the forced landing area.
- [NTSB CHI96LA132](https://openairdocs.org/ntsb/CHI96LA132.md): Siai-Marchetti S.205/22R · Anoka, MN · Accident · No injuries · Limited investigation · Final report · Apr 13, 1996 · N954W · Substantial damage
  > A loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.
- [NTSB MIA96IA114](https://openairdocs.org/ntsb/MIA96IA114.md): Mitsubishi MU-2G-30 · Columbia, SC · Incident · No injuries · Incident investigation · Final report · Apr 12, 1996 · N920S · Minor damage
  > failure of the nose landing gear bearing due to improper assembly and staking (inadequate quality control) by the manufacturer; which prevented the nose gear from retracting and the main gear from extending, and resulted in a subsequent landing on the nose…
- [NTSB CHI96LA129](https://openairdocs.org/ntsb/CHI96LA129.md): Cessna T310Q · Minneapolis, MN · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 1996 · N7713Q · Substantial damage
  > the inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…
- [NTSB IAD96LA058](https://openairdocs.org/ntsb/IAD96LA058.md): Boeing 757-200 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 1996 · N653A · No damage
  > the in-flight encounter with unforecast, unexpected turbulence.

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

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

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