NTSB investigations: Continental C145 series, 1993
10 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 | 7 |
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\") = 1993
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") = 1993
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 LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.NTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.NTSB ANC93LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Wulik River, AKThe pilot's failure to maintain control of the airplane. A factor was the crosswind.NTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB ANC93LA139Accident · No injuriesLimited investigationFinal reportCessna 170 · Northway, AKThe pilot-in-command's inadequate compensating for the variable wind conditions.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.