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

## Cases, newest first

- [NTSB CEN19FA165](https://openairdocs.org/ntsb/CEN19FA165.md): Beech V35 · Frankfort, MI · Accident · 2 fatal · Field investigation · Final report · May 13, 2019 · N1561Z · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN19FA140](https://openairdocs.org/ntsb/CEN19FA140.md): Air Tractor AT502 · Eagle Lake, TX · Accident · 1 fatal · Field investigation · Final report · May 11, 2019 · N713LA · Destroyed
  > The non-instrument-rated pilot's decision to fly into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and a subsequent impact with terrain.
- [NTSB ERA19IA178](https://openairdocs.org/ntsb/ERA19IA178.md): Cessna 550 · Savannah, GA · Incident · No injuries · Class 3 · Incident · Final report · May 9, 2019 · N744AT · No damage
  > The lineman's inadvertent introduction of diesel exhaust fluid (DEF) to the fuel truck fuel system icing inhibitor reservoir, which resulted in fuel contamination and a total loss of engine power. Contributing to the accident was the fixed-base operator's…
- [NTSB WPR19LA140](https://openairdocs.org/ntsb/WPR19LA140.md): Cessna 172 · Red Rock, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 6, 2019 · N8887U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA19CA245](https://openairdocs.org/ntsb/GAA19CA245.md): Ercoupe 415 C · Rosendale, WI · Accident · No injuries · Data collection · Final report · May 6, 2019 · N2101H · Substantial damage
  > The pilot's selection of unsuitable terrain for an off-airport precautionary landing, which resulted in impact with a fence and a nose-over.
- [NTSB WPR19LA137](https://openairdocs.org/ntsb/WPR19LA137.md): Grumman G164 · Sutter, CA · Accident · No injuries · Class 3 · Limited · Final report · May 5, 2019 · N3630D · Substantial damage
  > A loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.
- [NTSB CEN19WA137](https://openairdocs.org/ntsb/CEN19WA137.md): Canadair CL 600 2B16 · Coahuila, Mexico · Accident · 14 fatal · Foreign investigation · May 5, 2019 · N601VH · Substantial damage
  > On May 5, 2019, a Challenger Ltd CL-600-2B16 airplane, N601VH, impacted terrain near Coahuila, Mexico. The two pilots and fourteen passengers were fatally injured, and the airplane was substantially damaged. This investigation is under the jurisdiction and…
- [NTSB ANC19WA023](https://openairdocs.org/ntsb/ANC19WA023.md): Cessna 182 · Smithers, Canada · Accident · 3 fatal · Foreign investigation · May 4, 2019 · C-FLVN · Destroyed
  > The government of Canada has notified the NTSB of an accident involving a Cessna 182E airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…
- [NTSB GAA19WA274](https://openairdocs.org/ntsb/GAA19WA274.md): Cessna T210 · Atizapán de Zaragoza, Mexico (jjc airport), Mexico · Accident · 1 fatal · Foreign investigation · May 3, 2019 · XB-OWS · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB DCA19WA222](https://openairdocs.org/ntsb/DCA19WA222.md): Boeing 737 · Narita, Japan · Accident · Serious injuries · Foreign investigation · May 2, 2019 · HL8021 · No damage
  > The government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…
- [NTSB WPR19FA126](https://openairdocs.org/ntsb/WPR19FA126.md): Cessna 182 · Mill Creek, CA · Accident · 1 fatal · Class 3 · Field · Final report · May 1, 2019 · N7302S · Substantial damage
  > A total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.
- [NTSB GAA19WA248](https://openairdocs.org/ntsb/GAA19WA248.md): Piper PA46 · Rigolet, NL, Canada · Accident · 1 fatal · Foreign investigation · May 1, 2019 · N757NY · Destroyed
- [NTSB GAA19CA236](https://openairdocs.org/ntsb/GAA19CA236.md): Cessna 172 · Wasilla, AK · Accident · No injuries · Data collection · Final report · May 1, 2019 · N3031U · Substantial damage
  > The flight instructor's failure to verify the fuel level, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing and collision with a power line pole. Contributing to the accident was the student pilot's…
- [NTSB ERA19FA161](https://openairdocs.org/ntsb/ERA19FA161.md): Cessna 172 · Tyrone, PA · Accident · 2 fatal · Class 3 · Field · Final report · May 1, 2019 · N733KZ · Substantial damage
  > The pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.
- [NTSB WPR19LA125](https://openairdocs.org/ntsb/WPR19LA125.md): Stearman A75N1(PT17) · Sequim, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 28, 2019 · N68825 · Substantial damage
  > The total loss of engine power due to the fatigue failure of the crankshaft.
- [NTSB ERA19LA159](https://openairdocs.org/ntsb/ERA19LA159.md): Zenair Zodiac CH601 · Angier, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 27, 2019 · N61PG · Substantial damage
  > A partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.
- [NTSB CEN19LA129](https://openairdocs.org/ntsb/CEN19LA129.md): Piper PA 23 · Sulphur Spring, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 27, 2019 · N233P · Substantial damage
  > The pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…
- [NTSB ENG19WA022](https://openairdocs.org/ntsb/ENG19WA022.md): Bell 222 · Addis Ababa, Ethiopia · Accident · No injuries · Foreign investigation · Apr 26, 2019 · ET--AVF · Substantial damage
  > On April 26, 2019, a Trans Nation Airways, PLC, Bell 222UT helicopter, registered in Ethiopia as ET-AVF crashed near the Addis Ababa Bole International Airport, Addis Ababa, Ethiopia after both engines, Honeywell LTS101-750 turboshafts, lost power. The…
- [NTSB CEN19LA127](https://openairdocs.org/ntsb/CEN19LA127.md): Beech 50 · Sheldon, MO · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2019 · N29Y · Substantial damage
  > A partial loss of engine power on both engines due to detonation for undetermined reasons.
- [NTSB ERA19LA158](https://openairdocs.org/ntsb/ERA19LA158.md): Acro Super Acro Sport I · Elberton, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 25, 2019 · N20FB · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA19WA225](https://openairdocs.org/ntsb/DCA19WA225.md): Airbus A380 · Si Sa Ket Priovince, Thailand · Occurrence · Class 5 · Foreign · Apr 23, 2019 · HS-TUB · 2 aircraft · No damage
- [NTSB CEN19LA126](https://openairdocs.org/ntsb/CEN19LA126.md): Piper PA28 · Dwight, IL · Accident · No injuries · Class 3 · Limited · Final report · Apr 19, 2019 · N838JH · Substantial damage
  > A partial loss of engine power due to a restriction in fuel flow for undetermined reasons.
- [NTSB WPR19LA111](https://openairdocs.org/ntsb/WPR19LA111.md): MD Helicopter 369 · Hauula, HI · Accident · No injuries · Class 3 · Limited · Final report · Apr 16, 2019 · N593C · Substantial damage
  > Fuel exhaustion as a result of the pilot’s fuel burn miscalculation. Contributing to the accident was the inoperative caution light indicating low fuel level.
- [NTSB ANC19TA017](https://openairdocs.org/ntsb/ANC19TA017.md): Cessna A185 · Nome, AK · Accident · Serious injuries · Class 3 · Final report · Apr 15, 2019 · N5163E · Substantial damage
  > The pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…
- [NTSB WPR19WA225](https://openairdocs.org/ntsb/WPR19WA225.md): Pilatus PC12 · Merredin, Australia · Incident · No injuries · Foreign investigation · Apr 14, 2019 · VH-OWJ · No damage
  > On April 14, 2019, at 0020 local time, a Pilauts PC-12 airplane, VH-OWJ, experienced an uncontrolled pitch down while climbing through 2,600 ft mean sea level near Merredin, Western Australia. The pilot and three passengers were not injured. The airplane was…
- [NTSB WPR19LA108](https://openairdocs.org/ntsb/WPR19LA108.md): Europa XS · Winters, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 13, 2019 · N120EJ · Substantial damage
  > The pilot's failure to properly install a wrist pin circlip, which resulted in internal damage to the No. 5 cylinder and a subsequent total loss of engine power.
- [NTSB GAA19WA230](https://openairdocs.org/ntsb/GAA19WA230.md): Cessna CJ1 · Bournemouth, Dorset, United Kingdom · Incident · No injuries · Foreign investigation · Apr 13, 2019 · N680KH · No damage
  > The government of United Kingdom has notified the NTSB of an accident involving a CESSNA CJ1 airplane that occurred on April 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…
- [NTSB CEN19FA120](https://openairdocs.org/ntsb/CEN19FA120.md): Piper PA28 · Lake, MS · Accident · 1 fatal · Class 3 · Field · Final report · Apr 13, 2019 · N4890L · Destroyed
  > The noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…
- [NTSB CEN19FA119](https://openairdocs.org/ntsb/CEN19FA119.md): Rockwell International NA-265-65 · New Albany, MS · Accident · 3 fatal · Class 2 · Field · Final report · Apr 13, 2019 · N265DS · Destroyed
  > An unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.
- [NTSB ANC19LA016](https://openairdocs.org/ntsb/ANC19LA016.md): Piper PA-32-300 · Bethel, AK · Accident · No injuries · Class 3 · Limited · Final report · Apr 12, 2019 · N4466T · Substantial damage
  > A total loss of engine power due to a fatigue failure of the crankshaft. A contributing factor was the inadequate inspection during the engine’s last overhaul.
- [NTSB WPR19WA107](https://openairdocs.org/ntsb/WPR19WA107.md): Cessna 182 · Wongabel, Australia · Accident · 1 fatal · Foreign investigation · Apr 8, 2019 · VH-DJN · Destroyed
  > On April 8, 2019, about 0740 coordinated universal time a Cessna 182G airplane, VH-DJN, impacted terrain in the Wongabel State Forest, Wongabel, Queensland, Australia. The pilot in command was fatally injured, and the airplane was destroyed. The personal…
- [NTSB ERA19LA143](https://openairdocs.org/ntsb/ERA19LA143.md): Cessna 175 · Edgefield, SC · Accident · No injuries · Class 3 · Limited · Final report · Apr 4, 2019 · N7622M · Substantial damage
  > The total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.
- [NTSB ERA19FA142](https://openairdocs.org/ntsb/ERA19FA142.md): Robinson R44 II · Tampa, FL · Accident · 1 fatal · Field investigation · Final report · Apr 4, 2019 · N4046J · Substantial damage
  > Contamination of and an inadequate bond between the two layers of fabric comprising the helicopter engine's air induction inlet duct, which resulted a partial collapse of the duct, obstruction of the airflow into the engine, and a total loss of engine power.
- [NTSB CEN19LA132](https://openairdocs.org/ntsb/CEN19LA132.md): Piper PA28R · Prairieville, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 3, 2019 · N41AT · Minor damage
  > Installation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…
- [NTSB GAA19WA197](https://openairdocs.org/ntsb/GAA19WA197.md): Cessna P210 · Solunska glava (LBSF), North Macedonia · Accident · 4 fatal · Foreign investigation · Apr 2, 2019 · D-EUIB · Destroyed
  > The government of Macedonia has notified the NTSB of an accident involving a CESSNA P210 airplane that occurred on April 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Macedonia's investigation under the…
- [NTSB WPR19LA104](https://openairdocs.org/ntsb/WPR19LA104.md): Cameron A-400 · Yountville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 1, 2019 · N6954Y · No damage
  > The pilot’s inability to maintain obstacle clearance after the balloon’s encounter with a downdraft, which resulted in a collision with power lines.
- [NTSB WPR19LA102](https://openairdocs.org/ntsb/WPR19LA102.md): Cessna 172 · Placerville, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 31, 2019 · N7033Q · Substantial damage
  > The partial loss of engine power due to an improperly maintained carburetor.
- [NTSB WPR19FA103](https://openairdocs.org/ntsb/WPR19FA103.md): Cirrus SR22 · Farmington, NM · Accident · 1 fatal · Class 3 · Field · Final report · Mar 31, 2019 · N173CT · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.
- [NTSB GAA19WA187](https://openairdocs.org/ntsb/GAA19WA187.md): Epig 1000LT · Egelsbach (Germany), Germany · Accident · 3 fatal · Foreign investigation · Mar 31, 2019 · RA-2151G · Destroyed
  > The government of Germany has notified the NTSB of an accident involving an amateur-built EPIG 1000LT airplane that occurred on March 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under…
- [NTSB ERA19LA141](https://openairdocs.org/ntsb/ERA19LA141.md): Flight Design Ctls · Palatka, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 30, 2019 · N81KK · Substantial damage
  > The pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…
- [NTSB ERA19LA136](https://openairdocs.org/ntsb/ERA19LA136.md): Beech 95B55 · Clewiston, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 25, 2019 · N323MT · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to perform the appropriate emergency checklists following the loss of engine power.
- [NTSB GAA19CA180](https://openairdocs.org/ntsb/GAA19CA180.md): Piper PA23 · Tampa, FL · Accident · No injuries · Data collection · Final report · Mar 24, 2019 · N976AZ · Substantial damage
  > An in-flight collision with a bird during the approach, which resulted in damage to the vertical stabilizer.
- [NTSB ERA19LA137](https://openairdocs.org/ntsb/ERA19LA137.md): Pilatus PC12 · Fort Lauderdale, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 24, 2019 · N944BT · Substantial damage
  > Improper maintenance of the windshield, which resulted in delamination and in-flight depressurization.
- [NTSB ENG19WA025](https://openairdocs.org/ntsb/ENG19WA025.md): Airbus A320 · Guwahati, India · Incident · No injuries · Foreign investigation · Mar 24, 2019 · VT-ITJ · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 24, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 2 (right)…
- [NTSB CEN19LA106](https://openairdocs.org/ntsb/CEN19LA106.md): Robinson R22 · Madill, OK · Accident · No injuries · Class 3 · Limited · Final report · Mar 20, 2019 · N7782H · Substantial damage
  > The failure of the V-belts due to improper maintenance, which resulted in the loss of power to the helicopter's rotor system and subsequent forced landing on rough terrain.
- [NTSB WPR19LA097](https://openairdocs.org/ntsb/WPR19LA097.md): MD Helicopter 369 · Newberg, OR · Accident · No injuries · Class 3 · Limited · Final report · Mar 17, 2019 · N119T · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CEN19FA100](https://openairdocs.org/ntsb/CEN19FA100.md): Cessna 421 · Plain City, OH · Accident · 1 fatal · Class 2 · Field · Final report · Mar 17, 2019 · N424TW · Destroyed
  > A loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.
- [NTSB WPR19LA114](https://openairdocs.org/ntsb/WPR19LA114.md): Great Lakes 2T-1A-2 · San Diego, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 15, 2019 · N101GL · Substantial damage
  > The fracture of the aileron hinge strap due to fatigue crack propagation, which resulted in substantial damage to a wing rib aft of the spar at the outboard aileron cutout. Contributing to the accident was inadequate maintenance inspection.
- [NTSB ERA19FA130](https://openairdocs.org/ntsb/ERA19FA130.md): Mooney M20C · Cashiers, NC · Accident · 1 fatal · Class 3 · Field · Final report · Mar 14, 2019 · N6075Q · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.
- [NTSB GAA19CA168](https://openairdocs.org/ntsb/GAA19CA168.md): Hughes TH 55 · Keene, NH · Accident · No injuries · Data collection · Final report · Mar 13, 2019 · N8045H · Substantial damage
  > The helicopter’s collision with a bird during cruise flight.

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

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

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