Fatal NTSB investigations: Lycoming 0-320 series, 1979
42 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 11 |
|---|---|
| 1965 | 5 |
| 1966 | 17 |
| 1967 | 14 |
| 1968 | 16 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 13 |
| 1972 | 10 |
| 1973 | 15 |
| 1974 | 21 |
| 1975 | 17 |
| 1976 | 17 |
| 1977 | 25 |
| 1978 | 43 |
| 1979 | 42 |
| 1980 | 36 |
| 1981 | 39 |
| 1982 | 50 |
| 1983 | 29 |
| 1984 | 26 |
| 1985 | 24 |
| 1986 | 35 |
| 1987 | 22 |
| 1988 | 38 |
| 1989 | 21 |
| 1990 | 18 |
| 1991 | 22 |
| 1992 | 21 |
| 1993 | 28 |
| 1994 | 18 |
| 1995 | 27 |
| 1996 | 17 |
| 1997 | 17 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 15 |
| 2001 | 26 |
| 2002 | 45 |
| 2003 | 26 |
| 2004 | 32 |
| 2005 | 33 |
| 2006 | 24 |
| 2007 | 28 |
| 2008 | 27 |
| 2009 | 24 |
| 2010 | 23 |
| 2011 | 14 |
| 2012 | 23 |
| 2013 | 18 |
| 2014 | 17 |
| 2015 | 23 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 12 |
| 2023 | 22 |
| 2024 | 12 |
| 2025 | 8 |
| 2026 | 16 |
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\") = 1979
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 ('41508'))
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") = 1979
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 ('41508'))
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 DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CONTSB FTW80FA021Accident · 2 fatalClosedPiper PA-28 · Sonora, TXNTSB ANC80FA020Accident · 2 fatalClosedPiper PA-18 · Grayling, AKNTSB LAX80FA012Accident · 2 fatalClosedPiper PA-28 · Phoenix, AZNTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MINTSB NYC80FA006Accident · 1 fatalClosedPiper PA-28 · Gilead, MENTSB ANC79FA096Accident · 2 fatalClosedPiper PA-18 · Skwentna, AKNTSB NYC79FA101Accident · 2 fatalClosedBeech 19 · Manchester, NHNTSB IAD79FA080Accident · 1 fatalClosedPiper PA-28 · Cashiers, NCNTSB NYC79FA091Accident · 3 fatalClosedPiper PA-28 · Charlestown, NHNTSB CHI79FEI41Accident · 1 fatalClosedOsprey 2 · Medina, OHNTSB NYC79FA090Accident · 3 fatalClosedPiper PA-28 · No.Whitehall, PANTSB IAD79FA073Accident · 4 fatalClosedCessna 172N · Pinnacle, NCNTSB CHI79FEP74Accident · 1 fatalClosedPitts Spcl S1S · Camp Douglas, WINTSB MIA79FA112Accident · 1 fatalClosedPiper PA-28 · Canton, GANTSB LAX79FA062Accident · 1 fatalClosedCessna 172 · Mesa, AZNTSB NYC79FA057Accident · 2 fatalClosedPiper PA-18S · Shenley, PANTSB CHI79FEK17Accident · 1 fatalClosedVariviggen Edgar · Columbus, OHNTSB LAX79FAMS3Accident · 2 fatalClosedPiper PA-28 · Missing AircraftNTSB OAK79DAMS6Accident · 2 fatalClosedPiper PA-28 · Maui, HINTSB NYC79FA049Accident · 3 fatalClosedPiper PA-28 · Flushing, NYNTSB MIA79FLT06Accident · 1 fatalClosedPitts S1-C · Southaven, MSNTSB LAX79FA059Accident · 4 fatalClosedCessna 177 · Long Beach, CANTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSNTSB DEN79FA042Accident · 3 fatalClosedPiper PA-28 · Moab, UTNTSB LAX79FA053Accident · 2 fatalClosedPiper PA-28 · Long Beach, CANTSB MIA79FA082Accident · 4 fatalClosedCessna 172M · San Juan, PRNTSB NYC79FA042Accident · 1 fatalClosedPiper PA-18 · Lebanon, NHNTSB MIA79FA069Accident · 1 fatalClosedAmer Avco AA-5 · Marathon, FLNTSB NYC79FGM22Accident · 2 fatalClosedPiper PA-22 · Monroeville, PANTSB MIA79FA065Accident · 3 fatalClosedPiper PA-28 · Naples, FLNTSB NYC79FA032Accident · 4 fatalClosedGrum Amer AA-5 · Pompey, NYNTSB ANC79FA041Accident · 3 fatalClosedBellanca 7GCBC · Ruby, AKNTSB MIA79FA057Accident · 1 fatalClosedPiper PA-28 · Camden, SCNTSB FTW79FA064Accident · 1 fatalClosedPiper PA-22 · Gladewater, TXNTSB MKC79FA022Accident · 2 fatalClosedChampion 7GCB · Waverly, KSNTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LANTSB LAX79FA031Accident · 3 fatalClosedCessna 172 · Mt Baldy, CANTSB DEN79FA022Accident · 1 fatalClosedPiper PA-28 · Logan, UTNTSB FTW79FA049Accident · 1 fatalClosedPiper PA-28 · Comanche, TXNTSB OAK79FAMS1Accident · 4 fatalClosedPiper PA-23 · Missing AircraftNTSB OAK79FA015Accident · 1 fatalClosedPiper PA-28 · Porterville, CA