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

7 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, AZ per year, 1964–2026: 383 cases
19647
19656
19666
19675
19687
19693
19707
197111
19723
19736
19744
19757
19769
19775
197814
19799
19809
198110
198214
19832
19842
19857
19867
19872
19882
19899
19906
19918
19924
19933
19946
19955
19964
199710
19988
19995
20006
20017
200213
20036
20046
20059
200611
200710
20087
20096
20104
20113
201210
20135
20147
20151
20161
20173
20184
20194
20204
20216
20225
20234
20244
20251
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.\"eventStateOrRegion\" = 'AZ' 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 LAX87LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZAt the end of a local pleasure flight, the pilot attempted a downwind landing by following other traffic in the pattern. During touchdown, the left wing lifted. The pilot corrected by moving the control stick to the left. At that time, the aircraft became…Nov 17, 1986 · N4101E · Substantial damageNTSB LAX86FA315Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Phoenix, AZThe recently certificated private pilot initiated flt with an over loaded acft into high density alt conditions. The acft stalled as it made a climbing left turn to the crosswind leg of the traffic pattern. The stall resulted in an uncontrolled collision with…Aug 7, 1986 · N8876N · DestroyedNTSB LAX86LA269Accident · No injuriesLimited investigationFinal reportBeech B-19 · Scottsdale, AZThe acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy.Jun 25, 1986 · N5420M · Substantial damageNTSB LAX86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springerville, AZThe acft collided with two parked acft after the student pilot lost control during a go-around. The student stated that during his first landing of the day the acft started to 'slide sideways' and he elected to go-around. He increased the throttle and the…May 22, 1986 · N3505K · DestroyedNTSB LAX86LA195Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearny, AZThe plt stated that he was on a sightseeing flt and was flying westbound at about 100 ft AGL along the gila river, when the acft struck powerlines. The acft then descended into the river bed. He futher stated that he observed the powerlines at the last minute…Apr 27, 1986 · N12962 · DestroyedNTSB LAX86LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 · Grand Canyon, AZThe pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further…Apr 12, 1986 · N211DM · Substantial damageNTSB LAX86FA089Accident · 3 fatalField investigationFinal reportCessna 172N · Grand Canyon, AZThe acft deptd runway 03 at Grand Canyon airport, Grand Canyon, AZ on a moonless night. Shortly after departure the aircraft entered into a left turn. The aircraft collided into some trees in about a 45 deg nose down and about a 15 deg left wing down attitude…Jan 9, 1986 · N2113E · Destroyed