This is not very elegant but I built a quick and dirty sample to show how it can be achieved.
So first I created a simple blueprint that has a destructible mesh icicle hanging over a target and when the target enters it drops.
Turned off the Geometry Collections Physics and marked it to notify breaks and collisions
I placed a small collision sphere on top of the target so that when the player enters it enable physics on the Geometry Collection dropping it on the players head.
Then when the Geometry Collection breaks the event fires and I can play the sound I want. In this case I only allow sound to play on the first break index so as not to get an overwhelming cacophony of sound but you can do fancy things to have more complex sounds play when certain index breaks are triggered.
Then just for good measure on hitting the player I apply damage but I make sure it only happens once so as not to kill the player instantly (unless that’s the desired effect).
Hopefully that was what you were after. If anything is unclear or you have further questions please feel free to respond.