NTSB investigations: Lycoming 0-320 series, 1973, CA
31 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\") = 1973
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") = 1973
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 OAK74DVD18Accident · No injuriesClosedCessna 172 · Novato, CANTSB LAX74AUQ22Accident · No injuriesClosedPiper PA-28 · Valencia, CANTSB OAK74DVG19Accident · No injuriesClosedPiper PA-28 · Rio Linda, CANTSB LAX74DUG21Accident · No injuriesClosedPiper PA-28 · Yucca Vally, CANTSB OAK74FVG18Accident · No injuriesClosedBeech B19 · Sacremento, CANTSB LAX74DUQ14Accident · No injuriesClosedPiper PA-18A · Mojave, CANTSB OAK74DVA19Accident · No injuriesClosedPiper PA-28 · Madera, CANTSB OAK74DVA18Accident · No injuriesClosedPiper PA-22 · Kettleman, CANTSB ANC74DAG39Accident · No injuriesClosedPiper PA-18 · Palmer, CANTSB LAX74DUG12Accident · No injuriesClosedCessna 172K · Yucca Valy, CANTSB LAX74FUQ11Accident · Minor injuriesClosedPiper PA-28 · Boron, CANTSB OAK74DXQ06Accident · No injuriesClosedCessna 172 · Mammoth Lks, CANTSB LAX74FVA16Accident · Serious injuriesClosedPiper PA-28 · Bakersfield, CANTSB LAX74DVA10Accident · No injuriesClosedCessna 172K · Delano, CANTSB LAX74FUD01Accident · No injuriesClosedPiper PA-28 · Snta Monica, CANTSB LAX74FUQ05Accident · No injuriesClosedPiper PA-28 · Simi Valley, CANTSB LAX74FUG02Accident · No injuriesClosedPiper PA-28 · Mecca, CANTSB OAK73DVM41Accident · No injuriesClosedChampion 7GCBC · Palo Alto, CANTSB LAX73FUQ31Accident · Minor injuriesClosedPiper PA-28 · Van Nuys, CANTSB OAK73DVD33Accident · No injuriesClosedPiper PA-20 · Concord, CANTSB LAX73FUM28Accident · No injuriesClosedCessna 172K · Oceanside, CANTSB LAX73FUQ28Accident · No injuriesClosedPiper PA-18 · Tehachapi, CANTSB LAX73FUA37Accident · Minor injuriesClosedPiper PA-28 · Capistrano, CANTSB OAK73DVA45Accident · No injuriesClosedChampion 7GCAA · Chowchilla, CANTSB LAX73FUM20Accident · No injuriesClosedBeech B19 · San Diego, CANTSB LAX73FUG43Accident · Minor injuriesClosedCommuter 150 · Rubidoux, CANTSB LAX73DUG40Accident · No injuriesClosedHoward DGA15P · Elsinore, CANTSB OAK73DVM24Accident · No injuriesClosedPiper PA-28 · San Jose, CANTSB LAX73DUG32Accident · No injuriesClosedStarduster SA100 · Riverside, CANTSB LAX73DUM17Accident · No injuriesClosedPiper PA-28 · Valley Ctr, CANTSB OAK73AP019Accident · 1 fatalClosedPiper PA-28 · Hayward, CA