Fatal NTSB investigations

1,013 cases where the sequence of events included Unknown or undetermined.

Cases, newest first

Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn 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…Aug 11, 2026 · N202AZ · DestroyedNTSB GAA26WA279Accident · 4 fatalForeign investigationRobinson R44 · Rio de Janeiro, BrazilAug 8, 2026 · PP-MFSNTSB GAA26WA278Accident · 1 fatalClass 5 · ForeignCessna 150 · Portimao, PortugalAug 8, 2026 · CS-DIP · Substantial damageNTSB ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn 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…Aug 7, 2026 · N793HT · DestroyedNTSB ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn 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…Aug 6, 2026 · N5409D · Substantial damageNTSB WPR26FA289Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Bend, OROn 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…Aug 5, 2026 · N625LK · Substantial damageNTSB GAA26WA277Accident · 1 fatalForeign investigationCessna 172L · Chilliwack, CanadaAug 4, 2026 · C-FBZQ · 2 aircraftNTSB GAA26WA270Accident · 2 fatalClass 5 · ForeignBell 214ST · West Attica, GreeceAug 2, 2026 · N511EV · 2 aircraft · DestroyedNTSB GAA26WA268Accident · 13 fatalClass 5 · ForeignCessna 208 · Nazca, PeruAug 1, 2026 · OB-2001 · DestroyedNTSB GAA26WA267Accident · 7 fatalClass 5 · ForeignBell 412 · San Agustín, ArgentinaJul 29, 2026 · LV-KGR · DestroyedNTSB ANC26FA077Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA22 · Chitina, AKOn July 27, 2026, about 2130 Alaska daylight time, a deregistered Piper PA-22-150 airplane, N4535A, was destroyed when it was involved in an accident near Chitina, Alaska. The pilot and two passengers were fatally injured. The airplane was operated as a Title…Jul 28, 2026 · N4535A · DestroyedNTSB CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jul 24, 2026 · N27601 · DestroyedNTSB GAA26WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Temelli, TürkiyeJul 22, 2026 · TC-HTENTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…Jul 16, 2026 · N98GB · Substantial damageNTSB CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…Jul 16, 2026 · N84AJ · Substantial damageNTSB GAA26WA258Accident · 2 fatalClass 5 · ForeignCessna 335 · Barinas, VenezuelaJul 15, 2026 · YV2134 · Substantial damageNTSB GAA26WA261Incident · 1 fatalClass 5 · ForeignCessna 152 · Mengeringhausen, GermanyJul 14, 2026 · D-EJCP · DestroyedNTSB GAA26WA251Accident · 2 fatalClass 5 · ForeignHughes 369 · British Columbia, CanadaJul 14, 2026 · C-GHFL · Substantial damageNTSB CEN26FA253Accident · 1 fatalClass 3 · FieldPreliminary reportMontana Coyote · Fredericksburg, VAOn July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…Jul 14, 2026 · N448VQ · Substantial damageNTSB GAA26WA250Accident · 2 fatalClass 5 · ForeignPiper PA28 · Seitenstetten, AustriaJul 12, 2026 · D-EHHV · DestroyedNTSB GAA26WA265Accident · 1 fatalClass 5 · ForeignRobinson R44 · RorainóPolis, BrazilJul 11, 2026 · PT-HFS · DestroyedNTSB GAA26WA249Accident · 10 fatalClass 3 · ForeignCessna 402C · Nicholls Town, BahamasJul 10, 2026 · C6-FLXNTSB GAA26WA332Accident · 1 fatalClass 5 · ForeignRobin DR400 · Alençon, FranceJul 5, 2026 · F-GFXV · DestroyedNTSB GAA26WA243Accident · 2 fatalClass 5 · ForeignCessna 172 · Fujairah, United Arab EmiratesJul 3, 2026 · A6-MSS · DestroyedNTSB GAA26WA237Accident · 2 fatalClass 5 · ForeignBeech V35 · San Miguel Pochuta, GuatemalaJul 3, 2026 · TG-PIP · DestroyedNTSB GAA26WA234Accident · 2 fatalClass 5 · ForeignCessna A152 · Ongar, United KingdomJun 30, 2026 · G-BRCD · DestroyedNTSB ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn 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…Jun 29, 2026 · N9846B · DestroyedNTSB GAA26WA236Accident · 11 fatalClass 5 · ForeignPilatus PC6 · Tomblaine, FranceJun 28, 2026 · D-FIPS · DestroyedNTSB GAA26WA235Accident · 2 fatalClass 5 · ForeignPiper PA28 · Fochville, South AfricaJun 27, 2026 · ZS-ESZ · Substantial damageNTSB GAA26WA233Accident · 3 fatalClass 5 · ForeignRockwell 690 · Fort Simpson, CanadaJun 25, 2026 · C-FNRP · DestroyedNTSB GAA26WA230Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Warsaw, PolandJun 25, 2026 · SP-GOS · Substantial damageNTSB GAA26WA226Accident · 2 fatalClass 5 · ForeignPiper PA28 · Al Hoceïma, MoroccoJun 21, 2026 · F-GIEH · Substantial damageNTSB WPR26FA224Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Middlefield, OHOn June 20, 2026, about 1535 eastern daylight time, a Piper PA-24-250, N6403P, was substantially damaged when it was involved in an accident near Middlefield, Ohio. The pilot and two passengers sustained fatal injuries. The airplane was operated as a Title 14…Jun 20, 2026 · N6403P · Substantial damageNTSB GAA26WA220Accident · 2 fatalClass 5 · ForeignCessna 421 · La Baule-Escoublac, FranceJun 19, 2026 · F-GUST · DestroyedNTSB ANC26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502B · Forbes, MOOn June 15, 2026, about 2015 Central daylight time, an Air Tractor AT-502B airplane, N503GK, sustained substantial damage when it was involved in an accident near Forbes, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jun 16, 2026 · N503GK · Substantial damageNTSB GAA26WA216Accident · 9 fatalClass 4 · ForeignBell 206 · Recreio dos Bandeirantes, Rio de Janeiro., BrazilJun 14, 2026 · PP-MAC · 2 aircraft · DestroyedNTSB WPR26FA217Accident · 1 fatalClass 3 · FieldPreliminary reportLancair 235 · Hillsboro, OROn 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…Jun 12, 2026 · N10CF · Substantial damageNTSB WPR26FA216Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-36-300 · Henderson, NEOn 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…Jun 12, 2026 · N57846 · Substantial damageNTSB GAA26WA223Accident · 1 fatalClass 5 · ForeignBell 206 · Lesa, ItalyJun 12, 2026 · I-CHOP · DestroyedNTSB GAA26WA217Accident · 1 fatalClass 5 · ForeignCessna 172 · 6th of October City, EgyptJun 12, 2026 · SU-BRM · Substantial damageNTSB GAA26WA218Accident · 2 fatalClass 5 · ForeignBeech 58 · Marilia-Sao Paulo, BrazilJun 10, 2026 · PT-MDB · DestroyedNTSB GAA26WA210Accident · 2 fatalClass 5 · ForeignGulfstream Gulfstream 200 · La Romana, Dominican RepublicJun 7, 2026 · N318JF · DestroyedNTSB GAA26WA224Accident · 1 fatalClass 5 · ForeignShort SC7 · Be'er Sheva, IsraelJun 5, 2026 · 4X-AGP · Substantial damageNTSB GAA26WA207Accident · 4 fatalClass 5 · ForeignBeech G36 · Medulin, CroatiaJun 4, 2026 · D-ENTT · DestroyedNTSB GAA26WA209Accident · 1 fatalClass 5 · ForeignRobinson R44 · Kasina Wielka, PolandJun 3, 2026 · SP-MMO · DestroyedNTSB GAA26WA206Accident · 4 fatalClass 5 · ForeignCessna TU206 · La Macarena, ColombiaJun 1, 2026 · HK-2521NTSB GAA26WA205Accident · 1 fatalClass 5 · ForeignCessna 152 · Valbrembo, ItalyJun 1, 2026 · I-CNTR · DestroyedNTSB WPR26FA202Accident · 1 fatalClass 3 · FieldPreliminary reportPipistrel D O O Sinus 912 · Columbus, MSOn May 31, 2026, about 1236 central daylight time, a Pipistrel D O O Sinus 912, N1277P, was destroyed when it was involved in an accident near Columbus, Mississippi. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…May 31, 2026 · N1277P · DestroyedNTSB CEN26FA207Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Dawsonville, GAOn 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…May 30, 2026 · N4488H · Substantial damageNTSB GAA26WA331Accident · 1 fatalClass 5 · ForeignSocata Rallye 100S · Roquebrune-sur-Argens, FranceMay 29, 2026 · F-GPGE · Destroyed