NTSB investigations: Lycoming O&VO-360 series, OH
6 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 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 c.\"eventStateOrRegion\" = 'OH' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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" = 'OH' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 NYC99LA038Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Cincinnatti, OHThe flight instructor's delay in initiating remedial action. Factors include a wet runway, and the student's inability to maintain airplane directional control during a simulated, on-ground engine failure.NTSB NYC93LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Brookville, OHThe pilot's failure to maintain directional control. Contributing was the lack of recency of experience.NTSB BFO92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Carollton, OHThe pilot's inadequate starting procedure.NTSB ATL89LA134Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Millersburg, OHThe pilots failure to compensate for the gusty wind conditions during landing.NTSB CHI86LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · East Liverpool, OHAccording to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The…NTSB CHI84LA192Accident · No injuriesLimited investigationFinal reportBeech 23 · Put-In-Bay, OHDuring the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but…