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

## Cases, newest first

- [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…
- [NTSB GAA17CA361](https://openairdocs.org/ntsb/GAA17CA361.md): Cessna 182 · Doniphan, MO · Accident · No injuries · Data collection · Final report · Jun 23, 2017 · N1800M · Substantial damage
  > The pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA17WA207](https://openairdocs.org/ntsb/ERA17WA207.md): MD Helicopter 369 · Bultfontein, South Africa · Accident · No injuries · Foreign investigation · Jun 14, 2017 · ZT-RAC · Substantial damage
  > On June 14, 2017, about 1045 coordinated universal time, an MD Helicopter 369E, South African registration ZT-RAC, was substantially damaged during a forced landing near Bulfontein, South Africa. The pilot and two passengers were not injured. The personal…
- [NTSB CEN17FA227](https://openairdocs.org/ntsb/CEN17FA227.md): Beech E 90 · Ruidoso, NM · Accident · 2 fatal · Field investigation · Final report · Jun 14, 2017 · N48TA · Destroyed
  > The pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.
- [NTSB ERA17LA203](https://openairdocs.org/ntsb/ERA17LA203.md): Cessna 172 · Suffolk, NY · Accident · No injuries · Limited investigation · Final report · Jun 12, 2017 · N13306 · Substantial damage
  > A loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.
- [NTSB GAA17CA331](https://openairdocs.org/ntsb/GAA17CA331.md): Piper PA25 · Hood River, OR · Accident · Minor injuries · Data collection · Final report · Jun 11, 2017 · N8578L · Substantial damage
  > The pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.
- [NTSB WPR17LA124](https://openairdocs.org/ntsb/WPR17LA124.md): Piper PA28 · Carpinteria, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 2017 · N2171D · Substantial damage
  > The noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB WPR17FA125](https://openairdocs.org/ntsb/WPR17FA125.md): Beech 95 C55 · Mountain Ranch, CA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2017 · N3717Q · Destroyed
  > The pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.
- [NTSB CEN17LA226](https://openairdocs.org/ntsb/CEN17LA226.md): Piper PA 32R-301T · Dalhart, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2017 · N782SW · Substantial damage
  > The failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.
- [NTSB ENG17IA026](https://openairdocs.org/ntsb/ENG17IA026.md): Boeing 747 451 · Tokyo, Japan · Incident · No injuries · Incident investigation · Final report · Jun 7, 2017 · N668US · No damage
  > The PW4056 engine lost power due to the fatigue fracture of a 5th stage compressor blade. The cause of the fatigue fracture could not be determined.
- [NTSB ANC17LA028](https://openairdocs.org/ntsb/ANC17LA028.md): Cessna 172 · Chugiak, AK · Accident · Minor injuries · Class 2 · Limited · Final report · Jun 6, 2017 · N35700 · Substantial damage
  > The pilot's improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN17LA239](https://openairdocs.org/ntsb/CEN17LA239.md): Levy Adam V Legacy 2000 · Georgetown, TX · Accident · No injuries · Limited investigation · Final report · Jun 4, 2017 · N169BZ · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR17LA119](https://openairdocs.org/ntsb/WPR17LA119.md): Paul R Seipt Sonex · Garfield, WA · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2017 · N255BZ · Substantial damage
  > The pilot’s improper torque of screws that attached the flywheel mounting flange to the crankshaft during engine assembly, which resulted in heavy vibrations and the subsequent in-flight loss of the propeller.
- [NTSB ENG17IA027](https://openairdocs.org/ntsb/ENG17IA027.md): Boeing 737 7H4 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jun 3, 2017 · N765SW · Minor damage
  > The failure the control alternator gearshaft, which disconnected the accessory gearbox from the rest of the engine and resulted in an uncommanded in-flight shutdown of the left engine and subsequent flight diversion. The control alternator gearshaft failed…
- [NTSB ANC17WA027](https://openairdocs.org/ntsb/ANC17WA027.md): Cessna 172 · Tateyama, Japan · Accident · 4 fatal · Foreign investigation · Jun 3, 2017 · JA3989 · Substantial damage
  > On June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…
- [NTSB WPR17FA117](https://openairdocs.org/ntsb/WPR17FA117.md): Cessna 180 · Ventura, CA · Accident · 1 fatal · Field investigation · Final report · Jun 1, 2017 · N3683C · Destroyed
  > The pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.
- [NTSB CEN17WA214](https://openairdocs.org/ntsb/CEN17WA214.md): Piper PA-28-140 · Sacatepequez, Guatemala · Accident · 1 fatal · Foreign investigation · Jun 1, 2017 · TG-GYV · Destroyed
  > On June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…
- [NTSB CEN17FA207](https://openairdocs.org/ntsb/CEN17FA207.md): Varga 2150A · Bowling Green, OH · Accident · 1 fatal · Field investigation · Final report · Jun 1, 2017 · N4635V · Substantial damage
  > The pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…
- [NTSB ERA17TA196](https://openairdocs.org/ntsb/ERA17TA196.md): Ernest T Christley Zenith Zodiac 601XL · Sanford, NC · Accident · No injuries · Final report · May 29, 2017 · N167EZ · Substantial damage
  > The pilot’s selection of a threaded metal rod of insufficient strength to connect the fuel tank selector handle to the fuel valve, which resulted in his inability to switch fuel tanks and a subsequent total loss of engine power due to fuel starvation.
- [NTSB GAA17CA308](https://openairdocs.org/ntsb/GAA17CA308.md): Robert Hamblin Autogyro Gmbh Cavalo · Fort Worth, TX · Accident · Minor injuries · Data collection · Final report · May 27, 2017 · N721E · Substantial damage
  > The pilot’s failure to maintain clearance from terrain.
- [NTSB DCA17WA126](https://openairdocs.org/ntsb/DCA17WA126.md): Boeing 777 · Multan, Pakistan · Incident · No injuries · Foreign investigation · May 23, 2017 · AP-BGK · No damage
  > The government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…
- [NTSB ANC17LA025](https://openairdocs.org/ntsb/ANC17LA025.md): Airbus AS350 · Juneau, AK · Accident · Minor injuries · Class 3 · Limited · Final report · May 23, 2017 · N207CH · Substantial damage
  > The pilot's decision to depart into an area of degraded visual meteorological and flat light conditions, which resulted in a loss of visual references and subsequent controlled flight into terrain.
- [NTSB GAA17CA311](https://openairdocs.org/ntsb/GAA17CA311.md): Cessna 208 · Skagway, AK · Accident · No injuries · Data collection · Final report · May 22, 2017 · N754KP · Substantial damage
  > An in-flight collision with a goose.
- [NTSB DCA17CA123](https://openairdocs.org/ntsb/DCA17CA123.md): Airbus A319 132 · South Toledo Bend, TX · Accident · Serious injuries · Class 4 · Data collection · Final report · May 22, 2017 · N512NK · No damage
  > an encounter with convective turbulence.
- [NTSB GAA17CA306](https://openairdocs.org/ntsb/GAA17CA306.md): Cessna 150 · Zepp, VA · Accident · Minor injuries · Data collection · Final report · May 21, 2017 · N60579 · Substantial damage
  > A partial loss of engine power due to the formation of carburetor icing, which resulted from the student pilot’s failure to apply carburetor heat and the flight instructor’s delayed response in applying carburetor heat while operating in conditions conducive…
- [NTSB ERA17LA185](https://openairdocs.org/ntsb/ERA17LA185.md): Cessna 182 · West Chester, PA · Accident · No injuries · Limited investigation · Final report · May 21, 2017 · N378ES · Substantial damage
  > An engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.
- [NTSB ERA17LA188](https://openairdocs.org/ntsb/ERA17LA188.md): Maule M7 · Colton, NY · Accident · Minor injuries · Limited investigation · Final report · May 20, 2017 · N126MC · Substantial damage
  > The pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…
- [NTSB WPR17LA106](https://openairdocs.org/ntsb/WPR17LA106.md): Cessna 182P · Anderson, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 19, 2017 · N7352S · Substantial damage
  > Loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA17WA191](https://openairdocs.org/ntsb/ERA17WA191.md): Robinson R44 · Heilbron, South Africa · Accident · 2 fatal · Foreign investigation · May 19, 2017 · ZS-HFF · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 II helicopter that occurred on May 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB ERA17WA206](https://openairdocs.org/ntsb/ERA17WA206.md): Cessna 182 · Poesoegroenoe, Suriname · Incident · No injuries · Foreign investigation · May 18, 2017 · PZ-VAC · Minor damage
  > On May 18, 2017, at 1840 coordinated universal time, a Cessna 182P, registered as PZ-VAC, experienced an uncontained engine failure, and sustained minor damage during a subsequent forced landing in Poespegroenoe, Suriname. The pilot and two passengers were…
- [NTSB WPR17LA104](https://openairdocs.org/ntsb/WPR17LA104.md): Evolution Air Lancair Evolution · Firebaugh, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 15, 2017 · N846PM · Substantial damage
  > A failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.
- [NTSB ERA17FA181](https://openairdocs.org/ntsb/ERA17FA181.md): Mitsubishi MU2B · Eleuthera, Bahamas · Accident · 4 fatal · Field investigation · Final report · May 15, 2017 · N220N · Destroyed
  > The pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.
- [NTSB DCA17WA118](https://openairdocs.org/ntsb/DCA17WA118.md): Boeing 737 · Munich, Germany · Incident · No injuries · Foreign investigation · May 14, 2017 · TS-ION · No damage
  > The Germany Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB CEN17LA186](https://openairdocs.org/ntsb/CEN17LA186.md): Piper PA 28-140 · Muskogee, OK · Accident · Minor injuries · Limited investigation · Final report · May 13, 2017 · N3976K · Substantial damage
  > The pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.
- [NTSB CEN17WA256](https://openairdocs.org/ntsb/CEN17WA256.md): Lancair IV · Grenaa, Denmark · Accident · No injuries · Foreign investigation · May 12, 2017 · SE-XRU · Substantial damage
  > On May 12, 2017, about 0635 coordinated universal time, a Lancair IV P airplane, Swiss registration SE-XRU, was substantially damaged when it impacted terrain near Grenaa, Denmark. The airplane was registered to and operated by a private individual as a…
- [NTSB GAA17CA279](https://openairdocs.org/ntsb/GAA17CA279.md): Robinson Helicopter R44 · Vevay, IN · Accident · No injuries · Data collection · Final report · May 10, 2017 · N428JG · Substantial damage
  > The pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.
- [NTSB ERA17WA183](https://openairdocs.org/ntsb/ERA17WA183.md): Enstrom Helicopter 480B · Fundres, Italy · Accident · 1 fatal · Foreign investigation · May 10, 2017 · N480W · Destroyed
  > On May 10, 2017, about 1143 universal coordinated time,an Enstrom 480B, N480W, was destroyed during an infight break-up near Fundres, Italy. The flight departed from Bolzano, Italy, and was destined for Linz, Italy. The pilot was fatally injured. This…
- [NTSB ERA17LA176](https://openairdocs.org/ntsb/ERA17LA176.md): Cessna 150M · Homerville, GA · Accident · No injuries · Class 3 · Limited · Final report · May 9, 2017 · N714DW · Substantial damage
  > A total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.
- [NTSB CEN17WA195](https://openairdocs.org/ntsb/CEN17WA195.md): Cessna P210N · San Vicente Tancoayalab, Mexico · Accident · Serious injuries · Foreign investigation · May 9, 2017 · N116DC · Destroyed
  > On May 9, 2017, about 1430 universal coordinated time, a Cessna P210N airplane, N116DC, impacted trees and terrain during an emergency descent near San Vicente Tancoayalab, Mexico, following lightning strikes during cruise. The pilot was seriously injured and…
- [NTSB WPR17LA097](https://openairdocs.org/ntsb/WPR17LA097.md): Robinson Helicopter R44 · Santa Barbara, CA · Accident · Serious injuries · Limited investigation · Final report · May 5, 2017 · N981RR · Destroyed
  > A total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.
- [NTSB GAA17CA261](https://openairdocs.org/ntsb/GAA17CA261.md): Quicksilver Manufacturing SPORT2S R582 · Arecibo, PR · Accident · No injuries · Data collection · Final report · May 5, 2017 · N228KM · Substantial damage
  > The pilot’s failure to see and avoid trees during low-altitude flight.
- [NTSB ERA17WA173](https://openairdocs.org/ntsb/ERA17WA173.md): Robinson R44 · Beloretsk, Russia · Accident · 3 fatal · Foreign investigation · May 4, 2017 · RA-04156 · Substantial damage
  > On May 4, 2017, about 1020 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04156, was substantially damaged when it impacted mountainous terrain during a fire monitoring mission after departing from Beloretsk, Bashkortostan,…
- [NTSB ERA17FA172](https://openairdocs.org/ntsb/ERA17FA172.md): Piper PA31 · Colton, NY · Accident · 1 fatal · Field investigation · Final report · May 4, 2017 · C-GQAM · Destroyed
  > The pilot's incapacitation for unknown reasons, which resulted in an overflight of his destination, a subsequent loss of engine power due to fuel starvation, and collision with terrain.
- [NTSB DCA17CA111](https://openairdocs.org/ntsb/DCA17CA111.md): Airbus A320 232 · Boston, MA · Accident · Serious injuries · Data collection · Final report · May 2, 2017 · N595JB · No damage
  > an inadvertent encounter with convective turbulence.
- [NTSB CEN17LA174](https://openairdocs.org/ntsb/CEN17LA174.md): Bell 407 · Venice, LA · Accident · No injuries · Limited investigation · Final report · May 2, 2017 · N457PH · Substantial damage
  > An in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…
- [NTSB ANC17FA021](https://openairdocs.org/ntsb/ANC17FA021.md): Cessna 208B · Chignik Lake, AK · Accident · 1 fatal · Field investigation · Final report · May 1, 2017 · N803TH · Substantial damage
  > The pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…
- [NTSB ERA17LA169](https://openairdocs.org/ntsb/ERA17LA169.md): Piper PA32RT · Coral Springs, FL · Accident · No injuries · Limited investigation · Final report · Apr 30, 2017 · N31678 · Substantial damage
  > The in-flight disconnection of the fuel injection servo throttle linkage, which resulted in a loss of engine power.
- [NTSB WPR17LA094](https://openairdocs.org/ntsb/WPR17LA094.md): Yakovlev YAK 52 · Porterville, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2017 · N132MD · Substantial damage
  > A partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.
- [NTSB ENG17WA021](https://openairdocs.org/ntsb/ENG17WA021.md): Boeing Boeing 787-9 · London, United Kingdom · Incident · No injuries · Foreign investigation · Apr 29, 2017 · G-ZBKF · No damage
  > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 787-9, which occurred on April 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…

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

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

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