NTSB investigations: Lycoming 0-320 series, 1964, TX
28 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 | 28 |
|---|---|
| 1965 | 25 |
| 1966 | 30 |
| 1967 | 27 |
| 1968 | 34 |
| 1969 | 33 |
| 1970 | 30 |
| 1971 | 16 |
| 1972 | 24 |
| 1973 | 14 |
| 1974 | 20 |
| 1975 | 18 |
| 1976 | 26 |
| 1977 | 23 |
| 1978 | 23 |
| 1979 | 24 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 25 |
| 1983 | 14 |
| 1984 | 11 |
| 1985 | 11 |
| 1986 | 13 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 11 |
| 1993 | 16 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 13 |
| 2000 | 11 |
| 2001 | 9 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 14 |
| 2005 | 10 |
| 2006 | 14 |
| 2007 | 7 |
| 2008 | 13 |
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 10 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 13 |
| 2021 | 9 |
| 2022 | 11 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 7 |
| 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\") = 1964
AND c.\"eventStateOrRegion\" = 'TX' 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") = 1964
AND c."eventStateOrRegion" = 'TX' 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 UNK65X1086Accident · No injuriesClosedPiper PA28 · Addison, TXNTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXNTSB UNK65X0834Accident · No injuriesClosedPiper PA18 · Marfa, TXNTSB UNK65X0778Accident · No injuriesClosedPiper PA-28 · Bula, TXNTSB UNK65X0620Accident · No injuriesClosedBeechcraft PA-23 · Dallas, TXNTSB UNK65X0615Accident · No injuriesClosedPiper PA22 · Alice, TXNTSB UNK65X0405Accident · No injuriesClosedPiper PA28 · Beckenridge, TXNTSB UNK65X0372Accident · No injuriesClosedPiper PA23 · Laporte, TXNTSB UNK64X3929Accident · 1 fatalClosedPiper PA-25 · Hereford, TXNTSB UNK64X3906Accident · Serious injuriesClosedPiper PA25 · Mclean, TXNTSB UNK64X3819Accident · No injuriesClosedPiper PA28 · Houston, TXNTSB UNK64X3513Accident · No injuriesClosedPiper PA22 · Sheffield, TXNTSB UNK64X3412Accident · No injuriesClosedPiper PA25 · Abilene, TXNTSB UNK64X3346Accident · No injuriesClosedCallair A5 · Victoria, TXNTSB UNK64X2949Accident · No injuriesClosedBeechcraft 23 · Pearland, TXNTSB UNK64X2815Accident · Serious injuriesClosedChampion 7GCB · Raymondville, TXNTSB UNK64X2637Accident · No injuriesClosedBeechcraft M23 · Abilene, TXNTSB UNK64X2533Accident · No injuriesClosedPiper PA23 · Ft Worth, TXNTSB UNK64X2481Accident · No injuriesClosedBeechcraft 23 · Seminole, TXNTSB UNK64X2479Accident · No injuriesClosedPiper PA28 · Fabens, TXNTSB UNK64X2298Accident · No injuriesClosedPiper PA25 · Spearman, TXNTSB UNK64X2282Accident · No injuriesClosedBeechcraft 23 · Dallas, TXNTSB UNK64X2219Accident · No injuriesClosedPiper PA25 · Raymondville, TXNTSB UNK64X1735Accident · No injuriesClosedPiper PA28 · Cresson, TXNTSB UNK64X1628Accident · No injuriesClosedPiper PA23 · Abilene, TXNTSB UNK64X1537Accident · No injuriesClosedPiper PA28 · Post, TXNTSB UNK64X0537Accident · No injuriesClosedPiper PA23 · Beeville, TXNTSB UNK64X0462Accident · No injuriesClosedPiper PA22 · Cotton Center, TX