NTSB investigations: Lycoming O&VO-360 series, IL
5 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 | 3 |
|---|---|
| 2009 | 1 |
| 2020 | 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 c.\"eventStateOrRegion\" = 'IL' 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 ('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 c."eventStateOrRegion" = 'IL' 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 ('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 CEN20CA308Accident · Serious injuriesClass 4 · Data collectionFinal reportMaule MXT7 · Hillsboro, ILThe pilot's exceedance of the airplane's critical angle of attack while attempting to avoid a deer during landing, resulting in an aerodynamic stall.NTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of controlNTSB CHI08CA174Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Greenwood, ILThe student pilot's inadequate compensation for the gusting crosswind, and the flight instructor's delayed remedial actions that resulted in a loss of control during the go-around maneuver. Contributing to the accident was the gusting wind condition.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB CHI08CA078Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Cahokia, ILThe flight instructor's failure to correct for proper runway alignment during final approach and his failure to maintain aircraft control during his subsequent go-around. Contributing to the accident was the dual-student's failure to properly align with the…