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

6 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, IN per year, 1964–2026: 258 cases
19647
19657
196613
196712
196810
196910
19706
19718
19728
19736
19743
19759
19763
19776
197813
19799
19806
19816
19824
19832
19843
19852
19862
19876
19886
19893
19906
19914
19922
19935
19943
19963
19973
19984
19993
20002
20013
20022
20032
20044
20053
20061
20083
20093
20103
20124
20134
20143
20151
20161
20172
20181
20192
20203
20211
20222
20232
20241
20251
20261

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\" = 'IN' 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 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 CHI87LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nobelsville, INThe 160 hr tt pilot, recently checked out in this make/model acft, was returning to home base on a x-country flt. He ld long and was unable to stop before hitting a fence off the departure end of the rnwy.Aug 5, 1987 · N4358T · Substantial damageNTSB CHI87DET07Accident · 1 fatalFinal reportMcentee Stitsplaymate SA-11A · Rolling Prairie, INAircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.…Jun 21, 1987 · N2813 · DestroyedNTSB CHI87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Muncie, INAfter landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller…Jun 18, 1987 · N9174M · Substantial damageNTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…Jun 6, 1987 · N5240E · Substantial damageNTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…Feb 4, 1987 · N62503 · Substantial damage