NTSB investigations: Lycoming 0-320 series, 1987

8 cases on aircraft whose registry engine model is Lycoming 0-320 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

19822026
NTSB investigations: Lycoming 0-320 series, 1987 per year, 1982–2026: 254 cases
198224
19839
198411
19857
198613
19878
19888
198910
19909
199115
199213
199311
19944
19959
19969
199711
19986
19997
20006
200115
20027
200312
200413
20055
20065
20077

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\") = 1987
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
      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 CHI88LA028Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Belle Plaine, MNAfter the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in…Nov 19, 1987 · N2716Z · Substantial damageNTSB ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…Oct 11, 1987 · N111MJ · DestroyedNTSB LAX87LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Byron, CAWith the wind out of the southwest at 8 to 10 knots, the plt was taxiing the acft in a northerly direction at a high enough speed to keep 'on the step'. When he attempted to turn the acft to a southwesterly heading for tkof, the acft failed to respond. Rather…Sep 15, 1987 · N999BA · DestroyedNTSB ANC87LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Mcgrath, AKA local hunting guide crashed his airplane in a remote mountain pass in central Alaska. Another guide who overflew the crash site shortly after the accident saw the airplane burning, but was unable to land due to strong winds, severe turbulence and strong…Sep 5, 1987 · N4191Z · DestroyedNTSB NYC87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-28-161 · Nantucket, MAThe Piper PA-28-161 with a pilot and passenger onboard disappeared from the radar scope while being vectored to an ILS approach to rwy 24 at Nantucket, MA. The controller observed the aircraft in a southeasterly heading and asked the tower controller to…Aug 23, 1987 · N83232 · DestroyedNTSB ANC87LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot was reconnoitering for game animals when he overlooked the rising terrain until he could no longer outclimb or turn away from it. The acft collided with a large rock and came to rest in a grass area.Jul 24, 1987 · N2571H · Substantial damageNTSB ANC87LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKAfter several passes ovr the airstrip the plt set up to lnd on the 600 ft long dirt rwy located on a mtn ridge. He stated that on final he lost sight of the strip and elected not to land. The acft was unable to outclimb the rising terrain.Jul 20, 1987 · N9131D · Substantial damageNTSB ANC87LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear, AKThe pilot of the ski equipped airplane stated he taxied too fast after landing and damaged the airplane after the right ski toed into a large snow drift on rough surface ice.Feb 7, 1987 · N102TC · Substantial damage