Ongoing NTSB investigations, OK
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 6 |
| 2026 | 6 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'OK' 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 c."eventStateOrRegion" = 'OK' 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 CEN27LA029Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28 · Claremore, OKOn October 22, 2026, about 1510 central daylight time, a Piper PA-28-160 airplane, N5393W, was substantially damaged when it was involved in an accident near Claremore, Oklahoma. The flight instructor and student pilot were not injured. The airplane was…NTSB CEN26FA275Accident · 1 fatalClass 3 · FieldPreliminary reportBeech E18S · Guymon, OKOn August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA248Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Tulsa, OKOn July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…NTSB 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 CEN26LA175Accident · No injuriesClass 3 · LimitedPreliminary reportHiller UH-12E · Chickasha, OKOn April 30, 2026, about 1730 central daylight time, a Hiller UH-12E, N22SP, was substantially damaged when it was involved in an accident near Chickasha, Oklahoma. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ANC26LA035Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7EC · Hollis, OKNTSB WPR26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportHughes 369D · Pryor, OKOn December 5, 2025, about 0858 central standard time, a Hughes 369D, N161LA, was substantially damaged when it was involved in an accident near Pryor, Oklahoma. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB CEN25FA320Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172L · Walters, OKOn August 14, 2025, about 0934 central daylight time, a Cessna 172L, N2860Q, was destroyed when it was involved in an accident near Walters, Oklahoma. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code of Federal Regulations as…NTSB CEN25LA229Accident · 1 fatalClass 3 · LimitedPreliminary reportRans S-14 · Guthrie, OKOn June 30, 2025, about 2054 central daylight time, a Rans S-14 airplane, N981CS, was substantially damaged when it was involved in an accident near Guthrie, Oklahoma. The non-certificated pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN25LA192Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-32RT-300T · Tulsa, OKOn May 30, 2025, about 1627 central daylight time, a Piper PA-32RT-300T airplane, N130XR, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…NTSB CEN25LA173Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 180F · Duncan, OKOn April 30, 2025, about 1950 central daylight time, a Cessna 180F airplane, N2135Z, sustained substantial damage when it was involved in an accident at the Halliburton Field Airport (DUC), Duncan, Oklahoma. The pilot and passenger were not injured. The…NTSB CEN25FA148Accident · 1 fatalClass 3 · FieldPreliminary reportAnusiewicz Cassutt III M · Haskell, OKOn April 8, 2025, about 1459 central daylight time, a Cassutt III M airplane, N5RR, was substantially damaged when it was involved in an accident near Haskell, Oklahoma. The pilot was fatally injured. The aircraft was operated as a Title 14 Code of Federal…NTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…