NTSB investigations: Continental TSIO-360 series, 2014
11 cases on aircraft whose registry engine model is Continental TSIO-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 |
|---|---|
| 1967 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 5 |
| 1978 | 18 |
| 1979 | 9 |
| 1980 | 20 |
| 1981 | 14 |
| 1982 | 16 |
| 1983 | 18 |
| 1984 | 15 |
| 1985 | 18 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 14 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 7 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 12 |
| 1998 | 9 |
| 1999 | 12 |
| 2000 | 6 |
| 2001 | 13 |
| 2002 | 13 |
| 2003 | 16 |
| 2004 | 11 |
| 2005 | 10 |
| 2006 | 11 |
| 2007 | 14 |
| 2008 | 12 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 9 |
| 2012 | 10 |
| 2013 | 7 |
| 2014 | 11 |
| 2015 | 7 |
| 2016 | 5 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 3 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 7 |
| 2023 | 11 |
| 2024 | 10 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 2014
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17019', '17023'))
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") = 2014
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17019', '17023'))
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 CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.NTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.NTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…NTSB CEN14LA489Accident · No injuriesLimited investigationFinal reportGallager John C Glasair · Highland Heights, OHThe pilot’s loss of aircraft control during landing, and his failure to maintain directional control.NTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…NTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.NTSB ERA14CA284Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Defuniak Springs, FLThe pilot's failure to maintain directional control in gusty wind conditions during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.NTSB ERA14LA242Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Georgetown, DEThe pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.