NTSB investigations: Lycoming 0-320 series, 1986, KS

5 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, 1986, KS per year, 1964–2026: 226 cases
19647
19655
196617
19676
196811
19699
19709
19717
19728
19735
19748
19759
19765
197713
19782
197913
19804
19816
19826
19834
19841
19854
19865
19873
19882
19892
19902
19913
19922
19931
19942
19952
19961
19971
19981
19992
20011
20023
20032
20041
20052
20062
20083
20093
20104
20123
20133
20152
20191
20212
20221
20231
20241
20251
20262

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\") = 1986
    AND c.\"eventStateOrRegion\" = 'KS' 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 MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…Sep 20, 1986 · N80282 · Substantial damageNTSB MKC86LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-150C · Junction City, KSThe c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…Aug 27, 1986 · N5969W · Substantial damageNTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…Jul 18, 1986 · N2440H · Substantial damageNTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…May 18, 1986 · N1770B · Substantial damageNTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…Apr 4, 1986 · N9866G · Substantial damage