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

## Cases, newest first

- [NTSB CEN15IA365](https://openairdocs.org/ntsb/CEN15IA365.md): Beech V35 · Mount Vernon, OH · Incident · No injuries · Incident investigation · Final report · Aug 16, 2015 · N2059W · No damage
  > The loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.
- [NTSB ANC15CA064](https://openairdocs.org/ntsb/ANC15CA064.md): Champion 7HC · Coldfoot, AK · Accident · No injuries · Data collection · Final report · Aug 16, 2015 · N8556E · Destroyed
  > The loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.
- [NTSB WPR15LA242](https://openairdocs.org/ntsb/WPR15LA242.md): Bartels Lancair · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Limited investigation · Final report · Aug 14, 2015 · N427LE · Destroyed
  > The pilot's incapacitation for reasons that could not be determined because the airplane was not recovered from the ocean.
- [NTSB ERA15WA316](https://openairdocs.org/ntsb/ERA15WA316.md): Robinson R44 - II · Limpio, Paraguay · Accident · 1 fatal · Foreign investigation · Aug 14, 2015 · ZPHAH · Destroyed
  > On August 14, 2015, about 0830 local time (1130 coordinated universal time), a Robinson R44 Raven II, designated A02 and operated by the Paraguayan National Police, was destroyed when it impacted terrain in Limpio, Paraguay, about 6 nautical miles northeast…
- [NTSB WPR15FA241](https://openairdocs.org/ntsb/WPR15FA241.md): Cessna T182T · Oroville, WA · Accident · 2 fatal · Field investigation · Final report · Aug 13, 2015 · N6289Z · Destroyed
  > The pilot’s failure to maintain terrain clearance while maneuvering. Contributing to the accident was the pilots’ selection, for undetermined reasons, of a route different than the most commonly used route.
- [NTSB ERA15WA310](https://openairdocs.org/ntsb/ERA15WA310.md): Cessna 208B · Saba, NT · Accident · Minor injuries · Foreign investigation · Aug 12, 2015 · N924FE · Substantial damage
  > On August 12, 2015, at 1630 Universal Coordinated Time (UTC), a Cessna 208B, U.S. Registration N924FE, operated by Mountain Air Cargo, was substantially damaged following a loss of engine power and ditching in the Caribbean Sea near Saba, Netherlands…
- [NTSB DCA15RA171](https://openairdocs.org/ntsb/DCA15RA171.md): Sikorsky S76 - C · Lagos, Nigeria · Accident · No injuries · Foreign investigation · Aug 12, 2015 · 5N-BDG · Destroyed
  > The Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a SIKORSKY S76 - C helicopter that occurred on August 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the NAIB investigation under the…
- [NTSB CEN15FA347](https://openairdocs.org/ntsb/CEN15FA347.md): Grumman American Avn. AA 5A · Harrisburg, IL · Accident · 2 fatal · Field investigation · Final report · Aug 10, 2015 · N9684U · Substantial damage
  > The student pilot's improper decision to conduct a flight in dark, night conditions and his subsequent controlled flight into terrain.
- [NTSB OPS15IA020](https://openairdocs.org/ntsb/OPS15IA020.md): Airbus Industrie A320 211 · Max, NE · Incident · No injuries · Incident investigation · Final report · Aug 8, 2015 · N332NW · Minor damage
  > The flight crew's continued flight into a closing gap between areas of thunderstorm activity and their failure to maintain the required lateral separation from the thunderstorms, which resulted in the airplane's encounter with hail and subsequent airplane…
- [NTSB WPR15LA239](https://openairdocs.org/ntsb/WPR15LA239.md): Embraer E175 · South Lake Tahoe, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2015 · N204NN · No damage
  > The airplane's encounter with moderate turbulence during descent, which resulted in a serious injury to a flight attendant who was not securely seated. Contributing to the accident was the flight attendant's decision to continue to secure items before the…
- [NTSB WPR15FA236](https://openairdocs.org/ntsb/WPR15FA236.md): Cessna 182F · Montecito, CA · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2015 · N5738F · Substantial damage
  > Oil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.
- [NTSB ANC15FA062](https://openairdocs.org/ntsb/ANC15FA062.md): Piper PA 18-150 · Chugiak, AK · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2015 · N3675P · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN15WA339](https://openairdocs.org/ntsb/CEN15WA339.md): Kitfox Series 7 · Hundwil, Switzerland · Accident · No injuries · Foreign investigation · Aug 5, 2015 · HB-YMG · Destroyed
  > On August 5, 2015 about 0840 UTC, a Kitfox Series 7 airplane, Swiss registration HB-YMG, impacted into a forest near Hundwil-Appenzell, Switzerland. The pilot and the passenger were killed, and the airplane was destroyed. Visual Meteorological conditions…
- [NTSB CEN15LA341](https://openairdocs.org/ntsb/CEN15LA341.md): Hughes 269B · Atkinson, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2015 · N9427F · Destroyed
  > The pilot's improper decision to intentionally fly the helicopter at a low altitude and his subsequent failure to maintain clearance from a power line.
- [NTSB WPR15LA237](https://openairdocs.org/ntsb/WPR15LA237.md): Piper PA 28-181 · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N7963C · Substantial damage
  > The low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.
- [NTSB WPR15LA229](https://openairdocs.org/ntsb/WPR15LA229.md): Cessna TU206G · Saint Ignatius, MT · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N235HM · Substantial damage
  > Maintenance personnel’s failure to tighten a fuel line, which resulted in a loss of fuel pressure and a subsequent loss of engine power during cruise flight and an off-airport landing and collision with obstacles.
- [NTSB WPR15LA228](https://openairdocs.org/ntsb/WPR15LA228.md): Hudson Zodiac CH 601 XLB · Hubbard, OR · Accident · No injuries · Limited investigation · Final report · Aug 2, 2015 · N234S · Substantial damage
  > A severe propeller vibration due to the pilot's improper installation of the propeller spacer assembly, which necessitated an engine shutdown, an off-airport landing, and a collision with a sprinkler system.
- [NTSB ERA15LA293](https://openairdocs.org/ntsb/ERA15LA293.md): Beech C90B · Georgetown, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2015 · N257CQ · Substantial damage
  > Undetermined based on the available evidence.
- [NTSB WPR15FA227](https://openairdocs.org/ntsb/WPR15FA227.md): Cessna P337G · Santa Paula, CA · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2015 · N4CU · Substantial damage
  > The noninstrument-rated pilot's decision to conduct a visual flight in instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.
- [NTSB ERA15LA294](https://openairdocs.org/ntsb/ERA15LA294.md): Commander 114 · Reading, PA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2015 · N6566D · Substantial damage
  > The improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.
- [NTSB ERA15LA291](https://openairdocs.org/ntsb/ERA15LA291.md): Sontonastaso Mosquito · Winchendon, MA · Accident · No injuries · Limited investigation · Final report · Jul 29, 2015 · N285XE · Substantial damage
  > A partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.
- [NTSB CEN15FA316](https://openairdocs.org/ntsb/CEN15FA316.md): Beech V35B · Colbert, OK · Accident · 2 fatal · Field investigation · Final report · Jul 26, 2015 · N252G · Substantial damage
  > The pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…
- [NTSB CEN15WA358](https://openairdocs.org/ntsb/CEN15WA358.md): Robinson Helicopter Robinson R44 · Leixlip, Ireland · Incident · No injuries · Foreign investigation · Jul 25, 2015 · G-OCON · 2 aircraft · No damage
- [NTSB CEN15WA317](https://openairdocs.org/ntsb/CEN15WA317.md): Cox Bede BD-5G · Garranbane, Ireland · Accident · 1 fatal · Foreign investigation · Jul 25, 2015 · EI-DNN · Destroyed
  > On July 25, 2015, at 1745 universal coordinated time (UTC), a Cox model Bede BD-5G amateur-built airplane, Irish registration EI-DNN, serial number HJC4523, was destroyed during a postimpact fire following a forced landing near Garranbane, Ireland. The pilot,…
- [NTSB CEN15LA318](https://openairdocs.org/ntsb/CEN15LA318.md): Piper PA38 - 112 · Millbury, OH · Accident · 1 fatal · Limited investigation · Final report · Jul 25, 2015 · C-GTAO · Substantial damage
  > A loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.
- [NTSB CEN15FA315](https://openairdocs.org/ntsb/CEN15FA315.md): Sanford Zenith CH 601XL · Bristol, WI · Accident · 2 fatal · Field investigation · Final report · Jul 25, 2015 · N9601 · Substantial damage
  > The pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…
- [NTSB ERA15LA287](https://openairdocs.org/ntsb/ERA15LA287.md): Piper J3C 65 · Southside, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 2015 · N92653 · Substantial damage
  > The pilot’s exhaustion of the airplane’s fuel supply, which resulted in a total loss of engine power. Contributing to the outcome was the pilot’s failure to secure the engine before the forced landing.
- [NTSB ERA15LA280](https://openairdocs.org/ntsb/ERA15LA280.md): MD Helicopter 369FF · Vega Baja, PR · Accident · No injuries · Class 3 · Limited · Final report · Jul 24, 2015 · N5842Z · Substantial damage
  > A total loss of engine power due to insufficient lubrication to the engine's No. 2 bearing, which resulted in the failure of the bearing and a subsequent forced landing.
- [NTSB ANC15CA052](https://openairdocs.org/ntsb/ANC15CA052.md): Cessna 182 · Wasilla, AK · Accident · No injuries · Data collection · Final report · Jul 23, 2015 · N5722B · Substantial damage
  > The pilot's failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.
- [NTSB WPR15LA220](https://openairdocs.org/ntsb/WPR15LA220.md): Cessna 182Q · Prichard, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 2015 · N759LV · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 6 cylinder piston pin.
- [NTSB ERA15WA275](https://openairdocs.org/ntsb/ERA15WA275.md): Cessna 206G · Sucua, Ecuador · Accident · Serious injuries · Foreign investigation · Jul 19, 2015 · HC-CLR · Destroyed
  > On July 19, 2015, about 1515 universal coordinated time, a Cessna 206G, HC-CLR, was destroyed by collision with terrain during a forced landing following a loss of engine power during descent to Edmund Carvajal Airport (XMS), Macas, Santiago, Ecuador. The…
- [NTSB CEN15LA332](https://openairdocs.org/ntsb/CEN15LA332.md): Alon A2 · Holland, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 2015 · N5607F · Substantial damage
  > A total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.
- [NTSB CEN15LA346](https://openairdocs.org/ntsb/CEN15LA346.md): Ercoupe 415 · Saint Martin Island, MI · Accident · No injuries · Limited investigation · Final report · Jul 18, 2015 · CFGGS · Substantial damage
  > The failure of a connecting rod bearing, which resulted in a loss of engine power.
- [NTSB CEN15FA307](https://openairdocs.org/ntsb/CEN15FA307.md): Cessna T310R · Cody, WY · Accident · 4 fatal · Field investigation · Final report · Jul 18, 2015 · N72TP · Destroyed
  > The pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.
- [NTSB CEN15WA338](https://openairdocs.org/ntsb/CEN15WA338.md): 3xtrim 450 Ultra · Golub-Dobrzyn City, Poland · Accident · 1 fatal · Foreign investigation · Jul 17, 2015 · SP-SPRL · Destroyed
  > On July 17, 2015 about 1615 UTC, a 3Xtrim 450 Ultra, light sport airplane, Poland registration SP-SPRL, impacted terrain while on a sightseeing flight near Golub-Dobrzyn, Poland. The pilot was seriously injured and the passenger was killed. The airplane was…
- [NTSB ANC15FA049](https://openairdocs.org/ntsb/ANC15FA049.md): Cessna 207A · Juneau, AK · Accident · 1 fatal · Class 3 · Field · Final report · Jul 17, 2015 · N62AK · Substantial damage
  > The pilot's decision to initiate and continue visual flight into instrument meteorological conditions, which resulted in a loss of situational awareness and controlled flight into terrain. Contributing to the accident were the company's failure to follow its…
- [NTSB ERA15LA271](https://openairdocs.org/ntsb/ERA15LA271.md): Young John E Searey · Corbin, KY · Accident · No injuries · Limited investigation · Final report · Jul 16, 2015 · N236JY · Substantial damage
  > The pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.
- [NTSB CEN15LA308](https://openairdocs.org/ntsb/CEN15LA308.md): Devoe Clip Wing · Melbourne, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 2015 · N80917 · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…
- [NTSB CEN15FA305](https://openairdocs.org/ntsb/CEN15FA305.md): Piper PA 32-300 · Brazoria, TX · Accident · 2 fatal · Field investigation · Final report · Jul 14, 2015 · N555PK · Destroyed
  > The student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.
- [NTSB ERA15LA263](https://openairdocs.org/ntsb/ERA15LA263.md): Cessna 210 5A(205A) · Stafford Twp, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 2015 · N315EC · Substantial damage
  > The total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic's failure to properly torque the engine cylinder through bolts.
- [NTSB WPR15FA215](https://openairdocs.org/ntsb/WPR15FA215.md): Piper PA 22-160 · Twin Sisters Mtn, WA · Accident · 2 fatal · Field investigation · Final report · Jul 11, 2015 · N9712D · Destroyed
  > The noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.
- [NTSB WPR15FA212](https://openairdocs.org/ntsb/WPR15FA212.md): Beech A35 · Mazama, WA · Accident · 2 fatal · Field investigation · Final report · Jul 11, 2015 · N8749A · Destroyed
  > The noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance from mountainous terrain.
- [NTSB ERA15MA259](https://openairdocs.org/ntsb/ERA15MA259.md): Cessna 150M · Moncks Corner, SC · Accident · 2 fatal · Class 2 · Major · Final report · Jul 7, 2015 · N3601V · 2 aircraft · Destroyed
  > The approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…
- [NTSB ERA15LA258](https://openairdocs.org/ntsb/ERA15LA258.md): Cessna T210L · Oneonta, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2015 · N59024 · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ENG15WA029](https://openairdocs.org/ntsb/ENG15WA029.md): Embraer ERJ170 - 200STD · Niigata, Japan · Incident · No injuries · Foreign investigation · Jul 7, 2015 · JA06FJ · No damage
  > On July 7, 2015, an Embraer ERJ170 experienced a bleed system failure during climb after take-off from New Chitose Airport (RJCC), Chitose, Japan. The aircraft diverted to Niigata Airport (RJSN). No one on board the aircraft was injured. The incident is being…
- [NTSB CEN15LA296](https://openairdocs.org/ntsb/CEN15LA296.md): Colonial C 1 · Chico, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 2015 · N257B · Substantial damage
  > A loss of engine power due to fuel exhaustion. Contributing to the accident was the unsnapped fuel bladder, which resulted in an inaccurate fuel quantity indication, and the pilot's inadequate preflight fuel planning, during which he relied solely on the fuel…
- [NTSB ANC15LA046](https://openairdocs.org/ntsb/ANC15LA046.md): Cessna 182 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 5, 2015 · N4861D · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat.
- [NTSB WPR15CA207](https://openairdocs.org/ntsb/WPR15CA207.md): Piper PA 18-150 · Carlsbad, CA · Accident · Minor injuries · Data collection · Final report · Jul 4, 2015 · N8075P · Substantial damage
  > The pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.
- [NTSB GAA15CA164](https://openairdocs.org/ntsb/GAA15CA164.md): Piper PA 18-135 · Twin Falls, ID · Accident · Minor injuries · Data collection · Final report · Jul 3, 2015 · N8086C · Substantial damage
  > The pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.
- [NTSB CEN15LA292](https://openairdocs.org/ntsb/CEN15LA292.md): Cessna 172D · Shenandoah, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2015 · N2320U · Substantial damage
  > The pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.

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

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

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