NTSB investigations: Lycoming O-360 series
6 cases on aircraft whose registry engine model is Lycoming O-360 series, where the first occurrence was “Roll over”. 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
| 2003 | 2 |
|---|---|
| 2005 | 1 |
| 2007 | 3 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41575')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 380))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41575')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 380))
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 DFW07CA096Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · Spring, TXThe student pilot's improper use of the flight controls resulting in dynamic rollover. Contributing factors were the delayed remedial action by the flight instructor and the uneven, muddy terrain conditions.NTSB LAX07CA041Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Tulare, CAThe student pilot's improper use of the collective and cyclic control, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB LAX07CA073Accident · No injuriesData collectionFinal reportRobinson R-22 Beta 2 · Salem, ORThe student pilot's improper remedial action when a dynamic rollover was encountered.NTSB LAX05LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Waddell, AZthe pilot's failure to maintain adequate rotor rpm and obstacle clearance, resulting in a dynamic rollover and collision with terrain.NTSB LAX03LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta II · Phoenix, AZThe instructor's inadequate supervision and his failure to maintain aircraft control. The wind gusts were a factor.NTSB NYC03LA045Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Pittsfield, MAThe pilot's failure to maintain control, which resulted in a rollover. Factors in this accident were the night light conditions, ice covered ramp and a snowbank.