NTSB investigations: Continental TSIO-360 series, 1988
14 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\") = 1988
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") = 1988
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 NYC89FA036Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Gans, PAPilot's bad judgement in flying in weather conditions beyond the capabilities of his aircraft. The pilot overstressed the aircraft and sheared the left wing by making an abrupt turn in turbulent air above the design maneuvering speed (VA). The accumulation of…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB FTW88FA161Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Carthage, TXDrg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the…NTSB MIA88IA230Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tampa, FLShortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.…NTSB MIA88LA227Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St. Petersburg, FLThe 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt…NTSB DEN88LA143Accident · No injuriesLimited investigationFinal reportMooney M-20K · Gunnison, CONTSB DEN88FA141Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Capitan, NMNTSB LAX88LA208Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Corona, CACompany maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic…NTSB FTW88FA114Accident · Minor injuriesField investigationFinal reportCessna 172P · Houston, TXMooney N231QB was involved in a midair collision with Cessna N96957 while both aircraft were landing at the uncontrolled west Houston-lakeside airport. The Mooney aircraft was returning on a straight-in approach. The pilots of the Cessna aircraft were in the…NTSB LAX88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grand Canyon, AZFailure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee…NTSB LAX88FA215Accident · 4 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAInflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot , which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects…NTSB LAX88LA186Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Merced, CAWhile taxiing on a dirt road, the right wing struck a tree resulting in substantial damage. There were no mechanical failures or malfunctions reported at the time of the accident.NTSB LAX88LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbia, CAAt the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down…NTSB LAX88LA122Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lower Lake, CADrg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion…