NTSB investigations: Lycoming 0-320 series, 1970, TX
30 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\") = 1970
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") = 1970
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 FTW71FPD33Accident · No injuriesClosedPiper PA-28 · Springtown, TXNTSB FTW71DRA31Accident · No injuriesClosedPiper PA-28 · Tomball, TXNTSB FTW71FRG50Accident · No injuriesClosedCessna 172L · San Antonio, TXNTSB FTW71FPA12Accident · No injuriesClosedPiper PA-23 · Plano, TXNTSB FTW71FPD24Accident · No injuriesClosedCessna 177 · Abilene, TXNTSB FTW71FRA24Accident · No injuriesClosedPiper PA-18 · Conroe, TXNTSB FTW71FRG36Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXNTSB FTW71FPD20Accident · No injuriesClosedPiper PA-28 · Saginaw, TXNTSB FTW71FQD12Accident · No injuriesClosedPiper PA-28 · Fabens, TXNTSB FTW71FPD18Accident · No injuriesClosedCessna 172 · Arlington, TXNTSB FTW71DQG27Accident · No injuriesClosedCessna 172 · Memphis, TXNTSB FTW71DPD13Accident · No injuriesClosedCessna 177 · Iowa Park, TXNTSB FTW71DRG15Accident · No injuriesClosedPiper PA-22 · Jourdanton, TXNTSB FTW71FRA11Accident · Minor injuriesClosedPiper PA-28 · Humble, TXNTSB FTW71FPD08Accident · No injuriesClosedPiper PA-28 · Denton, TXNTSB FTW71DQG23Accident · No injuriesClosedCessna 172I · Childress, TXNTSB FTW71DQG01Accident · No injuriesClosedCessna 172K · Sterling City, TXNTSB FTW71FRG02Accident · Serious injuriesClosedPiper PA-22 · Sabinal, TXNTSB FTW71FRA04Accident · No injuriesClosedBeech 23 · Eagle Lake, TXNTSB FTW71DQG03Accident · Minor injuriesClosedChampion 7GCA · Slaton, TXNTSB FTW70DRG50Incident · No injuriesClosedPiper PA-18A · Sinton, TXNTSB FTW70AF077Accident · No injuriesClosedGen Dynamic F-102A · La Porte, TXNTSB FTW70DQG15Accident · No injuriesClosedPiper PA-28 · Sterling City, TXNTSB FTW70FPD09Accident · No injuriesClosedPiper PA-22 · Mansfield, TXNTSB FTW70DRJ09Accident · No injuriesClosedPiper PA-28 · Lufkin, TXNTSB FTW70FRG33Accident · No injuriesClosedMorrisey 2150 · San Antonio, TXNTSB FTW70FQD06Accident · No injuriesClosedPiper PA-18A · El Paso, TXNTSB FTW70DRG12Accident · No injuriesClosedCessna 177 · Randolph Afb, TXNTSB FTW70FRA04Accident · No injuriesClosedPiper PA-28 · Houston, TXNTSB FTW70FRA01Accident · Minor injuriesClosedCessna 177 · Beaumont, TX