Ongoing NTSB investigations: Cessna 208B
7 cases on aircraft the registry lists as Cessna 208B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 2 |
| 2026 | 3 |
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.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073701', '2073700', '2073705'))
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."completionStatus" = 'Ongoing'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073701', '2073700', '2073705'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 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 WPR26LA219Accident · 1 fatalClass 4 · LimitedInvestigation openCessna 208B · Marana, AZNTSB WPR26LA205Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 208B · Shelton, WANTSB ERA25LA254Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 208 · Monroe, NJOn July 2, 2025, about 1729 eastern daylight time, a Cessna 208B, N716MM, was substantially damaged when it was involved in an accident near Monroe, New Jersey. The two commercial pilots and 10 passengers were seriously injured, while three passengers…NTSB CEN25LA122Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Dallas, TXOn March 14, 2025, about 0738 central daylight time, a Cessna 208B airplane, N9471B, sustained substantial damage when it was involved in an accident at the Dallas-Fort Worth International Airport (DFW), Dallas, Texas. The pilot was not injured. The airplane…NTSB ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB ERA24FA309Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 208 · Youngstown, NYOn July 20, 2024, about 1140 eastern daylight time, a Cessna 208B, N1259K, was destroyed when it was involved in an accident near Youngstown, New York. The commercial pilot was fatally injured. The airplane was operated by Skydive the Falls as a Title 14 Code…