NTSB investigations: Lycoming 0-320 series, 1968, CA
41 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\") = 1968
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") = 1968
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 OAK69D0205Accident · No injuriesClosedPiper PA-28 · S Lake Tahoe, CANTSB LAX69D0188Accident · Minor injuriesClosedPiper PA-22 · Bermuda Dunes, CANTSB LAX69F0167Accident · No injuriesClosedPiper PA-28 · Torrance, CANTSB OAK69D0186Accident · No injuriesClosedPiper PA-23 · Morgan Hill, CANTSB OAK69D0166Accident · No injuriesClosedPiper PA-22 · Ukiah, CANTSB LAX69D0153Accident · No injuriesClosedCessna 177 · Santa Barbara, CANTSB OAK69D0135Accident · No injuriesClosedBeech A23-19 · Concord, CANTSB LAX69F0082Accident · Minor injuriesClosedPiper PA-28 · Calexico, CANTSB LAX69F0068Accident · No injuriesClosedPiper PA-28 · Upland, CANTSB OAK69D0063Accident · No injuriesClosedPiper PA-28 · Novato, CANTSB LAX69D0052Accident · No injuriesClosedPiper PA-22 · Eagle Mtn, CANTSB LAX69F0134Accident · Minor injuriesClosedPiper PA-28 · Huntgton Bch, CANTSB OAK69D0041Accident · No injuriesClosedBeech A-23 · San Carlos, CANTSB OAK69F0006Accident · No injuriesClosedPiper PA-18 · Dutch Flat, CANTSB OAK69D0024Accident · No injuriesClosedPiper PA-22 · Petaluma, CANTSB OAK68A0072Accident · 4 fatalClosedCessna 177 · Bass Lake, CANTSB LAX69F0015Accident · No injuriesClosedBeech A23 · Van Nuys, CANTSB OAK69F0097Accident · No injuriesClosedBeech A23-19 · Beckwourth, CANTSB OAK69D0018Accident · No injuriesClosedPiper PA-28 · Los Banos, CANTSB LAX68F0423Accident · No injuriesClosedPiper PA-16 · Long Beach, CANTSB LAX69D0007Accident · No injuriesClosedPiper PA-28 · Bakersfield, CANTSB LAX68D0409Accident · No injuriesClosedPiper PA-28 · Holtville, CANTSB OAK68D0373Accident · No injuriesClosedPiper PA-28 · Concord, CANTSB OAK69D0005Accident · No injuriesClosedCessna 177 · Fair Oaks, CANTSB OAK68D0371Accident · No injuriesClosedCessna 177 · Santa Cruz, CANTSB OAK68D0362Accident · No injuriesClosedPiper PA-28 · San Carlos, CANTSB LAX68D0394Accident · Minor injuriesClosedPiper PA-18 · Tehachapi, CANTSB OAK68D0364Accident · No injuriesClosedCessna 177 · Modesto, CANTSB LAX68F0401Accident · No injuriesClosedPiper PA-23 · Long Beach, CANTSB LAX68D0349Accident · No injuriesClosedCessna 150 · Compton, CANTSB OAK68D0339Accident · Minor injuriesClosedPiper PA-18 · Palo Alto, CANTSB OAK68D0342Accident · No injuriesClosedPiper PA-18 · Byron, CANTSB LAX68D0368Accident · No injuriesClosedBeech A23 · Gaviota, CANTSB OAK68D0311Accident · No injuriesClosedCessna 177 · Vernalis, CANTSB LAX68A0074Accident · 2 fatalClosedCessna 177 · Ocotillo Well, CANTSB OAK68D0292Accident · No injuriesClosedPiper PA-28 · Santa Cruz, CANTSB OAK68D0294Accident · No injuriesClosedCessna 177 · Waterford, CANTSB LAX68F0316Accident · Minor injuriesClosedCessna 177 · Imperial Bch, CANTSB OAK68D0273Accident · Minor injuriesClosedPiper PA-22 · Visalia, CANTSB OAK68D0319Accident · No injuriesClosedChampion 7GCBC · Hilt, CANTSB LAX68D0320Accident · Serious injuriesClosedPiper PA-28 · Baker, CA