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

## Cases, newest first

- [NTSB CHI04LA196](https://openairdocs.org/ntsb/CHI04LA196.md): McDonnell Douglas DC-9-82 · Sheridan, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 2004 · N585AA · No damage
  > The convection induced turbulence and the flight attendant not being restrained.
- [NTSB CHI04LA184](https://openairdocs.org/ntsb/CHI04LA184.md): Grumman G-164B · York, NE · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 2004 · N48675 · Destroyed
  > A loss of engine power for undetermined reasons. Contributing to the accident were the low altitude at the time of power loss and the unsuitable landing area encountered during the forced landing.
- [NTSB ATL04LA157](https://openairdocs.org/ntsb/ATL04LA157.md): Beech A45 · LaGrange, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2004 · N134BH · Substantial damage
  > The maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…
- [NTSB NYC04LA167](https://openairdocs.org/ntsb/NYC04LA167.md): Cessna 210M · Quarryville, PA · Accident · No injuries · Limited investigation · Final report · Jul 14, 2004 · N6043N · Substantial damage
  > Improper maintenance performed on the airplane, which resulted in a total electrical failure during cruise flight in IMC, and a subsequent precautionary landing. A factor in the accident was the low ceiling.
- [NTSB ANC04IA078](https://openairdocs.org/ntsb/ANC04IA078.md): Cessna 172M · Aniak, AK · Incident · No injuries · Incident investigation · Final report · Jul 14, 2004 · N1453V · Minor damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX04LA265](https://openairdocs.org/ntsb/LAX04LA265.md): Ercoupe 415-D · Santa Clarita, CA · Accident · No injuries · Limited investigation · Final report · Jul 13, 2004 · N3837H · Substantial damage
  > the pilot's inadequate planning/decision by his inadequate evaluation of the weather resulting in an attempt to conduct flight beyond the aircraft's climb performance capability.
- [NTSB ENG04IA021](https://openairdocs.org/ntsb/ENG04IA021.md): Raytheon Corporate Jets Beechjet 400A · Sarasota, FL · Incident · No injuries · Incident investigation · Final report · Jul 12, 2004 · N455CW · No damage
  > High-altitude ice crystals that had accreted on the compressor vanes and were ingested into the high pressure compressor when the pilots retarded the power levers causing compressor surges and flameouts of both engines. Contributing factors were the lack of…
- [NTSB ATL04LA153](https://openairdocs.org/ntsb/ATL04LA153.md): Convair Div. of Gen. Dynamics 440 · Beef Island · Accident · 1 fatal · Limited investigation · Final report · Jul 12, 2004 · N4826C · Substantial damage
  > The in-flight fire on the number two engine, for undetermined reasons.
- [NTSB LAX04LA260](https://openairdocs.org/ntsb/LAX04LA260.md): Piper PA-28-161 · Bridgeport, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 2004 · N6106H · Substantial damage
  > the pilot's failure to attain an adequate altitude to clear mountainous terrain during a high density altitude condition.
- [NTSB IAD04FA031](https://openairdocs.org/ntsb/IAD04FA031.md): Cessna 172C · Edinburgh, NY · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2004 · N8358X · Substantial damage
  > The pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.
- [NTSB DEN04FA104](https://openairdocs.org/ntsb/DEN04FA104.md): Cessna 172I · Paris, AR · Accident · 2 fatal · Field investigation · Final report · Jul 11, 2004 · N46174 · Destroyed
  > the pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…
- [NTSB ANC04LA075](https://openairdocs.org/ntsb/ANC04LA075.md): Cessna 180 · Talkeetna, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 2004 · N3267D · Substantial damage
  > The pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.
- [NTSB SEA04LA128](https://openairdocs.org/ntsb/SEA04LA128.md): Hughes 269C · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jul 10, 2004 · N56PH · Substantial damage
  > A significant power loss for undetermined reasons while in cruise flight, leading to a full autorotational landing. Factors include no suitable terrain in the area, and soft swampy terrain at the point where the pilot found it necessary to perform the forced…
- [NTSB LAX04LA257](https://openairdocs.org/ntsb/LAX04LA257.md): Ercoupe 415-C · Castaic, CA · Accident · No injuries · Limited investigation · Final report · Jul 10, 2004 · N2542H · Substantial damage
  > a catastrophic engine failure due to oil exhaustion, which was caused by the failure of maintenance personnel to completely tighten the oil screen.
- [NTSB DEN04CA101](https://openairdocs.org/ntsb/DEN04CA101.md): Whitlock Rotorway Exec 162F · Meeker, CO · Accident · No injuries · Data collection · Final report · Jul 10, 2004 · N518W · Substantial damage
  > aircraft control not maintained by the pilot. A contributing factor was the failure of the supercharger.
- [NTSB ATL04LA199](https://openairdocs.org/ntsb/ATL04LA199.md): Adventura II · Naples, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2004 · UNREG · Substantial damage
  > Loss of engine power for undetermined reasons and the pilot's improper landing flare which resulted in a hard landing and collapse of the main landing gear.
- [NTSB ATL04LA152](https://openairdocs.org/ntsb/ATL04LA152.md): Stein Skybolt Skybolt · Jasper, GA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2004 · N8048G · Substantial damage
  > The pilot's attempt to operate the airplane with known deficiencies in the equipment, and the fuel system contamination that resulted in fuel starvation to the engine. A factor was rough and uneven terrain.
- [NTSB ATL04CA151](https://openairdocs.org/ntsb/ATL04CA151.md): Cessna 182A · Walterboro, SC · Accident · No injuries · Data collection · Final report · Jul 10, 2004 · N3955D · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB ATL04CA149](https://openairdocs.org/ntsb/ATL04CA149.md): Piper PA-28-161 · Tallassee, AL · Accident · Minor injuries · Data collection · Final report · Jul 10, 2004 · N6AU · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. A factor was pilot fatigue and the unauthorized use of the airplane.
- [NTSB FTW04LA180](https://openairdocs.org/ntsb/FTW04LA180.md): Cessna 150M · Sherrill, AR · Accident · No injuries · Limited investigation · Final report · Jul 9, 2004 · N8959U · Substantial damage
  > the pilot's inadequate in-flight planning/decision which resulted in the loss of engine power due to fuel exhaustion.
- [NTSB CHI04LA183](https://openairdocs.org/ntsb/CHI04LA183.md): Cessna 340A · Mason City, IA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2004 · N60PP · Substantial damage
  > The proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.
- [NTSB CHI04LA181](https://openairdocs.org/ntsb/CHI04LA181.md): Beech BE-N35 · Austin, MN · Accident · No injuries · Limited investigation · Final report · Jul 9, 2004 · N80HL · Substantial damage
  > The loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.
- [NTSB LAX04LA256](https://openairdocs.org/ntsb/LAX04LA256.md): Eurocopter AS350 B2 · Hilo, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2004 · N196BH · Substantial damage
  > the pilot's inadequate planning/decision by his VFR flight into IMC, and his failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. A low ceiling and fog were contributing factors.
- [NTSB CHI04LA173](https://openairdocs.org/ntsb/CHI04LA173.md): Piper PA-28-161 · Waubun, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2004 · N248ND · Substantial damage
  > The pilot's failure to get the proper rest prior to the night cross country flight and the pilot's failure to maintain altitude. Contributing factors to the accident were fatigue as a result of inadequate sleep, conditions conducive to fatigue, and night.
- [NTSB LAX04LA253](https://openairdocs.org/ntsb/LAX04LA253.md): Anderson Harmon Rocket II · Seal Beach, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 7, 2004 · N28BE · Destroyed
  > the in-flight separation of the elevator, which resulted in a loss of airplane control and an uncontrolled descent. The underlying cause and mechanism of the elevator separation could not be determined.
- [NTSB NYC04FA157](https://openairdocs.org/ntsb/NYC04FA157.md): Lake LA-4-200 · Wilmot, NH · Accident · 1 fatal · Field investigation · Final report · Jul 5, 2004 · N6248V · Substantial damage
  > The pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.
- [NTSB IAD04LA028](https://openairdocs.org/ntsb/IAD04LA028.md): Cessna 150 · Paxton, MA · Accident · No injuries · Limited investigation · Final report · Jul 5, 2004 · N5058R · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing. Factors included the pilot's use of a fuel gauge that was calibrated for a different model airplane, and a lack…
- [NTSB DEN04LA098](https://openairdocs.org/ntsb/DEN04LA098.md): Cessna T210N · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Jul 5, 2004 · N5408A · Substantial damage
  > the improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…
- [NTSB DEN04CA099](https://openairdocs.org/ntsb/DEN04CA099.md): Cessna 172N · Laramie, WY · Accident · No injuries · Data collection · Final report · Jul 5, 2004 · N737YJ · Substantial damage
  > fuel exhaustion due to the pilot's improper inflight decision not to stop and refuel. A contributing factor was the unsuitable terrain on which to make a forced landing.
- [NTSB SEA04LA121](https://openairdocs.org/ntsb/SEA04LA121.md): Exp Acft Assn Wi Chapter 60 Moni · Rochester, WA · Accident · No injuries · Limited investigation · Final report · Jul 4, 2004 · N87TW · Substantial damage
  > The pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power during descent. Factors contributing to the accident included the pilot's lack of experience in the aircraft and the tree.
- [NTSB NYC04LA156](https://openairdocs.org/ntsb/NYC04LA156.md): Cessna 182Q · Brighton Beach, NY · Accident · No injuries · Limited investigation · Final report · Jul 4, 2004 · N6550F · Substantial damage
  > A partial loss of engine power during cruise flight for undetermined reasons.
- [NTSB CHI04LA187](https://openairdocs.org/ntsb/CHI04LA187.md): Beech A36 · Algona, IA · Accident · No injuries · Limited investigation · Final report · Jul 2, 2004 · N3248T · Substantial damage
  > The failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…
- [NTSB LAX04LA254](https://openairdocs.org/ntsb/LAX04LA254.md): Eurocopter AS-350-B2 · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 2004 · N513TS · Destroyed
  > Inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was caused by the improper installation and/or adjustment of the collective locking system, which…
- [NTSB LAX04LA251](https://openairdocs.org/ntsb/LAX04LA251.md): Socata TB-20 · Perris, CA · Accident · No injuries · Limited investigation · Final report · Jun 28, 2004 · N110U · Substantial damage
  > A loss of engine power due to oil exhaustion as a result of the mechanic's use of an incorrect gasket during the installation of the vacuum pump.
- [NTSB ATL04FA141](https://openairdocs.org/ntsb/ATL04FA141.md): Robinson R44 · Barnesville, GA · Accident · 3 fatal · Field investigation · Final report · Jun 27, 2004 · N441MG · Destroyed
  > The certified flight instructor's in-flight decision to continue VFR flight into IMC, which resulted in spatial disorientation, and the subsequent in a loss of control. A factor was fog.
- [NTSB ANC04FA070](https://openairdocs.org/ntsb/ANC04FA070.md): Beech 36 · Talkeetna, AK · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2004 · N7673N · Destroyed
  > The pilot's failure to maintain clearance from terrain during cruise flight, which resulted in an in-flight collision with terrain.
- [NTSB FTW04LA169](https://openairdocs.org/ntsb/FTW04LA169.md): Piper PA-32R-300 · Dalhart, TX · Accident · No injuries · Limited investigation · Final report · Jun 25, 2004 · N49KG · Substantial damage
  > loss of engine power due to a corroded magneto for undetermined reasons.
- [NTSB ATL04LA140](https://openairdocs.org/ntsb/ATL04LA140.md): Cessna 172S · Asheville, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2004 · N2116P · Substantial damage
  > The CFII's inadequate visual lookout and failure to maintain clear of objects during flight. Factors were clouds and dark night.
- [NTSB FTW04FA168](https://openairdocs.org/ntsb/FTW04FA168.md): Bell 206-L1 · Vermillion Bay, LA · Accident · 3 fatal · Field investigation · Final report · Jun 24, 2004 · N5006F · Destroyed
  > The pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the prevailing thunderstorms and the pilot's inadequate in flight preparation and planning.
- [NTSB NYC04FA144](https://openairdocs.org/ntsb/NYC04FA144.md): Cessna P210N · Dunkirk, NY · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2004 · N99HW · Destroyed
  > The pilot's loss of aircraft control and the subsequent overstress and separation of the wing during an encounter with convection induced turbulence.
- [NTSB MIA04FA100](https://openairdocs.org/ntsb/MIA04FA100.md): Piper PA-23-250 · Baker, FL · Accident · 2 fatal · Field investigation · Final report · Jun 21, 2004 · N54134 · Destroyed
  > The flight crew's inadvertent flight into thunderstorms resulting in the design limits of the airplane being exceeded, loss of aircraft control and subsequent in-flight breakup. A factor in the accident was the lack of required advisory by ATC about a radar…
- [NTSB CHI04CA159](https://openairdocs.org/ntsb/CHI04CA159.md): Bracken CB540 · Lapeer, MI · Accident · Serious injuries · Data collection · Final report · Jun 19, 2004 · N5439N · Destroyed
  > The pilot's loss of control due to an undetermined flight control system malfunction. Contributing factors to the accident were the wires and trees.
- [NTSB IAD04FA025](https://openairdocs.org/ntsb/IAD04FA025.md): Robinson R-44 · Killingly, CT · Accident · 2 fatal · Field investigation · Final report · Jun 18, 2004 · N70144 · Destroyed
  > The pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…
- [NTSB CHI04FA157](https://openairdocs.org/ntsb/CHI04FA157.md): Piper PA-24-180 · Great Bend, KS · Accident · 4 fatal · Field investigation · Final report · Jun 17, 2004 · N6698P · Destroyed
  > The pilot's inadequate preflight planning due to his failure to obtain a weather briefing prior to takeoff. Additional causes were the pilot's inadvertent flight into adverse weather and his failure to maintain clearance with the terrain during his attempt to…
- [NTSB SEA04FA106](https://openairdocs.org/ntsb/SEA04FA106.md): North American SNJ 5 · Oroville, WA · Accident · 1 fatal · Field investigation · Final report · Jun 16, 2004 · C-GKGE · Destroyed
  > The pilot's failure to maintain adequate terrain clearance, which resulted in the in-flight collision with terrain. Rising terrain was a factor.
- [NTSB SEA04CA107](https://openairdocs.org/ntsb/SEA04CA107.md): Steward Rocky 162F · Hood River, OR · Accident · No injuries · Data collection · Final report · Jun 16, 2004 · N717CS · Substantial damage
  > The pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.
- [NTSB MIA04LA097](https://openairdocs.org/ntsb/MIA04LA097.md): Gulfstream American AA5B · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · Jun 14, 2004 · N4516V · Substantial damage
  > The failure of the number three cylinder exhaust valve which resulted in the partial loss of engine power. The pilot's misjudgment of speed and distance resulted in an overrun of the runway.
- [NTSB NYC04FA139](https://openairdocs.org/ntsb/NYC04FA139.md): Beech 200 · Rupert, WV · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2004 · N200BE · Destroyed
  > The pilot-in-command's improper decision to continue VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors were the FAA Principle Operations Inspector's inadequate surveillance of the operator, and a low ceiling.
- [NTSB DEN04CA095](https://openairdocs.org/ntsb/DEN04CA095.md): Northwing WS2 · Fort Collins, CO · Accident · Serious injuries · Data collection · Final report · Jun 13, 2004 · UNREG · Destroyed
  > A loss of engine power for undetermined reasons. Contributing factors include low altitude, and the lack of suitable terrain for a forced landing.
- [NTSB SEA04LA104](https://openairdocs.org/ntsb/SEA04LA104.md): Piper PA-38-112 · Jerome, ID · Accident · No injuries · Limited investigation · Final report · Jun 11, 2004 · N2579N · Substantial damage
  > The pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.

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

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

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