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

5 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight collision with terrain/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

19872026
NTSB investigations: Lycoming O&VO-360 series, CO per year, 1987–2026: 5 cases
19871
19941
19991
20011
20021

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\" = 230))
  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 FTW02FA222Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Gypsum, COThe pilot's failure to perform remedial action and maintain clearance with the rising mountainous terrain. Contributing factors were the pilot's poor planning/decision, the rising terrain, and the high density altitude.Aug 1, 2002 · N6444J · DestroyedNTSB DEN01LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Gunnison, COthe pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…Jul 28, 2001 · N401TA · DestroyedNTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.Sep 1, 1999 · N4366D · DestroyedNTSB FTW94LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Trinidad, COThe pilot's failure to maintain terrain clearance.Aug 28, 1994 · N5372T · Substantial damageNTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.Jul 28, 1987 · N4709R · Substantial damage