NTSB investigations: Lycoming 0-320 series, 1987, GA

8 cases on aircraft whose registry engine model is Lycoming 0-320 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 0-320 series, 1987, GA per year, 1964–2026: 282 cases
19647
196511
19668
19675
19686
19699
19704
197115
19725
19734
19747
19753
19764
19773
197810
19795
19808
19819
19827
19834
19845
19857
19864
19878
19881
19891
19903
19912
19923
19933
19943
19953
19962
19976
19986
19992
20002
20015
20026
20036
20044
20057
20065
20074
20087
20092
20105
20116
20123
20131
20141
20151
20162
20172
20181
20192
20202
20211
20225
20234
20242
20263

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.\"eventStateOrRegion\" = 'GA' 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 ('41508'))
  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 ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…Nov 22, 1987 · N7109L · Substantial damageNTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…Nov 6, 1987 · N7140G · Substantial damageNTSB ATL88LA021Accident · No injuriesLimited investigationFinal reportCessna 172P · Swainsboro, GAThe acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…Oct 23, 1987 · N4946G · Substantial damageNTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…Oct 3, 1987 · N5266E · Substantial damageNTSB ATL87LA238Accident · No injuriesLimited investigationFinal reportCessna 172M · Marietta, GAThe student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,…Aug 24, 1987 · N64191 · Substantial damageNTSB ATL87LA227Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hopeful, GAThe plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…Aug 6, 1987 · N1023K · Substantial damageNTSB ATL87FA212Accident · Serious injuriesField investigationFinal reportPiper PA-28 · Elberton, GAThe plt noted a progressive loss of pwr that began drg the climb to cruise. He diverted back toward the dep arpt & atmtdto restore pwr by activating the boost pump, moving the mixture to full rich, switching fuel tanks & applying carb heat. However, the eng…Jul 15, 1987 · N5502F · Substantial damageNTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…Jan 14, 1987 · N26900 · Substantial damage