# Fatal NTSB investigations: Landing

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 1 of 16 · 766 cases

## Latest cases

- [NTSB ANC27FA003](https://openairdocs.org/ntsb/ANC27FA003.md): Cessna A185F · Kodiak, AK · Accident · 1 fatal · Class 3 · Field · Investigation open · Oct 30, 2026 · N9863Q
- [NTSB ERA27FA004](https://openairdocs.org/ntsb/ERA27FA004.md): Hughes 269B · Lahmansville, WV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 6, 2026 · N9390F · Substantial damage
  > On October 06, 2026, at about 1653 eastern daylight time, a Hughes 269B, N9390F, was substantially damaged when it was involved in an accident near Lahmansville, West Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of…
- [NTSB DCA26MA352](https://openairdocs.org/ntsb/DCA26MA352.md): Boeing 767 · Miami, FL · Accident · 5 fatal · Class 1 · Major · Preliminary report · Sep 6, 2026 · N1997A · Substantial damage
  > On September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…
- [NTSB ANC26FA091](https://openairdocs.org/ntsb/ANC26FA091.md): Piper PA-24-260 · Seldovia, AK · Accident · 4 fatal · Class 3 · Field · Preliminary report · Aug 26, 2026 · N9485P · Substantial damage
  > On August 26, 2026 about 1317 Alaska daylight time, a Piper PA-24-260 airplane, N9485P, was substantially damaged when it was involved in an accident near Seldovia, Alaska. The pilot and three passengers were fatally injured. The airplane was operated as a…
- [NTSB ERA26FA309](https://openairdocs.org/ntsb/ERA26FA309.md): Cessna 150 · Carlisle, PA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 19, 2026 · N23330 · 2 aircraft · Destroyed
  > On August 19, 2026, at 1852 eastern daylight time, a Bell Helicopter Textron Canada 407, N873ST, and a Cessna 150H airplane, N23330, collided in flight near Carlisle, Pennsylvania. The two commercial pilots onboard the helicopter were seriously injured, and…
- [NTSB ANC26FA077](https://openairdocs.org/ntsb/ANC26FA077.md): Piper PA22 · Chitina, AK · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 28, 2026 · N4535A · Destroyed
  > On July 27, 2026, about 2130 Alaska daylight time, a deregistered Piper PA-22-150 airplane, N4535A, was destroyed when it was involved in an accident near Chitina, Alaska. The pilot and two passengers were fatally injured. The airplane was operated as a Title…
- [NTSB CEN26LA238](https://openairdocs.org/ntsb/CEN26LA238.md): Airborne Windsports PTY Edge XT-912-L · Winona, MN · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jun 26, 2026 · N912CV · Substantial damage
  > On June 25, 2026, about 2000 central daylight time, an Airborne Windsports Pty Ltd Edge Xt-912-L weight-shift-control light sport aircraft, N912CV was substantially damaged when it was involved in an accident at Winona Municipal Airport (ONA) Winona,…
- [NTSB ERA26LA207](https://openairdocs.org/ntsb/ERA26LA207.md): I.C.A.-Brasov IS-28B2 · Scotts Fork, VA · Accident · 1 fatal · Class 4 · Limited · Final report · May 12, 2026 · N8217W · Minor damage
  > The photographer’s failure to remain clear of an active taxiway.
- [NTSB WPR26FA151](https://openairdocs.org/ntsb/WPR26FA151.md): Piper PA-32R-301T · Marana, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 9, 2026 · N4190E · Substantial damage
  > On April 08, 2026 at 1710 mountain standard time, a Piper PA-32R-301T, N4190E, sustained substantial damage when it was involved in an accident near Marana, AZ. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of…
- [NTSB DCA26MA161](https://openairdocs.org/ntsb/DCA26MA161.md): Mitsubishi CL-600 · New York, NY · Accident · 2 fatal · Class 1 · Major · Preliminary report · Mar 23, 2026 · C-GNJZ · Substantial damage
  > On March 22, 2026, at 2337 eastern daylight time, Jazz Aviation LP flight 646 (doing business as Air Canada flight 8646), an MHI (Mitsubishi Heavy Industries) RJ Aviation (formerly Bombardier) CL-600-2D24 (CRJ-900) airplane, registration C-GNJZ, was…
- [NTSB ERA26FA115](https://openairdocs.org/ntsb/ERA26FA115.md): Cessna A185 · Everglades City, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 15, 2026 · N7574N · Substantial damage
  > On February 15, 2026, about 1155 eastern standard time, a Cessna A185F, N7574N, was substantially damaged when it was involved in an accident near Everglades City, Florida. The pilot was seriously injured, and the passenger was fatally injured. The airplane…
- [NTSB CEN26FA114](https://openairdocs.org/ntsb/CEN26FA114.md): Beech A36 · Murchison, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 11, 2026 · N3215U · Substantial damage
  > On February 11, 2026, about 1726 central standard time, a Beech A36 airplane, N3215U, sustained substantial damage when it was involved in an accident near Murchison, Texas. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was…
- [NTSB ERA26FA084](https://openairdocs.org/ntsb/ERA26FA084.md): Cessna 172 · Provincetown, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 4, 2026 · N9360E · Substantial damage
  > On January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26MA063](https://openairdocs.org/ntsb/WPR26MA063.md): Cessna 550 · Statesville, NC · Accident · 7 fatal · Class 2 · Major · Preliminary report · Dec 18, 2025 · N257BW · Substantial damage
  > On December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…
- [NTSB GAA26WA034](https://openairdocs.org/ntsb/GAA26WA034.md): Vans RV7 · New South Wales, Australia · Accident · 1 fatal · Class 5 · Foreign · Nov 30, 2025 · VH-EWS · 2 aircraft · Substantial damage
- [NTSB WPR26FA032](https://openairdocs.org/ntsb/WPR26FA032.md): Cirrus Design SR22T · Lincoln, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 25, 2025 · N740TS · Destroyed
  > On October 24, 2025 at 2115 mountain daylight time, a Cirrus SR22T, N740TS, was destroyed when it was involved in an accident near Lincoln, Montana. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…
- [NTSB DCA26WA017](https://openairdocs.org/ntsb/DCA26WA017.md): Boeing 747 · Hong Kong, Hong Kong SAR China · Accident · 2 fatal · Class 3 · Foreign · Oct 19, 2025 · TC-ACF · Substantial damage
- [NTSB CEN26FA005](https://openairdocs.org/ntsb/CEN26FA005.md): Beech 58P · Williston, FL · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 5, 2025 · N121GJ · Destroyed
  > On October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25FA395](https://openairdocs.org/ntsb/CEN25FA395.md): Cessna 340 · Klein, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 28, 2025 · N269WT · Destroyed
  > On September 28, 2025, about 1212 central daylight time, a Cessna 340 airplane, N269WT, was destroyed when it was involved in an accident near Klein, Texas. The pilot and passenger were fatally injured. The airplane was operated as a Title Code of Federal…
- [NTSB GAA25WA265](https://openairdocs.org/ntsb/GAA25WA265.md): Piper PA18 · Cham, Switzerland · Accident · 1 fatal · Class 5 · Foreign · Sep 19, 2025 · HB-ORK · Destroyed
- [NTSB CEN25FA346](https://openairdocs.org/ntsb/CEN25FA346.md): Cessna 340 · Kearney, MO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 27, 2025 · N888MT · Substantial damage
  > On August 27, 2025, about 1158 central daylight time, a Cessna 340A, N888MT, was substantially damaged when it was involved in an accident near Kearney, Missouri. The pilot and passenger were fatally injured. The airplane operated as a Title 14 Code of…
- [NTSB ERA25FA309](https://openairdocs.org/ntsb/ERA25FA309.md): Cessna A185F · Bangor, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 22, 2025 · N714HE · Substantial damage
  > On August 22, 2025, at 1321 eastern daylight time, a Cessna A185F, N714HE, was substantially damaged when it was involved in an accident near Bangor, Maine. The pilot was fatally injured. The flight was being conducted as a 14 Code of Federal Regulations Part…
- [NTSB WPR25FA252](https://openairdocs.org/ntsb/WPR25FA252.md): Vans RV-7A · West Glacier, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 12, 2025 · N30SG · Substantial damage
  > On August 12, 2025, about 1457 mountain daylight time, an experimental amateur-built Vans RV-7A N30SG, was substantially damaged when it was involved in an accident near West Glacier, Montana. The pilot was fatally injured. The airplane was operated as a…
- [NTSB ERA25FA280](https://openairdocs.org/ntsb/ERA25FA280.md): Piper PA-28-181 · Block Island, RI · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 30, 2025 · N961DA · Substantial damage
  > On July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…
- [NTSB ERA25FA239](https://openairdocs.org/ntsb/ERA25FA239.md): Piper J3C-65 · Dunlap, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 24, 2025 · N28DR · Substantial damage
  > On June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…
- [NTSB ERA25FA185](https://openairdocs.org/ntsb/ERA25FA185.md): MX Aircraft Tech PTY MXS · Hampton, VA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 24, 2025 · N530RH · Substantial damage
  > A counterweight plug that loosened during the accident flight, jammed the elevator, and resulted in loss of control during landing.
- [NTSB WPR25FA088](https://openairdocs.org/ntsb/WPR25FA088.md): Gates Learjet 35A · Scottsdale, AZ · Accident · 1 fatal · Class 2 · Field · Preliminary report · Feb 10, 2025 · N81VN · Substantial damage
  > On February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously…
- [NTSB GAA25WA056](https://openairdocs.org/ntsb/GAA25WA056.md): Cessna 525 · Ubatuba, Brazil · Accident · 1 fatal · Class 4 · Foreign · Jan 9, 2025 · PR-GFS · Substantial damage
- [NTSB DCA25WA072](https://openairdocs.org/ntsb/DCA25WA072.md): Boeing 737 · Muan County, South Korea · Accident · 173 fatal · Class 2 · Foreign · Dec 29, 2024 · HL8088
- [NTSB GAA25WA044](https://openairdocs.org/ntsb/GAA25WA044.md): Bombardier BD100 · San Fernando, Argentina · Accident · 2 fatal · Class 5 · Foreign · Dec 18, 2024 · LV-GOK · Substantial damage
- [NTSB DCA25WA046](https://openairdocs.org/ntsb/DCA25WA046.md): Boeing 737 · Vilnius, Lithuania · Accident · 1 fatal · Class 3 · Foreign · Nov 25, 2024 · EC-MFE · Substantial damage
- [NTSB WPR25FA002](https://openairdocs.org/ntsb/WPR25FA002.md): Taylor J-2 · Roseburg, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 3, 2024 · N19252 · Substantial damage
  > On October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA24FA397](https://openairdocs.org/ntsb/ERA24FA397.md): Cirrus Design SR22 · Kill Devil Hills, NC · Accident · 5 fatal · Class 3 · Field · Final report · Sep 28, 2024 · N1281F · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB GAA24WA274](https://openairdocs.org/ntsb/GAA24WA274.md): Piper 38 · Córdoba, Spain · Accident · 1 fatal · Class 5 · Foreign · Aug 31, 2024 · EC-KYX · Substantial damage
- [NTSB WPR24FA288](https://openairdocs.org/ntsb/WPR24FA288.md): Textron T206H · Yellow Pine, ID · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 29, 2024 · N712AM · Destroyed
  > On August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR24FA285](https://openairdocs.org/ntsb/WPR24FA285.md): Cessna A185F · Kent, WA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 24, 2024 · N61323 · Substantial damage
  > The pilot’s failure to properly configure the amphibious landing gear for a water landing, which resulted in a touchdown on the water with the wheels extended, noseover, and airplane submersion.
- [NTSB CEN24FA325](https://openairdocs.org/ntsb/CEN24FA325.md): Arrow Falcon Exporters OH-58A+ · Newton, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 23, 2024 · N199BD · Substantial damage
  > On August 23, 2024, about 1330 central daylight time, a restricted category Arrow Falcon Exporters OH-58A helicopter, N199BD was substantially damaged when it was involved in an accident near Newton, Texas. The pilot was fatally injured and one person on the…
- [NTSB GAA24WA246](https://openairdocs.org/ntsb/GAA24WA246.md): Zodiac CH601XL · Tambon Khok Kham, Thailand · Accident · 1 fatal · Class 5 · Foreign · Aug 3, 2024 · HS-DEV · Destroyed
- [NTSB GAA24WA238](https://openairdocs.org/ntsb/GAA24WA238.md): Supermarine Spitfire MK26 · West Oxfordshire, United Kingdom · Accident · 1 fatal · Class 5 · Foreign · Jul 28, 2024 · G-ENAA · Substantial damage
- [NTSB WPR24FA252](https://openairdocs.org/ntsb/WPR24FA252.md): Textron T206H · Kneeland, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jul 23, 2024 · N460DC · Destroyed
  > The pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.
- [NTSB GAA24WA072](https://openairdocs.org/ntsb/GAA24WA072.md): Piper PA 46-350P · Ramos Arizpe, Coahuila,, Mexico · Accident · 4 fatal · Class 5 · Foreign · Jan 5, 2024 · N6074A · Destroyed
- [NTSB GAA24WA014](https://openairdocs.org/ntsb/GAA24WA014.md): Cessna 172 · Barrancabermeja, Colombia · Accident · 1 fatal · Class 4 · Foreign · Oct 19, 2023 · HK-2465G · Substantial damage
- [NTSB GAA24WA015](https://openairdocs.org/ntsb/GAA24WA015.md): Cessna 172N · Merriton, Australia · Accident · 2 fatal · Class 5 · Foreign · Oct 8, 2023 · VH-RSB
- [NTSB WPR24FA001](https://openairdocs.org/ntsb/WPR24FA001.md): Cubcrafters CCK-1865 · Twisp, WA · Accident · 1 fatal · Class 3 · Field · Final report · Oct 1, 2023 · N56DV · Substantial damage
  > The pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.
- [NTSB CEN23LA423](https://openairdocs.org/ntsb/CEN23LA423.md): Beech A36 · Broken Bow, OK · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 29, 2023 · N9379Q · Substantial damage
  > The pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…
- [NTSB CEN23FA369](https://openairdocs.org/ntsb/CEN23FA369.md): Piper J5A · Iola, WI · Accident · 1 fatal · Class 3 · Field · Final report · Aug 19, 2023 · N35417 · Substantial damage
  > The pilot’s failure to maintain control of the airplane after landing on a grass taxiway with a tailwind, which resulted in a nose over.
- [NTSB GAA23WA188](https://openairdocs.org/ntsb/GAA23WA188.md): Cessna 206 · Gracias A Dios, Honduras · Accident · 2 fatal · Class 5 · Foreign · Jul 3, 2023 · HR-NCH · Substantial damage
- [NTSB GAA23WA148](https://openairdocs.org/ntsb/GAA23WA148.md): Cessna 185 · Sao Paulo, Brazil · Accident · 2 fatal · Class 5 · Foreign · Apr 30, 2023 · PP-NIK · Substantial damage
- [NTSB GAA23WA131](https://openairdocs.org/ntsb/GAA23WA131.md): Cirrus SR22 · Bankstown, Australia · Accident · 1 fatal · Class 5 · Foreign · Apr 17, 2023 · VH-XGR · Substantial damage
- [NTSB GAA23WA095](https://openairdocs.org/ntsb/GAA23WA095.md): Cessna 182 · Belo Horizonte, Brazil · Accident · 1 fatal · Class 4 · Foreign · Mar 11, 2023 · PT-FLK · Substantial damage

Next page: https://openairdocs.org/ntsb-phases/550/cases.md?fatal=1&page=2

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?fatal=1

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