NTSB investigations: Lycoming O&VO-360 series, CO

10 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

19832026
NTSB investigations: Lycoming O&VO-360 series, CO per year, 1983–2026: 10 cases
19831
19871
19891
19921
19952
20011
20031
20041
20051

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\" = 'CO' 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.

NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…Aug 6, 2005 · N5136R · Substantial damageNTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.Sep 6, 2004 · N1907Y · DestroyedNTSB DEN03LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Englewood, COthe pilot's failure to maintain aircraft control during landing. Factors contributing to the accident were the gusting crosswinds and the high density altitude.Jul 1, 2003 · N2686W · Substantial damageNTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.Jul 3, 2001 · N66076 · Substantial damageNTSB FTW95LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind condition.Aug 6, 1995 · N7980W · Substantial damageNTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.Aug 5, 1995 · N15621 · Substantial damageNTSB DEN92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Longmont, COThe pilot's failure to maintain directional control during landing. Factors were: a snow bank alongside the runway, and gusty crosswind.Mar 16, 1992 · N6863P · Substantial damageNTSB DEN89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Durango, COThe pilot failed to maintain directional control, which resulted in an inadvertent groundloop/swerve. A factor related to the accident was: the adverse wind condition.Jun 26, 1989 · N4137Z · Substantial damageNTSB DEN87LA099Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Erie, COThe private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed…Apr 15, 1987 · N84KG · Substantial damageNTSB DEN83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Erie, CODuring a second touch & go the acft ran off the side of the rwy. The plt last flew on 10/4/82 for about a 1 hr flt.May 2, 1983 · N9088J · Substantial damage