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 GAA26WA244Accident · 2 fatalClass 5 · ForeignMaxair MU582 · Tel Adashim, IsraelMay 24, 2026 · 4X-HCC · DestroyedNTSB CEN26FA192Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172N · Westerly, RIOn May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…May 18, 2026 · N733CP · Substantial damageNTSB GAA26WA248Accident · 2 fatalClass 5 · ForeignNorth American T28 · Limburghof, GermanyMay 16, 2026 · N728NA · DestroyedNTSB GAA26WA193Accident · 4 fatalClass 5 · ForeignCessna 210 · Hammerstein, NamibiaMay 10, 2026 · V5-KER · DestroyedNTSB ANC26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 182T · Armistead, CAOn May 7, 2026, about 1055 pacific daylight time (PDT), a Cessna 182T airplane, N227TF, was destroyed when it was involved in an accident near Armistead, California. The flight instructor and the pilot receiving instruction were fatally injured. The airplane…May 7, 2026 · N227TF · Substantial damageNTSB GAA26WA183Accident · 1 fatalClass 5 · ForeignCessna 182 · Santa Cruz Barillas, GuatemalaMay 3, 2026 · TG-JEB · Substantial damageNTSB CEN26FA174Accident · 5 fatalClass 3 · FieldPreliminary reportCessna 421 · Wimberley, TXOn 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…May 1, 2026 · N291AN · DestroyedNTSB GAA26WA179Accident · 2 fatalClass 5 · ForeignDiamond DA42 · Parafield, AustraliaApr 29, 2026 · VH-YQP · DestroyedNTSB GAA26WA319Accident · 1 fatalClass 5 · ForeignShark Aero Shark · Oldenburg Hatten, GermanyApr 28, 2026 · OM-S160 · DestroyedNTSB GAA26WA178Accident · 14 fatalClass 5 · ForeignCessna 208 · Jubasu, SudanApr 27, 2026 · 5Y-NOK · DestroyedNTSB GAA26WA174Accident · 1 fatalClass 5 · ForeignThrush S2R · Tiquisate, Escunintia, GuatemalaApr 25, 2026 · TG-BUA · Substantial damageNTSB GAA26WA176Accident · 1 fatalClass 5 · ForeignRobinson R22 · Jericho, AustraliaApr 20, 2026 · VH-ESG · DestroyedNTSB GAA26WA190Accident · 1 fatalClass 5 · ForeignCessna U206 · Sao Paulo, BrazilApr 18, 2026 · PT-XRI · DestroyedNTSB ERA26FA177Accident · 1 fatalClass 3 · FieldPreliminary reportRajchl Vladimir Airplane Swing 06 · O'Brien, FLOn 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…Apr 16, 2026 · N613SA · Substantial damageNTSB GAA26WA164Accident · 1 fatalClass 5 · ForeignCessna 208 · Imbaimadai, GuyanaApr 10, 2026 · 8R-YAC · DestroyedNTSB ANC26FA024Accident · 2 fatalClass 3 · FieldPreliminary reportAirplane Factory Ltd The Sling · Avalon, CAOn April 09, 2026, about 1224 Pacific daylight time, an Airplane Factory (Pty) Ltd. Sling 2 airplane, N166TW, was substantially damaged when it was involved in an accident near Avalon, California. The pilot and pilot-rated passenger were fatally injured. The…Apr 9, 2026 · N166TW · Substantial damageNTSB GAA26WA157Accident · 1 fatalForeign investigationCessna F172 · Middelburg, NetherlandsApr 8, 2026 · PH-VSSNTSB GAA26WA150Accident · 4 fatalClass 5 · ForeignPiper PA46 · Capão da Canoa, BrazilApr 3, 2026 · PS-RBK · DestroyedNTSB GAA26WA149Accident · 2 fatalClass 5 · ForeignBeech 18 · Coron, PhilippinesApr 2, 2026 · RP-C2984NTSB GAA26WA171Accident · 1 fatalForeign investigationRobinson R44 · New Brunswick, CanadaMar 28, 2026 · C-GKVHNTSB GAA26WA140Accident · 1 fatalClass 5 · ForeignThrush S2R · San Juan, EcuadorMar 26, 2026 · HC-CGL · 2 aircraftNTSB CEN26FA147Accident · 1 fatalClass 3 · FieldPreliminary reportExperimental Homebuilt Airshark · Statesboro, GAOn March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a…Mar 25, 2026 · N220AS · Substantial damageNTSB WPR26FA130Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Olympic Valley, CAOn 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…Mar 23, 2026 · N2882W · Substantial damageNTSB ANC26FA021Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Boynton Beach, FLOn March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The…Mar 23, 2026 · N478AT · DestroyedNTSB CEN26FA142Accident · 1 fatalClass 3 · FieldPreliminary reportBeechcraft B200GT · Sharp, LAOn 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…Mar 22, 2026 · N886DS · DestroyedNTSB GAA26WA135Accident · 2 fatalClass 5 · ForeignCessna 152 · Amazonas, BrazilMar 21, 2026 · PR-TSM · Substantial damageNTSB CEN26FA141Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Rock Falls, ILOn March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14…Mar 20, 2026 · N9913W · DestroyedNTSB CEN26FA140Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 500-B · Chesterfield, MOOn 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…Mar 17, 2026 · N444CA · DestroyedNTSB GAA26WA129Accident · 4 fatalClass 5 · ForeignCessna 182 · San Marcos, GuatemalaMar 14, 2026 · TG-SCO · DestroyedNTSB GAA26WA257Accident · 1 fatalClass 5 · ForeignVans RV14 · Cima di Lago, SwitzerlandMar 13, 2026 · HB-YSI · DestroyedNTSB GAA26WA124Accident · 1 fatalClass 5 · ForeignThrush S2R · La Lima, HondurasMar 8, 2026 · HR-ARC · DestroyedNTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn 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…Mar 8, 2026 · N66519 · DestroyedNTSB CEN26FA132Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T210M · Deerfield, ILOn March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of…Mar 5, 2026 · N19FB · Substantial damageNTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Feb 28, 2026 · N3170Z · DestroyedNTSB WPR26FA108Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-8 · Hurricane, UTOn February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…Feb 28, 2026 · N80AR · Substantial damageNTSB GAA26WA118Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Wesselsbron, South AfricaFeb 25, 2026 · ZS-XAP · Substantial damageNTSB GAA26WA117Accident · 3 fatalClass 5 · ForeignRobinson R44 · Amaranka, RussiaFeb 19, 2026 · RA-04261 · DestroyedNTSB ERA26FA114Accident · 1 fatalClass 3 · FieldPreliminary reportTailwind W-8 · Poplar Grove, ILOn 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…Feb 14, 2026 · N9424H · DestroyedNTSB WPR26FA098Accident · 2 fatalClass 3 · FieldPreliminary reportBell 407 · Flagstaff, AZOn 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…Feb 5, 2026 · N56AZ · DestroyedNTSB GAA26WA088Accident · 2 fatalClass 5 · ForeignCirrus SR20 · Greater Manchester, United KingdomFeb 3, 2026 · G-GXVV · DestroyedNTSB GAA26WA085Accident · 5 fatalClass 3 · ForeignLearjet 45XR · Sawantwadi, IndiaJan 28, 2026 · VT-SSK 417 · DestroyedNTSB GAA26WA087Accident · 2 fatalClass 5 · ForeignHughes 269C · Paekakariki Hill, New ZealandJan 27, 2026 · ZK-HGP · DestroyedNTSB GAA26WA082Accident · 3 fatalClass 5 · ForeignCessna 172 · Comunidad Wichimi, EcuadorJan 26, 2026 · HC-BAN · DestroyedNTSB GAA26WA091Accident · 1 fatalClass 5 · ForeignCessna 172 · Caracaraí,, BrazilJan 20, 2026 · PT-BGV · Substantial damageNTSB GAA26WA074Accident · 3 fatalClass 5 · ForeignRobinson R44 · Rio de Janeiro, BrazilJan 17, 2026 · PS-GJSNTSB GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaJan 10, 2026 · N325FA · DestroyedNTSB GAA26WA073Accident · 1 fatalClass 3 · ForeignAir Tractor AT602 · Lucas do Rio Verde, BrazilJan 9, 2026 · PS-GVO · Substantial damageNTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn 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…Jan 8, 2026 · N5677X · Substantial damageNTSB GAA26WA067Accident · 2 fatalClass 5 · ForeignRobinson R44 · Bardymsky Municipal District, RussiaJan 7, 2026 · RA-04389 · Substantial damageNTSB GAA26WA060Accident · 8 fatalClass 3 · ForeignDassault FALCON50 · Ankara, TürkiyeDec 23, 2025 · 9H-DFS · Destroyed