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

## Cases, newest first

- [NTSB ERA15FA141](https://openairdocs.org/ntsb/ERA15FA141.md): Colyaer SL Freedom · Boynton Beach, FL · Accident · 2 fatal · Field investigation · Final report · Mar 2, 2015 · N787Z · Destroyed
  > An in-flight loss of control for reasons that could not be determined based on the available evidence.
- [NTSB WPR15LA137](https://openairdocs.org/ntsb/WPR15LA137.md): Piper PA 46-310P · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Mar 1, 2015 · N9133G · Substantial damage
  > A loss of engine power during cruise flight 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 ERA15LA142](https://openairdocs.org/ntsb/ERA15LA142.md): Piper PA28 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Feb 27, 2015 · N2122K · Substantial damage
  > The total loss of engine power due to carburetor ice.
- [NTSB CEN15LA157](https://openairdocs.org/ntsb/CEN15LA157.md): Piper PA 28R-200 · Frankenmuth, MI · Accident · No injuries · Limited investigation · Final report · Feb 27, 2015 · N2837R · Substantial damage
  > The failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.
- [NTSB CEN15CA155](https://openairdocs.org/ntsb/CEN15CA155.md): Gaddis Michael Exec 162 F · Plymouth, IN · Accident · No injuries · Data collection · Final report · Feb 26, 2015 · N123XZ · Substantial damage
  > The failure of the helicopter's main drive belt resulting in the pilot performing a forced landing, during which the helicopter's fuselage was substantially damage.
- [NTSB DCA15WA080](https://openairdocs.org/ntsb/DCA15WA080.md): Boeing 737 - 8AS · Bordeaux, France · Accident · Serious injuries · Foreign investigation · Feb 25, 2015 · EI-DAC · No damage
  > The Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist…
- [NTSB CEN15LA156](https://openairdocs.org/ntsb/CEN15LA156.md): Agusta Aerospace AW119 Mkii · Gulf of Mexico · Accident · No injuries · Limited investigation · Final report · Feb 20, 2015 · N802SM · Substantial damage
  > The fracture of the tail rotor pitch change link due to excessive bearing rotational friction, which resulted from the bearings being installed in exceedance of the maximum allowable torque during the last overhaul of the pitch change link.
- [NTSB ERA15WA137](https://openairdocs.org/ntsb/ERA15WA137.md): Cessna 182P · Bueno Brandao, Brazil · Accident · 4 fatal · Foreign investigation · Feb 19, 2015 · PT-KBV · Destroyed
  > On February 19, 2015, about 1340 Universal Coordinated Time (UTC), a Cessna 182P, Brazilian registration PT-KBV, was destroyed when it broke up inflight and impacted terrain near the Bueno Brandao Municipality, in the State of Minas Gerais, Brazil. The pilot,…
- [NTSB DCA15LA067](https://openairdocs.org/ntsb/DCA15LA067.md): Boeing 767 · Honolulu (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Feb 15, 2015 · N59053 · No damage
  > an encounter with convective turbulence associated with a forecasted area of thunderstorms.
- [NTSB WPR15LA103](https://openairdocs.org/ntsb/WPR15LA103.md): Cessna 150M · Layton, UT · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 2015 · N827CH · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.
- [NTSB CEN15LA146](https://openairdocs.org/ntsb/CEN15LA146.md): Piper PA 28R-180 · Haviland, KS · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2015 · N3918T · Substantial damage
  > The loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…
- [NTSB ENG15RA011](https://openairdocs.org/ntsb/ENG15RA011.md): Bell 206 - L4 · Remote Location, South Africa · Incident · No injuries · Foreign investigation · Feb 12, 2015 · ZS-RMB
  > On February 12, 2015, a Bell 206L-4 powered by a Rolls-Royce 250-C30P turboshaft engine experienced an uncontained engine failure followed by a successful force landing. This incident is being investigated by the South Africa Civil Aviation Authority (CAA)…
- [NTSB WPR15LA101](https://openairdocs.org/ntsb/WPR15LA101.md): Vans RV7 - Undesignat · Belfair, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 2015 · N513BW · Substantial damage
  > A total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.
- [NTSB WPR15CA110](https://openairdocs.org/ntsb/WPR15CA110.md): Raytheon B300 · Mammoth Lakes, CA · Accident · No injuries · Data collection · Final report · Feb 10, 2015 · N49WC · Substantial damage
  > The airplane encountered extreme turbulence during descent.
- [NTSB ANC15LA011](https://openairdocs.org/ntsb/ANC15LA011.md): Cessna 180 · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Feb 9, 2015 · N9280C · Substantial damage
  > An in-flight fire and a partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN15LA132](https://openairdocs.org/ntsb/CEN15LA132.md): Butler Raymond Rotorway Exec 162F · Seadrift, TX · Accident · No injuries · Limited investigation · Final report · Jan 31, 2015 · N162RB · Substantial damage
  > A fault in the No. 1 engine control module, which disabled the ignition system and resulted in the engine losing power; during the subsequent autorotation, the main rotor rpm was further reduced just before touchdown, which resulted in a hard landing.
- [NTSB ANC15FA009](https://openairdocs.org/ntsb/ANC15FA009.md): Piper PA 18 · Wasilla, AK · Accident · Serious injuries · Field investigation · Final report · Jan 31, 2015 · N82735 · 2 aircraft · Substantial damage
  > Both pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.
- [NTSB WPR15CA095](https://openairdocs.org/ntsb/WPR15CA095.md): Piper PA 12 · Ridgefield, WA · Accident · No injuries · Data collection · Final report · Jan 29, 2015 · N918TF · Substantial damage
  > The pilot's delayed action to use carburetor heat before the engine experienced a total loss of power while operating at cruise flight in conditions conducive to carburetor icing.
- [NTSB CEN15CA130](https://openairdocs.org/ntsb/CEN15CA130.md): Cessna 310B · Rothville, MO · Accident · No injuries · Data collection · Final report · Jan 28, 2015 · N131X · Substantial damage
  > The pilot's inadequate preflight planning and fuel management which resulted in fuel exhaustion.
- [NTSB WPR15LA089](https://openairdocs.org/ntsb/WPR15LA089.md): Cirrus SR22 - NO Series · Maui (Pacific Ocean) · Accident · No injuries · Limited investigation · Final report · Jan 26, 2015 · N7YT · Substantial damage
  > The pilot's inability to transfer fuel from the aft auxiliary fuel tank to the main fuel tanks for reasons that could not be determined because the airplane was ditched and not recovered.
- [NTSB WPR15CA091](https://openairdocs.org/ntsb/WPR15CA091.md): Cessna 172N · Makaha, HI · Accident · Minor injuries · Data collection · Final report · Jan 26, 2015 · N422BP · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because the airplane was ditched and not recovered.
- [NTSB CEN15WA124](https://openairdocs.org/ntsb/CEN15WA124.md): Piper PA-30 · Rockenhausen, Germany · Accident · 1 fatal · Foreign investigation · Jan 26, 2015 · D-GHFW · Substantial damage
  > On January 26, 2015, about 1032 coordinated universal time, a Piper PA-30 airplane, D-GHFW, crashed under unknown circumstances near Rockenhausen, Germany. The airplane was substantially damaged, and the pilot fatally injured. The airplane departed Annemasse…
- [NTSB CEN15FA119](https://openairdocs.org/ntsb/CEN15FA119.md): Cessna 182L · Owen, WI · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2015 · N3181R · Substantial damage
  > The flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…
- [NTSB CEN15CA125](https://openairdocs.org/ntsb/CEN15CA125.md): Cessna 182C · Fort Morgan, CO · Accident · Minor injuries · Data collection · Final report · Jan 26, 2015 · N8997T · Substantial damage
  > The pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.
- [NTSB WPR15LA090](https://openairdocs.org/ntsb/WPR15LA090.md): Cessna 150E · Silver Springs, NV · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2015 · N4017U · Substantial damage
  > The loss of engine power for reasons that could not be determined during a postaccident examination of the airplane.
- [NTSB ENG15RA012](https://openairdocs.org/ntsb/ENG15RA012.md): Robinson R44 - II · Waikaia, New Zealand · Accident · No injuries · Foreign investigation · Jan 23, 2015 · ZK-HPC · Substantial damage
  > On January 23, 2015, a Robinson R44 II experienced a severe in-flight vibration, after which the pilot successfully landed the helicopter. A subsequent inspection found a crack on one of the main rotor blades. This incident is being investigated by the New…
- [NTSB ENG15RA006](https://openairdocs.org/ntsb/ENG15RA006.md): Boeing 787-8 · Budapest, Hungary · Incident · No injuries · Foreign investigation · Jan 22, 2015 · VT-ANL · No damage
  > On January 22, 2015, about 1700 local (1600 UTC), an Air India Boeing 787-8, VT-ANL, experienced a failure of the right engine, a General Electric GEnx-1B, while in cruise flight and diverted to Budapest, Hungary. The airplane was enroute from London Heathrow…
- [NTSB WPR15FA088](https://openairdocs.org/ntsb/WPR15FA088.md): Beech 36 · Mountain Pass, CA · Accident · 2 fatal · Field investigation · Final report · Jan 21, 2015 · N999CJ · Destroyed
  > An in-flight loss of control for reasons that could not be determined based on available information.
- [NTSB CEN15LA117](https://openairdocs.org/ntsb/CEN15LA117.md): Piper PA-31-350 · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Jan 21, 2015 · N66906 · Substantial damage
  > The pilot's improper fuel management and failure to conduct the engine failure emergency procedures and his improper conduct of the forced landing, which resulted in fuel starvation, a total loss of engine power, and the subsequent high-energy impact with…
- [NTSB WPR15LA086](https://openairdocs.org/ntsb/WPR15LA086.md): Cessna 172N · Ualapue, HI · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2015 · N5660E · 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 WPR15LA085](https://openairdocs.org/ntsb/WPR15LA085.md): Cubcrafters CC11-160 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Jan 16, 2015 · N232LT · Substantial damage
  > The pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…
- [NTSB CEN15LA104](https://openairdocs.org/ntsb/CEN15LA104.md): Baker Bobby J Safari · The Woodlands, TX · Accident · 1 fatal · Limited investigation · Final report · Jan 16, 2015 · N416JB · Substantial damage
  > An in-flight separation of the helicopter’s horizontal stabilizer due to undetected fatigue cracking of the stabilizer spar, which resulted in a loss of control.
- [NTSB DCA15WA074](https://openairdocs.org/ntsb/DCA15WA074.md): Boeing 747 - 406 · Novosibirisk, Russia · Incident · No injuries · Foreign investigation · Jan 13, 2015 · HL7417 · No damage
  > The Republic of South Korea Aviation and Railway Accident Investigation Board (ARAIB) has notified the NTSB of an incident involving a BOEING 747 that occurred on January 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB in…
- [NTSB ERA15WA104](https://openairdocs.org/ntsb/ERA15WA104.md): Robinson R44 - II · Santa Monica, Brazil · Accident · 1 fatal · Foreign investigation · Jan 10, 2015 · PR-HPR · Destroyed
  > On January 10, 2015, about 2000 universal coordinated time, a Robinson R44 II, Brazilian registration PR-HPR, was destroyed by impact and fire after collision with wires and terrain during cruise flight in Santa Monica, Parana, Brazil. There was a post-crash…
- [NTSB WPR15FA082](https://openairdocs.org/ntsb/WPR15FA082.md): Cirrus Design SR22 · Tooele, UT · Accident · 1 fatal · Field investigation · Final report · Jan 9, 2015 · N383GM · Substantial damage
  > The non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…
- [NTSB CEN15CA128](https://openairdocs.org/ntsb/CEN15CA128.md): Burton Calidus · Grand Junction, CO · Accident · Serious injuries · Data collection · Final report · Jan 6, 2015 · N50NE · Substantial damage
  > The pilot's failure to maintain clearance with terrain that was along the planned route of flight.
- [NTSB WPR15LA077](https://openairdocs.org/ntsb/WPR15LA077.md): Cessna 172D · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 2015 · N2948U · Substantial damage
  > The pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA15FA088](https://openairdocs.org/ntsb/ERA15FA088.md): Piper PA34 · Kuttawa, KY · Accident · 4 fatal · Field investigation · Final report · Jan 2, 2015 · N81291 · Substantial damage
  > The pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.
- [NTSB WPR15FA072](https://openairdocs.org/ntsb/WPR15FA072.md): Bell 206 · Benson, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 1, 2015 · N57AW · Destroyed
  > The pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…
- [NTSB WPR15TA071](https://openairdocs.org/ntsb/WPR15TA071.md): MD Helicopter 369FF · Las Vegas, NV · Accident · Serious injuries · Final report · Dec 31, 2014 · N530KK · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN15FA092](https://openairdocs.org/ntsb/CEN15FA092.md): Piper PA 28-181 · Vaughn, NM · Accident · 2 fatal · Field investigation · Final report · Dec 30, 2014 · N2558M · Substantial damage
  > The noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.
- [NTSB DCA15WA046](https://openairdocs.org/ntsb/DCA15WA046.md): Airbus A320 - 216 · Pangkalan Bun, Indonesia · Accident · 162 fatal · Foreign investigation · Dec 28, 2014 · PK-AXC · Destroyed
  > The National Transportation Safety Committee (NTSC) of Indonesia, has notified the NTSB of an accident involving an Airbus A320-216 that occurred on December 28, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…
- [NTSB ENG15WA019](https://openairdocs.org/ntsb/ENG15WA019.md): Airbus A330 - 201 · Athens, Greece, Greece · Incident · No injuries · Foreign investigation · Dec 26, 2014 · F-GRSQ · No damage
  > On 12/26/2014 an Airbus A330 operated by XL Airways took off from La Réunion (Indian Ocean) to Marseille (France). The information provided by the three inertial reference systems became successively unavailable, leading autopilot + auto-thrust to disconnect,…
- [NTSB ERA15WA082](https://openairdocs.org/ntsb/ERA15WA082.md): Cessna T207 - A · Piedecuesta, Colombia · Accident · 7 fatal · Foreign investigation · Dec 24, 2014 · HK4892 · Destroyed
  > On December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…
- [NTSB CEN15WA096](https://openairdocs.org/ntsb/CEN15WA096.md): Piper PA-32-260 · Lorrha, Tipperary, Ireland, Ireland · Accident · No injuries · Foreign investigation · Dec 24, 2014 · G-OCTI · Substantial damage
  > On December 24, 2014, at 1410 universal coordinated time (UTC), a Piper PA-32-260, United Kingdom registration G-OCTI, sustained substantial damage during an forced landing near Lorrha, Tipperary, Ireland, after experiencing an engine failure. There were no…
- [NTSB ERA15LA091](https://openairdocs.org/ntsb/ERA15LA091.md): Cessna 172M · South Bimini, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2014 · N12182 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.
- [NTSB ENG15RA010](https://openairdocs.org/ntsb/ENG15RA010.md): Bombardier DHC-8-402 · Belfast, N Ireland, United Kingdom · Incident · No injuries · Foreign investigation · Dec 16, 2014 · G-FLBC
  > On December 16, 2014, about 1839 UTC, a DeHavilland DHC-8-400Q, powered by two Pratt & Whitney Canada (PWC) PW150A turboprop engines, experienced an engine casing burn-through and in-flight shutdown near Belfast International Airport. Belfast, N. Ireland.…
- [NTSB DCA15WA041](https://openairdocs.org/ntsb/DCA15WA041.md): Boeing 777 223 · Ishikawa, Japan · Accident · Serious injuries · Foreign investigation · Dec 16, 2014 · N751AN · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…
- [NTSB CEN15WA108](https://openairdocs.org/ntsb/CEN15WA108.md): Airbus Helicopter EC135T2+ · Lake Siutghiol, Romania · Accident · 4 fatal · Foreign investigation · Dec 15, 2014 · N348 · Substantial damage
  > On December 14, 2014, about 1615 local time, an Airbus Helicopter EC135T2+ helicopter, Romanian registration number 348, impacted Lake Siutghiol, Romania. The four occupants, flight and medical crew, were all fatally injured. The helicopter sustained…
- [NTSB ERA15LA077](https://openairdocs.org/ntsb/ERA15LA077.md): Thomas R Wade Revelation · Ellisville, MS · Accident · No injuries · Limited investigation · Final report · Dec 13, 2014 · N783QJ · Substantial damage
  > The failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…

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

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

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