# Fatal NTSB investigations: Initial climb 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 74 · 3,672 cases ## Latest cases - [NTSB WPR27FA033](https://openairdocs.org/ntsb/WPR27FA033.md): Stewart Daniel E RV-6 · Como, MT · Accident · 1 fatal · Class 3 · Field · Investigation open · Nov 4, 2026 · N691DS - [NTSB WPR27FA012](https://openairdocs.org/ntsb/WPR27FA012.md): Vans RV7A · Petaluma, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 7, 2026 · N425DG · Destroyed > On October 7, 2026, about 1038 Pacific daylight time, an experimental amateur built Vans RV-7A, N425DG, was destroyed when it was involved in an accident near Petaluma, California. The pilot and flight instructor were fatally injured. The airplane was… - [NTSB CEN26FA325](https://openairdocs.org/ntsb/CEN26FA325.md): EXP PA-18 Replica · Buffalo, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 27, 2026 · N43LK · Substantial damage > On September 27, 2026, about 1608 central daylight time, an experimental PA-18 Replica airplane, N43LK, sustained substantial damage when it was involved in an accident near Buffalo, Minnesota. The pilot was fatally injured, and the pilot-rated passenger was… - [NTSB ANC26FA106](https://openairdocs.org/ntsb/ANC26FA106.md): Piper PA-18-150 · Northway, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 18, 2026 · N9128D · Substantial damage > On September 17, 2026, about 1930 Alaska daylight time, a Piper PA-18-150 airplane, N9128D, was substantially damaged when it was involved in an accident near Northway, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title… - [NTSB WPR26FA329](https://openairdocs.org/ntsb/WPR26FA329.md): Grumman American Avn. AA-5 · Fresno, CA · Accident · 4 fatal · Class 3 · Field · Preliminary report · Sep 5, 2026 · N6510L · Destroyed > On September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA326](https://openairdocs.org/ntsb/ERA26FA326.md): Maclura Evolution · Tampa, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N305PV · Destroyed > On September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was… - [NTSB CEN26LA296](https://openairdocs.org/ntsb/CEN26LA296.md): Para-Ski VX · Westport, SD · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 20, 2026 · C-IFBY · Substantial damage > On August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal… - [NTSB WPR26FA294](https://openairdocs.org/ntsb/WPR26FA294.md): Textron 172S · Provo, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N1842E · Substantial damage > On August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction… - [NTSB CEN26LA282](https://openairdocs.org/ntsb/CEN26LA282.md): Pzl-Bielsko B1-PW-5 · Briggs, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 6, 2026 · N105WS · Substantial damage > On August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal… - [NTSB CEN26FA275](https://openairdocs.org/ntsb/CEN26FA275.md): Beech E18S · Guymon, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 2, 2026 · N210Q · Destroyed > On August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26FA281](https://openairdocs.org/ntsb/WPR26FA281.md): Piper PA-28-180 · Chandler, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 29, 2026 · N9062J · Destroyed > On July 28, 2026, about 1949 mountain standard time, a Piper PA-28-180, N9062J, was destroyed when it was involved in an accident near Chandler, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB ERA26FA271](https://openairdocs.org/ntsb/ERA26FA271.md): Smith Aerostar 601 · Lake Clear, NY · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N800AA · Destroyed > On July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14… - [NTSB ERA26FA270](https://openairdocs.org/ntsb/ERA26FA270.md): Beech 95-B55 (T42A) · Metter, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 13, 2026 · N55FD · Destroyed > On July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14… - [NTSB ERA26FA269](https://openairdocs.org/ntsb/ERA26FA269.md): Cessna 182 · Piseco, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2026 · N43TB · Destroyed > On July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB ERA26FA252](https://openairdocs.org/ntsb/ERA26FA252.md): Piper PA24 · Hazen, ND · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 28, 2026 · N6852P · Destroyed > On June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB CEN26FA224](https://openairdocs.org/ntsb/CEN26FA224.md): Pacific Aerospace 750XL · Butler, MO · Accident · 12 fatal · Class 2 · Field · Preliminary report · Jun 14, 2026 · N221BN · Destroyed > On June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as… - [NTSB ERA26FA214](https://openairdocs.org/ntsb/ERA26FA214.md): Piper PA-25-235 · Saratoga Springs, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 26, 2026 · N8656L · 2 aircraft · Substantial damage > On May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26FA172](https://openairdocs.org/ntsb/CEN26FA172.md): Beechcraft F33A · Minneapolis, MN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 25, 2026 · N8032X · Destroyed > On April 25, 2026, about 1151 central daylight time, a Beechcraft F33A airplane, N8032X was destroyed when it was involved in an accident near Minneapolis, Minnesota. The pilot and passenger were fatally injured. The airplane was operated under Title 14 Code… - [NTSB ERA26FA179](https://openairdocs.org/ntsb/ERA26FA179.md): Cessna 401B · Land O' Lakes, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 19, 2026 · N122AT · Destroyed > On April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26FA160](https://openairdocs.org/ntsb/WPR26FA160.md): Mooney M20J · Union, SC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N1151H · Substantial damage > On April 17, 2026, about 1750 eastern daylight time, a Mooney M20J, N1151H, was destroyed when it was involved in an accident near Union, South Carolina. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA178](https://openairdocs.org/ntsb/ERA26FA178.md): Mooney M20J · Ironton, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N205MK · Substantial damage > On April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB GAA26WA134](https://openairdocs.org/ntsb/GAA26WA134.md): Air Tractor AT502B · Cruz Alta, Brazil · Incident · 1 fatal · Class 5 · Foreign · Mar 16, 2026 · PT-SEF · Destroyed - [NTSB WPR26FA101](https://openairdocs.org/ntsb/WPR26FA101.md): Sonex Onex · Caldwell, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N362DZ · Destroyed > On February 6, 2026, about 0945 mountain standard time, a Sonex Onex airplane, N362DZ, was destroyed when it was involved in an accident near Caldwell, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB GAA26WA072](https://openairdocs.org/ntsb/GAA26WA072.md): Piper PA-31-325 · Paipa, Colombia · Accident · 6 fatal · Class 3 · Foreign · Jan 10, 2026 · N325FA · Destroyed - [NTSB ERA26FA067](https://openairdocs.org/ntsb/ERA26FA067.md): American Champion 8KCAB · Irvington, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 13, 2025 · N157WB · Substantial damage > On December 13, 2025, about 1145 central standard time, an American Champion Decathlon, N157WB, was destroyed when it was involved in an accident near Roy E. Ray Airfield (5R7), Bayou La Batre, Alabama. The commercial pilot was fatally injured. The airplane… - [NTSB GAA26WA063](https://openairdocs.org/ntsb/GAA26WA063.md): Robin DR400 · Le Havre, France · Accident · 1 fatal · Class 5 · Foreign · Dec 11, 2025 · F-GLVG · Destroyed - [NTSB GAA26WA012](https://openairdocs.org/ntsb/GAA26WA012.md): Piper PA31T · San Cristóba, Venezuela · Accident · 2 fatal · Class 4 · Foreign · Oct 22, 2025 · YV1443 · Destroyed - [NTSB GAA26WA008](https://openairdocs.org/ntsb/GAA26WA008.md): Piper PA28 · Pilanesberg, South Africa · Accident · 1 fatal · Class 5 · Foreign · Oct 10, 2025 · ZS-FTS · Destroyed - [NTSB GAA26WA006](https://openairdocs.org/ntsb/GAA26WA006.md): Piper PA32 · Shell Harbor, Australia · Accident · 3 fatal · Class 5 · Foreign · Oct 10, 2025 · VH-JVA · Destroyed - [NTSB WPR26FA008](https://openairdocs.org/ntsb/WPR26FA008.md): Airbus Helicopters EC 130 T2 · Sacramento, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N414RX · Substantial damage > On October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse… - [NTSB ERA25FA367](https://openairdocs.org/ntsb/ERA25FA367.md): Toop Thomas A Glasair Super II FT · Wallkill, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 27, 2025 · N45BT · Destroyed > On September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a… - [NTSB GAA25WA264](https://openairdocs.org/ntsb/GAA25WA264.md): Cessna 150M · Municipio de Garcia, Mexico · Accident · 2 fatal · Class 5 · Foreign · Sep 21, 2025 · XB-BGH · Substantial damage - [NTSB WPR25FA289](https://openairdocs.org/ntsb/WPR25FA289.md): Murphy SR3500 · Bigfork, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 19, 2025 · N62ZT · Destroyed > On September 19, 2025, about 1205 mountain daylight time, an experimental amateur built Murphy SR3500, N62ZT, was destroyed when it was involved in an accident near Bigfork, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB WPR25FA257](https://openairdocs.org/ntsb/WPR25FA257.md): Cessna 140 · Shelter Cove, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 17, 2025 · N89447 > On August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14… - [NTSB GAA25WA248](https://openairdocs.org/ntsb/GAA25WA248.md): Quicksilver MX II · Phuket, Thailand · Accident · 1 fatal · Class 5 · Foreign · Aug 17, 2025 · U-M22 · Destroyed - [NTSB CEN25FA296](https://openairdocs.org/ntsb/CEN25FA296.md): Helms Richard Lancair IVP · Greenwood, IN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 30, 2025 · N49BX · Destroyed > On July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB WPR25FA225](https://openairdocs.org/ntsb/WPR25FA225.md): Mooney M20J · Nampa, ID · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 27, 2025 · N5764H · Substantial damage > On August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB GAA25WA219](https://openairdocs.org/ntsb/GAA25WA219.md): Piper PA31 · Deer Lake, Canada · Accident · 2 fatal · Class 5 · Foreign · Jul 26, 2025 · C-GYYP · Substantial damage - [NTSB ANC25FA079](https://openairdocs.org/ntsb/ANC25FA079.md): Piper J3C-65 · Dillingham, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 25, 2025 · N5050R · Substantial damage > On July 25, 2025, about 0916 Alaska daylight time, a Piper J3C-65 airplane, N5050R, was substantially damaged when it was involved in an accident near Dillingham, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA25FA272](https://openairdocs.org/ntsb/ERA25FA272.md): Piper PA46-500TP · Lititz, PA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 20, 2025 · N819MA · Substantial damage > On July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The… - [NTSB CEN25FA248](https://openairdocs.org/ntsb/CEN25FA248.md): Piper PA-25 · Hot Springs, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N8186K · Substantial damage > On July 12, 2025, about 1322 mountain daylight time, a Piper PA-25, N8186K, was substantially damaged when it was involved in an accident near Hot Springs, South Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB GAA25WA210](https://openairdocs.org/ntsb/GAA25WA210.md): Jodel DR1050 · Châteauroux-Villers, France · Accident · 1 fatal · Class 5 · Foreign · Jul 5, 2025 · F-BJOZ · Destroyed - [NTSB CEN25FA216](https://openairdocs.org/ntsb/CEN25FA216.md): Murphy Aircraft Manufacturing Moose · Montrose, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 23, 2025 · N250MK · Destroyed > On June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.… - [NTSB WPR25FA169](https://openairdocs.org/ntsb/WPR25FA169.md): Cessna 414 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 8, 2025 · N414BA · Substantial damage > On June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA25FA211](https://openairdocs.org/ntsb/ERA25FA211.md): Zenith Stol CH701 · Geneva, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 25, 2025 · N514JG · Substantial damage > On May 25, 2025, about 1007 eastern daylight time, an experimental, amateur-built Zenith STOL CH701, N514JG, was substantially damaged when it was involved in an accident near Geneva, Ohio. The pilot was fatally injured and the pilot-rated passenger sustained… - [NTSB ERA25FA202](https://openairdocs.org/ntsb/ERA25FA202.md): Harteveld Drew J Chinook Plus 2 · Pittstown, NJ · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 16, 2025 · N3300K · Destroyed > On May 16, 2025, about 1642 eastern daylight time, an experimental, amateur-built Chinook Plus 2, N3300K, was destroyed when it was involved in an accident near Pittstown, NJ. The private pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ERA25FA201](https://openairdocs.org/ntsb/ERA25FA201.md): Piper PA32RT · Yulee, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 10, 2025 · N30689 · Destroyed > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot… - [NTSB ERA25FA158](https://openairdocs.org/ntsb/ERA25FA158.md): Cirrus Design SR22 · Franklin Township, NJ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 30, 2025 · N319TM · Substantial damage > On March 30, 2025, about 1034 eastern daylight time, a Cirrus SR22, N319TM, was substantially damaged when it was involved in an accident near Franklin Township, New Jersey. The private pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB CEN25FA124](https://openairdocs.org/ntsb/CEN25FA124.md): Robinson Helicopter R44 · Danville, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 15, 2025 · N331ES · Destroyed > On March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal… - [NTSB ERA25LA145](https://openairdocs.org/ntsb/ERA25LA145.md): Wild Sky Goat · Chester, CT · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Mar 14, 2025 · N372WS · Substantial damage > On March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal… Next page: https://openairdocs.org/ntsb-phases/350/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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/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.