NTSB investigations: Lycoming 0-320 series, 1969, TX
33 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\") = 1969
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") = 1969
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 FTW70F0325Accident · No injuriesClosedPiper PA-28 · Wilderado, TXNTSB FTW70F0316Accident · No injuriesClosedPiper PA-22 · Rockwall, TXNTSB FTW70F0299Accident · No injuriesClosedPiper PA-23 · Plainview, TXNTSB FTW70F0287Accident · No injuriesClosedPiper PA-28 · Pecos, TXNTSB FTW70D0241Accident · No injuriesClosedPiper PA-22 · Pilot Point, TXNTSB FTW70D0191Accident · No injuriesClosedBeech A23 · Dimmitt, TXNTSB FTW70D0131Accident · No injuriesClosedBeech A23-19 · Amarillo, TXNTSB FTW70D0139Accident · Minor injuriesClosedPiper PA-22 · Freer, TXNTSB FTW70D0128Accident · No injuriesClosedPiper PA-22 · Dickinson, TXNTSB FTW70F0089Accident · Minor injuriesClosedCessna 177 · Matagorda Is., TXNTSB FTW70D0036Accident · No injuriesClosedPiper PA-22 · Evant, TXNTSB FTW70D0057Accident · No injuriesClosedPiper PA-18 · Sterling City, TXNTSB FTW69D0530Accident · No injuriesClosedPiper PA-28 · Slaton, TXNTSB FTW70F0103Accident · Serious injuriesClosedCessna 177 · Mountain Home, TXNTSB FTW70F0149Accident · No injuriesClosedCessna 177 · Mission Valey, TXNTSB FTW70D0004Accident · No injuriesClosedPiper PA-28 · Vernon, TXNTSB FTW69F0515Accident · No injuriesClosedPiper PA-18 · Presidio, TXNTSB FTW70D0095Accident · No injuriesClosedPiper PA-28 · George West, TXNTSB FTW69D0539Accident · No injuriesClosedPiper PA-18A · Sonora, TXNTSB FTW69D0522Accident · No injuriesClosedBeech A23-19 · Plainview, TXNTSB FTW70D0002Accident · No injuriesClosedCessna 172 · Smithfield, TXNTSB FTW69D0520Accident · No injuriesClosedCallair A-5 · Littlefield, TXNTSB FTW69D0511Accident · No injuriesClosedPiper PA-28 · Eldorado, TXNTSB FTW69D0484Accident · No injuriesClosedPiper PA-28 · Abilene, TXNTSB FTW69D0473Accident · No injuriesClosedCessna 172 · Burleson, TXNTSB FTW70F0014Accident · No injuriesClosedPiper PA-18A · Bloomington, TXNTSB FTW69D0438Accident · No injuriesClosedCessna 177 · Tomball, TXNTSB FTW69F0471Accident · No injuriesClosedPiper PA-28 · San Antonio, TXNTSB FTW69D0443Accident · No injuriesClosedPiper PA-22 · Sweetwater, TXNTSB FTW69D0475Accident · No injuriesClosedPiper PA-23 · Burnet, TXNTSB FTW69D0379Accident · No injuriesClosedPiper PA-18 · Lubbock, TXNTSB FTW69F0335Accident · No injuriesClosedPiper PA-28 · Dallas, TXNTSB FTW69F0367Accident · No injuriesClosedPiper PA-28 · Seminole, TX