NTSB investigations: Lycoming 0-540 series, 1982, CA
4 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\") = 1982
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") = 1982
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 LAX82FA260Accident · 5 fatalField investigationFinal reportCessna TR182 · Happy Camp, CAThe aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined.NTSB LAX82DA198Accident · No injuriesFinal reportPiper PA-24-250 · Apple Valley, CADuring a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was…NTSB LAX82FVA11Accident · 1 fatalFinal reportCessna TR182 · Oakdale, CAThe aircraft was observed to porpoise several times during the takeoff roll, become airborne with the landing gear immediately retracting, then nose down with the propeller striking, the runway. The pilot continued the takeoff and the aircraft climbed to…NTSB LAX82FA049Accident · 2 fatalField investigationFinal reportMooney M20C · Victorville, CAThe pilot had planned to fly to the big bear airport, but changed his destination to apple valley, California. While on an easterly heading at about 6800 ft MSL, a collision occurred with another aircraft, a Mooney M20C, N7860V. The Piper pilot believed that…