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

9 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

19822026
NTSB investigations: Lycoming O&VO-360 series, 2007 per year, 1982–2026: 200 cases
19829
19836
19849
198512
19867
198711
19888
19898
19908
19912
19929
19939
19947
19957
19962
19974
19989
19993
20007
20019
20028
20039
20049
200510
20069
20079

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 year(c.\"eventDate\") = 2007
    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 DEN08CA034Accident · No injuriesData collectionFinal reportGodwin, David P Sorrell SNJ-7 · Belen, NMthe pilot's loss of directional control during landing resulting in a ground loop.Nov 27, 2007 · N74SR · Substantial damageNTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.Sep 18, 2007 · N9285J · Substantial damageNTSB DFW07CA213Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Tunica, MSThe pilot's failure to compensate for the existing wind conditions during a crosswind landing. A factor was the crosswind.Aug 15, 2007 · N7906W · Substantial damageNTSB CHI07CA236Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Berryville, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway and impacting terrain. A factor in the accident was the dirt embankment.Jul 27, 2007 · N5094P · Substantial damageNTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.Apr 24, 2007 · N800CP · Substantial damageNTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.Mar 24, 2007 · N4988L · Substantial damageNTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.Mar 11, 2007 · N9150S · Substantial damageNTSB SEA07CA042Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Buckley, WAThe pilot's failure to release brake pressure soon enough when his airplane skidded from wet grass onto dry terrain during an off-airport, full-stop landing. A factor was the change in terrain from wet grass to dry ground in the landing area.Jan 5, 2007 · N186AC · Substantial damageNTSB LAX07CA070Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Jackpot, NVthe pilot's failure to maintain directional control after encountering loose snow conditions on the runway.Jan 1, 2007 · N7769W · Substantial damage