# Fatal 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 1 of 197 · 9,804 cases ## Latest cases - [NTSB CEN27FA016](https://openairdocs.org/ntsb/CEN27FA016.md): Piper PA 46-350P · Reedsburg, WI · Accident · 6 fatal · Class 3 · Field · Preliminary report · Oct 14, 2026 · N931TT · Destroyed > On October 13, 2026, about 2130 central daylight time, a Piper Aircraft PA-46-350P JetProp DLX airplane, N931TT, was destroyed when it was involved in an accident near Reedsburg, Wisconsin. The pilot, the pilot-rated passenger, and the four passengers… - [NTSB WPR27FA014](https://openairdocs.org/ntsb/WPR27FA014.md): Piper PA-18-150 · Wauconda, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 11, 2026 · N927JS · Destroyed > On October 10, 2026, about 2014 Pacific daylight time, a Piper PA-18-150, N927JS, was substantially damaged when it was involved in an accident near Wauconda, Washington. The flight instructor and student pilot were fatally injured. The airplane was operated… - [NTSB CEN27LA005](https://openairdocs.org/ntsb/CEN27LA005.md): Diamond Aircraft Ind DA 40 · Eldorado Springs, CO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Oct 5, 2026 · N162GL · Destroyed > On October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a… - [NTSB WPR26FA363](https://openairdocs.org/ntsb/WPR26FA363.md): Eurocopter Deutschland EC 135 P2+ · Avalon, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 1, 2026 · N313RX · Substantial damage > On September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the… - [NTSB CEN26LA324](https://openairdocs.org/ntsb/CEN26LA324.md): Magni M16 · Annapolis, MO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Sep 23, 2026 · N109MG · Substantial damage > On September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was… - [NTSB ERA26LA346](https://openairdocs.org/ntsb/ERA26LA346.md): Schleicher ASW-24 · Edinburg, NY · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Sep 18, 2026 · N94CG · 2 aircraft · Substantial damage > On September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was… - [NTSB ANC26FA105](https://openairdocs.org/ntsb/ANC26FA105.md): Cessna A185F · Stony River, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N4358Q · Substantial damage > On September 15, 2026 about 1210 Alaska daylight time, a Cessna A185F airplane, N4358Q, was substantially damaged when it was involved in an accident near Stony River, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title… - [NTSB ERA26FA329](https://openairdocs.org/ntsb/ERA26FA329.md): Piper PA-28-181 · Ludlow, MA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 6, 2026 · N7653F · Destroyed > On September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB ANC26FA097](https://openairdocs.org/ntsb/ANC26FA097.md): Cessna T206H · Dunton, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N919CW · Destroyed > On September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of… - [NTSB ERA26FA317](https://openairdocs.org/ntsb/ERA26FA317.md): Consolidated Aeronautics Lake LA-4-200 · Ithaca, NY · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 30, 2026 · N6185V · Substantial damage > On August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was… - [NTSB ERA26FA310](https://openairdocs.org/ntsb/ERA26FA310.md): Diamond Aircraft Ind DA20-A1 · Bristol, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 20, 2026 · N83RF · Substantial damage > On August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor… - [NTSB GAA26WA285](https://openairdocs.org/ntsb/GAA26WA285.md): Eurocopter EC130 · Ewaso Nyiro, Kenya · Accident · 7 fatal · Class 5 · Foreign · Aug 19, 2026 · 5Y-GYM · Destroyed - [NTSB WPR26FA301](https://openairdocs.org/ntsb/WPR26FA301.md): New Glasair Sportsman 2 Plus 2 · Pine, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 11, 2026 · N202AZ · Destroyed > On August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The… - [NTSB CEN26FA280](https://openairdocs.org/ntsb/CEN26FA280.md): Piper PA-24-250 · Bethany, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 4, 2026 · N8422P · Destroyed > On August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal… - [NTSB WPR26FA254](https://openairdocs.org/ntsb/WPR26FA254.md): Beech 95-B55 (T42A) · Waterloo, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 10, 2026 · N202DK · Destroyed > On July 9, 2026, at about 2248 central daylight time, a Beech 95-B55, N202DK, was destroyed when it was involved in an accident near Waterloo, Illinois. The pilot and pilot rated passenger were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB GAA26WA249](https://openairdocs.org/ntsb/GAA26WA249.md): Cessna 402C · Nicholls Town, Bahamas · Accident · 10 fatal · Class 3 · Foreign · Jul 10, 2026 · C6-FLX - [NTSB WPR26FA232](https://openairdocs.org/ntsb/WPR26FA232.md): Cessna 172 · Willard, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N387AF · Destroyed > On June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB ERA26FA243](https://openairdocs.org/ntsb/ERA26FA243.md): Piper PA-28-181 · Bowie, MD · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jun 21, 2026 · N249WF · Substantial damage > On June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB WPR26FA223](https://openairdocs.org/ntsb/WPR26FA223.md): Comp Air CA6-WB · Nicholasville, KY · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 20, 2026 · N82BT · Destroyed > On June 20, 2026, about 0846 eastern daylight time, an experimental amateur-built Comp Air CA6-WB, N82BT, was destroyed when it was involved in an accident near Nicholasville, Kentucky. The pilot and passenger were fatally injured. The airplane was operated… - [NTSB ANC26FA057](https://openairdocs.org/ntsb/ANC26FA057.md): Piper PA20 · Cordova, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 18, 2026 · N7635K · Destroyed > On June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26FA228](https://openairdocs.org/ntsb/CEN26FA228.md): Textron 680A · Laredo, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N523QS · Substantial damage > On June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one… - [NTSB ERA26FA239](https://openairdocs.org/ntsb/ERA26FA239.md): Blessing RV-3A · Lakeland, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 15, 2026 · N696DB · Substantial damage > On June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA189](https://openairdocs.org/ntsb/WPR26FA189.md): Piper PA-32-300 · Empire, NV · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 17, 2026 · N8502N · Substantial damage > On May 17, 2026, about 0738 PDT, a Piper PA-32-300, N8502N, was substantially damaged when it was involved in an accident near Empire, Nevada. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA190](https://openairdocs.org/ntsb/CEN26LA190.md): Downer 14-19-3 · Forney, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · May 16, 2026 · N7NL · Substantial damage > On May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived… - [NTSB CEN26FA174](https://openairdocs.org/ntsb/CEN26FA174.md): Cessna 421 · Wimberley, TX · Accident · 5 fatal · Class 3 · Field · Preliminary report · May 1, 2026 · N291AN · Destroyed > On April 30, 2026, about 2303 central daylight time, a Cessna 421C airplane, N291AN, was destroyed when it was involved in an accident near Wimberley, Texas. The private pilot and four passengers were fatally injured. The airplane was operated under the… - [NTSB ERA26FA177](https://openairdocs.org/ntsb/ERA26FA177.md): Rajchl Vladimir Airplane Swing 06 · O'Brien, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 16, 2026 · N613SA · Substantial damage > On April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title… - [NTSB WPR26FA141](https://openairdocs.org/ntsb/WPR26FA141.md): Hughes 369D · Haena, HI · Accident · 3 fatal · Class 3 · Field · Preliminary report · Mar 27, 2026 · N715KV · Substantial damage > On March 26, 2026, about 1539 Hawaii standard time, a Hughes 369D helicopter, N715KV, was substantially damaged when it was involved in an accident near Haena, Hawaii. The pilot and one passenger sustained serious injuries, and three passengers were fatally… - [NTSB WPR26FA130](https://openairdocs.org/ntsb/WPR26FA130.md): Beech A36 · Olympic Valley, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 23, 2026 · N2882W · Substantial damage > On March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal… - [NTSB CEN26FA142](https://openairdocs.org/ntsb/CEN26FA142.md): Beechcraft B200GT · Sharp, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 22, 2026 · N886DS · Destroyed > On March 22, 2026, at 1418 central daylight time (CDT), a Beechcraft B200GT (Super King Air) airplane, N886DS, was destroyed when it was involved in an accident near Sharp, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB GAA26WA130](https://openairdocs.org/ntsb/GAA26WA130.md): Robinson R44 · Drake, Australia · Accident · 1 fatal · Class 5 · Foreign · Mar 12, 2026 · VH-TCF · Substantial damage - [NTSB ERA26LA140](https://openairdocs.org/ntsb/ERA26LA140.md): Beech A36 · Gulf Shores, AL · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N66519 · Destroyed > On March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26FA126](https://openairdocs.org/ntsb/CEN26FA126.md): Peck JODEL-F12 · Rogers, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 26, 2026 · N30P · Destroyed > On February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code… - [NTSB WPR26FA103](https://openairdocs.org/ntsb/WPR26FA103.md): Cessna 210B · Camarillo, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 16, 2026 · N9735X · Substantial damage > On February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane… - [NTSB ERA26FA114](https://openairdocs.org/ntsb/ERA26FA114.md): Tailwind W-8 · Poplar Grove, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 14, 2026 · N9424H · Destroyed > On February 14, 2026, about 1600 central standard time, an experimental, amateur-built Tailwind W-8 airplane, N9424H, was destroyed when it was involved in an accident near Poplar Grove, Illinois. The pilot was fatally injured. The airplane was operated as a… - [NTSB CEN26FA115](https://openairdocs.org/ntsb/CEN26FA115.md): Epic E1000 · Steamboat Springs, CO · Accident · 4 fatal · Class 3 · Field · Preliminary report · Feb 13, 2026 · N98FK · Substantial damage > On February 13, 2026, about 0019 mountain standard time, an Epic E1000 airplane, N98FK, was substantially damaged when it was involved in an accident near Steamboat Springs, Colorado. The pilot and three passengers were fatally injured. The airplane was… - [NTSB GAA26WA102](https://openairdocs.org/ntsb/GAA26WA102.md): Beech 200 · Normanton, Australia · Accident · 1 fatal · Class 5 · Foreign · Feb 6, 2026 · VH-PUY · Destroyed - [NTSB ERA26FA106](https://openairdocs.org/ntsb/ERA26FA106.md): Cirrus Design SR22 · Lexington, SC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N705CD · Substantial damage > On February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally… - [NTSB CEN26FA109](https://openairdocs.org/ntsb/CEN26FA109.md): Robert G Elves Tarragon (Tarr) · Shawmut, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N35RR · Substantial damage > On February 6, 2026, at 1532 mountain standard time, a Tarragon airplane, N35RR, was substantially damaged when it was involved in an accident near Shawmut, Arizona. The pilot was fatally injured and the passenger received serious injuries. The airplane was… - [NTSB DCA26WA113](https://openairdocs.org/ntsb/DCA26WA113.md): Embraer EMB-110P1 · Les Cayes, Haiti · Accident · 2 fatal · Class 5 · Foreign · Feb 5, 2026 · N316AF · Destroyed - [NTSB DCA26WA105](https://openairdocs.org/ntsb/DCA26WA105.md): Beech 1900 · Santander, Colombia · Accident · 15 fatal · Class 5 · Foreign · Jan 28, 2026 · HK4709 · Destroyed - [NTSB WPR26FA091](https://openairdocs.org/ntsb/WPR26FA091.md): N126c CCX-1865 · Montour, ID · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jan 27, 2026 · N126C · Substantial damage > On January 27, 2026, about 1100 mountain standard time, an amateur-built, experimental CCX-1865 Carbon Cub, N126C, was substantially damaged when it was involved in an accident near Montour, Idaho. The pilot and pilot-rated passenger were fatally injured. The… - [NTSB GAA26WA086](https://openairdocs.org/ntsb/GAA26WA086.md): Vans RV-8A · Norwell, Australia · Accident · 2 fatal · Class 5 · Foreign · Jan 26, 2026 · VH-MKX · Destroyed - [NTSB CEN26FA086](https://openairdocs.org/ntsb/CEN26FA086.md): Beech A36 · Sabine Pass, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 8, 2026 · N5677X · Substantial damage > On January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title… - [NTSB CEN26FA071](https://openairdocs.org/ntsb/CEN26FA071.md): Lancair Legacy · Fredericksburg, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 30, 2025 · N618AM · Destroyed > On December 30, 2025, about 1623 central standard time, a Lancair Legacy RG airplane, N618AM, was destroyed when it was involved in an accident near Fredericksburg, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB WPR26FA068](https://openairdocs.org/ntsb/WPR26FA068.md): Beech K35 · Summer Lake, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 23, 2025 · N9540R · Substantial damage > On December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal… - [NTSB GAA26WA057](https://openairdocs.org/ntsb/GAA26WA057.md): Lancair 360 · Mazarambroz, Spain · Accident · 1 fatal · Class 5 · Foreign · Dec 17, 2025 · EC-XXD · Substantial damage - [NTSB GAA26WA051](https://openairdocs.org/ntsb/GAA26WA051.md): Bell 206 · Ranana, New Zealand · Accident · 2 fatal · Class 5 · Foreign · Dec 13, 2025 · ZK-IWZ · Substantial damage - [NTSB WPR26FA043](https://openairdocs.org/ntsb/WPR26FA043.md): Cessna 172M · Poleta, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N13221 · Substantial damage > On November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously… - [NTSB WPR26FA040](https://openairdocs.org/ntsb/WPR26FA040.md): Beech B100 · Coral Springs, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N30HG · Destroyed > On November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB GAA26WA019](https://openairdocs.org/ntsb/GAA26WA019.md): Rans S9 · San Felipe, Chile · Accident · 1 fatal · Class 4 · Foreign · Oct 29, 2025 · ULM-200 · Destroyed Next page: https://openairdocs.org/ntsb-phases/400/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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/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.