NTSB investigations: Lycoming 0-320 series, 1987

12 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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

19822026
NTSB investigations: Lycoming 0-320 series, 1987 per year, 1982–2026: 393 cases
198232
198312
198417
198519
198620
198712
198814
198915
199013
199114
199218
199315
199417
199511
199614
199715
199815
199916
20009
200115
200213
200311
200415
200512
200616
200713

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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 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 CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…Sep 20, 1987 · N7108B · Substantial damageNTSB ANC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot of the airplane was an Alaska state trooper performing his official duties and was flying an airplane owned and operated by the state of Alaska. He had landed on a remote ridge top to recover essential items of evidence for a pending case. Upon…Sep 17, 1987 · N7051 · Substantial damageNTSB CHI87LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Perham, MNThe pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed.Sep 6, 1987 · N734GF · Substantial damageNTSB BFO87FA050Accident · Minor injuriesField investigationFinal reportCessna 172P · Whitemarsh, MDThe pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not…Aug 2, 1987 · N54905 · Substantial damageNTSB BFO87DIG08Accident · Minor injuriesFinal reportPiper PA-28 · Mitchellville, MDDuring takeoff, the acft hit the tops of trees near the departure end of the rwy. The plt stated that after clipping the treetops, he knew the acft was 'going in,' so he pulled the yoke back to slow it as much as possible. Also, the plt stated that during…Jul 31, 1987 · N55757 · Substantial damageNTSB LAX87LA258Accident · No injuriesLimited investigationFinal reportCessna 172 · Hawthorne, CADrg an apch to rwy 25, the acft collided with the omni directional apch lighting system (odals). The plt indcd that she enctrd a downdraft on short final & applied full power; however, the acft contd to dscnd & struck one of the odals light cover lenses with…Jul 8, 1987 · N1466U · Substantial damageNTSB LAX87LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auberry, CADuring an approach into a private airstrip, the student pilot touched-down, then decided that there was not enough stopping distance and elected to go-around. On the initial climb-out the aircraft struck an object that made the aircraft yaw right then left.…Jun 28, 1987 · N2856H · Substantial damageNTSB NYC87LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Valatie, NYThe Robinson R-22B took off from a open field, traveled 600 feet and struck suspended utility lines at approximately 25-30 ft. afterward, the helicopter was landed successfully. Other lines were approximately 1000 ft from the departure point. The pilot was…May 2, 1987 · N2442A · Substantial damageNTSB MKC87FA094Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Neelyville, MOWitnesses stated that the p.I.c. had aborted several takeoff attempts while trying to depart to the north--the winds were originating from the southwest at approximately 5 mph. The aircraft eventually departed from, and almost used the full length of, runway…Apr 29, 1987 · N44213 · DestroyedNTSB MKC87LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Muscatine, IAThe grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a…Apr 5, 1987 · N79179 · Destroyed