NTSB investigations: Continental TSIO-360 series, 2003
16 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
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\") = 2003
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") = 2003
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 FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.NTSB LAX04LA028Accident · No injuriesLimited investigationFinal reportMooney M20K · San Diego, CAthe pilot's failure to configure the airplane properly for the go-around which resulted in degraded climb performance, and his failure to maintain adequate airspeed which resulted in a stall. The tailwind was a contributing factor.NTSB DEN04LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Grand Junction, COthe pilot's improper flare and his failure to maintain airspeed resulting in a stall and hard landing.NTSB ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.NTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB IAD03LA073Accident · No injuriesLimited investigationFinal reportMooney M20K · Chesterfield, VAThe loss of engine power due to the fatigue fracture of the #2 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Alpine, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB CHI03LA279Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Port Huron, MIThe pilot misjudging the flare during landing, and his inadequate remedial action resulting in the inadvertent porpoise of the airplane.NTSB IAD03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Burnet, TXThe pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…NTSB NYC03FA153Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Montauk, NYA loss of control during climb for undetermined reasons.NTSB DEN03LA086Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Colorado Sprngs, COthe pilot's improper decision to land in the reported crosswind conditions, and his failure to maintain aircraft control. Contributing factors were the crosswind, rough terrain, airport stop sign, and fence.NTSB NYC03LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control. Factors in the accident were the crosswind and landing at night.NTSB CHI03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILThe pilot's improper flare resulting in a hard landing.NTSB SEA03FA042Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Rexburg, IDThe pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.NTSB MIA03FA071Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Cedar Key, FLThe pilot's inadequate in-flight planning/decision by his continued VFR flight into instrument meteorological condition after receiving an in-flight weather advisory. Also causal was his failure to maintain aircraft control, which resulted in flight that…NTSB MIA03LA049Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Myrtle Beach, SCA loss of engine power for undetermined reasons.