# Fatal NTSB investigations: Takeoff 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 17 · 836 cases ## Latest cases - [NTSB CEN27LA021](https://openairdocs.org/ntsb/CEN27LA021.md): Piper J3C-65 · Boonville, IN · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Oct 18, 2026 · N88218 · Substantial damage > On October 18, 2026, about 1500 central daylight time, a Piper J3C-65 airplane, N88218, was involved in an accident near Boonville, Indiana. The pilot was not injured and a passenger in a vehicle that was struck by the airplane was fatally injured. The… - [NTSB CEN27FA006](https://openairdocs.org/ntsb/CEN27FA006.md): Lancair IV · Haslet, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2026 · N5SV · Destroyed > On October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)… - [NTSB WPR27FA001](https://openairdocs.org/ntsb/WPR27FA001.md): Stoddard Hamilton Glasair · Everett, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 1, 2026 · N314SR · Destroyed > On October 1, 2026, about 1450 Pacific daylight time, an experimental amateur built Glasair FT airplane, N314SR, was destroyed when it was involved in an accident near Everett, Washington. The pilot was fatally injured. The airplane was operated as a Title 14… - [NTSB CEN26FA310](https://openairdocs.org/ntsb/CEN26FA310.md): Mooney M20F · Titusville, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 7, 2026 · N9546M · Substantial damage > On September 7, 2026, about 1015 eastern daylight time, a Mooney M20F airplane, N9546M, was destroyed when it was involved in an accident near Titusville, Florida. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA291](https://openairdocs.org/ntsb/ERA26FA291.md): Beech H35 · Bogalusa, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 6, 2026 · N5409D · Substantial damage > On August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA253](https://openairdocs.org/ntsb/ERA26FA253.md): Bellanca 14-19-2 · Goldsby, OK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 29, 2026 · N9846B · Destroyed > On June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN26LA231](https://openairdocs.org/ntsb/CEN26LA231.md): Bailey-Moyes Dragonfly · Whitewater, WI · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jun 23, 2026 · N3849A · No damage > On June 22, 2026, about 1915 central daylight time, a Bailey-Moyes Dragonfly, N3849A, was involved in an accident near Whitewater, Wisconsin. The pilot of the Dragonfly was not injured. The pilot of the hang glider in tow was fatally injured. The tow… - [NTSB ERA26FA241](https://openairdocs.org/ntsb/ERA26FA241.md): Cessna 177RG · Morrison, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N7637V · Substantial damage > On June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title… - [NTSB WPR26FA217](https://openairdocs.org/ntsb/WPR26FA217.md): Lancair 235 · Hillsboro, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 12, 2026 · N10CF · Substantial damage > On June 12, 2026, at about 1508 Pacific daylight time, a Lancair 235, N10CF, was destroyed when it was involved in an accident near Hillsboro, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB GAA26WA223](https://openairdocs.org/ntsb/GAA26WA223.md): Bell 206 · Lesa, Italy · Accident · 1 fatal · Class 5 · Foreign · Jun 12, 2026 · I-CHOP · Destroyed - [NTSB CEN26FA222](https://openairdocs.org/ntsb/CEN26FA222.md): Cirrus Design SR20 · Wheelers Mill, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 11, 2026 · N858SD · Destroyed > On June 11, 2026, about 1030 eastern daylight time, a Cirrus SR20 airplane, N858SD, was destroyed when it was involved in an accident near Wheelers Mill, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN26FA140](https://openairdocs.org/ntsb/CEN26FA140.md): Aero Commander 500-B · Chesterfield, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 17, 2026 · N444CA · Destroyed > On March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26FA098](https://openairdocs.org/ntsb/CEN26FA098.md): Bombardier CL-600-2B16 · Bangor, ME · Accident · 6 fatal · Class 2 · Field · Preliminary report · Jan 26, 2026 · N10KJ · Substantial damage > On January 25, 2026, at 1944 eastern standard time (EST), a Bombardier CL-600-2B16 (Challenger 650) airplane, N10KJ, sustained substantial damage when it was involved in an accident near Bangor, Maine. The pilot, copilot, and 4 passengers were fatally… - [NTSB CEN26FA093](https://openairdocs.org/ntsb/CEN26FA093.md): Piper PA-28-140 · Holly Springs, MS · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jan 18, 2026 · N6711J · Destroyed > On January 18, 2026, about 1640 central standard time, a Piper PA28-140 airplane, N6711J, was destroyed when it was involved in an accident near Holly Springs, Mississippi. The flight instructor and student pilot were fatally injured. The airplane was… - [NTSB WPR26FA069](https://openairdocs.org/ntsb/WPR26FA069.md): Piper PA-32-260 · Rio Linda, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 24, 2025 · N2785Q · Substantial damage > On December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was… - [NTSB DCA26MA024](https://openairdocs.org/ntsb/DCA26MA024.md): Mcdonnell Douglas MD-11F · Louisville, KY · Accident · 14 fatal · Class 1 · Major · Preliminary report · Nov 4, 2025 · N259UP · Destroyed > On November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad… - [NTSB ERA26FA027](https://openairdocs.org/ntsb/ERA26FA027.md): Mooney M20E · Ballston Spa, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 31, 2025 · N79338 · Destroyed > On October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was… - [NTSB GAA26WA015](https://openairdocs.org/ntsb/GAA26WA015.md): Cessna 208 · Diani, Kenya · Accident · 1 fatal · Class 5 · Foreign · Oct 28, 2025 · 5Y-CCA · Destroyed - [NTSB CEN26FA022](https://openairdocs.org/ntsb/CEN26FA022.md): Kitfox II · Spruce Pine, NC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 17, 2025 · N8610X · Destroyed > On October 17, 2025, about 1154 eastern daylight time, a Kitfox II airplane, N8610X was destroyed when it was involved in an accident near Spruce Pine, North Carolina. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26FA011](https://openairdocs.org/ntsb/ERA26FA011.md): Socata TBM 700 · Dartmouth, MA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 13, 2025 · N111RF · Substantial damage > On October 13, 2025, at about 0815 eastern daylight time, a Socata TBM 700C2, N111RF, was substantially damaged when it was involved in an accident near Dartmouth, Massachusetts. The private pilot and the passenger were fatally injured and an automobile… - [NTSB GAA25WA266](https://openairdocs.org/ntsb/GAA25WA266.md): Learjet 55 · La Guaira, Venezuela · Accident · 2 fatal · Class 3 · Foreign · Sep 24, 2025 · YV3440 · Destroyed - [NTSB GAA25WA251](https://openairdocs.org/ntsb/GAA25WA251.md): Mooney M20J · Norrtälje, Sweden · Accident · 2 fatal · Class 5 · Foreign · Sep 5, 2025 · SE-GXI · Substantial damage - [NTSB GAA25WA261](https://openairdocs.org/ntsb/GAA25WA261.md): Skystar Kitfox · Casey, Canada · Accident · 2 fatal · Class 5 · Foreign · Aug 31, 2025 · C-GMFA · Substantial damage - [NTSB WPR25FA223](https://openairdocs.org/ntsb/WPR25FA223.md): Grumman American Avn. AA-5 · West Glacier, MT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 26, 2025 · N1342R · Substantial damage > On July 26, 2025, about 0942 mountain daylight time, a Grumman AA-5, N1342R, was destroyed when it was involved in an accident near West Glacier, Montana. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB GAA25WA208](https://openairdocs.org/ntsb/GAA25WA208.md): Beech B200 · Southend-on-Sea, United Kingdom · Accident · 4 fatal · Class 5 · Foreign · Jul 13, 2025 · PH-ZAZ · Destroyed - [NTSB WPR25FA197](https://openairdocs.org/ntsb/WPR25FA197.md): Evolution Revolt · Mount Vernon, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N774RS · Substantial damage > On July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally… - [NTSB GAA25WA207](https://openairdocs.org/ntsb/GAA25WA207.md): Air Tractor AT502 · Porto Dos GaúChos, Brazil · Accident · 1 fatal · Class 5 · Foreign · Jul 1, 2025 · PP-LTO · No damage - [NTSB CEN25LA229](https://openairdocs.org/ntsb/CEN25LA229.md): Rans S-14 · Guthrie, OK · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N981CS · Substantial damage > On June 30, 2025, about 2054 central daylight time, a Rans S-14 airplane, N981CS, was substantially damaged when it was involved in an accident near Guthrie, Oklahoma. The non-certificated pilot was fatally injured. The airplane was operated as a Title 14… - [NTSB ERA25FA248](https://openairdocs.org/ntsb/ERA25FA248.md): Robert Fidler Lancair 320/360 · Zeeland, MI · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 29, 2025 · N360RF · Destroyed > On June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ERA25FA246](https://openairdocs.org/ntsb/ERA25FA246.md): Cessna 441 · Warren, OH · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 29, 2025 · N441LS · Substantial damage > On June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB CEN25FA197](https://openairdocs.org/ntsb/CEN25FA197.md): Air Tractor AT-502 · Grady, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 6, 2025 · N9185F · Substantial damage > On June 6, 2025, about 1830 central daylight time, an Air Tractor AT-502 airplane, N9185F, was substantially damaged when it was involved in an accident near Grady, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25FA153](https://openairdocs.org/ntsb/WPR25FA153.md): American Champion 7GCBC · Big Creek, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 9, 2025 · N342H · Substantial damage > On May 9, 2025, about 0900 mountain daylight time, an American Champion Aircraft 7GCBC, N342H, was substantially damaged when it was involved in an accident near Big Creek, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25FA145](https://openairdocs.org/ntsb/WPR25FA145.md): Champion 7ECA · Cottonwood, CA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2025 · N6310N · Destroyed > The flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees. - [NTSB GAA25WA182](https://openairdocs.org/ntsb/GAA25WA182.md): Tecnam P2008 · Amreli, India · Accident · 1 fatal · Class 3 · Foreign · Apr 22, 2025 · VT-VDF · Destroyed - [NTSB ERA25FA173](https://openairdocs.org/ntsb/ERA25FA173.md): Cessna 310R · Boca Raton, FL · Accident · 3 fatal · Class 3 · Field · Preliminary report · Apr 11, 2025 · N8930N · Destroyed > On April 11, 2025, at 1023 eastern daylight time, a Cessna 310R, N8930N, was destroyed when it was involved in an accident near Boca Raton, Florida. The two pilots and the passenger were fatally injured, and one person on the ground sustained minor injuries.… - [NTSB GAA25WA130](https://openairdocs.org/ntsb/GAA25WA130.md): Cessna 152 · Lingayen, Philippines · Accident · 2 fatal · Class 5 · Foreign · Mar 30, 2025 · RP-C8595 · Destroyed - [NTSB ERA25FA154](https://openairdocs.org/ntsb/ERA25FA154.md): Aero SP Z O O AT-4 LSA · Zellwood, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 22, 2025 · N8548U · Substantial damage > On March 22, 2025, about 0925 eastern daylight time, a Aero SP Z O O AT-4 LSA, N8548U, was substantially damaged when it was involved in an accident near Zellwood, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25FA119](https://openairdocs.org/ntsb/CEN25FA119.md): Cessna 525 · Mesquite, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 13, 2025 · N525CZ · Destroyed > On March 13, 2025, about 0733 central daylight time, a Cessna 525A airplane, N525CZ, was destroyed when it was involved in an accident near Mesquite, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB ERA25FA120](https://openairdocs.org/ntsb/ERA25FA120.md): Rockwell 112 · Covington, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 16, 2025 · N1423J · Destroyed > On February 15, 2025, about 2300, a Rockwell 112, N1423J, was destroyed when it was involved in an accident near Covington, Georgia. The private pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB GAA25WA094](https://openairdocs.org/ntsb/GAA25WA094.md): Beecraft F90 · São Paulo city, Brazil · Accident · 2 fatal · Class 5 · Foreign · Feb 7, 2025 · PS-FEM · Destroyed - [NTSB GAA25WA077](https://openairdocs.org/ntsb/GAA25WA077.md): Robinson R44 · Pacific Ocean, Ecuador · Accident · 1 fatal · Class 5 · Foreign · Feb 1, 2025 · HC-CQY · Substantial damage - [NTSB ERA25MA106](https://openairdocs.org/ntsb/ERA25MA106.md): Learjet 55 · Philadelphia, PA · Accident · 7 fatal · Class 2 · Major · Preliminary report · Jan 31, 2025 · XA-UCI · Destroyed > On January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two… - [NTSB DCA25WA118](https://openairdocs.org/ntsb/DCA25WA118.md): Beech 1900 · Juba, Sudan · Accident · 20 fatal · Class 5 · Foreign · Jan 29, 2025 · 5X-RHB · Destroyed - [NTSB GAA25WA052](https://openairdocs.org/ntsb/GAA25WA052.md): Cessna 208 · Rottnest Island, Australia · Accident · 3 fatal · Class 5 · Foreign · Jan 7, 2025 · VH-WTY · Destroyed - [NTSB GAA25WA048](https://openairdocs.org/ntsb/GAA25WA048.md): Piper PA42 · Gramado, Brazil · Accident · 10 fatal · Class 3 · Foreign · Dec 22, 2024 · PR-NDN · Destroyed - [NTSB WPR25FA031](https://openairdocs.org/ntsb/WPR25FA031.md): Honda HA420 · Mesa, AZ · Accident · 5 fatal · Class 3 · Field · Preliminary report · Nov 5, 2024 · N57HP · Destroyed > On November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of… - [NTSB GAA25WA012](https://openairdocs.org/ntsb/GAA25WA012.md): North American SNJ-3 · Räyskälä, Finland · Accident · 2 fatal · Class 5 · Foreign · Oct 16, 2024 · OH-NAT · Destroyed - [NTSB CEN25FA006](https://openairdocs.org/ntsb/CEN25FA006.md): Beech C99 · Norfolk, NE · Accident · 1 fatal · Class 3 · Field · Final report · Oct 8, 2024 · N130GP · Destroyed > The pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade. - [NTSB GAA25WA007](https://openairdocs.org/ntsb/GAA25WA007.md): Cirrus Design SR22 · La Bretonnière la Claye, France · Accident · 2 fatal · Class 5 · Foreign · Oct 7, 2024 · N456AR · Destroyed - [NTSB GAA25WA005](https://openairdocs.org/ntsb/GAA25WA005.md): Cessna 404 · Les Cayes, Haiti · Accident · 3 fatal · Class 5 · Foreign · Oct 3, 2024 · N404EC · Substantial damage Next page: https://openairdocs.org/ntsb-phases/300/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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/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.