How to turn off Physics Simulation after collision

I have a VR pawn set up that triggers the sphere (Projectiles) to turn on its Physics simulation. I was wondering if there is a way to turn off the simulation after it collides with a destructible mesh?

I was also thinking of creating a projectile instead but mine is not an FPS game. The VR experience I’m making only triggers events through object overlap since I’m only using the headset.

^ I want the simulation to end after it creates this effect.

But unfortunately it continues to roll off and creates an undesirable look.

Went about it differently instead. And this set up works fine:
https://docs.unrealengine.com/latest/INT/Engine/Matinee/HowTo/MHT_8/