NTSB investigations: Lycoming O&VO-360 series, PA
5 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
| 1987 | 2 |
|---|---|
| 1988 | 1 |
| 1993 | 1 |
| 2006 | 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\" = 'PA' 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" = 'PA' 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 NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.NTSB BFO93LA097Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reedsville, PATailwheel landing gear system components failing due to their worn condition resulting in the loss of ground steering capability. A factor in this accident was a gusting crosswind encountered during landing roll.NTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…NTSB NYC87LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Waynesburg, PAThe pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the…NTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.