NTSB investigations: Lycoming 0-320 series, 1979, CA
32 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 | 25 |
|---|---|
| 1965 | 30 |
| 1966 | 46 |
| 1967 | 50 |
| 1968 | 41 |
| 1969 | 33 |
| 1970 | 41 |
| 1971 | 30 |
| 1972 | 36 |
| 1973 | 31 |
| 1974 | 24 |
| 1975 | 24 |
| 1976 | 18 |
| 1977 | 39 |
| 1978 | 36 |
| 1979 | 32 |
| 1980 | 32 |
| 1981 | 30 |
| 1982 | 28 |
| 1983 | 27 |
| 1984 | 24 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 22 |
| 1988 | 22 |
| 1989 | 19 |
| 1990 | 29 |
| 1991 | 22 |
| 1992 | 20 |
| 1993 | 28 |
| 1994 | 25 |
| 1995 | 20 |
| 1996 | 20 |
| 1997 | 13 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 24 |
| 2001 | 24 |
| 2002 | 25 |
| 2003 | 21 |
| 2004 | 17 |
| 2005 | 20 |
| 2006 | 19 |
| 2007 | 18 |
| 2008 | 17 |
| 2009 | 17 |
| 2010 | 12 |
| 2011 | 9 |
| 2012 | 6 |
| 2013 | 11 |
| 2014 | 8 |
| 2015 | 12 |
| 2016 | 12 |
| 2017 | 12 |
| 2018 | 13 |
| 2019 | 14 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 13 |
| 2024 | 9 |
| 2025 | 3 |
| 2026 | 11 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 LAX80FUA06Accident · No injuriesClosedPiper PA-22 · Dana Point, CANTSB LAX80FUA05Accident · Serious injuriesClosedPiper PA-28 · Avalon, CANTSB LAX80FUG11Accident · Serious injuriesClosedCessna 172N · La Verne, CANTSB LAX80FVD0OAccident · No injuriesClosedBellanca 7GCBC · Fremont, CANTSB LAX80DXQ01Accident · No injuriesClosedCessna 172N · Truckee, CANTSB LAX80DVM04Accident · Minor injuriesClosedPiper PA-18 · San Jose, CANTSB LAX80FUA02Accident · No injuriesClosedPiper PA-28 · Huntington Bch, CANTSB LAX79FUQ44Accident · Serious injuriesClosedPiper PA-28 · Frazier Park, CANTSB LAX79FVG75Accident · Serious injuriesClosedPiper PA-28 · Rio Linda, CANTSB LAX80DXQ09Accident · No injuriesClosedCessna 172 · Mammoth Lakes, CANTSB LAX79DA063Accident · No injuriesClosedCessna 172N · Santa Ana, CANTSB OAK79DVG63Accident · No injuriesClosedCessna 172M · Lower Lake, CANTSB LAX79FXQ22Accident · Minor injuriesClosedPiper PA-18 · Sierraville, CANTSB LAX79FUM21Accident · Minor injuriesClosedPiper PA-28 · Chula Vista, CANTSB OAK79FVD34Accident · No injuriesClosedCessna 172K · Livermore, CANTSB LAX79DUQ36Accident · No injuriesClosedBeech 19 · Santa Barbara, CANTSB LAX79FUG47Accident · No injuriesClosedPiper PA-28 · Big Bear, CANTSB LAX79FA059Accident · 4 fatalClosedCessna 177 · Long Beach, CANTSB OAK79FVM26Accident · No injuriesClosedPiper PA-28 · San Carlos, CANTSB LAX79FUG44Accident · No injuriesClosedPiper PA-23 · Riverside, CANTSB OAK79DVG47Accident · No injuriesClosedCessna 172 · Chico, CANTSB OAK79DVG44Accident · No injuriesClosedPiper PA-28 · Zenia, CANTSB LAX79FA053Accident · 2 fatalClosedPiper PA-28 · Long Beach, CANTSB LAX79DUG41Accident · No injuriesClosedCessna 172M · Giant Rock, CANTSB LAX79DUG36Accident · No injuriesClosedCessna 172N · Murrieta, CANTSB LAX79FUG32Accident · No injuriesClosedPiper PA-18A · Lake Elsinore, CANTSB LAX79FUQ23Accident · No injuriesClosedCessna 172 · Lompoc, CANTSB OAK79DVM16Accident · No injuriesClosedBellanca 7GCBC · Hollister, CANTSB LAX79DUG24Accident · No injuriesClosedMustang TWO · Yucca Valley, CANTSB LAX79FA031Accident · 3 fatalClosedCessna 172 · Mt Baldy, CANTSB LAX79FUQ18Accident · No injuriesClosedPiper PA-28 · Van Nuys, CANTSB OAK79FA015Accident · 1 fatalClosedPiper PA-28 · Porterville, CA