NTSB investigations: Continental TSIO-360 series, 1987
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
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\") = 1987
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") = 1987
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 MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…NTSB NYC88FA042Accident · 2 fatalField investigationFinal reportMooney M20K · Danby, VTThe pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose…NTSB CHI87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grayslake, ILThe aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…NTSB DEN87LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-210 · Yuma, COThe plt said that during his final approach for landing he thought his airspeed was too high for touchdown and he attempted to go around. During the go around his acft struck an arpt sign and a bldg.NTSB CHI87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Plymouth, INWhile on final approach about 200 feet from the end of the runway, the right front seat passenger told the pilot she thought she saw a deer. The pilot added power for a possible go-around. Since he did not see any deer, the pilot continued his landing. He…NTSB ATL87FA142Accident · 4 fatalField investigationFinal reportCessna T337G · Oxford, OHThe pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…NTSB LAX87FA198Accident · No injuriesField investigationFinal reportMooney M20K · Long Beach, CAOn 4/28/87, after a flt from Long Beach to las vegas, the plt requested the left wing tank be svcd with 15 gal of fuel; no fuel was added to the rgt tank. Two days later, the plt took off on the return flt. Drg arrival at Long Beach, he was vectored for an…NTSB ATL87FA100Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Georgetown, DEThe plt was cleared for approach with instructions to close flt plan upon landing. Aprx thirty min later approach control called the fss and asked if the plt had been in contact. The reply was negative. No further action was taken by approach control.…NTSB LAX87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Santa Ynez, CAJust after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…NTSB ANC87LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tyonek, AKThe on-demand air taxi flight struck a moose during the takeoff roll at a private rural airstrip. The two pilot crew and one passenger were uninjured. The leading edge of the aircraft's left wing was substantially damaged; but the pilot-in-command elected to…NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…