NTSB investigations: Lycoming 0-320 series, 1972, CA
36 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\") = 1972
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") = 1972
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 LAX73DUM16Accident · No injuriesClosedCessna 177 · Imperial, CANTSB LAX73DVA27Accident · No injuriesClosedCessna 172 · Bakersfield, CANTSB LAX73DUG2IAccident · No injuriesClosedPiper PA-28 · Havasu Ldg, CANTSB OAK73DVG22Accident · No injuriesClosedCessna 172 · Vacaville, CANTSB LAX73DUG19Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CANTSB LAX73FUM06Accident · No injuriesClosedPiper PA-23 · San Diego, CANTSB OAK73DVD13Accident · Minor injuriesClosedPitts Spec S-1C · Tracey, CANTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CANTSB OAK73DVG14Accident · No injuriesClosedPiper PA-22 · Redding, CANTSB LAX73DVM03Accident · No injuriesClosedAero-Comdr 100 · Niland, CANTSB LAX73AL007Accident · 3 fatalClosedPiper PA-28 · Ontario, CANTSB OAK73DVA13Accident · No injuriesClosedPiper PA-22 · Mariposa, CANTSB LAX73FUM01Accident · No injuriesClosedPiper PA-28 · Ramona, CANTSB LAX73FUG08Accident · No injuriesClosedPiper PA-28 · Rialto, CANTSB LAX73FUG07Accident · Serious injuriesClosedCessna 177 · Corona, CANTSB LAX73AL004Accident · 3 fatalClosedCessna 172 · La Jolla, CANTSB LAX73FUA04Accident · No injuriesClosedPiper PA-28 · Torrance, CANTSB OAK73FVD05Accident · No injuriesClosedBeech A23-19 · Vineburg, CANTSB OAK73FVG03Accident · No injuriesClosedCessna 177 · Shngle Spgs, CANTSB LAX73DUQ06Accident · No injuriesClosedCessna 172 · Inyokern, CANTSB OAK72FVA79Accident · No injuriesClosedPiper PA-28 · Columbia, CANTSB OAK72DVM35Accident · No injuriesClosedCessna 172 · San Jose, CANTSB LAX72DUQ88Accident · No injuriesClosedChampion 7KCAB · Pacoima, CANTSB OAK72DVG56Accident · No injuriesClosedCessna 177 · Paradise, CANTSB LAX72FUQ79Accident · No injuriesClosedPiper PA-28 · Quartz Hill, CANTSB OAK72DVA65Accident · No injuriesClosedCessna 172 · Dunlap, CANTSB LAX72DVA63Accident · No injuriesClosedCessna 172 · Shafter, CANTSB LAX72DVA64Accident · No injuriesClosedPiper PA-28 · Bakersfield, CANTSB LAX72DUM22Accident · No injuriesClosedPiper PA-28 · Santee, CANTSB OAK72DVG40Accident · No injuriesClosedPiper PA-28 · Nut Tree, CANTSB OAK72DVA50Accident · No injuriesClosedPiper PA-28 · Tulare, CANTSB OAK72DVD36Accident · No injuriesClosedCessna 177 · Hayward, CANTSB OAK72DVM24Accident · No injuriesClosedPiper PA-22 · Gonzales, CANTSB LAX72AL045Accident · No injuriesClosedCessna 150J · Fntn Valley, CANTSB LAX72DUG49Accident · Minor injuriesClosedPiper PA-28 · Thermal, CANTSB LAX72FUQ59Accident · Minor injuriesClosedCessna 172K · Palmdale, CA