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

## Cases, newest first

- [NTSB CEN19LA015](https://openairdocs.org/ntsb/CEN19LA015.md): Cessna 172 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 27, 2018 · N3973L · Substantial damage
  > The pilot's failure to apply carburetor heat while operating in an area conducive to carburetor icing, which resulted in a total loss of engine power on approach and subsequent forced landing into a creek.
- [NTSB ERA19LA026](https://openairdocs.org/ntsb/ERA19LA026.md): Piper PA31T · Atlantic Ocean (Atlantic Ocean) · Accident · 5 fatal · Limited investigation · Final report · Oct 25, 2018 · N555PM · Destroyed
  > An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.
- [NTSB WPR19LA014](https://openairdocs.org/ntsb/WPR19LA014.md): North American SNJ · Agoura Hills, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 23, 2018 · N7969C · Destroyed
  > The failure of the No. 5 piston rod end due to fatigue, which resulted in a total loss of engine power.
- [NTSB WPR19LA013](https://openairdocs.org/ntsb/WPR19LA013.md): Robinson R44 · Kaneohe, HI · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 23, 2018 · N4132H · Substantial damage
  > The pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.
- [NTSB WPR19LA011](https://openairdocs.org/ntsb/WPR19LA011.md): Piper PA32R · Indianapolis, IN · Accident · No injuries · Class 3 · Limited · Final report · Oct 21, 2018 · N2920Q · Substantial damage
  > A total loss of engine power due to displacement of the dual magneto’s internal camshaft, which resulted in the magneto’s inability to produce spark.
- [NTSB WPR19LA010](https://openairdocs.org/ntsb/WPR19LA010.md): Piper PA46 · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2018 · N413LL · Substantial damage
  > The mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.
- [NTSB ERA19LA022](https://openairdocs.org/ntsb/ERA19LA022.md): Piper PA22 · Brownstown, IN · Accident · No injuries · Limited investigation · Final report · Oct 20, 2018 · N5581Z · Destroyed
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…
- [NTSB DCA19WA015](https://openairdocs.org/ntsb/DCA19WA015.md): Boeing 787 · Hong Kong, China · Incident · No injuries · Foreign investigation · Oct 20, 2018 · VT-ANE · No damage
  > The government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…
- [NTSB ERA19FA020](https://openairdocs.org/ntsb/ERA19FA020.md): Bowers Flybaby · Milton, FL · Accident · 1 fatal · Field investigation · Final report · Oct 19, 2018 · N107KW · Substantial damage
  > A loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall at low altitude.
- [NTSB DCA19WA027](https://openairdocs.org/ntsb/DCA19WA027.md): Boeing 737 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Oct 19, 2018 · HS-LTJ · No damage
  > The AAIC of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIC of Thailand's investigation under the provisions of ICAO…
- [NTSB WPR19WA012](https://openairdocs.org/ntsb/WPR19WA012.md): Hughes 369 · Wanaka, New Zealand · Accident · 3 fatal · Class 5 · Foreign · Oct 17, 2018 · ZK-H0J · Destroyed
- [NTSB DCA19WA071](https://openairdocs.org/ntsb/DCA19WA071.md): Boeing 747 · Kolkata, India · Incident · No injuries · Foreign investigation · Oct 16, 2018 · N578UP · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…
- [NTSB CEN19FA008](https://openairdocs.org/ntsb/CEN19FA008.md): Cessna 182 · Canoncito, NM · Accident · 2 fatal · Class 3 · Field · Final report · Oct 16, 2018 · N9326G · Substantial damage
  > The partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.
- [NTSB ERA19LA014](https://openairdocs.org/ntsb/ERA19LA014.md): Hargrove Hummel Ultra Cruiser · Zephyrhills, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 15, 2018 · N245AP · Substantial damage
  > The pilot's failure to activate the airplane’s auxiliary fuel pump, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were the impairing effects of the pilot’s medication on his performance.
- [NTSB DCA19CA207](https://openairdocs.org/ntsb/DCA19CA207.md): Boeing 737 · Albany, NY · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 15, 2018 · N7816B · No damage
  > an encounter with convective turbulence that resulted in a serious injury to a flight attendant.
- [NTSB ERA19LA015](https://openairdocs.org/ntsb/ERA19LA015.md): Avid Avid Flyer · Grant-Valkaria, FL · Accident · No injuries · Class 3 · Limited · Final report · Oct 13, 2018 · N3HH · Substantial damage
  > A total loss of engine power due to a carburetor malfunction, which resulted in a forced landing.
- [NTSB ERA19LA012](https://openairdocs.org/ntsb/ERA19LA012.md): Piper PA34 · Westhampton Beach, NY · Accident · 3 fatal · Limited investigation · Final report · Oct 13, 2018 · N593MS · Destroyed
  > The instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…
- [NTSB CEN19FA005](https://openairdocs.org/ntsb/CEN19FA005.md): Piper PA28 · Cartersville, GA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2018 · N180QT · Destroyed
  > The pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA19WA013](https://openairdocs.org/ntsb/DCA19WA013.md): Boeing 737 · East Midlands, United Kingdom · Incident · No injuries · Foreign investigation · Oct 12, 2018 · G-JMCR · No damage
  > The government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…
- [NTSB CEN19LA002](https://openairdocs.org/ntsb/CEN19LA002.md): Cirrus SR22 · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 2018 · N729TG · Substantial damage
  > The loss of engine power due to excessive fuel flow.
- [NTSB CEN19FA004](https://openairdocs.org/ntsb/CEN19FA004.md): Piper PA32RT · Poolville, TX · Accident · 2 fatal · Field investigation · Final report · Oct 12, 2018 · N221MC · Destroyed
  > The pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.
- [NTSB CEN19FA003](https://openairdocs.org/ntsb/CEN19FA003.md): Air Tractor AT502 · Placedo, TX · Accident · 1 fatal · Field investigation · Final report · Oct 12, 2018 · N6135P · Destroyed
  > The pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.
- [NTSB DCA19CA006](https://openairdocs.org/ntsb/DCA19CA006.md): Boeing 737 · San Jose, CA · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 11, 2018 · N734SA · No damage
  > A passenger falling while returning to her seat which resulted in a serious injury.
- [NTSB DCA19CA005](https://openairdocs.org/ntsb/DCA19CA005.md): Boeing 737 · Nashville, TN · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 10, 2018 · N287WN · No damage
  > flight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.
- [NTSB WPR19LA003](https://openairdocs.org/ntsb/WPR19LA003.md): Piper PA28 · Grass Valley, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 8, 2018 · N2250S · Substantial damage
  > A loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.
- [NTSB WPR19LA002](https://openairdocs.org/ntsb/WPR19LA002.md): Robinson R44 · Salinas, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 7, 2018 · N611TH · Substantial damage
  > The partial loss of engine power after takeoff due to faulty wiring to the engine governor.
- [NTSB GAA19CA015](https://openairdocs.org/ntsb/GAA19CA015.md): Titan Titan Tornado 912 · Corry, PA · Accident · No injuries · Data collection · Final report · Oct 7, 2018 · N912R · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB ERA19FA003](https://openairdocs.org/ntsb/ERA19FA003.md): Piper J3C · Fancy Gap, VA · Accident · 1 fatal · Field investigation · Final report · Oct 6, 2018 · N38811 · Substantial damage
  > The non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…
- [NTSB ERA19LA008](https://openairdocs.org/ntsb/ERA19LA008.md): North American Navion A · Stonewall, MS · Accident · No injuries · Limited investigation · Final report · Oct 5, 2018 · N969TR · Substantial damage
  > The fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a fractured camshaft and a total loss of engine power.
- [NTSB DCA19WA009](https://openairdocs.org/ntsb/DCA19WA009.md): Boeing 737 · Zagreb, Croatia · Incident · Minor injuries · Foreign investigation · Oct 2, 2018 · TC-AMP · No damage
  > The AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…
- [NTSB CEN19WA001](https://openairdocs.org/ntsb/CEN19WA001.md): Cessna 210 5 · Yécora, Mexico · Accident · 3 fatal · Foreign investigation · Oct 1, 2018 · N8388Z · Substantial damage
  > On October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…
- [NTSB CEN18LA392](https://openairdocs.org/ntsb/CEN18LA392.md): Cirrus SR22 · Addison, TX · Accident · No injuries · Limited investigation · Final report · Sep 30, 2018 · N818GM · Substantial damage
  > Maintenance personnel’s improper installation of the muffler attachment hardware, which resulted in the muffler separating in flight, thermal damage that interrupted the magnetos’ function, and the subsequent total loss of engine power.
- [NTSB ERA18LA265](https://openairdocs.org/ntsb/ERA18LA265.md): Piper PA32 · Bartow, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2018 · N4592X · Substantial damage
  > A total loss of engine power after the separation of the No. 3 cylinder from the crankcase due to improper maintenance.
- [NTSB DCA18WA300](https://openairdocs.org/ntsb/DCA18WA300.md): Boeing 737 · Diagoras, Hungary · Incident · No injuries · Foreign investigation · Sep 28, 2018 · N917XA · No damage
  > The government of Hungary has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Hungary's investigation under the…
- [NTSB CEN18FA391](https://openairdocs.org/ntsb/CEN18FA391.md): Airbus Helicopters AS350 · Gustavus, AK · Accident · 3 fatal · Field investigation · Final report · Sep 28, 2018 · N907PL · Destroyed
  > The pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.
- [NTSB ANC18WA078](https://openairdocs.org/ntsb/ANC18WA078.md): Cessna 208 · Narita, Japan · Accident · 1 fatal · Foreign investigation · Sep 27, 2018 · VH-FAY · Destroyed
  > On September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…
- [NTSB ANC18LA073](https://openairdocs.org/ntsb/ANC18LA073.md): Cessna A185 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 27, 2018 · N70391 · Substantial damage
  > The total loss of engine power due to fuel exhaustion.
- [NTSB ANC18LA072](https://openairdocs.org/ntsb/ANC18LA072.md): Cessna 182 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 2018 · N2571G · Substantial damage
  > The pilot's failure to avoid wake turbulence from a crossing heavy airplane.
- [NTSB DCA18WA296](https://openairdocs.org/ntsb/DCA18WA296.md): Airbus A320 · Tijuana, Mexico · Incident · Minor injuries · Foreign investigation · Sep 26, 2018 · XA-VOW
  > The government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB CEN18WA390](https://openairdocs.org/ntsb/CEN18WA390.md): Robinson R44 · Buttonville, Canada · Accident · 1 fatal · Foreign investigation · Sep 25, 2018 · C-GMCT · Substantial damage
  > On September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…
- [NTSB ERA18LA271](https://openairdocs.org/ntsb/ERA18LA271.md): Bell OH 58A · Juana Diaz, PR · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 24, 2018 · N206WH · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18FA386](https://openairdocs.org/ntsb/CEN18FA386.md): Cessna U206 · Rainy Pass, AK · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2018 · N1738R · Destroyed
  > The pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.
- [NTSB ERA18TA263](https://openairdocs.org/ntsb/ERA18TA263.md): Zenith CH 750 · DeLeon Springs, FL · Accident · Minor injuries · Final report · Sep 23, 2018 · N752VK · Substantial damage
  > The pilot's operation of the airplane with the alternator switch in the off position, which allowed the selected battery to discharge and resulted in an ignition system failure and a total loss of engine power.
- [NTSB WPR18WA282](https://openairdocs.org/ntsb/WPR18WA282.md): Bell 206 · Yarraden, Australia · Accident · Minor injuries · Foreign investigation · Sep 22, 2018 · VH-HZO · Substantial damage
  > On September 22, 2018, at 2045 coordinated universal time, a Bell 206B helicopter, registration VH-HZO, sustained substantial damage after colliding with the ground following a total loss of power near Yarraden, Australia. The pilot was not injured. The three…
- [NTSB DCA18CA303](https://openairdocs.org/ntsb/DCA18CA303.md): Embraer EMB120 · 40 nm vicinity south of Lake Jackson, TX · Accident · No injuries · Class 4 · Data collection · Final report · Sep 20, 2018 · N233SW · Substantial damage
  > an encounter with severe turbulence, which caused the improperly secured cargo to shift and damage the airplane floor structure.
- [NTSB WPR18LA269](https://openairdocs.org/ntsb/WPR18LA269.md): Robinson R44 · Wahiawa, HI · Accident · No injuries · Class 3 · Limited · Final report · Sep 18, 2018 · N632NV · Substantial damage
  > Loss of oil in flight as a result of a loose oil filter adapter which resulted in the pilot initiating an immediate landing to an open field. Contributing to the accident was the pilot's manipulation of the throttle that led to a reduction in rotor rpm, which…
- [NTSB WPR18LA265](https://openairdocs.org/ntsb/WPR18LA265.md): Schweizer 300CBi 269C1 · Granada Hills, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 15, 2018 · N2128T · Substantial damage
  > A partial loss of engine power that was the result of a loss of compression in the No. 1 and 4 cylinders due to damage and material separation from the exhaust valve heads, which resulted in a subsequent forced, hard landing. Contributing to the accident was…
- [NTSB ERA18WA252](https://openairdocs.org/ntsb/ERA18WA252.md): Beech C90 · Ipumirim County, Brazil · Accident · 1 fatal · Foreign investigation · Sep 15, 2018 · PR-RFB. · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on September 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB ERA18TA250](https://openairdocs.org/ntsb/ERA18TA250.md): American AA1 · Warthen, GA · Accident · Minor injuries · Final report · Sep 14, 2018 · N9218L · Substantial damage
  > A fuel leak from the carburetor float bowl due to a missing plug, which resulted in excessive fuel consumption and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to depart on the accident flight leg…
- [NTSB DCA18WA302](https://openairdocs.org/ntsb/DCA18WA302.md): Boeing 737 · Edinburgh, United Kingdom · Incident · No injuries · Foreign investigation · Sep 10, 2018 · EI-GJT · No damage
  > The Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…

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

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

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