NTSB investigations: Lycoming 0-540 series, 1966, CA
25 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 | 18 |
|---|---|
| 1965 | 13 |
| 1966 | 25 |
| 1967 | 12 |
| 1968 | 14 |
| 1969 | 7 |
| 1970 | 5 |
| 1971 | 14 |
| 1972 | 7 |
| 1973 | 9 |
| 1974 | 8 |
| 1975 | 10 |
| 1976 | 10 |
| 1977 | 9 |
| 1978 | 10 |
| 1979 | 10 |
| 1980 | 7 |
| 1981 | 5 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 1 |
| 1996 | 10 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 10 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 4 |
| 2026 | 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\") = 1966
AND c.\"eventStateOrRegion\" = 'CA' 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") = 1966
AND c."eventStateOrRegion" = 'CA' 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 OAK67A0053Accident · Minor injuriesClosedPiper PA-32 · Cloverdale, CANTSB LAX67D0249Accident · No injuriesClosedHelio H-250 · New Cuyama, CANTSB OAK67D0155Accident · No injuriesClosedPiper PA-24 · Resno, CANTSB LAX66F0159Accident · No injuriesClosedPiper PA-24 · Blythe, CANTSB LAX67D0136Accident · No injuriesClosedPiper PA-24 · Lancaster, CANTSB OAK67D0113Accident · No injuriesClosedPiper PA-23 · Fresno, CANTSB LAX67F0151Accident · No injuriesClosedPiper PA-24 · Palm Springs, CANTSB LAX67D0134Accident · No injuriesClosedPiper PA-24 · El Monte, CANTSB OAK67D0182Accident · No injuriesClosedPiper PA-23 · Arcata, CANTSB OAK67F0094Accident · Minor injuriesClosedPiper PA-28 · Petaluma, CANTSB LAX67D0128Accident · No injuriesClosedPiper PA-32 · Oildale, CANTSB LAX67D0111Accident · No injuriesClosedPiper PA-23 · Oceanside, CANTSB OAK67D0051Accident · No injuriesClosedPiper PA-25 · Huron, CANTSB LAX67F0094Accident · No injuriesClosedAero Cmdr 500 · Van Nuys, CANTSB LAX67F0065Accident · Minor injuriesClosedPiper PA-32 · Walteria Sta., CANTSB OAK67D0063Accident · No injuriesClosedPiper PA-24 · San Francisco, CANTSB LAX66A0101Accident · 6 fatalClosedPiper PA-32 · Guadalupe, CANTSB LAX67F0012Accident · No injuriesClosedPiper PA-24 · Los Angeles, CANTSB OAK67D0005Accident · No injuriesClosedPiper PA-24 · Palo Alto, CANTSB LAX66F0339Accident · No injuriesClosedPiper PA-24 · Palm Springs, CANTSB LAX66D0298Accident · No injuriesClosedFpiper PA-24 · Palm Springs, CANTSB OAK66D0250Accident · No injuriesClosedPiper PA-24 · Mammoth Lakes, CANTSB LAX66D0268Accident · No injuriesClosedPiper PA-28 · Hawthorne, CANTSB LAX66D0260Accident · No injuriesClosedPiper PA-24 · Van Nuys, CANTSB LAX66F0276Accident · No injuriesClosedAero Comdr 500 · Palm Sprngs, CA