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

## Cases, newest first

- [NTSB DCA17CA217](https://openairdocs.org/ntsb/DCA17CA217.md): Boeing 737-8H4 · Sioux City, IA · Accident · Serious injuries · Data collection · Final report · Sep 25, 2017 · N500WR · No damage
  > the flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.
- [NTSB WPR17LA212](https://openairdocs.org/ntsb/WPR17LA212.md): Mooney M20E · Glendale, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2017 · N34BE · Substantial damage
  > The pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB DCA17WA205](https://openairdocs.org/ntsb/DCA17WA205.md): Boeing 777 · Osaka, Japan · Incident · No injuries · Foreign investigation · Sep 23, 2017 · PHBQC · Minor damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on September 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…
- [NTSB DCA17IA202](https://openairdocs.org/ntsb/DCA17IA202.md): DJI Phantom · Hoffman Island, NY · Incident · No injuries · Incident investigation · Final report · Sep 21, 2017 · UNREG · 2 aircraft · Destroyed
  > the failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.
- [NTSB CEN17LA358](https://openairdocs.org/ntsb/CEN17LA358.md): Cessna 177B · London, OH · Accident · No injuries · Limited investigation · Final report · Sep 17, 2017 · N35170 · Substantial damage
  > The flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA17LA347](https://openairdocs.org/ntsb/ERA17LA347.md): Beech 35 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 2017 · N3187V · Substantial damage
  > A total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.
- [NTSB ERA17FA327](https://openairdocs.org/ntsb/ERA17FA327.md): Mooney M20C · North Branford, CT · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2017 · N53CP · Substantial damage
  > A total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…
- [NTSB CEN17FA355](https://openairdocs.org/ntsb/CEN17FA355.md): Bell 206L 3 · Ancho, NM · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2017 · N213TV · Destroyed
  > The pilot's distraction by a cell phone during a low-altitude flight, which resulted in controlled flight into terrain.
- [NTSB ERA17WA345](https://openairdocs.org/ntsb/ERA17WA345.md): Cessna U206F · Caracarai, Brazil · Accident · 1 fatal · Foreign investigation · Sep 15, 2017 · PT-JPW · Substantial damage
  > On September 15, 2017, about 1300 coordinated universal time, a Cessna U206F, Brazilian registration PT-JPW, was substantially damaged after ditching in the Rio Branco river, near Caracaraí, Brazil. The pilot was fatally injured. The flight was conducted…
- [NTSB ERA17LA338](https://openairdocs.org/ntsb/ERA17LA338.md): Parks Richard A Starduster SA 100 · Southfields, NY · Accident · No injuries · Limited investigation · Final report · Sep 15, 2017 · N1356W · Substantial damage
  > A loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.
- [NTSB ERA17LA326](https://openairdocs.org/ntsb/ERA17LA326.md): Air Tractor AT 502 · Union City, TN · Accident · No injuries · Limited investigation · Final report · Sep 15, 2017 · N4531K · Substantial damage
  > The catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.
- [NTSB DCA17WA198](https://openairdocs.org/ntsb/DCA17WA198.md): Boeing 737 · Adelaide, Australia · Accident · Serious injuries · Foreign investigation · Sep 13, 2017 · UNK · No damage
  > The ATSB of Australia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…
- [NTSB CEN17LA352](https://openairdocs.org/ntsb/CEN17LA352.md): Cessna 210G · Hallsville, MO · Accident · No injuries · Limited investigation · Final report · Sep 13, 2017 · N5906F · Substantial damage
  > The total loss of engine power due to a fatigue failure of the engine mixture control cable.
- [NTSB CEN17LA356](https://openairdocs.org/ntsb/CEN17LA356.md): Cessna R182 · Worland, WY · Accident · No injuries · Limited investigation · Final report · Sep 12, 2017 · N1835R · Substantial damage
  > The pilot's decision to operate an airplane with unreliable fuel gauges and the worn fuel cap seal that allowed fuel to siphon from the left wing fuel tank, which ultimately resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN17WA343](https://openairdocs.org/ntsb/CEN17WA343.md): Piper Piper PA-28RT-201 · Wolferton, United Kingdom · Accident · 2 fatal · Foreign investigation · Sep 11, 2017 · G-BHAY · Substantial damage
  > On September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…
- [NTSB CEN17LA344](https://openairdocs.org/ntsb/CEN17LA344.md): Aviat A 1B · Prairie du Chien, WI · Accident · No injuries · Limited investigation · Final report · Sep 9, 2017 · N299CA · Substantial damage
  > The fatigue failure of the aileron hinge bracket tubing for reasons that could not be determined based on the available evidence.
- [NTSB ERA17MA316](https://openairdocs.org/ntsb/ERA17MA316.md): Eurocopter Deutschland MBB BK 117 · Hertford, NC · Accident · 4 fatal · Class 2 · Major · Final report · Sep 8, 2017 · N146DU · Destroyed
  > A failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…
- [NTSB WPR17FA196](https://openairdocs.org/ntsb/WPR17FA196.md): Cessna 172N · Bolinas, CA · Accident · 1 fatal · Field investigation · Final report · Sep 7, 2017 · N737QQ · Substantial damage
  > The non-instrument rated private pilot's improper decision to embark on a flight and continue to fly into forecasted instrument meteorological conditions and mountain obscuration while conducting a visual flight rules flight.
- [NTSB GAA17CA529](https://openairdocs.org/ntsb/GAA17CA529.md): Cessna 182 · Fairfield, MT · Accident · Minor injuries · Data collection · Final report · Sep 7, 2017 · N735KQ · Destroyed
  > The pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.
- [NTSB DCA17WA223](https://openairdocs.org/ntsb/DCA17WA223.md): Boeing 737 · Cancun, Mexico · Incident · No injuries · Foreign investigation · Sep 6, 2017 · XA-UQX · No damage
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA17FA313](https://openairdocs.org/ntsb/ERA17FA313.md): Cirrus Design SR20 · Jacksonburg, WV · Accident · 2 fatal · Field investigation · Final report · Sep 5, 2017 · N135CD · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions in the vicinity of adverse weather conditions.
- [NTSB WPR17LA197](https://openairdocs.org/ntsb/WPR17LA197.md): Boeing A75N1(PT17) · Santa Paula, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 4, 2017 · N75753 · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined based on the available information.
- [NTSB CEN17LA338](https://openairdocs.org/ntsb/CEN17LA338.md): Golden Eagle Chief · Mt. Zion, IL · Accident · No injuries · Limited investigation · Final report · Sep 3, 2017 · N68N · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA17LA307](https://openairdocs.org/ntsb/ERA17LA307.md): Cessna U206 · Harpswell, ME · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 1, 2017 · N4615X · Substantial damage
  > A total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.
- [NTSB ERA17LA302](https://openairdocs.org/ntsb/ERA17LA302.md): Pacific Aerospace 750XL · Harvest, AL · Accident · No injuries · Limited investigation · Final report · Aug 28, 2017 · N750UP · Substantial damage
  > The pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN17LA333](https://openairdocs.org/ntsb/CEN17LA333.md): Gulfstream American AA 5B · Carbondale, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 2017 · N28005 · Substantial damage
  > The failure of the propeller due to fatigue as a result of improper installation by unknown maintenance personnel at some point during the life of the propeller.
- [NTSB CEN17FA331](https://openairdocs.org/ntsb/CEN17FA331.md): Beech A36 · Ellabell, GA · Accident · 3 fatal · Class 3 · Field · Final report · Aug 28, 2017 · N87RY · Destroyed
  > The total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…
- [NTSB ERA17WA296](https://openairdocs.org/ntsb/ERA17WA296.md): Cessna T210 · Ciudad Bolivar, Venezuela · Accident · 1 fatal · Foreign investigation · Aug 27, 2017 · YV2594 · Substantial damage
  > On August 27, 2017 about 2052 coordinated universal time (UTC), a Cessna T210M, Venezuelan registration YV2594, was substantially damaged during a forced landing, after a loss of engine power near Ciudad Bolivar, Venezuela. The pilot and three passengers were…
- [NTSB DCA17WA189](https://openairdocs.org/ntsb/DCA17WA189.md): Airbus A320 233 · Lima, Peru · Incident · No injuries · Foreign investigation · Aug 27, 2017 · N491TA · No damage
  > The Comisión de Investigación de Accidentes de Aviación (CIAA) of Peru has notified the NTSB of an incident involving a AIRBUS A320 233 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…
- [NTSB GAA17CA511](https://openairdocs.org/ntsb/GAA17CA511.md): Piper PA 12 · Gulkana, AK · Accident · No injuries · Data collection · Final report · Aug 26, 2017 · N3233M · Substantial damage
  > The pilot’s inadequate in-flight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA17WA308](https://openairdocs.org/ntsb/ERA17WA308.md): Maule M7 · Zhideli, Kazakhstan · Accident · 1 fatal · Foreign investigation · Aug 25, 2017 · UP-ML003 · Substantial damage
  > On August 25, 2017, about 0450 coordinated universal time, a Maule M7-260C airplane, Kazakhstan registration UP-ML003, impacted terrain during a forced landing near Zhideli, Kazakhstan. The pilot was fatally injured and the passenger sustained serious…
- [NTSB ANC17FA049](https://openairdocs.org/ntsb/ANC17FA049.md): Piper PA-18AS · Tyonek, AK · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2017 · N1905A · Destroyed
  > The noninstrument-rated pilot's decision to initiate a visual flight rules flight into dark night, marginal visual flight rules to instrument flight rules conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB GAA17CA505](https://openairdocs.org/ntsb/GAA17CA505.md): Cessna 177RG · Byron, CA · Accident · No injuries · Data collection · Final report · Aug 22, 2017 · N8053G · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB DCA17LA183](https://openairdocs.org/ntsb/DCA17LA183.md): Bombardier CL 600 2C10 · McKellar, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 22, 2017 · N745SK · No damage
  > An encounter with convective turbulence while maneuvering to avoid conflicting traffic.
- [NTSB ERA17WA283](https://openairdocs.org/ntsb/ERA17WA283.md): Robinson R66 · Maly Utrish, Russia · Accident · 1 fatal · Foreign investigation · Aug 21, 2017 · RA-05750 · Substantial damage
  > On July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…
- [NTSB ERA17LA285](https://openairdocs.org/ntsb/ERA17LA285.md): Bell 47G · St Marys, PA · Accident · No injuries · Limited investigation · Final report · Aug 20, 2017 · N9526 · Substantial damage
  > The student pilot's inadequate prefight planning and en route fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA17WA289](https://openairdocs.org/ntsb/ERA17WA289.md): Learjet 25 · Naiguata, Venezuela · Accident · 5 fatal · Foreign investigation · Aug 19, 2017 · YV3191 · Substantial damage
  > On August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…
- [NTSB CEN17LA317](https://openairdocs.org/ntsb/CEN17LA317.md): Piper PA22 · Beckville, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2017 · N2591A · Substantial damage
  > A stuck exhaust valve, which resulted in the failure of the valve and a loss of engine power. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.
- [NTSB ANC17WA048](https://openairdocs.org/ntsb/ANC17WA048.md): Socata TBM 700 · Zemyo, Japan · Accident · 2 fatal · Foreign investigation · Aug 14, 2017 · N702AV · Destroyed
  > On Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…
- [NTSB ERA17LA275](https://openairdocs.org/ntsb/ERA17LA275.md): Piper J3C · Salisbury, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2017 · N98550 · Substantial damage
  > An improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.
- [NTSB CEN17FA315](https://openairdocs.org/ntsb/CEN17FA315.md): Piper PA 22-150 · Las Vegas, NM · Accident · 1 fatal · Field investigation · Final report · Aug 9, 2017 · N3664Z · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to land, which resulted in an accelerated stall and the pilot’s subsequent loss of control. Contributing to the accident was the gap in the pilot’s flight experience, his…
- [NTSB DCA17WA172](https://openairdocs.org/ntsb/DCA17WA172.md): Boeing 787-9 · Madrid, Spain · Incident · No injuries · Foreign investigation · Aug 8, 2017 · N825AA · No damage
  > The government of Spain has notified the NTSB of an incident involving a BOEING 787-9 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB WPR17LA180](https://openairdocs.org/ntsb/WPR17LA180.md): Lockheed P2V 5F · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Aug 6, 2017 · N410NA · Substantial damage
  > Maintenance personnel's failure to secure hardware, which resulted in an uncommanded upward deflection of the left elevator and aft movement of the control yoke and inhibited the flight crew from adjusting the airplane's pitch attitude in flight. Contributing…
- [NTSB ERA17LA268](https://openairdocs.org/ntsb/ERA17LA268.md): Cessna 140 · Mount Sterling, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2017 · N89738 · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB DCA17LA173](https://openairdocs.org/ntsb/DCA17LA173.md): Airbus 330 · East Hampton, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2017 · N276AY · No damage
  > an inadvertent encounter with convective turbulence.
- [NTSB GAA17CA468](https://openairdocs.org/ntsb/GAA17CA468.md): Cessna 170 · Moab, UT · Accident · Serious injuries · Data collection · Final report · Aug 4, 2017 · N1214D · Substantial damage
  > The pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.
- [NTSB CEN17WA310](https://openairdocs.org/ntsb/CEN17WA310.md): Piper PA28 · Berghaus Diavolezza, Switzerland · Accident · 3 fatal · Foreign investigation · Aug 4, 2017 · HB-PER · Substantial damage
  > On August 4, 2017, at 0720 UTC, a Piper PA-28-181, Swiss registration HB-PER, owned and operated by a private individual, impacted mountainous terrain near Berghaus Diavolezza, Switzerland. The pilot and two passengers on board were fatally injured. A third…
- [NTSB WPR17FA179](https://openairdocs.org/ntsb/WPR17FA179.md): Michaelian Lancair IV-TP · Rio Linda, CA · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2017 · N420M · Substantial damage
  > A loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR17WA178](https://openairdocs.org/ntsb/WPR17WA178.md): Robinson Helicopter R22 Beta · Cloncurry, Australia · Accident · 1 fatal · Foreign investigation · Aug 2, 2017 · VH-HGU · Destroyed
  > On August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…
- [NTSB WPR17LA172](https://openairdocs.org/ntsb/WPR17LA172.md): Cessna T210F · Llano, CA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2017 · N6109R · Substantial damage
  > A failure of the turbocharger that resulted in complete depletion of the engine oil and catastrophic internal failure of the engine. Contributing to the accident was improper and/or incomplete maintenance and inspection of the turbocharger.

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

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

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