Fatal NTSB investigations: Lycoming O&VO-360 series, 1978
26 cases on aircraft whose registry engine model is Lycoming O&VO-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 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 8 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 6 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 5 |
| 1975 | 7 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 26 |
| 1979 | 19 |
| 1980 | 20 |
| 1981 | 20 |
| 1982 | 15 |
| 1983 | 9 |
| 1984 | 14 |
| 1985 | 8 |
| 1986 | 8 |
| 1987 | 17 |
| 1988 | 9 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 11 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 17 |
| 2002 | 21 |
| 2003 | 25 |
| 2004 | 18 |
| 2005 | 14 |
| 2006 | 11 |
| 2007 | 6 |
| 2008 | 9 |
| 2009 | 11 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 13 |
| 2013 | 6 |
| 2014 | 11 |
| 2015 | 2 |
| 2016 | 7 |
| 2017 | 13 |
| 2018 | 9 |
| 2019 | 16 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 7 |
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 ('41514'))
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 ('41514'))
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 IAD79FA026Accident · 2 fatalClosedCessna 177B · Charlotte, NCNTSB LAX79FA022Accident · 4 fatalClosedPiper PA-24 · Springerville, AZNTSB FTW79FA022Accident · 1 fatalClosedPiper PA-28 · Hempstead, TXNTSB IAD79FA020Accident · 3 fatalClosedPiper PA-24 · Marlinton, WVNTSB OAK79FA004Accident · 1 fatalClosedPiper PA-28 · Galt, CANTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDNTSB SEA78FA066Accident · 4 fatalClosedPiper PA-28 · Hall, MTNTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, INNTSB OAK78DA046Accident · 1 fatalClosedPiper PA-28 · Fort Ross, CANTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYNTSB ANC79FA051Accident · 1 fatalClosedBrantly B2-B · Nome, AKNTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKNTSB DEN78FA050Accident · 4 fatalClosedPiper PA-28 · Silverton, CONTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTNTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NENTSB MIA78FA091Accident · 3 fatalClosedMooney M20C · Jackson, ALNTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WANTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VANTSB DEN78FA042Accident · 2 fatalClosedBellanca 8GCBC · Nunn, CONTSB MIA78FA063Accident · 1 fatalClosedPiper PA-28 · St.Petersburg, FLNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORNTSB IAD78FA051Accident · 3 fatalClosedPiper PA-28 · Wilmington, DENTSB DEN78FA023Accident · 1 fatalClosedPiper PA-24 · Pojoaque, NMNTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UTNTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RINTSB LAX78FA018Accident · 4 fatalClosedBeech C-23 · Mojave, CA