NTSB investigations: Continental IO-360 series, 2018
7 cases on aircraft whose registry engine model is Continental IO-360 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 | 1 |
|---|---|
| 1965 | 11 |
| 1966 | 12 |
| 1967 | 17 |
| 1968 | 18 |
| 1969 | 16 |
| 1970 | 19 |
| 1971 | 15 |
| 1972 | 12 |
| 1973 | 12 |
| 1974 | 13 |
| 1975 | 20 |
| 1976 | 12 |
| 1977 | 17 |
| 1978 | 29 |
| 1979 | 20 |
| 1980 | 19 |
| 1981 | 13 |
| 1982 | 17 |
| 1983 | 10 |
| 1984 | 14 |
| 1985 | 12 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 10 |
| 1989 | 10 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 5 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 6 |
| 1999 | 9 |
| 2000 | 8 |
| 2001 | 12 |
| 2002 | 13 |
| 2003 | 12 |
| 2004 | 9 |
| 2005 | 17 |
| 2006 | 13 |
| 2007 | 6 |
| 2008 | 15 |
| 2009 | 12 |
| 2010 | 8 |
| 2011 | 11 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 5 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 7 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 9 |
| 2023 | 7 |
| 2024 | 8 |
| 2025 | 8 |
| 2026 | 4 |
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\") = 2018
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045'))
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") = 2018
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045'))
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 CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB CEN18LA335Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Springs, COThe airplane’s failure to maintain a climb after takeoff, which resulted in a forced landing on unsuitable terrain; the reason for the airplane’s failure to climb could not be determined based on the available evidence.NTSB WPR18LA215Accident · No injuriesLimited investigationFinal reportCessna T337 · Lewiston, IDThe liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…NTSB CEN18LA246Accident · No injuriesLimited investigationFinal reportCessna 337 · Baldwin City, KSThe loss of hydraulic accumulator pressure for reasons that could not be determined, which prevented the propeller from unfeathering, and the pilot's improper decision to attempt a go-around, which resulted in an off-airport landing and the airplane impacting…NTSB ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.NTSB CEN18LA195Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Katy, TXThe loss of airplane control on takeoff due to the absence of the attachment bolt for the left aileron actuation arm.NTSB ERA18LA098Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Churchville, MDThe pilot's improper landing flare, which resulted in the airplane ballooning on touchdown, and his subsequent failure to maintain directional control during the attempted landing and subsequent go-around.