NTSB investigations: Lycoming O&VO-360 series, 2008
73 cases on aircraft whose registry engine model is Lycoming O&VO-360 series. 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, newest first
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\") = 2008
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'))
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") = 2008
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'))
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 DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.NTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.NTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.NTSB DEN08CA083Accident · No injuriesData collectionFinal reportBeech 76 · Cleburne, TXThe failure of the flight instructor and student pilot to extend the landing gear prior to the airplane touching down on the runway.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB DFW08LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Paducah, TXFatigue failure and separation of the propeller during cruise flight. Contributing to the accident was the owner's failure to comply with a long standing Airworthiness Directive.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB DFW08CA082Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Horseshoe Bay, TXThe certified flight instructor's delay in taking remedial action which resulted in an unsuccessful autorotation.NTSB LAX08CA075Accident · No injuriesData collectionFinal reportBeech C23 · Marble Canyon, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed during the flare. Contributing to the accident were wind gusts and a crosswind.NTSB NYC08FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta II · Wilmington, NCThe pilot's failure to maintain proper rotor rpm after a partial loss of engine power.NTSB NYC08CA118Accident · No injuriesData collectionFinal reportCessna 172SP · Lincoln Park, NJThe certificated flight instructor's delayed decision to go-around.NTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.NTSB LAX08FA068Accident · 3 fatalField investigationFinal reportMooney M20C · Riverside, CAThe pilot's failure to maintain airspeed and aircraft control, resulting in an aerodynamic stall.NTSB NYC08CA113Accident · Serious injuriesData collectionFinal reportCessna 177B · Quincy, FLThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of engine power.NTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.NTSB CHI08CA079Accident · No injuriesData collectionFinal reportCessna 172RG · Litchfield, ILThe pilot's intentional low altitude flight and his failure to maintain clearance from the static wire. Contributing to the accident were the static wire, the partial loss of engine power due to propeller vibration, and the muddy field in which the forced…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…NTSB MIA08LA053Accident · No injuriesLimited investigationFinal reportCessna C-172RG · Chamblee, GAA cracked nose gear actuator o-ring resulting in hydraulic fluid exhaustion, and collapse of the main gear.NTSB MIA08LA041Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Norwood, MAThe loss of engine power for undetermined reasons. *This report was modified on May 20, 2008.*NTSB SEA08LA057Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Sonoma, CAThe departing pilot's inadequate visual lookout.