NTSB investigations: Cessna 208B, 1995
6 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
| 1973 | 1 |
|---|---|
| 1981 | 1 |
| 1987 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 6 |
| 1996 | 1 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 6 |
| 2006 | 1 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 6 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 5 |
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 year(c.\"eventDate\") = 1995
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 year(c."eventDate") = 1995
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 LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB LAX95FA141Accident · 1 fatalField investigationFinal reportCessna 208B · Reno, NVthe pilot's failure to comply with published instrument approach procedures by a premature descent below the minimum altitude specified for the approach.NTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB LAX95FA077Accident · 1 fatalField investigationFinal reportCessna 208B · Pleasanton, CAfailure of the pilot-in-command to maintain visual contact with terrain and sufficient altitude for terrain clearance. Factors in the accident were the pilot's decision to initiate a descent 14 miles from the airport, and weather, specifically cloud…NTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…