NTSB investigations: Lycoming 0-540 series, 1967, TX
26 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 10 |
|---|---|
| 1965 | 16 |
| 1966 | 14 |
| 1967 | 26 |
| 1968 | 13 |
| 1969 | 14 |
| 1970 | 12 |
| 1971 | 12 |
| 1972 | 10 |
| 1973 | 5 |
| 1974 | 10 |
| 1975 | 9 |
| 1976 | 7 |
| 1977 | 16 |
| 1978 | 5 |
| 1979 | 6 |
| 1980 | 9 |
| 1981 | 8 |
| 1982 | 7 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 6 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 1 |
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\") = 1967
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 ('41532'))
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") = 1967
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 ('41532'))
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 FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXNTSB FTW68D0377Accident · No injuriesClosedPiper PA-23 · Andrews, TXNTSB FTW68D0426Accident · No injuriesClosedPiper PA-24 · Maude, TXNTSB FTW68D0345Accident · Serious injuriesClosedPiper PA-32 · Del Rio, TXNTSB FTW68F0295Accident · No injuriesClosedPiper PA-25 · Dumas, TXNTSB FTW68F0272Accident · No injuriesClosedPiper PA-24 · Mcniel, TXNTSB FTW68F0233Accident · Minor injuriesClosedPiper PA-25 · Hereford, TXNTSB FTW68D0198Accident · No injuriesClosedPiper PA-28 · Matador, TXNTSB FTW68D0258Accident · No injuriesClosedPiper PA-25 · Dimmitt, TXNTSB FTW68D0168Accident · No injuriesClosedPiper PA-25 · Plainview, TXNTSB FTW68D0153Accident · No injuriesClosedPiper PA-24 · Stanton, TXNTSB FTW68D0183Accident · No injuriesClosedPiper PA-25 · La Sara, TXNTSB FTW68F0120Accident · Serious injuriesClosedPiper PA-25 · Wharton, TXNTSB FTW68F0031Accident · No injuriesClosedPiper PA-24 · Rockwell, TXNTSB FTW68D0110Accident · No injuriesClosedPiper PA-28 · Petersburg, TXNTSB FTW68D0068Accident · No injuriesClosedCallair A-9 · Floydada, TXNTSB FTW68F0084Accident · No injuriesClosedPiper PA-25 · Santa Rosa, TXNTSB FTW68D0025Accident · No injuriesClosedPiper PA-25 · Sunray, TXNTSB FTW68D0009Accident · No injuriesClosedPiper PA-28 · Ralls, TXNTSB FTW68D0007Accident · No injuriesClosedPiper PA-32 · Shallowater, TXNTSB FTW67D0602Accident · No injuriesClosedPiper PA-25 · Wharton, TXNTSB FTW67F0582Accident · No injuriesClosedPiper PA-24 · Luling, TXNTSB FTW67D0560Accident · No injuriesClosedPiper PA-24 · Stamford, TXNTSB FTW67F0536Accident · No injuriesClosedPiper PA-24 · Big Springs, TXNTSB FTW67D0552Accident · Minor injuriesClosedPiper PA-25 · Spearman, TXNTSB FTW67F0434Accident · No injuriesClosedPiper PA-24 · Angleton, TX