Ongoing NTSB investigations, 2026, ID
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 2024 | 1 |
|---|---|
| 2025 | 7 |
| 2026 | 10 |
Where
Latest cases
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 year(c.\"eventDate\") = 2026
AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Ongoing'
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 year(c."eventDate") = 2026 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Ongoing' 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 WPR26LA353Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182P · Warren, IDNTSB WPR26LA314Accident · No injuriesClass 4 · LimitedInvestigation openKfa Safari · Coolin, IDNTSB WPR26LA304Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · McCall, IDNTSB WPR26LA307Accident · Serious injuriesClass 4 · LimitedInvestigation openCirrus Design SF50 · Driggs, IDNTSB WPR26LA302Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Salmon, IDOn August 9, 2026, at 1420 mountain daylight time, a Cessna 208B airplane, N247JP, was substantially damaged when it was involved in an accident near Salmon, Idaho. The pilot and eight passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26FA284Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Blackfoot, IDOn August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…NTSB WPR26LA270Accident · No injuriesClass 3 · LimitedPreliminary reportEnstrom F-28F · Malad City, IDOn July 21, 2026, about 0815 mountain daylight time, an Enstrom F-28F helicopter, N8624B, was substantially damaged when it was involved in an accident near Malad City, Idaho. The pilot and pilot-rated passenger were not injured. The helicopter was operated…NTSB WPR26LA185Accident · No injuriesClass 3 · LimitedPreliminary reportCraig Ellison Bearhawk Four · Sandpoint, IDOn May 12, 2026, about 1940 Pacific daylight time (PDT), an experimental amateur-built Bearhawk Four airplane, N953CN, was substantially damaged when it was involved in an accident at Olmstead Sky Ranch in Sandpoint, Idaho. The pilot was uninjured, and the…NTSB WPR26FA101Accident · 1 fatalClass 3 · FieldPreliminary reportSonex Onex · Caldwell, IDOn February 6, 2026, about 0945 mountain standard time, a Sonex Onex airplane, N362DZ, was destroyed when it was involved in an accident near Caldwell, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA091Accident · 2 fatalClass 3 · FieldPreliminary reportN126c CCX-1865 · Montour, IDOn January 27, 2026, about 1100 mountain standard time, an amateur-built, experimental CCX-1865 Carbon Cub, N126C, was substantially damaged when it was involved in an accident near Montour, Idaho. The pilot and pilot-rated passenger were fatally injured. The…