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

11 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, FL per year, 1964–2026: 824 cases
19647
19658
196617
196716
196816
196911
197015
197118
197213
19739
197415
197516
197611
197718
197816
197919
198021
198120
198217
198310
198415
198515
198615
198711
198811
198911
199010
199111
199216
199310
199413
199510
199611
199714
199812
199913
200018
200115
200212
200315
200419
200514
200613
20076
200816
200914
20106
201113
20129
201310
201411
201511
201613
20179
201819
201916
202010
202113
202211
20239
202410
202510
202611

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\" = 'FL' 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 MIA88FA006Accident · 1 fatalField investigationFinal reportRobinson R-22-B · Plymouth, FLThe private pilot, with an expired medical certificate and a license restricted to no carriage of passengers, took off and experienced an engine failure for undetermined causes. He did not execute an autorotation and the aircraft crashed. The pilot had also…Oct 10, 1987 · N2276X · DestroyedNTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…Sep 19, 1987 · N92919 · 2 aircraft · DestroyedNTSB MIA87FA189Accident · 2 fatalField investigationFinal reportBeech 23 · Miramar, FLAfter the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…Jun 20, 1987 · N2387J · DestroyedNTSB MIA87LA174Accident · No injuriesLimited investigationFinal reportCessna 172P · Tallahassee, FLWhile taxiing to take off the left wing collided with an utility pole.Jun 7, 1987 · N109ER · Substantial damageNTSB MIA87LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLWhile landing, the acft floated down the rwy as the result of excessive airspeed during the apch. The plt continued to flare the acft, & as the airspeed bled off, the wings stalled, resulting in a hard landing. The acft then began to propoise, & on the third…Apr 26, 1987 · N217JA · Substantial damageNTSB MIA87LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Pine Key, FLThe plt stated that during cruise flt the eng began to run rough. He then attempted to solve the problem to no avail. Unable to maintain alt he elected to land the acft on a road. While taxiing, both wings collided with street signs. Post crash examination of…Apr 9, 1987 · N6328D · Substantial damageNTSB MIA87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ft.Lauderdale, FLThe plt reported that while towing a banner aprx 200-300 yards offshore at an alt of aprx 500 ft the eng sputtered, then quit. Attempts to restart it were unsuccessful. The banner was then released & the acft was ditched in the ocean. Post crash examination…Apr 5, 1987 · N9663H · Substantial damageNTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…Apr 5, 1987 · N8678V · Substantial damageNTSB MIA87FA114Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…Mar 20, 1987 · N726FL · DestroyedNTSB MIA87LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar Key, FLThe plt was attempting to go around after landing fast, due to a tail wind that was stronger that anticipated. Unable to climb, the acft was then blown off the rwy, collided with trees, & came to rest in the gulf of Mexico.Feb 20, 1987 · N12198 · Substantial damageNTSB MIA87LA076Accident · Minor injuriesLimited investigationFinal reportPiper J3-C65 · Pembroke Pines, FLThe plt stated that after dropping his banner, he circled back to drop the banner hook so he could land, and as he was circling, the acft stalled, started a spin to the right and struck the ground.Jan 19, 1987 · N3666K · Substantial damage