# 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 55 of 718 · 35,883 cases

## Cases, newest first

- [NTSB GAA18CA330](https://openairdocs.org/ntsb/GAA18CA330.md): Sorensen Danny S BF9 2 · Evanston, WY · Accident · No injuries · Data collection · Final report · May 31, 2018 · N81973 · Substantial damage
  > The pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustion
- [NTSB WPR18LA156](https://openairdocs.org/ntsb/WPR18LA156.md): Beech A36 · Tonopah, NV · Accident · Minor injuries · Limited investigation · Final report · May 30, 2018 · N191HL · Substantial damage
  > The pilot's failure to properly lean the fuel/air mixture and to monitor critical engine parameters during the en route climb to cruise level, which resulted in excessive engine heat and oil starvation and the subsequent catastrophic engine failure.
- [NTSB GAA18CA312](https://openairdocs.org/ntsb/GAA18CA312.md): Piper PA 46 · Prescott, AZ · Accident · No injuries · Data collection · Final report · May 30, 2018 · N148ME · Substantial damage
  > The pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB CEN18LA200](https://openairdocs.org/ntsb/CEN18LA200.md): Irlbeck Thomas H RV 8 · Somerset, WI · Accident · No injuries · Class 3 · Limited · Final report · May 29, 2018 · N214FF · Substantial damage
  > A total loss of engine power due to damaged and disconnected electronic ignition wires from both the main and backup batteries, which resulted in a forced landing.
- [NTSB WPR18LA151](https://openairdocs.org/ntsb/WPR18LA151.md): Cessna 150M · Bainbridge Island, WA · Accident · 1 fatal · Limited investigation · Final report · May 28, 2018 · N6AF · Substantial damage
  > The pilot's failure to maintain clearance from the water and his distraction by using the tablet for navigation, which resulted in his failure to detect that the airplane had entered a descent.
- [NTSB ERA18WA156](https://openairdocs.org/ntsb/ERA18WA156.md): Cessna 152 · Tulua, Colombia · Incident · No injuries · Foreign investigation · May 28, 2018 · HK2367G · Minor damage
  > The government of Colombia has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions of…
- [NTSB CEN18LA199](https://openairdocs.org/ntsb/CEN18LA199.md): Aeronca 58B · Tekamah, NE · Accident · Serious injuries · Limited investigation · Final report · May 28, 2018 · N47252 · Substantial damage
  > The partial loss of engine power due to the formation of carburetor ice. Contributing to the accident was the pilot's failure to use carburetor heat and his decision to continue flight with reduced engine power rather than landing the airplane on suitable…
- [NTSB WPR18LA149](https://openairdocs.org/ntsb/WPR18LA149.md): Cessna 182 · Aberdeen, ID · Accident · No injuries · Class 3 · Limited · Final report · May 27, 2018 · N5700B · Substantial damage
  > The pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and nose-over.
- [NTSB GAA18CA325](https://openairdocs.org/ntsb/GAA18CA325.md): Cosentino Garey A Pegasus · Kingston, OK · Accident · Minor injuries · Data collection · Final report · May 27, 2018 · N339PG · Substantial damage
  > The pilot’s failure to maintain altitude and the powered parachute’s subsequent impact with trees.
- [NTSB GAA18CA307](https://openairdocs.org/ntsb/GAA18CA307.md): Piper PA28 · Butler, KY · Accident · No injuries · Data collection · Final report · May 27, 2018 · N95410 · Substantial damage
  > The pilot’s improper fuel management, which resulted in fuel starvation.
- [NTSB ERA18LA155](https://openairdocs.org/ntsb/ERA18LA155.md): Devries WM H Kitfox Sport · Taghkanic, NY · Accident · No injuries · Class 3 · Limited · Final report · May 26, 2018 · N47DV · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18FA192](https://openairdocs.org/ntsb/CEN18FA192.md): Beech D17S · Santa Fe, NM · Accident · 1 fatal · Field investigation · Final report · May 25, 2018 · N79091 · Substantial damage
  > The pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.
- [NTSB WPR18LA145](https://openairdocs.org/ntsb/WPR18LA145.md): Sportavia Putzer RF5B Sperber · Lookout Pass, MT · Accident · Minor injuries · Limited investigation · Final report · May 22, 2018 · N66GL · Substantial damage
  > The pilot’s improper decision to continue flight toward rising terrain after the engine overheated, which necessitated a precautionary landing when the motorglider could not maintain altitude in downdrafts.
- [NTSB ERA18FA150](https://openairdocs.org/ntsb/ERA18FA150.md): Piper PA28 · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · May 22, 2018 · N6177W · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.
- [NTSB CEN18LA189](https://openairdocs.org/ntsb/CEN18LA189.md): M-Squared Sprint 1000 · Gurdon, AR · Accident · Serious injuries · Class 3 · Limited · Final report · May 22, 2018 · N138ZX · Substantial damage
  > Inadequate engine maintenance, which resulted in the failure of the MAG piston ring and the subsequent total loss of engine power due to a piston seizure.
- [NTSB ERA18FA148](https://openairdocs.org/ntsb/ERA18FA148.md): Piper PA34 · Bennington, VT · Accident · 1 fatal · Field investigation · Final report · May 20, 2018 · N1101X · Destroyed
  > The pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.
- [NTSB CEN18LA181](https://openairdocs.org/ntsb/CEN18LA181.md): Vans RV7A · Hanover Park, IL · Accident · Minor injuries · Class 3 · Limited · Final report · May 19, 2018 · N667AZ · Substantial damage
  > A partial loss of engine power shortly after takeoff due to water contamination of the fuel system.
- [NTSB ERA18WA151](https://openairdocs.org/ntsb/ERA18WA151.md): Cessna 210 · Itacoatiara, Brazil · Accident · 2 fatal · Foreign investigation · May 16, 2018 · PR-RCJ · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a CESSNA 210 airplane that occurred on May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB ENG18WA027](https://openairdocs.org/ntsb/ENG18WA027.md): Bombardier CL600 2B19 · Geuteng, South Africa, South Africa · Incident · No injuries · Foreign investigation · May 16, 2018 · ZS-NMI · No damage
  > The Government of South Africa has notified the NTSB of an incident involving a Bombardier CL-600-2B19 that occurred May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the South African Civil Aviation Authority (CAA) investigation…
- [NTSB CEN18LA174](https://openairdocs.org/ntsb/CEN18LA174.md): Cessna 177 · Fort Wayne, IN · Accident · No injuries · Limited investigation · Final report · May 15, 2018 · N9058F · Substantial damage
  > The failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.
- [NTSB WPR18FA141](https://openairdocs.org/ntsb/WPR18FA141.md): Cessna 182G · Cascade, ID · Accident · 1 fatal · Field investigation · Final report · May 13, 2018 · N2377R · Destroyed
  > The non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.
- [NTSB GAA18CA283](https://openairdocs.org/ntsb/GAA18CA283.md): Schweizer SGS123 · Tunbridge, VT · Accident · No injuries · Data collection · Final report · May 13, 2018 · N9915J · Substantial damage
  > The student glider’s inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.
- [NTSB ERA18FA146](https://openairdocs.org/ntsb/ERA18FA146.md): Beech 35A33 · Jacksonville, AL · Accident · 1 fatal · Field investigation · Final report · May 13, 2018 · N486T · Destroyed
  > The pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…
- [NTSB CEN18WA191](https://openairdocs.org/ntsb/CEN18WA191.md): Mooney M20K · Tarragona, Portugal · Accident · 3 fatal · Foreign investigation · May 12, 2018 · D-EFTF · Destroyed
  > On May 12, 2018, about 1340 coordinated universal time, a Mooney M20K airplane, D-EFTF, impacted terrain near Tarragone, Portugal, after reporting an engine issue to air traffic control. The pilot and two passengers were fatally injured. The airplane was…
- [NTSB ANC18FA036](https://openairdocs.org/ntsb/ANC18FA036.md): Piper PA-28-180 · Whittier, AK · Accident · 1 fatal · Class 2 · Field · Final report · May 12, 2018 · N7061W · Substantial damage
  > The student pilot's decision to depart and continue on a solo cross-country flight through mountainous terrain in marginal visual flight rules conditions, which resulted in controlled flight into terrain.
- [NTSB WPR18LA142](https://openairdocs.org/ntsb/WPR18LA142.md): Kolb Firestar · Atmore, AL · Accident · Serious injuries · Limited investigation · Final report · May 11, 2018 · N9216E · Substantial damage
  > The noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.
- [NTSB ERA18WA153](https://openairdocs.org/ntsb/ERA18WA153.md): Bell Helicopter 206 · Barra da Tijuca, Brazil · Accident · 1 fatal · Class 5 · Foreign · May 9, 2018 · PT-HKY · Substantial damage
- [NTSB GAA18CA264](https://openairdocs.org/ntsb/GAA18CA264.md): Piper PA28 · Addison, TX · Accident · No injuries · Data collection · Final report · May 8, 2018 · N642RJ · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA18WA177](https://openairdocs.org/ntsb/DCA18WA177.md): Boeing 767 · Guayaquil · Incident · No injuries · Foreign investigation · May 8, 2018 · N342AN · Minor damage
  > The Civil Aviation Authority of Ecuador has notified the NTSB of an incident involving a Boeing 767-300, which occurred on May 8, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All investigative…
- [NTSB ERA18TA142](https://openairdocs.org/ntsb/ERA18TA142.md): Barry Maggio Apollo AG-1 · Smith Beach, VA · Accident · Minor injuries · Final report · May 6, 2018 · N141C · Substantial damage
  > The noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.
- [NTSB ANC18LA034](https://openairdocs.org/ntsb/ANC18LA034.md): Grumman TBM-3 · Fort Apache, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · May 6, 2018 · N337VT · Destroyed
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA18CA273](https://openairdocs.org/ntsb/GAA18CA273.md): Christopher Lord ELA Eclipse 10 · Calhoun, GA · Accident · Minor injuries · Data collection · Final report · May 5, 2018 · N533EA · Substantial damage
  > The student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.
- [NTSB DCA18WA174](https://openairdocs.org/ntsb/DCA18WA174.md): Boeing 737 · Arequipa, Peru · Incident · No injuries · Foreign investigation · May 5, 2018 · OB-2079-P · No damage
  > The government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…
- [NTSB CEN18LA159](https://openairdocs.org/ntsb/CEN18LA159.md): Beech A36 · Shullsburg, WI · Accident · No injuries · Limited investigation · Final report · May 5, 2018 · N36LP · Substantial damage
  > A catastrophic engine failure due to improper torque on the engine through-bolt nuts, which resulted in relative movement between the crankcase halves, damage to a main journal bearing, and a loss of oil lubrication.
- [NTSB WPR18LA135](https://openairdocs.org/ntsb/WPR18LA135.md): Cessna 152 · Tamiami, FL · Accident · Serious injuries · Class 3 · Limited · Final report · May 4, 2018 · N6198Q · Substantial damage
  > The non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…
- [NTSB ERA18WA166](https://openairdocs.org/ntsb/ERA18WA166.md): PZL Swidnik SW4 · Curitibanos, Brazil · Accident · No injuries · Foreign investigation · May 4, 2018 · PP-MHJ · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a PZL Swidnik, SW4, helicopter that occurred on May 4, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB DCA18WA180](https://openairdocs.org/ntsb/DCA18WA180.md): Boeing 737 · Port Elizabeth, South Africa · Incident · No injuries · Foreign investigation · May 4, 2018 · ZS-VDP · No damage
  > The Civil Aviation Authority (CAA) of South Africa has informed the NTSB of an incident involving a Boeing 737-300, which occurred on May 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist the CAA investigation under the provisions of…
- [NTSB WPR18FA131](https://openairdocs.org/ntsb/WPR18FA131.md): American Air Racing Thunder Mustang · Reno, NV · Accident · 1 fatal · Field investigation · Final report · May 2, 2018 · N352BT · Substantial damage
  > The pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…
- [NTSB GAA18CA347](https://openairdocs.org/ntsb/GAA18CA347.md): Piper PA28 · Pine Spring, TX · Accident · No injuries · Data collection · Final report · May 2, 2018 · N9494J · Substantial damage
  > The pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.
- [NTSB ERA18WA139](https://openairdocs.org/ntsb/ERA18WA139.md): Agusta Bell AB206B · Cacao, French Guiana · Accident · 2 fatal · Foreign investigation · May 2, 2018 · F-HGJL · Substantial damage
  > The government of France has notified the NTSB of an accident involving a Agusta Bell AB206B helicopter that occurred on May 2, 2018 near Cacao, French Guiana. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…
- [NTSB ERA18LA140](https://openairdocs.org/ntsb/ERA18LA140.md): Robinson R22 · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · May 2, 2018 · N923SM · Substantial damage
  > The pilot's failure to properly remove and secure the tie-down ropes during the preflight inspection, which resulted in the ropes becoming entangled in the rotor head swashplate and pitch control rods during flight and the subsequent loss of pitch control.
- [NTSB DCA18WA171](https://openairdocs.org/ntsb/DCA18WA171.md): Boeing 737 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · May 2, 2018 · HS-KMA · No damage
  > The Air Accident Investigation Committee of Thailand has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on May 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's…
- [NTSB CEN18WA253](https://openairdocs.org/ntsb/CEN18WA253.md): Beech 400 · Geneva, Switzerland · Incident · No injuries · Foreign investigation · May 2, 2018 · G-FXAR
  > On May 2, 2018, about 1035 Universal Coordinated Time, a Beech 400, United Kingdom registration G-FXAR, experienced a cabin depressurization event and landed without further incident at the Geneva International Airport (LSGG), Geneva, Switzerland. There were…
- [NTSB CEN18LA156](https://openairdocs.org/ntsb/CEN18LA156.md): Laminar Lancair 360 · Woodward, OK · Accident · No injuries · Limited investigation · Final report · May 2, 2018 · N92WL · Substantial damage
  > The pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…
- [NTSB ERA18FA137](https://openairdocs.org/ntsb/ERA18FA137.md): Piper PA28R · Gainesville, GA · Accident · 1 fatal · Field investigation · Final report · Apr 28, 2018 · N4363F · Substantial damage
  > A partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…
- [NTSB CEN18WA401](https://openairdocs.org/ntsb/CEN18WA401.md): Beech 58 · Hautes-Alpes, France · Accident · No injuries · Foreign investigation · Apr 28, 2018 · HB-GGP · Substantial damage
  > On April 28, 2018, about 0720 UTC, a Beechcraft BE-58P, Swiss registry HB-GGP, operated by a private individual, experienced an uncontained engine failure while in cruise flight near the Hautes-Alpes, France. The pilot, the sole person on board was not…
- [NTSB CEN18LA150](https://openairdocs.org/ntsb/CEN18LA150.md): Wolfe Kitfox V · Kalkaska, MI · Accident · 2 fatal · Limited investigation · Final report · Apr 27, 2018 · N818TW · Destroyed
  > The pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.
- [NTSB CEN18FA149](https://openairdocs.org/ntsb/CEN18FA149.md): Eurocopter AS 350 B2 · Hazelhurst, WI · Accident · 3 fatal · Field investigation · Final report · Apr 27, 2018 · N127LN · Destroyed
  > The pilot's loss of helicopter control as a result of fatigue during cruise flight at night.
- [NTSB CEN18LA151](https://openairdocs.org/ntsb/CEN18LA151.md): Cessna 152 · Cullman, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 2018 · N89904 · Substantial damage
  > The pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.
- [NTSB CEN18LA146](https://openairdocs.org/ntsb/CEN18LA146.md): Cessna T303 · Pine Ridge, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2018 · N9746C · Substantial damage
  > The airplane’s inadvertent encounter with severe icing conditions during descent, which resulted in structural icing, the pilot’s inability to maintain altitude, and an emergency landing. Contributing to the accident was an incomplete preflight weather…

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

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

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