NTSB investigations: Lycoming 0-540 series, 2014, CA
5 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
Open the mapLatest 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\") = 2014
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") = 2014
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 WPR15FA045Accident · 1 fatalField investigationFinal reportPiper PA 24-250 · Garberville, CAA loss of engine power for reasons that could not be determined due to extensive damage sustained during the collision and postaccident water immersion.NTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.NTSB WPR14LA367Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Warner Springs, CAThe glider pilot's failure to maintain directional control during the initial climb while being towed, which led to the tow plane's unstable flight and its subsequent aerodynamic stall. Contributing to the accident was the tow pilot's delayed release of the…NTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.NTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.