NTSB investigations: Lycoming 0-540 series, 1985, CA
7 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\") = 1985
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") = 1985
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 LAX86LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Canoga Park, CAWhile the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest…NTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…NTSB LAX86LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Tustin, CAThe plt's mechanic performed a pre-purchase inspection of the acft. No malfunctions were detected with the fuel system, & the mechanic informed the plt that the acft was overall 'in good condition.' Later in the day the plt purchased the acft, & after…NTSB LAX85LA303Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Maria, CAThe pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for…NTSB LAX85FA216Accident · 1 fatalField investigationFinal reportPiper PA25-235 · Walnut Grove, CAThe acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's…NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…NTSB LAX85FA137Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Corona, CAAfter refueling, the acft took off & lost pwr at 150 ft to 200 ft AGL. The acft struck trees while in a steepening left bank & crashed in an open field adjacent to the arpt. No contaminants or water were found either in the acft's fuel system or in the fuel…