NTSB investigations: Lycoming O&VO-360 series, 2012
10 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the defining event was Loss of control in flight. 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 | 12 |
|---|---|
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 10 |
| 2013 | 6 |
| 2014 | 8 |
| 2015 | 3 |
| 2016 | 9 |
| 2017 | 10 |
| 2018 | 5 |
| 2019 | 9 |
| 2020 | 8 |
| 2021 | 7 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 6 |
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\") = 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\" = '240'))
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" = '240'))
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 CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.NTSB WPR12CA419Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · French Valley, CAThe pilot’s loss of directional control during a go-around following a sudden change in wind direction.NTSB ERA12LA549Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Manville, NJThe pilot’s failure to maintain directional control during the landing and attempted go-around.NTSB WPR12CA390Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Manzanita, ORThe pilot’s inadequate compensation for the crosswind during landing, which resulted in a loss of directional control.NTSB CEN12LA532Accident · No injuriesLimited investigationFinal reportCessna 177B · Evansville, INThe pilot’s loss of control due to an inaccurate attitude reference, which was caused by an impending (“in process”) failure of the bearing in the attitude indicator.NTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.NTSB CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB WPR12LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Rawlins, WYThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.NTSB ERA12LA145Accident · 2 fatalLimited investigationFinal reportPiper PA-24-180 · Brewster, MAThe flight crew’s loss of airplane control.