NTSB investigations: Lycoming O&VO-360 series, 2003, NY

7 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 per year

19642026
NTSB investigations: Lycoming O&VO-360 series, 2003, NY per year, 1964–2026: 152 cases
19642
196511
19668
19673
19684
19697
19701
19711
19724
19735
19745
19753
19767
19772
19789
19794
19801
19811
19824
19831
19844
19852
19861
19872
19882
19894
19901
19912
19932
19944
19953
19962
19971
19982
19991
20002
20011
20037
20052
20072
20081
20103
20113
20122
20131
20141
20165
20213
20243

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'NY' 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'))
  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 NYC04LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Montauk, NYThe pilot's loss of control after performing an evasive maneuver to avoid a deer crossing the unlit runway, which resulted in a collision with trees. Factors related to the accident were the nighttime conditions, the inoperative runway lighting system, and…Nov 7, 2003 · N80852 · Substantial damageNTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.Jul 6, 2003 · N86985 · Substantial damageNTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.Jun 8, 2003 · N560FL · Substantial damageNTSB NYC03LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montgomery, NYThe inadequate 100-hour inspection by maintenance personnel, which resulted in a loose fuel line and loss of power. A factor related to the accident was the dark night conditions.May 5, 2003 · N55854 · Substantial damageNTSB NYC03LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ava, NYThe pilot's inadequate preflight which did not detect the contamination in the fuel, and subsequent power loss due to contaminated fuel while operating over unsuitable terrain.May 4, 2003 · N9834P · Substantial damageNTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.Apr 12, 2003 · N8985J · DestroyedNTSB NYC03LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Poughkeepsie, NYThe pilot's failure to maintain an adequate amount of engine power while maneuvering to land, which produced delayed engine response times. A facture in the accident was the cold day.Jan 18, 2003 · N5136L · Substantial damage