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

## Cases, newest first

- [NTSB CHI05LA067](https://openairdocs.org/ntsb/CHI05LA067.md): Cessna 152 · Sturtevant, WI · Accident · No injuries · Limited investigation · Final report · Feb 3, 2005 · N68714 · Substantial damage
  > The pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.
- [NTSB DEN05LA053](https://openairdocs.org/ntsb/DEN05LA053.md): Eurocopter AS 350 B3 · Pilar, NM · Accident · No injuries · Limited investigation · Final report · Jan 30, 2005 · N351LG · Substantial damage
  > the pilot's failure to maintain control of the helicopter, and his improper use of night vision goggles (NVG). Contributing factors were the pilot's spatial disorientation, his self-induced pressure to return the helicopter to its home base, his lack of…
- [NTSB DFW05CA061](https://openairdocs.org/ntsb/DFW05CA061.md): Maule M-4-210C · McAlister, OK · Accident · Minor injuries · Data collection · Final report · Jan 24, 2005 · N9866M · Substantial damage
  > The loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…
- [NTSB LAX05LA074](https://openairdocs.org/ntsb/LAX05LA074.md): Mdhi 369E · Pahoa, HI · Accident · No injuries · Limited investigation · Final report · Jan 22, 2005 · N142MK · Substantial damage
  > the in-flight separation of the tail rotor blade abrasion strip due to a degraded adhesive bond and fatigue fracture of the metallic abrasion strip. The ultimate cause for the degraded bond is unknown.
- [NTSB SEA05FA038](https://openairdocs.org/ntsb/SEA05FA038.md): Cirrus SR22 · Hood River, OR · Accident · 3 fatal · Field investigation · Final report · Jan 21, 2005 · N6057M · Destroyed
  > The pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.
- [NTSB CHI05FA056](https://openairdocs.org/ntsb/CHI05FA056.md): Cessna 421C Riley Turbine E · Overland Park, KS · Accident · 5 fatal · Field investigation · Final report · Jan 21, 2005 · N844JK · Destroyed
  > The pilot's failure to maintain adequate altitude/clearance during cruise flight, resulting in collision with trees. Contributing factors were the low altitude and low ceiling.
- [NTSB DFW05LA067](https://openairdocs.org/ntsb/DFW05LA067.md): Cessna 172F · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Jan 20, 2005 · N8203U · Substantial damage
  > A loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD05LA034](https://openairdocs.org/ntsb/IAD05LA034.md): Cessna 414 · Akron, OH · Accident · No injuries · Limited investigation · Final report · Jan 19, 2005 · N5DS · Substantial damage
  > The pilot's failure to obtain a complete weather briefing, which resulted in an inadequate weather decision, and flight into known icing conditions. A factor was the airplane not being equipped for flight in icing conditions.
- [NTSB CHI05FA055](https://openairdocs.org/ntsb/CHI05FA055.md): Cessna T-37B · Hollister, OK · Accident · 1 fatal · Field investigation · Final report · Jan 18, 2005 · 66-8003 · 2 aircraft · Destroyed
  > The pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…
- [NTSB IAD05LA033](https://openairdocs.org/ntsb/IAD05LA033.md): Ghiles MCR-01 VLA · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Jan 17, 2005 · N3085Q · Substantial damage
  > A total loss of engine power due to an oil hose collapse, which resulted in failure of the #4 connecting rod.
- [NTSB LAX05LA070](https://openairdocs.org/ntsb/LAX05LA070.md): Cessna 150H · Pauma Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 2005 · N22562 · Substantial damage
  > the loss of engine power due to an undetermined obstruction in the vent system for the fuel tanks and failure of the fuel caps to vent.
- [NTSB LAX05LA068](https://openairdocs.org/ntsb/LAX05LA068.md): Cessna T210L · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 2005 · N5177V · Substantial damage
  > the pilot's inadequate preflight preparation and failure to verify the fuel supply, which resulted in fuel exhaustion and subsequent loss of engine power.
- [NTSB NYC05FA042](https://openairdocs.org/ntsb/NYC05FA042.md): Embraer EMB-110P1 · Swanzey, NH · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2005 · N49BA · Destroyed
  > The pilot's improper decision to attempt a single-engine missed approach with the airplane in a slow airspeed, full flap configuration, which resulted in a minimum control speed (Vmc) roll. Contributing factors included an inoperative engine for undetermined…
- [NTSB LAX05LA065](https://openairdocs.org/ntsb/LAX05LA065.md): Cessna T210M · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jan 14, 2005 · N761YH · Substantial damage
  > the pilot's failure to use the emergency gear extension procedure to manually extend the landing gear to the down and locked position.
- [NTSB CHI05CA052](https://openairdocs.org/ntsb/CHI05CA052.md): Piper PA-32R-300 · Cumberland, WI · Accident · Minor injuries · Data collection · Final report · Jan 12, 2005 · N427KP · Substantial damage
  > The pilot could not maintain altitude or airspeed due to airframe icing as a result of the pilot flying into known adverse weather and failing to comply with the airplane's icing limitation. Factors included the icing conditions and the ice accumulation on…
- [NTSB ATL05LA046](https://openairdocs.org/ntsb/ATL05LA046.md): Air Tractor AT-402A · Bainbridge, GA · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 2005 · N90772 · Substantial damage
  > The pilot's inadequate management of the fuel supply, which resulted in fuel starvation.
- [NTSB NYC05MA039](https://openairdocs.org/ntsb/NYC05MA039.md): Eurocopter Deutschland EC 135 P2 · Oxon Hill, MD · Accident · 2 fatal · Major investigation · Final report · Jan 11, 2005 · N136LN · Destroyed
  > The pilot's failure to identify and arrest the helicopter's descent, which resulted in controlled flight into terrain. Contributing to the accident were the dark night conditions, limited outside visual references, and the lack of an operable radar altimeter…
- [NTSB MIA05LA046](https://openairdocs.org/ntsb/MIA05LA046.md): Cessna 172M · Orlando, FL · Accident · 1 fatal · Limited investigation · Final report · Jan 11, 2005 · N9336H · Substantial damage
  > The failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…
- [NTSB LAX05FA062](https://openairdocs.org/ntsb/LAX05FA062.md): Cessna 150J · Marana, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 8, 2005 · N51256 · Substantial damage
  > the failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.
- [NTSB ATL05FA041](https://openairdocs.org/ntsb/ATL05FA041.md): Piper PA-28-181 · Bradley, SC · Accident · 4 fatal · Field investigation · Final report · Jan 7, 2005 · N2823H · Destroyed
  > The pilot's loss of control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with trees and the ground. A factor was the dark night conditions.
- [NTSB ATL05LA039](https://openairdocs.org/ntsb/ATL05LA039.md): Piper PA-32-300 · Polkton, NC · Accident · No injuries · Limited investigation · Final report · Jan 6, 2005 · N364BW · Substantial damage
  > A loss of engine power due to the failure of the engine-driven fuel pump, which resulted in fuel starvation.
- [NTSB ATL05FA038](https://openairdocs.org/ntsb/ATL05FA038.md): Aerospatiale AS350-D · Falkner, MS · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2005 · N350RM · Destroyed
  > The pilot's improper decision to attempt VFR flight into known instrument flight conditions and failure to maintain altitude clearance resulted in an in-flight collision with trees and the ground.
- [NTSB MIA05FA044](https://openairdocs.org/ntsb/MIA05FA044.md): Cessna 210N · Weston, FL · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2005 · N6195N · Destroyed
  > The pilot's failure to maintain his assigned altitude, and allowed the airplane to descend for undetermined reasons resulting in an in-flight collision with terrain. Factors in the accident were clouds, rain, and the dark night.
- [NTSB IAD05LA028](https://openairdocs.org/ntsb/IAD05LA028.md): Cessna 172 · Knottsville, KY · Accident · 2 fatal · Limited investigation · Final report · Jan 1, 2005 · N6225E · Destroyed
  > the pilot's loss of control in flight due to spatial disorientation. Also causal to the accident was the pilot's inadequate preflight planning which resulted in his inadvertent flight into night instrument meteorological conditions.
- [NTSB ANC05LA021](https://openairdocs.org/ntsb/ANC05LA021.md): Maule M-7 · Chickaloon, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 1, 2005 · N4262D · Substantial damage
  > The pilot's failure to maintain altitude/clearance during cruise flight, which resulted in an in-flight collision with power lines, and an uncontrolled descent and collision with terrain. A factor associated with the accident was the power lines.
- [NTSB NYC05LA036](https://openairdocs.org/ntsb/NYC05LA036.md): Cessna 175B · Lawrenceburg, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 2004 · N8141T · Substantial damage
  > The pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.
- [NTSB LAX05LA057](https://openairdocs.org/ntsb/LAX05LA057.md): Orr Long-Ez · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 2004 · N321EZ · Substantial damage
  > a loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.
- [NTSB DFW05IA048](https://openairdocs.org/ntsb/DFW05IA048.md): Beech A36 · Natchitoches, LA · Incident · No injuries · Incident investigation · Final report · Dec 29, 2004 · N920GL · Minor damage
  > The loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.
- [NTSB DEN05FA045](https://openairdocs.org/ntsb/DEN05FA045.md): Piper PA-31P · Gallup, NM · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2004 · N573B · Destroyed
  > the pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.
- [NTSB CHI05FA049](https://openairdocs.org/ntsb/CHI05FA049.md): Piper PA-23-250 · Ironwood, MI · Accident · 5 fatal · Field investigation · Final report · Dec 28, 2004 · N5398M · Substantial damage
  > Fatigue fracture of an engine cylinder resulting in a loss of power on the left engine. Additional causes were the pilot's failure to maintain minimum control airspeed (Vmc), the resulting loss of aircraft control, and an inadvertent stall/spin. Contributing…
- [NTSB LAX05CA055](https://openairdocs.org/ntsb/LAX05CA055.md): Top Dog Trike · Torrey Pines, CA · Accident · No injuries · Data collection · Final report · Dec 26, 2004 · UNREG · Substantial damage
  > the pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.
- [NTSB IAD05LA026](https://openairdocs.org/ntsb/IAD05LA026.md): Cessna 150C · East Moriches, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 2004 · N7857Z · Substantial damage
  > Several mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.
- [NTSB CHI05FA048](https://openairdocs.org/ntsb/CHI05FA048.md): Beech S35 · Herman, WI · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2004 · N5631K · Substantial damage
  > The installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…
- [NTSB DEN05LA043](https://openairdocs.org/ntsb/DEN05LA043.md): Mooney M20E · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Dec 23, 2004 · N5550Q · Substantial damage
  > the pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.
- [NTSB LAX05LA036](https://openairdocs.org/ntsb/LAX05LA036.md): Piper PA-28-180 · Jean, NV · Accident · No injuries · Limited investigation · Final report · Dec 19, 2004 · N32034 · Substantial damage
  > the pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.
- [NTSB DEN05LA041](https://openairdocs.org/ntsb/DEN05LA041.md): Arctic S-1B2 · Steamboat Spngs, CO · Accident · No injuries · Limited investigation · Final report · Dec 18, 2004 · N78AT · Substantial damage
  > the loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.
- [NTSB DFW05FA038](https://openairdocs.org/ntsb/DFW05FA038.md): Cessna T210N · Abita Springs, LA · Accident · 2 fatal · Field investigation · Final report · Dec 14, 2004 · N4873C · Destroyed
  > The loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…
- [NTSB CHI05LA045](https://openairdocs.org/ntsb/CHI05LA045.md): Pilatus PC-12/45 · South Bend, IN · Accident · No injuries · Limited investigation · Final report · Dec 14, 2004 · N922RG · Substantial damage
  > Failure of the fuel control unit (FCU) bellows which resulted in a significant loss of engine power and the pilot's encounter with unsuitable terrain during the subsequent forced landing. A contributing factor was the pilot's inadvertent exceedence of the…
- [NTSB ANC05LA018](https://openairdocs.org/ntsb/ANC05LA018.md): Piper PA-28-140 · Sleetmute, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 2004 · N801FS · Substantial damage
  > A loss of engine power during cruise flight due to a fractured exhaust valve, which resulted in a forced landing, and subsequent nose over of the airplane. A factor associated with the accident was the lack of suitable terrain for a successful emergency…
- [NTSB LAX05LA050](https://openairdocs.org/ntsb/LAX05LA050.md): Schweizer 269C · Ontario, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 2004 · N130JS · Substantial damage
  > a loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.
- [NTSB LAX05LA049](https://openairdocs.org/ntsb/LAX05LA049.md): Robinson R22B · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 2004 · N145RJ · Substantial damage
  > The activation of the low main rotor rpm warning system for undetermined reasons.
- [NTSB DFW05LA033](https://openairdocs.org/ntsb/DFW05LA033.md): Mooney M20F · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Dec 9, 2004 · N3208F · Substantial damage
  > The loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX05FA046](https://openairdocs.org/ntsb/LAX05FA046.md): Cessna T207A · Meadview, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2004 · N1783U · Destroyed
  > a loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.
- [NTSB IAD05LA024](https://openairdocs.org/ntsb/IAD05LA024.md): Hare Seawind · Trenton, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2004 · N42HA · Substantial damage
  > The pilot's improper fuel management which resulted in fuel starvation and subsequent loss of engine power. A contributing factor to the accident was the pilot's inadvertent loss of airspeed.
- [NTSB CHI05CA041](https://openairdocs.org/ntsb/CHI05CA041.md): Piper PA-30 · Atlantic, IA · Accident · No injuries · Data collection · Final report · Dec 5, 2004 · N7803Y · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.
- [NTSB ANC05IA016](https://openairdocs.org/ntsb/ANC05IA016.md): Boeing 747SR-146B SF · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Dec 5, 2004 · JA8158 · Minor damage
  > The fatigue and subsequent fracture of a portion of the airplane's pressure bulkhead, which resulted in a rapid decompression during cruise flight.
- [NTSB NYC05IA029](https://openairdocs.org/ntsb/NYC05IA029.md): Fairchild-Heliporter Pilatus PC6/B2-H2 · Cross Keys, NJ · Incident · No injuries · Incident investigation · Final report · Dec 4, 2004 · N7391U · Minor damage
  > A total failure of the left elevator attachment point for undetermined reasons.
- [NTSB MIA05FA040](https://openairdocs.org/ntsb/MIA05FA040.md): Convair Div. of Gen. Dynamics 340 · N. Miami Beach, FL · Accident · No injuries · Field investigation · Final report · Dec 4, 2004 · N41626 · Substantial damage
  > The improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…
- [NTSB DFW05LA027](https://openairdocs.org/ntsb/DFW05LA027.md): Cessna P210N · Pawhuska, OK · Accident · No injuries · Limited investigation · Final report · Dec 1, 2004 · N6300P · Substantial damage
  > The pilot's mismanagement of the fuel by his failure to adequately set the fuel selector position which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX05LA042](https://openairdocs.org/ntsb/LAX05LA042.md): Piper PA-22-108 · Big Pine, CA · Accident · No injuries · Limited investigation · Final report · Nov 28, 2004 · N4913Z · Substantial damage
  > oil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…

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

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

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