NTSB investigations: Lycoming IO-540 series, 2010, CA
6 cases on aircraft whose registry engine model is Lycoming IO-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
| 1967 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 4 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 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\") = 2010
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 ('41530', '41585'))
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") = 2010
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 ('41530', '41585'))
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 WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.NTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.NTSB WPR10LA420Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · San Diego, CAThe pilot's failure to utilize carburetor heat during initial climb, which resulted in a loss of engine power due to carburetor icing.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB WPR10GA231Accident · 1 fatalFinal reportCessna T206H · Borrego Springs, CAThe pilot suffered a sudden incapacitating event as a result of his severe cardiovascular disease.NTSB WPR10LA195Accident · 1 fatalLimited investigationFinal reportSnow Rocket F1 · Borrego Springs, CAThe pilot's inability to maintain control due to the in-flight failure and separation of the pilot's flight control stick. The reason for the flight control stick failure could not be determined.