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

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, 1987, WA per year, 1964–2026: 401 cases
19645
196511
19667
196712
19684
19695
19704
19716
19728
19734
19741
19756
197610
19772
197812
197910
19809
198114
19828
19837
19846
19856
19863
19875
19885
19898
19904
19918
19928
19933
199411
19958
19966
19978
199811
199911
20009
20019
20028
20037
200416
20055
20064
20071
200811
20097
20106
20117
20127
20136
20143
20151
20165
20174
20184
20192
20203
20214
20224
20231
20243
20252
20266

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\" = 'WA' 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 SEA88LA027Accident · No injuriesLimited investigationFinal reportCessna 172M · Tacoma, WAThe Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor…Nov 27, 1987 · N9134H · 2 aircraft · Substantial damageNTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…Sep 26, 1987 · N2330Q · Substantial damageNTSB SEA87LA175Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tukwila, WAWhile attempting to land in a field and at about 3 feet AGL, the pilot attempted to secure the right cabin door. Due to the distraction the pilot allowed the rear skids to contact the ground and a hard landing resulted.Aug 23, 1987 · N8379Z · Substantial damageNTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…Jun 6, 1987 · N65994 · Substantial damageNTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…Mar 19, 1987 · N64728 · Substantial damage