NTSB investigations: Lycoming 0-320 series, 1980, TX
19 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\") = 1980
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") = 1980
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 FTW81FRG13Accident · No injuriesClosedCessna 172N · Laredo, TXNTSB FTW81FPD03Accident · Serious injuriesClosedHughes 269A · Newport, TXNTSB FTW80DQD04Accident · No injuriesClosedPiper PA-18 · Tornillo, TXNTSB FTW80FRG75Accident · No injuriesClosedCessna 172 · New Braunfels, TXNTSB FTW81FPA18Accident · No injuriesClosedBeech B19 · Dallas, TXNTSB FTW80FRG67Accident · No injuriesClosedCessna 150 · Mcallen, TXNTSB FTW80FA099Accident · 2 fatalClosedCessna 172M · Bridgeport, TXNTSB FTW80FRG52Accident · No injuriesClosedPiper PA-22 · Pipecreek, TXNTSB FTW80DQD11Accident · No injuriesClosedPiper PA-18 · Tornillo, TXNTSB FTW80FQG21Accident · No injuriesClosedBeech B19 · Lubbock, TXNTSB FTW80DRJ18Accident · No injuriesClosedAero-Comdr 100 · Mt.Pleasant, TXNTSB FTW80DPD26Accident · No injuriesClosedPiper PA-28 · Frisco, TXNTSB FTW80DQD06Accident · No injuriesClosedCessna 172 · Dell City, TXNTSB FTW80FA059Accident · 4 fatalClosedCessna 172B · Tomball, TXNTSB FTW80DPD16Accident · No injuriesClosedPiper PA-28 · Stamford, TXNTSB FTW80DPD09Accident · No injuriesClosedHughes 269A · Ringo, TXNTSB FTW80DRJ10Accident · No injuriesClosedCessna 172 · Milam, TXNTSB FTW80DRG21Accident · No injuriesClosedBeech B19 · George West, TXNTSB FTW80DQG09Accident · No injuriesClosedPiper PA-28 · Wink, TX