NTSB investigations: Lycoming O&VO-360 series, 2012
8 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the defining event was Loss of control on ground. 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
| 2008 | 6 |
|---|---|
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 8 |
| 2013 | 8 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 2 |
| 2026 | 4 |
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\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.NTSB WPR12LA325Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gooding, IDThe pilot’s failure to maintain airplane control after encountering an unexpected wind gust during landing.NTSB CEN12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Sheboygan, WIThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.NTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.NTSB ERA12CA134Accident · No injuriesData collectionFinal reportMaule M-5-180C · River Ranch, FLThe pilot’s failure to maintain directional control after encountering a wind gust during landing.