NTSB investigations: Continental C145 series, 2016
9 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
| 1964 | 68 |
|---|---|
| 1965 | 53 |
| 1966 | 52 |
| 1967 | 54 |
| 1968 | 45 |
| 1969 | 41 |
| 1970 | 21 |
| 1971 | 35 |
| 1972 | 30 |
| 1973 | 34 |
| 1974 | 26 |
| 1975 | 44 |
| 1976 | 29 |
| 1977 | 29 |
| 1978 | 33 |
| 1979 | 27 |
| 1980 | 18 |
| 1981 | 23 |
| 1982 | 13 |
| 1983 | 22 |
| 1984 | 15 |
| 1985 | 17 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 12 |
| 1990 | 21 |
| 1991 | 17 |
| 1992 | 11 |
| 1993 | 10 |
| 1994 | 8 |
| 1995 | 9 |
| 1996 | 16 |
| 1997 | 18 |
| 1998 | 16 |
| 1999 | 8 |
| 2000 | 7 |
| 2001 | 8 |
| 2002 | 11 |
| 2003 | 11 |
| 2004 | 10 |
| 2005 | 7 |
| 2006 | 9 |
| 2007 | 10 |
| 2008 | 8 |
| 2009 | 15 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 8 |
| 2013 | 16 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 9 |
| 2017 | 14 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 15 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 7 |
| 2024 | 12 |
| 2025 | 8 |
| 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 year(c.\"eventDate\") = 2016
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") = 2016
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 CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB GAA17CA091Accident · No injuriesData collectionFinal reportCessna 170 · Martinsville, VAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA16CA492Accident · No injuriesData collectionFinal reportCessna 170 · Sidney, MTThe student pilot’s improper landing flare, which resulted in a bounced landing, and the flight instructor’s inability to recover the airplane, which resulted in a runway excursion.NTSB CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.NTSB GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB GAA16CA324Accident · No injuriesData collectionFinal reportCessna 170 · Palmer, AKThe pilot's failure to maintain a wings-level attitude during takeoff in gusty wind conditions, which resulted in the right wing striking the ground, a loss of lateral bank control, and a nose over during the subsequent landing.NTSB GAA16CA275Accident · No injuriesData collectionFinal reportCessna 170 · Saginaw, MIThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.NTSB GAA16CA138Accident · No injuriesData collectionFinal reportCessna 170 · Enumclaw, WAThe pilot's incorrect brake application during taxi, which resulted in a nose over.NTSB CEN16LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Ingleside, TXThe loss of engine power during takeoff due to carburetor icing, which resulted in a forced landing.