Fatal NTSB investigations: Continental TSIO-360 series, 1983
4 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
| 1977 | 2 |
|---|---|
| 1978 | 3 |
| 1979 | 3 |
| 1980 | 9 |
| 1981 | 4 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 5 |
| 1990 | 1 |
| 1991 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 7 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 7 |
| 2007 | 4 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 4 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2026 | 1 |
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\") = 1983
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1983
AND c."highestInjuryLevel" = 'Fatal'
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 LAX84FA107Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Tehachapi, CAThe acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the…NTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…NTSB ATL83FA145Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Roanoke, VAThe acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…