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

## Cases, newest first

- [NTSB ANC13LA021](https://openairdocs.org/ntsb/ANC13LA021.md): Cessna 172N · Kalskag, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2013 · N5290J · Substantial damage
  > The pilot’s decision to take off into deteriorating weather conditions, which resulted in a loss of visual reference and the subsequent controlled flight into terrain. Contributing to the severity of the rear seat passenger’s injuries was the incorrect…
- [NTSB ERA13LA126](https://openairdocs.org/ntsb/ERA13LA126.md): Mccowan Steve A Shttd · Montrose, GA · Accident · No injuries · Limited investigation · Final report · Feb 4, 2013 · N4201S · Substantial damage
  > A total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.
- [NTSB ERA13WA128](https://openairdocs.org/ntsb/ERA13WA128.md): Beech C90 · Candido Mota, Brazil · Accident · 5 fatal · Foreign investigation · Feb 3, 2013 · PP-AVJ · Destroyed
  > On February 3, 2013, about 2230 coordinated universal time, a Beech C90A, Brazilian registration PP-AVG, was destroyed when it impacted terrain near Cândido Mota, Brazil. The pilot and four passengers were fatally injured. The flight originated from Regional…
- [NTSB WPR13LA113](https://openairdocs.org/ntsb/WPR13LA113.md): Cessna 172 · Wilcox, AZ · Accident · No injuries · Limited investigation · Final report · Feb 2, 2013 · N1421V · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.
- [NTSB WPR13LA108](https://openairdocs.org/ntsb/WPR13LA108.md): Cessna 175B · Wellsville, UT · Accident · No injuries · Limited investigation · Final report · Feb 2, 2013 · N8125T · Substantial damage
  > A loss of engine power during cruise flight due to carburetor ice.
- [NTSB ERA13RA125](https://openairdocs.org/ntsb/ERA13RA125.md): Robinson R44 · Asuncion, Paraguay · Accident · 3 fatal · Foreign investigation · Feb 2, 2013 · ZP-HAH · Destroyed
  > On February 2, 2013, about 2115 local time (February 3, 2013, 0015 coordinated universal time), a Robinson R44, Paraguayan registration ZP-HAH, operated by Helitactica S.A., was destroyed when it impacted sparsely populated terrain about 27 nautical miles…
- [NTSB CEN13LA149](https://openairdocs.org/ntsb/CEN13LA149.md): Cirrus Design SR22 · College Station, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 2013 · N247RB · 2 aircraft · Substantial damage
  > The flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…
- [NTSB CEN13CA145](https://openairdocs.org/ntsb/CEN13CA145.md): Hughes 369HS · London, OH · Accident · No injuries · Data collection · Final report · Jan 29, 2013 · N193M · Substantial damage
  > The pilot's failure to comply with established cold weather operating procedures, which resulted in a total loss of engine power. Contributing to the accident was the pilot's excessive aft cyclic input during the landing flare, which resulted in main rotor…
- [NTSB ERA13LA121](https://openairdocs.org/ntsb/ERA13LA121.md): Piper PA-32-260 · Yonkers, NY · Accident · No injuries · Limited investigation · Final report · Jan 27, 2013 · N1967E · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.
- [NTSB WPR13LA101](https://openairdocs.org/ntsb/WPR13LA101.md): Cessna 150L · Matlock, WA · Accident · No injuries · Limited investigation · Final report · Jan 24, 2013 · N18690 · Substantial damage
  > A partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.
- [NTSB DCA13WA042](https://openairdocs.org/ntsb/DCA13WA042.md): Boeing 737 · Genoa, Italy · Incident · Minor injuries · Foreign investigation · Jan 23, 2013 · EI-DCX · No damage
  > On 23 January 2013, at about 0947 UTC time, a Boeing 737-800, registration EI-DCX, operated by RyanAir, declared an emergency and diverted into Genoa, Italy, after experiencing a pressurization problem on both systems. Two passengers sustained minor injuries…
- [NTSB CEN13FA137](https://openairdocs.org/ntsb/CEN13FA137.md): Beech 95-B55 (T42A) · Mangum, OK · Accident · 3 fatal · Field investigation · Final report · Jan 19, 2013 · N143E · Substantial damage
  > The airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.
- [NTSB WPR13CA103](https://openairdocs.org/ntsb/WPR13CA103.md): Cessna 150J · Porterville, CA · Accident · No injuries · Data collection · Final report · Jan 18, 2013 · N50690 · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA13IA114](https://openairdocs.org/ntsb/ERA13IA114.md): Cessna 560XL · Debary, FL · Incident · No injuries · Incident investigation · Final report · Jan 13, 2013 · N662QS · No damage
  > An accumulation of debris in the airplane’s bilge drain holes that prevented accumulated moisture from properly draining; the accumulated moisture subsequently froze around the elevator control components, which resulted in the flight control stiffness.…
- [NTSB CEN13FA131](https://openairdocs.org/ntsb/CEN13FA131.md): Piper PA46-500TP · Paris, TX · Accident · 3 fatal · Field investigation · Final report · Jan 12, 2013 · N5339V · Destroyed
  > The pilot's encounter with convective weather, which resulted in a loss of airplane control.
- [NTSB WPR13CA092](https://openairdocs.org/ntsb/WPR13CA092.md): Heinz Rans S-4 Coyote · Lake Pleasant, AZ · Accident · No injuries · Data collection · Final report · Jan 11, 2013 · N571K · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.
- [NTSB ERA13LA112](https://openairdocs.org/ntsb/ERA13LA112.md): Cessna T182 · Brandon, FL · Accident · No injuries · Limited investigation · Final report · Jan 11, 2013 · N9454H · Substantial damage
  > Failure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.
- [NTSB CEN13FA130](https://openairdocs.org/ntsb/CEN13FA130.md): Raytheon 58 · Maxwell, NE · Accident · 4 fatal · Field investigation · Final report · Jan 11, 2013 · N36VE · Destroyed
  > The pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.
- [NTSB CEN13CA134](https://openairdocs.org/ntsb/CEN13CA134.md): Mooney M20C · Moriarty, NM · Accident · No injuries · Data collection · Final report · Jan 10, 2013 · N6242U · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power during cruise flight due to fuel starvation.
- [NTSB WPR13FA086](https://openairdocs.org/ntsb/WPR13FA086.md): Beech V35A · Woody, CA · Accident · 2 fatal · Field investigation · Final report · Jan 7, 2013 · N35SD · Destroyed
  > An in-flight encounter with icing conditions during descent, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall followed by an in-flight breakup.
- [NTSB ERA13RA106](https://openairdocs.org/ntsb/ERA13RA106.md): Boeing-Vertol 234 · Pucallpa, Peru, Peru · Accident · 7 fatal · Class 5 · Foreign · Jan 7, 2013 · N241CH · Destroyed
  > On January 7, 2013, about 2002 universal coordinated time (1502 local time), a Boeing-Vertol 234, N241CH, operated by Columbia Helicopters Peru, S.A.C., was destroyed during an inflight breakup and subsequent impact with terrain near Pucallpa, Peru. The U.S.…
- [NTSB ERA13CA107](https://openairdocs.org/ntsb/ERA13CA107.md): Brewer James M KR2 · Bear Branch, KY · Accident · No injuries · Data collection · Final report · Jan 7, 2013 · N216CB · Substantial damage
  > The pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.
- [NTSB CEN13LA132](https://openairdocs.org/ntsb/CEN13LA132.md): Bellanca 17-30A · Antlers, OK · Accident · No injuries · Limited investigation · Final report · Jan 7, 2013 · N222EG · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR13LA085](https://openairdocs.org/ntsb/WPR13LA085.md): Jeremiah Jackson Vans RV-10 · Julian, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 2013 · N262NJ · Substantial damage
  > A loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.
- [NTSB ERA13WA282](https://openairdocs.org/ntsb/ERA13WA282.md): Robinson R66 · Caraguatatuba, Brazil · Accident · 2 fatal · Foreign investigation · Jan 3, 2013 · PR-DUB · Destroyed
  > On January 3, 2013, about 1600 coordinated universal time (UTC), a Robinson R-66 Helicopter, Brazilian registration PR-DUB, was destroyed when it impacted a dense forest and the side of a hill in the Caraguatatuba Municipality, in the State of São Paulo,…
- [NTSB CEN13FA122](https://openairdocs.org/ntsb/CEN13FA122.md): Bell Helicopter 407 · Clear Lake, IA · Accident · 3 fatal · Field investigation · Final report · Jan 3, 2013 · N445MT · Destroyed
  > The pilot’s inadvertent encounter with localized icing conditions and his subsequent in-flight loss of helicopter control.
- [NTSB CEN13FA121](https://openairdocs.org/ntsb/CEN13FA121.md): Eurocopter EC130 B4 · Seminole, OK · Accident · Serious injuries · Field investigation · Final report · Jan 2, 2013 · N334AM · Substantial damage
  > The loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…
- [NTSB WPR13FA076](https://openairdocs.org/ntsb/WPR13FA076.md): Mckenzie Lancair IV-P Turbine · Lakeside, CA · Accident · 3 fatal · Field investigation · Final report · Dec 29, 2012 · N5M · Substantial damage
  > The pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.
- [NTSB CEN13LA119](https://openairdocs.org/ntsb/CEN13LA119.md): Bell 407 · Big Lake, TX · Accident · No injuries · Limited investigation · Final report · Dec 29, 2012 · N534MT · Substantial damage
  > The loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.
- [NTSB ERA13FA096](https://openairdocs.org/ntsb/ERA13FA096.md): Piper PA-31-350 · Leesburg, FL · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2012 · N78WM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…
- [NTSB ERA13LA097](https://openairdocs.org/ntsb/ERA13LA097.md): Piper PA-28R-200 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2012 · N2074T · Substantial damage
  > The reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…
- [NTSB CEN13LA110](https://openairdocs.org/ntsb/CEN13LA110.md): Beech 95-B55 (T42A) · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2012 · N30WC · Substantial damage
  > The pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.
- [NTSB WPR13FA072](https://openairdocs.org/ntsb/WPR13FA072.md): Piper PA-31-350 · Payson, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2012 · N62959 · Substantial damage
  > The airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…
- [NTSB ERA13LA094](https://openairdocs.org/ntsb/ERA13LA094.md): Wragg George Skybolt · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 2012 · N328GW · Substantial damage
  > The pilot's inadequate preflight planning and failure to monitor the fuel quantity during flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN13LA111](https://openairdocs.org/ntsb/CEN13LA111.md): Piper L-18C · Graham, TX · Accident · No injuries · Limited investigation · Final report · Dec 19, 2012 · N3134G · Substantial damage
  > The failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.
- [NTSB WPR13FA312](https://openairdocs.org/ntsb/WPR13FA312.md): Mooney M20F · Yosemite Valley, CA · Accident · 1 fatal · Field investigation · Final report · Dec 17, 2012 · N9524M · Substantial damage
  > The pilot’s decision to continue flight into instrument meteorological conditions, which resulted in his failure to maintain situational awareness and sufficient altitude to clear mountainous terrain.
- [NTSB WPR13FA070](https://openairdocs.org/ntsb/WPR13FA070.md): Piper PA-31T1 · Ely, NV · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N93CN · Destroyed
  > The pilot’s failure to regain airplane control following a sudden rapid descent during cruise flight, which resulted in an exceedance of the design stress limits of the aircraft and led to an in-flight structural failure.
- [NTSB CEN13FA105](https://openairdocs.org/ntsb/CEN13FA105.md): Beech E-90 · Amarillo, TX · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N67PS · Substantial damage
  > The pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.
- [NTSB ANC13FA017](https://openairdocs.org/ntsb/ANC13FA017.md): Eurocopter AS350 B3 · Beluga, AK · Accident · Serious injuries · Field investigation · Final report · Dec 15, 2012 · C-GYPH · Substantial damage
  > The pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…
- [NTSB ERA13WA089](https://openairdocs.org/ntsb/ERA13WA089.md): Piper PA34 · Zulia, Colombia · Accident · 4 fatal · Foreign investigation · Dec 12, 2012 · HK4477G · Destroyed
  > On December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…
- [NTSB ERA13FA083](https://openairdocs.org/ntsb/ERA13FA083.md): Diamond Aircraft Ind DA 40 · Lake Park, GA · Accident · 1 fatal · Field investigation · Final report · Dec 11, 2012 · N840DS · Substantial damage
  > The noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.
- [NTSB CEN13LA103](https://openairdocs.org/ntsb/CEN13LA103.md): Auman JL T-51 · Dekalb, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 2012 · N512JA · Substantial damage
  > The improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.
- [NTSB CEN13FA096](https://openairdocs.org/ntsb/CEN13FA096.md): MBB BK 117 A-3 · Compton, IL · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2012 · N911BK · Substantial damage
  > The inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.
- [NTSB DCA13RA025](https://openairdocs.org/ntsb/DCA13RA025.md): Learjet 25 · Monterrey, Mexico · Accident · 7 fatal · Foreign investigation · Dec 9, 2012 · N345MC · Destroyed
- [NTSB CEN13WA092](https://openairdocs.org/ntsb/CEN13WA092.md): Piper PA-32-301 · Melbach, Germany · Accident · 8 fatal · Foreign investigation · Dec 8, 2012 · D-EUEU · 2 aircraft · Substantial damage
  > On December 8, 2012, about 1513 coordinated universal time, a Piper PA-32, German registration, D-EUEU, and a Robin Regent DR400, German registration D-EHJP, collided while on cross country flights near Melbach, Germany. Visual meteorological conditions…
- [NTSB WPR13CA064](https://openairdocs.org/ntsb/WPR13CA064.md): Robinson Helicopter R44 II · Roosevelt Lake, AZ · Accident · Serious injuries · Data collection · Final report · Dec 7, 2012 · N557AC · Substantial damage
  > The pilot's visual disorientation, which resulted in a collision with the lake.
- [NTSB CEN13LA104](https://openairdocs.org/ntsb/CEN13LA104.md): Cessna 172M · Arcola, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2012 · N172BJ · Substantial damage
  > The loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA095](https://openairdocs.org/ntsb/CEN13LA095.md): Mooney M20E · Gurdon, AR · Accident · No injuries · Limited investigation · Final report · Dec 5, 2012 · N9493V · Substantial damage
  > The total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.
- [NTSB CEN13LA091](https://openairdocs.org/ntsb/CEN13LA091.md): Stinson 108-2 · Halfway, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2012 · N8775K · Substantial damage
  > The pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.
- [NTSB DCA13WA160](https://openairdocs.org/ntsb/DCA13WA160.md): Boeing Boeing 777-236 · Shannon, Ireland · Incident · No injuries · Foreign investigation · Dec 2, 2012 · G-VIIK · Minor damage
  > The Air Accident Investigations Unit of Ireland has notified the NTSB of an incident involving a Boeing 777 that occurred on December 02, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-I investigation under the provisions of…

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

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

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