Skip to content

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

21 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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" = 'RI' 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

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

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" = 'RI' 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

Run 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 ERA25FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Block Island, RIOn July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…Jul 30, 2025 · N961DA · Substantial damage NTSB ERA17LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Hopkinton, RIThe pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion.Nov 8, 2016 · N30703 · Substantial damage NTSB ERA12IA459Incident · No injuriesIncident investigationFinal reportSocata TB10 · Pawtucket, RIThe in-flight separation of the propeller blade tip due to a fatigue fracture.Jul 15, 2012 · N189TB · No damage NTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.Jun 2, 2010 · N47661 · Substantial damage NTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.Oct 14, 2002 · N5675V · Substantial damage NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.Apr 20, 2000 · N9187V · Substantial damage NTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…Aug 12, 1996 · N8121K · Substantial damage NTSB NYC95LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's failure to obtain the proper touchdown point which resulted in insufficient runway stopping distance and a subsequent overrun of the runway, and collision with trees.Aug 9, 1995 · N8121K · Substantial damage NTSB NYC93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Pawtucket, RIThe failure of both pilots to see and avoid, resulting in a ground collision between their two airplanes.Apr 7, 1993 · N3866R · 2 aircraft · Minor damage NTSB NYC87FA061Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Westerly, RIThe Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just…Jan 20, 1987 · N3293W · 2 aircraft · Minor damage NTSB NYC81FNA12Accident · Minor injuriesClosedPiper PA-28 · Chepachet, RIFeb 22, 1981 · N5248L · Destroyed NTSB NYC80FNA07Accident · Minor injuriesClosedBeech B23 · Block Island, RIJan 8, 1980 · N6699S · Substantial damage NTSB NYC78FNA23Accident · No injuriesClosedMooney M20C · Westerly, RIMay 20, 1978 · N9474V · Substantial damage NTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RIJan 14, 1978 · N2406B · Destroyed NTSB NYC75FNA26Accident · No injuriesClosedPiper PA-28 · Warwick, RINov 23, 1974 · N4375T · Substantial damage NTSB NYC72DNA32Accident · No injuriesClosedMccullough J-2 · Newport, RIFeb 5, 1972 · N4314G · Substantial damage NTSB NYC72DNA04Accident · No injuriesClosedPiper PA-28 · Block Island, RIJul 28, 1971 · N9524J · Substantial damage NTSB NYC69A0037Accident · No injuriesClosedPiper PA-28 · Lincoln, RISep 19, 1968 · N6690J · 2 aircraft · Minor damage NTSB NYC67F0403Accident · No injuriesClosedMooney M20C · Smithfield, RINov 23, 1966 · N1384W · Substantial damage NTSB NYC67A0049Accident · 1 fatalClosedHughes 269A · Lincoln, RISep 16, 1966 · N8799F · Destroyed NTSB NYC66F0012Accident · No injuriesClosedMooney M20 · Lincoln, RIMay 30, 1965 · N7863V · Substantial damage