NTSB investigations: Cessna 208B, Outside the U.S.
12 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
| 1993 | 1 |
|---|---|
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2007 | 2 |
| 2015 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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 c.\"eventCountry\" <> 'USA'
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."eventCountry" <> 'USA'
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 GAA26WA272Occurrence · No injuriesClass 5 · ForeignCessna 208B · Bimini, BahamasNTSB GAA24WA089Accident · 1 fatalClass 5 · ForeignCessna 208 · Puerto Escondido, MexicoNTSB GAA23WA099Accident · No injuriesClass 5 · ForeignCessna 208B · Puente de Ixtla, MexicoNTSB GAA22WA316Accident · Serious injuriesClass 5 · ForeignCessna 208 · Al Ajban, United Arab EmiratesNTSB CEN20WA423IncidentClass 5 · ForeignCessna 208B · Beef Island, British Virgin IslandsNTSB ERA15WA310Accident · Minor injuriesForeign investigationCessna 208B · Saba, NTOn August 12, 2015, at 1630 Universal Coordinated Time (UTC), a Cessna 208B, U.S. Registration N924FE, operated by Mountain Air Cargo, was substantially damaged following a loss of engine power and ditching in the Caribbean Sea near Saba, Netherlands…NTSB MIA08WA033Accident · No injuriesClass 5 · ForeignCessna 208B · Chub Cay, BahamasOn December 20, 2007, about 1630 Atlantic standard time, a Cessna 208B, N954PA, registered to and operated by Agape Flights, Inc., was ditched in the Atlantic Ocean approximately 30 nautical miles west-northwest of Chub Cay, Bahamas. The commercial-rated…NTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandNTSB ENG03RA010Accident · Minor injuriesForeign investigationCessna 208 · Caqueta Province, ColombiaNTSB NYC00WA014Accident · No injuriesForeign investigationCessna 208B · Lake Erie, CanadaNTSB NYC99WA028Accident · No injuriesForeign investigationCessna 208B · Hamilton, CanadaNTSB BFO93WA145Accident · 1 fatalForeign investigationCessna 208B · Valensol, France