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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA26WA244Accident · 2 fatalClass 5 · ForeignMaxair MU582 · Tel Adashim, IsraelNTSB 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…NTSB GAA26WA248Accident · 2 fatalClass 5 · ForeignNorth American T28 · Limburghof, GermanyNTSB GAA26WA193Accident · 4 fatalClass 5 · ForeignCessna 210 · Hammerstein, NamibiaNTSB 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…NTSB GAA26WA183Accident · 1 fatalClass 5 · ForeignCessna 182 · Santa Cruz Barillas, GuatemalaNTSB 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…NTSB GAA26WA179Accident · 2 fatalClass 5 · ForeignDiamond DA42 · Parafield, AustraliaNTSB GAA26WA319Accident · 1 fatalClass 5 · ForeignShark Aero Shark · Oldenburg Hatten, GermanyNTSB GAA26WA178Accident · 14 fatalClass 5 · ForeignCessna 208 · Jubasu, SudanNTSB GAA26WA174Accident · 1 fatalClass 5 · ForeignThrush S2R · Tiquisate, Escunintia, GuatemalaNTSB GAA26WA176Accident · 1 fatalClass 5 · ForeignRobinson R22 · Jericho, AustraliaNTSB GAA26WA190Accident · 1 fatalClass 5 · ForeignCessna U206 · Sao Paulo, BrazilNTSB 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…NTSB GAA26WA164Accident · 1 fatalClass 5 · ForeignCessna 208 · Imbaimadai, GuyanaNTSB 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…NTSB GAA26WA157Accident · 1 fatalForeign investigationCessna F172 · Middelburg, NetherlandsNTSB GAA26WA150Accident · 4 fatalClass 5 · ForeignPiper PA46 · Capão da Canoa, BrazilNTSB GAA26WA149Accident · 2 fatalClass 5 · ForeignBeech 18 · Coron, PhilippinesNTSB GAA26WA171Accident · 1 fatalForeign investigationRobinson R44 · New Brunswick, CanadaNTSB GAA26WA140Accident · 1 fatalClass 5 · ForeignThrush S2R · San Juan, EcuadorNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB GAA26WA135Accident · 2 fatalClass 5 · ForeignCessna 152 · Amazonas, BrazilNTSB 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…NTSB 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…NTSB GAA26WA129Accident · 4 fatalClass 5 · ForeignCessna 182 · San Marcos, GuatemalaNTSB GAA26WA257Accident · 1 fatalClass 5 · ForeignVans RV14 · Cima di Lago, SwitzerlandNTSB GAA26WA124Accident · 1 fatalClass 5 · ForeignThrush S2R · La Lima, HondurasNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB GAA26WA118Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Wesselsbron, South AfricaNTSB GAA26WA117Accident · 3 fatalClass 5 · ForeignRobinson R44 · Amaranka, RussiaNTSB 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…NTSB 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…NTSB GAA26WA088Accident · 2 fatalClass 5 · ForeignCirrus SR20 · Greater Manchester, United KingdomNTSB GAA26WA085Accident · 5 fatalClass 3 · ForeignLearjet 45XR · Sawantwadi, IndiaNTSB GAA26WA087Accident · 2 fatalClass 5 · ForeignHughes 269C · Paekakariki Hill, New ZealandNTSB GAA26WA082Accident · 3 fatalClass 5 · ForeignCessna 172 · Comunidad Wichimi, EcuadorNTSB GAA26WA091Accident · 1 fatalClass 5 · ForeignCessna 172 · Caracaraí,, BrazilNTSB GAA26WA074Accident · 3 fatalClass 5 · ForeignRobinson R44 · Rio de Janeiro, BrazilNTSB GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaNTSB GAA26WA073Accident · 1 fatalClass 3 · ForeignAir Tractor AT602 · Lucas do Rio Verde, BrazilNTSB 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…NTSB GAA26WA067Accident · 2 fatalClass 5 · ForeignRobinson R44 · Bardymsky Municipal District, RussiaNTSB GAA26WA060Accident · 8 fatalClass 3 · ForeignDassault FALCON50 · Ankara, Türkiye