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

## Cases, newest first

- [NTSB WPR17IA173](https://openairdocs.org/ntsb/WPR17IA173.md): Columbia Aircraft Mfg LC41 550FG · Chandler, AZ · Incident · No injuries · Class 3 · Incident · Final report · Aug 1, 2017 · N8725 · Minor damage
  > The over-tensioning of the accessory belt, which resulted in damage to the starter adapter and subsequent loss of oil that led to oil starvation and catastrophic engine failure.
- [NTSB DCA17WA174](https://openairdocs.org/ntsb/DCA17WA174.md): Boeing 777 · Singapore, Singapore · Accident · Serious injuries · Foreign investigation · Aug 1, 2017 · 9V-SQN · No damage
  > The Transport Safety Investigation Bureau (TSIB) Ministry of Transport of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB DCA17WA164](https://openairdocs.org/ntsb/DCA17WA164.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Aug 1, 2017 · D-ABYS · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB WPR17LA176](https://openairdocs.org/ntsb/WPR17LA176.md): Cessna 172S · Seattle, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 31, 2017 · N957TA · Substantial damage
  > The total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.
- [NTSB CEN17LA295](https://openairdocs.org/ntsb/CEN17LA295.md): Steele Acro Sport II · Loudonville, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2017 · N896JC · Substantial damage
  > A partial loss of engine power due to carburetor icing.
- [NTSB CEN17LA292](https://openairdocs.org/ntsb/CEN17LA292.md): Piper PA 46 350P · Tahlequah, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2017 · N786MD · Substantial damage
  > The total loss of engine power, which resulted from fatigue failure of two engine through bolts and the No. 2 cylinder attachment studs due to the lack of sufficient clamping force.
- [NTSB DCA17WA163](https://openairdocs.org/ntsb/DCA17WA163.md): Boeing Boeing 737-330 · Frankfurt-Main, Germany · Incident · No injuries · Foreign investigation · Jul 28, 2017 · G-CELI · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 737-330 airplane that occurred on July 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB CEN17FA288](https://openairdocs.org/ntsb/CEN17FA288.md): Zenith CH701SP · Laddonia, MO · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2017 · N701XL · Destroyed
  > The pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…
- [NTSB ANC17FA039](https://openairdocs.org/ntsb/ANC17FA039.md): Cessna U206 · Port Alsworth, AK · Accident · 1 fatal · Class 2 · Field · Final report · Jul 27, 2017 · N1749R · Destroyed
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…
- [NTSB ERA17LA257](https://openairdocs.org/ntsb/ERA17LA257.md): Robinson Helicopter R44 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 24, 2017 · N828RD · Substantial damage
  > A loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…
- [NTSB DCA17WA158](https://openairdocs.org/ntsb/DCA17WA158.md): Boeing Boeing 777-236 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jul 23, 2017 · G-YMMC · No damage
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…
- [NTSB CEN17WA289](https://openairdocs.org/ntsb/CEN17WA289.md): Cessna U206 · Culiacan, Mexico · Accident · 7 fatal · Foreign investigation · Jul 23, 2017 · XB-MUM · Substantial damage
- [NTSB DCA17WA161](https://openairdocs.org/ntsb/DCA17WA161.md): Boeing 767 · Newcastle, United Kingdom · Incident · No injuries · Foreign investigation · Jul 22, 2017 · D-ABUK · Minor damage
  > The UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB WPR17LA159](https://openairdocs.org/ntsb/WPR17LA159.md): Robinson Helicopter R44 II · Van Nuys, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 2017 · N3254E · Substantial damage
  > An improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…
- [NTSB GAA17CA427](https://openairdocs.org/ntsb/GAA17CA427.md): Let L23 · Deatsville, AL · Accident · Minor injuries · Data collection · Final report · Jul 21, 2017 · N342BA · Substantial damage
  > The student pilot’s failure to maintain clearance from trees and power lines while landing.
- [NTSB DCA17CA155](https://openairdocs.org/ntsb/DCA17CA155.md): Embraer S A ERJ170-200LR · Minneapolis, MN · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 20, 2017 · N427YX · No damage
  > An encounter with convective turbulence.
- [NTSB CEN17LA313](https://openairdocs.org/ntsb/CEN17LA313.md): Canion Michael W Zodiac 601XL · Grady, AR · Accident · No injuries · Limited investigation · Final report · Jul 20, 2017 · N577M · Substantial damage
  > The loss of engine power due to a lack of ignition resulting from a broken alternator wire.
- [NTSB DCA17WA159](https://openairdocs.org/ntsb/DCA17WA159.md): Boeing 747 422 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Jul 18, 2017 · N121UA · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB ANC17LA037](https://openairdocs.org/ntsb/ANC17LA037.md): Cessna A185 · Wasilla, AK · Accident · No injuries · Class 3 · Limited · Final report · Jul 16, 2017 · N401WC · Substantial damage
  > The pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…
- [NTSB CEN17WA276](https://openairdocs.org/ntsb/CEN17WA276.md): Cessna T210 · Cerro Viejo, Mexico · Accident · 2 fatal · Foreign investigation · Jul 15, 2017 · XB-LJK · Substantial damage
  > On July 15, 2017, at 1616 coordinated universal time, a Cessna T210N, Mexican registration XB-LJK, collided with the terrain in Cerro Viejo, Mexico, following a loss of engine power. The pilot and passenger were fatally injured. The airplane was substantially…
- [NTSB ANC17FA035](https://openairdocs.org/ntsb/ANC17FA035.md): Aeronca 15AC · Big Lake, AK · Accident · 1 fatal · Field investigation · Final report · Jul 15, 2017 · N1370H · Substantial damage
  > The pilot's failure to maintain clearance from trees during low-altitude flight, which resulted in an in-flight collision and impact with terrain.
- [NTSB WPR17FA151](https://openairdocs.org/ntsb/WPR17FA151.md): Piper PA 44-180 · Marineland, FL · Accident · 2 fatal · Field investigation · Final report · Jul 14, 2017 · N2173S · Destroyed
  > A loss of control in flight for reasons that could not be determined based on the available information, which resulted in an in-flight breakup.
- [NTSB ERA17LA242](https://openairdocs.org/ntsb/ERA17LA242.md): Cessna 172 · Key Biscayne, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 2017 · N80457 · Substantial damage
  > The nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…
- [NTSB ERA17FA241](https://openairdocs.org/ntsb/ERA17FA241.md): Extra Flugzeugbau EA 300/L · Winchester, NH · Accident · 1 fatal · Field investigation · Final report · Jul 13, 2017 · N210MX · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…
- [NTSB WPR17LA148](https://openairdocs.org/ntsb/WPR17LA148.md): Charles J Norris Arion Lightning · New River, AZ · Accident · No injuries · Limited investigation · Final report · Jul 10, 2017 · N273DB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined due to a lack of available evidence.
- [NTSB WPR17LA147](https://openairdocs.org/ntsb/WPR17LA147.md): Cessna 180 · Baker City, OR · Accident · No injuries · Limited investigation · Final report · Jul 9, 2017 · N4683B · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning.
- [NTSB CEN17LA265](https://openairdocs.org/ntsb/CEN17LA265.md): Cubcrafters CC11-160 · Milesville, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2017 · N111JW · Substantial damage
  > Fuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…
- [NTSB WPR17FA146](https://openairdocs.org/ntsb/WPR17FA146.md): Chicco Miguel E Quicksilver Sport II · Point Mugu, CA · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2017 · N2812
  > A partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…
- [NTSB CEN17LA286](https://openairdocs.org/ntsb/CEN17LA286.md): Beech V35 · Walters, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2017 · N6257V · Substantial damage
  > Maintenance personnel’s installation of an improper vacuum pump gasket, which resulted in oil starvation to the engine and a subsequent total loss of engine power.
- [NTSB ERA17LA278](https://openairdocs.org/ntsb/ERA17LA278.md): Piper PA28 · Gainsville, GA · Accident · No injuries · Limited investigation · Final report · Jul 7, 2017 · N6653J · Substantial damage
  > The separation of the mixture control cable from the mixture control lever at the carburetor, which resulted in the partial loss of engine power.
- [NTSB ERA17LA234](https://openairdocs.org/ntsb/ERA17LA234.md): Cessna 172 · Cape Coral, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N2492U · Substantial damage
  > A total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.
- [NTSB CEN17WA339](https://openairdocs.org/ntsb/CEN17WA339.md): Schweizer Schweizer 269C · Bonvilliers, France · Accident · No injuries · Foreign investigation · Jul 5, 2017 · F-GHAF
  > On July 5, 2017, a Schweizer 269C helicopter, French registration F-GHAF, experienced a dynamic rollover near Boinvilliers, France. During a simulated engine failure, the engine lost power. The instructor attempted to restart the engine unsuccessfully three…
- [NTSB CEN17LA271](https://openairdocs.org/ntsb/CEN17LA271.md): Piper PA 32-300 · Rushville, IN · Accident · No injuries · Limited investigation · Final report · Jul 5, 2017 · N112DE · Substantial damage
  > The pilot’s inability to properly control engine power because of an improperly installed throttle control arm, which resulted in a partial loss of engine power and led to a forced landing.
- [NTSB ERA17WA230](https://openairdocs.org/ntsb/ERA17WA230.md): Gulfstream G1159A · Nueva Esparta, Venezuela · Accident · 9 fatal · Foreign investigation · Jul 4, 2017 · YV2896 · Destroyed
  > On July 4, 2017, about 1745 coordinated universal time (UTC), a Gulfstream 1159A, Venezuela registration YV2895, descended into the Caribbean Sea northwest of Nueva Esparta, Venezuela, and was presumed to be destroyed. Visual meteorological conditions…
- [NTSB CEN17LA255](https://openairdocs.org/ntsb/CEN17LA255.md): Beech A36 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 2017 · N24LF · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.
- [NTSB DCA17WA170](https://openairdocs.org/ntsb/DCA17WA170.md): Airbus A320 214 · Cali, Colombia · Incident · No injuries · Foreign investigation · Jul 3, 2017 · N742AV · No damage
  > The Grupo de Investigacion de Accidentes of Colombia has notified the NTSB of an incident involving a AIRBUS A320 214 airplane that occurred on July 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's…
- [NTSB CEN17WA373](https://openairdocs.org/ntsb/CEN17WA373.md): Cessna Cessna U 206 G · Granville Mont-Saint Michel, France · Accident · No injuries · Foreign investigation · Jul 3, 2017 · F-GAMJ · Substantial damage
  > On July 3, 2017, a Cessna 206 airplane, F-GAMJ, conducted a forced landing after experiencing an inflight fire in the cabin. The pilot was not injured and the airplane sustained substantial damage during the landing. The accident investigation is under the…
- [NTSB CEN17FA252](https://openairdocs.org/ntsb/CEN17FA252.md): Airbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MO · Accident · Minor injuries · Field investigation · Final report · Jul 2, 2017 · N238BK · Substantial damage
  > Fuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…
- [NTSB ERA17FA222](https://openairdocs.org/ntsb/ERA17FA222.md): Piper PA23 · Chatsworth, GA · Accident · 4 fatal · Field investigation · Final report · Jul 1, 2017 · N44HJ · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…
- [NTSB DCA17WA154](https://openairdocs.org/ntsb/DCA17WA154.md): Boeing 787-9 · Fukushima, Japan · Accident · Serious injuries · Foreign investigation · Jul 1, 2017 · N29968 · No damage
  > The Japanese Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 787-9 airplane that occurred on July 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions…
- [NTSB CEN17FA248](https://openairdocs.org/ntsb/CEN17FA248.md): Cessna 421C · Catawba, WI · Accident · 6 fatal · Field investigation · Final report · Jul 1, 2017 · N2655B · Destroyed
  > A loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.
- [NTSB WPR17LA137](https://openairdocs.org/ntsb/WPR17LA137.md): Cirrus Design SR22 · Dixon, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 30, 2017 · N744TC · Substantial damage
  > A total loss of engine power for reasons that could not be determined due to extensive damage.
- [NTSB DCA17WA192](https://openairdocs.org/ntsb/DCA17WA192.md): Boeing 737 · Monterrey, Mexico · Incident · No injuries · Foreign investigation · Jun 29, 2017 · XA-UNY · No damage
  > The government of Mexico has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB WPR17WA135](https://openairdocs.org/ntsb/WPR17WA135.md): Socata TB10 · Suttontown, Australia · Accident · 3 fatal · Foreign investigation · Jun 28, 2017 · VH-YTM · Substantial damage
- [NTSB WPR17LA133](https://openairdocs.org/ntsb/WPR17LA133.md): Eurocopter EC 130 B4 · Boulder City, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 2017 · N151GC · Substantial damage
  > A loss of engine power due to the failure of the manufacturer to reinstall the oil filter after it was removed for inspection, which led to coke pollution that obstructed the oil jet and resulted in the subsequent oil starvation of the axial compressor rear…
- [NTSB WPR17FA134](https://openairdocs.org/ntsb/WPR17FA134.md): Jordan John RV7 · Arlington, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 27, 2017 · N731RV · Destroyed
  > The inflight overstress separation of the vertical stabilizer and rudder during flight which resulted in the pilot's inability to maintain airplane control. Contributing to the accident was an inflight collision with a bird.
- [NTSB GAA17CA373](https://openairdocs.org/ntsb/GAA17CA373.md): Cessna 172 · Roseburg, OR · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N79938 · Substantial damage
  > An in-flight collision with a bird during the approach.
- [NTSB GAA17CA367](https://openairdocs.org/ntsb/GAA17CA367.md): Cessna 182 · San Martin, CA · Accident · Minor injuries · Data collection · Final report · Jun 25, 2017 · N524BF · Substantial damage
  > The pilot’s failure to attain a proper glidepath on approach for landing, which resulted in an impact with a guard rail and post. Contributing to the accident was the pilot’s failure to ensure that sufficient fuel was onboard for nonlevel flight, which…
- [NTSB GAA17CA371](https://openairdocs.org/ntsb/GAA17CA371.md): Aero Commander Callair A 9 · Morgan, UT · Accident · No injuries · Data collection · Final report · Jun 24, 2017 · N7662V · Substantial damage
  > The pilot’s failure to see and avoid transmission wires.
- [NTSB WPR17LA144](https://openairdocs.org/ntsb/WPR17LA144.md): Cessna U206F · Page, AZ · Accident · No injuries · Limited investigation · Final report · Jun 23, 2017 · N71001 · Substantial damage
  > The failure of the throttle control cable due to fatigue and maintenance personnel’s failure to replace the cable at the last engine overhaul, which resulted in the pilots’ inability to control engine power and led to a precautionary landing during which the…

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

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

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