# Fatal NTSB investigations: Maneuvering

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 129 · 6,439 cases

## Latest cases

- [NTSB ERA27FA010](https://openairdocs.org/ntsb/ERA27FA010.md): Bell 407 · Myakka City, FL · Accident · 1 fatal · Class 3 · Field · Investigation open · Oct 16, 2026 · N618TS
- [NTSB WPR26FA354](https://openairdocs.org/ntsb/WPR26FA354.md): Cessna 172B · Royal City, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N44P · Substantial damage
  > On September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA352](https://openairdocs.org/ntsb/WPR26LA352.md): Beech B95 · Newport, OR · Accident · 1 fatal · Class 4 · Limited · Investigation open · Sep 21, 2026 · N529RB
- [NTSB WPR26FA346](https://openairdocs.org/ntsb/WPR26FA346.md): Airbus AS332 · Yosemite Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2026 · N332N · Destroyed
  > On September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…
- [NTSB WPR26FA345](https://openairdocs.org/ntsb/WPR26FA345.md): Eurocopter AS 350 B2 · Chatsworth, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 16, 2026 · N358TV · Destroyed
  > On September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…
- [NTSB ERA26FA338](https://openairdocs.org/ntsb/ERA26FA338.md): Reed Julian Estill RV-4 · Albertville, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N469TW · Substantial damage
  > On September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…
- [NTSB WPR26FA320](https://openairdocs.org/ntsb/WPR26FA320.md): Mooney M20C · Mount Hood, OR · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 31, 2026 · N2783W · Substantial damage
  > On August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26FA294](https://openairdocs.org/ntsb/ERA26FA294.md): Bachem Fritz M Avid Mark IV · Arp, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 9, 2026 · N77FB · Substantial damage
  > On August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…
- [NTSB ANC26FA079](https://openairdocs.org/ntsb/ANC26FA079.md): Helicopter Transport Services CH-54A · Cove Fort, UT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N793HT · Destroyed
  > On August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…
- [NTSB WPR26FA289](https://openairdocs.org/ntsb/WPR26FA289.md): Cirrus Design SR22T · Bend, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 5, 2026 · N625LK · Substantial damage
  > On August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…
- [NTSB CEN26FA247](https://openairdocs.org/ntsb/CEN26FA247.md): Kaman Aerospace K-1200 · Silver Jack Reservoir, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2026 · N40HX · Substantial damage
  > On July 12, 2026, about 1705 mountain daylight time, a Kaman Aerospace Corporation K-1200 (K-MAX) helicopter, N40HX, was substantially damaged when it was involved in an accident at Silver Jack Reservoir, Colorado. The pilot was fatally injured. The…
- [NTSB WPR26FA233](https://openairdocs.org/ntsb/WPR26FA233.md): Cessna 195 · Pasco, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N3877V · Substantial damage
  > On June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…
- [NTSB GAA26WA239](https://openairdocs.org/ntsb/GAA26WA239.md): Supermarine Spitfire · Muluckine, Australia · Accident · 1 fatal · Class 5 · Foreign · Jun 24, 2026 · VH-SFX · Substantial damage
- [NTSB WPR26FA216](https://openairdocs.org/ntsb/WPR26FA216.md): Piper PA-36-300 · Henderson, NE · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 12, 2026 · N57846 · Substantial damage
  > On June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26FA207](https://openairdocs.org/ntsb/CEN26FA207.md): Robinson Helicopter R66 · Dawsonville, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 30, 2026 · N4488H · Substantial damage
  > On May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…
- [NTSB WPR26FA198](https://openairdocs.org/ntsb/WPR26FA198.md): Mooney M20J · Woodlake, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 23, 2026 · N4452H · Destroyed
  > On May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…
- [NTSB ERA26FA205](https://openairdocs.org/ntsb/ERA26FA205.md): Cessna A185F · Avon, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 12, 2026 · N61368 · Substantial damage
  > On May 12, 2026, about 1058 eastern daylight time, a Cessna A185F airplane, N61368, was substantially damaged when it was involved in an accident near Avon, Maine. The pilot was fatally injured. The airplane was owned by the state of Maine and operated as a…
- [NTSB CEN26FA184](https://openairdocs.org/ntsb/CEN26FA184.md): North American F-51D · Mound, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 12, 2026 · N251CS · Substantial damage
  > On May 12, 2026, at 1519 central daylight time, a North American F-51D airplane, N251CS, was destroyed when it was involved in an accident at the Vicksburg Tallulah Regional Airport (TVR), Mound, Louisiana. The pilot was fatally injured. The airplane was…
- [NTSB ERA26FA166](https://openairdocs.org/ntsb/ERA26FA166.md): North American AT-6D · Bronson, FL · Accident · 2 fatal · Class 3 · Field · Investigation open · Apr 13, 2026 · N29678 · Destroyed
- [NTSB ERA26FA165](https://openairdocs.org/ntsb/ERA26FA165.md): Beech 58 · New Market, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 13, 2026 · N2063G · Destroyed
  > On April 13, 2026, about 1308 eastern daylight time, a Beechcraft 58 multi-engine airplane, N2063G, was destroyed when it was involved in an accident near New Market, Tennessee. The flight instructor and the commercial pilot were fatally injured. The airplane…
- [NTSB GAA26WA142](https://openairdocs.org/ntsb/GAA26WA142.md): Cessna 172 · Ausnek, Namibia · Accident · 1 fatal · Class 5 · Foreign · Mar 29, 2026 · D-EGZE · Substantial damage
- [NTSB WPR26FA121](https://openairdocs.org/ntsb/WPR26FA121.md): MD Helicopters 369FF · Mojave, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 9, 2026 · N530XX · Substantial damage
  > On March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB GAA26WA117](https://openairdocs.org/ntsb/GAA26WA117.md): Robinson R44 · Amaranka, Russia · Accident · 3 fatal · Class 5 · Foreign · Feb 19, 2026 · RA-04261 · Destroyed
- [NTSB WPR26FA098](https://openairdocs.org/ntsb/WPR26FA098.md): Bell 407 · Flagstaff, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 5, 2026 · N56AZ · Destroyed
  > On February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…
- [NTSB WPR26FA074](https://openairdocs.org/ntsb/WPR26FA074.md): MD Helicopters 369FF · Superior, AZ · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jan 2, 2026 · N3502P · Substantial damage
  > On January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter…
- [NTSB ERA26FA077](https://openairdocs.org/ntsb/ERA26FA077.md): Enstrom 280 · Hammonton, NJ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 28, 2025 · N280MG · 2 aircraft · Destroyed
  > On December 28, 2025, at 1124 eastern standard time, an Enstrom F-28A helicopter, N520H, and an Enstrom 280C helicopter, N280MG, collided in midair near Hammonton, New Jersey. The private pilots onboard each of the helicopters were fatally injured. Both…
- [NTSB GAA26WA059](https://openairdocs.org/ntsb/GAA26WA059.md): Cessna 170 · Rio de Janeiro, Brazil · Accident · 1 fatal · Class 5 · Foreign · Dec 27, 2025 · PT-AGB · Substantial damage
- [NTSB WPR26FA054](https://openairdocs.org/ntsb/WPR26FA054.md): Hughes 369D · Pryor, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 5, 2025 · N161LA · Substantial damage
  > On December 5, 2025, about 0858 central standard time, a Hughes 369D, N161LA, was substantially damaged when it was involved in an accident near Pryor, Oklahoma. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA039](https://openairdocs.org/ntsb/ERA26FA039.md): Jabiru USA Sport J230-SP · New Bavaria, OH · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 14, 2025 · N755J · Substantial damage
  > On November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…
- [NTSB GAA26WA025](https://openairdocs.org/ntsb/GAA26WA025.md): Air Tractor AT401 · Jaú, Brazil · Accident · 1 fatal · Class 5 · Foreign · Nov 11, 2025 · PT-WBU · Substantial damage
- [NTSB ERA26FA035](https://openairdocs.org/ntsb/ERA26FA035.md): Airbus Helicopters EC 130 T2 · Lebanon, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N107VU · Substantial damage
  > On November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was…
- [NTSB ERA26FA034](https://openairdocs.org/ntsb/ERA26FA034.md): Extra Flugzeugproduktions EA 300/SC · Keystone Heights, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N330SL · Destroyed
  > On November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA019](https://openairdocs.org/ntsb/ERA26FA019.md): Cirrus SR22 · Ruston, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 21, 2025 · N42BE · Destroyed
  > On October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ANC26FA002](https://openairdocs.org/ntsb/ANC26FA002.md): Raytheon Hawker 800XP · Bath, MI · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 16, 2025 · XA-JMR · Destroyed
  > On October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.…
- [NTSB GAA26WA007](https://openairdocs.org/ntsb/GAA26WA007.md): Robinson R22 · Rutland Plains, Australia · Accident · 1 fatal · Class 5 · Foreign · Oct 9, 2025 · VH-LYD · Destroyed
- [NTSB GAA26WA003](https://openairdocs.org/ntsb/GAA26WA003.md): Robinson R22 · Brogans Creek, Australia · Accident · 1 fatal · Class 4 · Foreign · Oct 3, 2025 · VH-RDL · Destroyed
- [NTSB WPR25FA294](https://openairdocs.org/ntsb/WPR25FA294.md): Cessna 172F · Battle Ground, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2025 · N8219U · Destroyed
  > On September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25FA388](https://openairdocs.org/ntsb/CEN25FA388.md): North American T-6G · Louise, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2025 · N32SZ · Substantial damage
  > On September 20, 2025, about 1724 central daylight time, a North American T-6G airplane, N32SZ, was destroyed when it was involved in an accident near Lousie, Texas. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14…
- [NTSB ERA25FA344](https://openairdocs.org/ntsb/ERA25FA344.md): Hughes 369D · Jim Thorpe, PA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 11, 2025 · N5072F · Destroyed
  > On September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The…
- [NTSB GAA25WA255](https://openairdocs.org/ntsb/GAA25WA255.md): Air Tractor AT802 · Yeelanna, Australia · Accident · 1 fatal · Class 5 · Foreign · Sep 8, 2025 · VH-ODX · Substantial damage
- [NTSB CEN25FA339](https://openairdocs.org/ntsb/CEN25FA339.md): Rans S-12 Airaile · Concordia, KS · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 25, 2025 · N2757A · Substantial damage
  > On August 24, 2025, about 1926 central daylight time, a Rans S-12 Airaile airplane, N2757A, was substantially damaged when it was involved in an accident near Concordia, Kansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25FA253](https://openairdocs.org/ntsb/WPR25FA253.md): Pitts S-1T · Goodyear, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 12, 2025 · N51HC · Substantial damage
  > On August 12, 2025, about 1019 mountain standard time, a Pitts S-1T, N51HC, was substantially damaged when it was involved in an accident near Goodyear, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25FA307](https://openairdocs.org/ntsb/CEN25FA307.md): Hughes 369D · West Alton, MO · Accident · 2 fatal · Class 3 · Field · Final report · Aug 7, 2025 · N173AL · Destroyed
  > The pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.
- [NTSB GAA25WA222](https://openairdocs.org/ntsb/GAA25WA222.md): Lional Ray Ward Ward F-4 Rocket · Mallorca, Spain · Accident · 2 fatal · Class 5 · Foreign · Aug 2, 2025 · N31VX · Substantial damage
- [NTSB WPR25FA233](https://openairdocs.org/ntsb/WPR25FA233.md): Cessna 152 · Hornell, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N6125B · Destroyed
  > On August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN25FA289](https://openairdocs.org/ntsb/CEN25FA289.md): Piper PA-22-150 · New Underwood, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 28, 2025 · N9642D · Substantial damage
  > On July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…
- [NTSB CEN25FA281](https://openairdocs.org/ntsb/CEN25FA281.md): Bell Helicopter Textron 206L-1 · Thibodaux, LA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 23, 2025 · N2611 · Destroyed
  > The pilot’s failure to maintain clearance to powerlines during an agricultural application pass.
- [NTSB GAA25WA244](https://openairdocs.org/ntsb/GAA25WA244.md): ProMecc Aerosapce Freccia FG · Azzano Mella, Italy · Accident · 2 fatal · Class 3 · Foreign · Jul 22, 2025 · I-E607 · Destroyed
- [NTSB CEN25FA273](https://openairdocs.org/ntsb/CEN25FA273.md): Cessna T188C · Oregon, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 22, 2025 · N2802J · Substantial damage
  > On July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN25FA247](https://openairdocs.org/ntsb/CEN25FA247.md): Zenith CH601 · Pawnee National Grassland, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N314LB · Destroyed
  > On July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/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.