Fatal NTSB investigations: Lycoming I0360 series, 1986

6 cases on aircraft whose registry engine model is Lycoming I0360 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
Fatal NTSB investigations: Lycoming I0360 series, 1986 per year, 1964–2026: 386 cases
19642
19662
19672
19684
19692
19704
19711
19736
19746
19753
19765
197711
197811
197914
198012
198118
19827
19839
19846
19852
19866
19875
19888
19898
19903
19911
19926
19936
19944
19953
19964
19973
19987
199911
20006
200110
20029
20039
200412
200510
200610
20079
20085
20095
20106
20118
20126
201310
201411
20157
20165
20174
20184
20198
20203
20216
20226
20234
20241
20256
20264

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41515'))
  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 LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…Dec 27, 1986 · N50U · DestroyedNTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.Dec 11, 1986 · N32693 · Substantial damageNTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…Dec 7, 1986 · N4475F · DestroyedNTSB NYC87FA022Accident · 1 fatalField investigationFinal reportGulfstream American 112 · Beekman, NYThe acft departed dutchess county airport, poughkeepsie, NY, and had an engine failure due to inadequate lubrication. The oil filter was found disconnected from the engine. At duthess county airport parking area, fresh oil was found on the grass parking area…Oct 18, 1986 · N1207J · DestroyedNTSB DEN86FAMS3Accident · 2 fatalMissing aircraftFinal reportMooney M20F · Cuba, NMThe acft departed a private airstrip in Cuba, NM, for the purpose of viewing real estate property before continuing to taos. State authorities were notified the following day when the plt failed to arrive at work. A search for the acft was conducted until…Sep 9, 1986 · N2688W · DestroyedNTSB LAX86FA206Accident · 3 fatalField investigationFinal reportMooney M20F · Morgan Hill, CAThe pilot requested and received preflight weather briefings, twice, and was advised that VFR flight was not recommended. The flight departed and crashed into mountainous terrain that was obscured by adverse weather conditions. Witnesses reported that the…May 3, 1986 · N9309V · Destroyed