NTSB investigations
1,708 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.\"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."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 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…NTSB GAA26WA258Accident · 2 fatalClass 5 · ForeignCessna 335 · Barinas, VenezuelaNTSB GAA26WA255Accident · No injuriesClass 5 · ForeignCessna TU206 · Gachancipa, ColombiaNTSB GAA26WA261Incident · 1 fatalClass 5 · ForeignCessna 152 · Mengeringhausen, GermanyNTSB GAA26WA251Accident · 2 fatalClass 5 · ForeignHughes 369 · British Columbia, CanadaNTSB 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…NTSB GAA26WA273Accident · No injuriesClass 5 · ForeignCessna 208 · Monterrey, MexicoNTSB GAA26WA254Incident · No injuriesForeign investigationBritish Aerospace HS-125-700 · Santa Lucia, MexicoNTSB GAA26WA250Accident · 2 fatalClass 5 · ForeignPiper PA28 · Seitenstetten, AustriaNTSB GAA26WA265Accident · 1 fatalClass 5 · ForeignRobinson R44 · RorainóPolis, BrazilNTSB ANC26LA071Accident · Serious injuriesClass 4 · LimitedInvestigation openBellanca 7GCBC · Skwentna, AKNTSB GAA26WA249Accident · 10 fatalClass 3 · ForeignCessna 402C · Nicholls Town, BahamasNTSB GAA26WA245Accident · Serious injuriesClass 5 · ForeignAyres S2R · La Lima, HondurasNTSB GAA26WA259Accident · Serious injuriesClass 5 · ForeignPiper PA31T · Navegantes, BrazilNTSB GAA26WA332Accident · 1 fatalClass 5 · ForeignRobin DR400 · Alençon, FranceNTSB GAA26WA274Incident · No injuriesClass 5 · ForeignCessna 180 · El Cebruno, ColombiaNTSB GAA26WA243Accident · 2 fatalClass 5 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB GAA26WA238Accident · No injuriesClass 5 · ForeignCirrus SR22 · Chichester, United KingdomNTSB GAA26WA237Accident · 2 fatalClass 5 · ForeignBeech V35 · San Miguel Pochuta, GuatemalaNTSB GAA26WA234Accident · 2 fatalClass 5 · ForeignCessna A152 · Ongar, United KingdomNTSB 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…NTSB GAA26WA236Accident · 11 fatalClass 5 · ForeignPilatus PC6 · Tomblaine, FranceNTSB GAA26WA235Accident · 2 fatalClass 5 · ForeignPiper PA28 · Fochville, South AfricaNTSB GAA26WA242Accident · No injuriesClass 5 · ForeignCessna 172 · São Gabriel do Oeste, BrazilNTSB GAA26WA231Incident · No injuriesForeign investigationHonda HA420 · Yao, JapanNTSB GAA26WA233Accident · 3 fatalClass 5 · ForeignRockwell 690 · Fort Simpson, CanadaNTSB GAA26WA230Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Warsaw, PolandNTSB GAA26WA228Accident · No injuriesClass 5 · ForeignCessna 401 · Ciudad del Carmen, MexicoNTSB GAA26WA227Accident · No injuriesClass 5 · ForeignLake LA4 · Egelsbach, GermanyNTSB GAA26WA226Accident · 2 fatalClass 5 · ForeignPiper PA28 · Al Hoceïma, MoroccoNTSB 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…NTSB GAA26WA220Accident · 2 fatalClass 5 · ForeignCessna 421 · La Baule-Escoublac, FranceNTSB 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…NTSB GAA26WA216Accident · 9 fatalClass 4 · ForeignBell 206 · Recreio dos Bandeirantes, Rio de Janeiro., BrazilNTSB 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…NTSB 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…NTSB GAA26WA223Accident · 1 fatalClass 5 · ForeignBell 206 · Lesa, ItalyNTSB GAA26WA217Accident · 1 fatalClass 5 · ForeignCessna 172 · 6th of October City, EgyptNTSB GAA26WA225Accident · No injuriesClass 5 · ForeignRobinson R44 · Nadi, FijiNTSB GAA26WA222Occurrence · No injuriesClass 5 · ForeignBombardier CL-600-2B16 · Asaba, NigeriaNTSB GAA26WA218Accident · 2 fatalClass 5 · ForeignBeech 58 · Marilia-Sao Paulo, BrazilNTSB GAA26WA210Accident · 2 fatalClass 5 · ForeignGulfstream Gulfstream 200 · La Romana, Dominican RepublicNTSB GAA26WA224Accident · 1 fatalClass 5 · ForeignShort SC7 · Be'er Sheva, IsraelNTSB GAA26WA207Accident · 4 fatalClass 5 · ForeignBeech G36 · Medulin, CroatiaNTSB GAA26WA209Accident · 1 fatalClass 5 · ForeignRobinson R44 · Kasina Wielka, PolandNTSB GAA26WA293Accident · No injuriesClass 5 · ForeignChampion 8KCAB · Stockholm, SwedenNTSB GAA26WA206Accident · 4 fatalClass 5 · ForeignCessna TU206 · La Macarena, ColombiaNTSB GAA26WA205Accident · 1 fatalClass 5 · ForeignCessna 152 · Valbrembo, ItalyNTSB 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…NTSB 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…