I did this explosion by rendering out a fluid simulation in Maya, creating a flipbook of it in After Effects and bringing all that fireball goodness into Unreal Engine 4. 

 

The ground material is from Unreal Engine 4's Starter Content.