Fatal NTSB investigations: Lycoming 0-235 series, 1978
13 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 4 |
| 1967 | 5 |
| 1968 | 4 |
| 1969 | 4 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 3 |
| 1975 | 2 |
| 1977 | 5 |
| 1978 | 13 |
| 1979 | 14 |
| 1980 | 11 |
| 1981 | 12 |
| 1982 | 15 |
| 1983 | 14 |
| 1984 | 14 |
| 1985 | 6 |
| 1986 | 8 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 6 |
| 1990 | 11 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 3 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 10 |
| 2002 | 8 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 10 |
| 2006 | 4 |
| 2007 | 5 |
| 2008 | 6 |
| 2009 | 10 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 5 |
| 2016 | 5 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 1 |
| 2025 | 4 |
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\") = 1978
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 ('41505'))
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."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 ('41505'))
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 FTW79DA027Accident · 2 fatalClosedCessna 152 · Husser, LANTSB MIA79FA013Accident · 2 fatalClosedCessa 152 · Boca Raton, FLNTSB SEA79FA003Accident · 2 fatalClosedPiper PA-18S · Bozeman, MTNTSB MIA78FA122Accident · 2 fatalClosedPiper PA-38 · Florence, SCNTSB CHI78FEP47Accident · 1 fatalClosedChampion 7ECA · Howard, WINTSB LAX78FA062Accident · 2 fatalClosedGrum Amer AA1C · Prescott, AZNTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHNTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PANTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYNTSB ANC78FA025Accident · 1 fatalClosedPiper PA-12 · Kotzebue, AKNTSB OAK78FVG21Accident · 1 fatalClosedBreezy Stokie · Lincoln, CANTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MINTSB MIA78FA034Accident · 1 fatalClosedAmer Avco AA1-A · Ormond Beach, FL