Fatal NTSB investigations: Continental C145 series, 2005
3 cases on aircraft whose registry engine model is Continental C145 series. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 4 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2005 | 3 |
| 2007 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2017 | 1 |
| 2019 | 2 |
| 2021 | 1 |
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\") = 2005
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012'))
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") = 2005
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012'))
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 SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.