NTSB investigations: Continental TSIO-360 series, 1978
18 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\") = 1978
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") = 1978
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 DEN79FQA08Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMNTSB FTW79DRD02Accident · No injuriesClosedPiper PA-34 · Westwego, LANTSB NYC78FNE35Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB LAX78DUM38Accident · No injuriesClosedPiper PA-34T · San Diego, CANTSB MKC78DER92Accident · No injuriesClosedCessna P337H · Jacobsen, MNNTSB IAD78DLJ25Accident · No injuriesClosedCessna 188B · Zebvlon, NCNTSB MKC78DCG54Accident · No injuriesClosedPiper PA-28R · Bethany, MONTSB IAD78FLQ26Accident · No injuriesClosedPiper PA-34 · Louisville, KYNTSB MIA78FA101Accident · 2 fatalClosedPiper PA-28R · Courtland, ALNTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORNTSB SEA78FYA11Accident · No injuriesClosedPiper PA-28R · Hailey, IDNTSB LAX78DUJ80Accident · No injuriesClosedPiper PA-28R · Dolan Springs, AZNTSB MIA78DKJ37Accident · No injuriesClosedPiper PA-34 · Eufaula, ALNTSB LAX78FUA15Accident · No injuriesClosedPiper PA-34 · Fullerton, CANTSB OAK78FVG26Accident · 1 fatalClosedPiper PA-28R · Alturas, CANTSB DEN78FTC20Accident · No injuriesClosedPiper PA-34 · Cheyenne, WYNTSB MIA78FLA26Accident · Minor injuriesClosedPiper PA-34 · Madison, FLNTSB MKC78DCA18Accident · No injuriesClosedPiper PA-34 · Malden, MO