It's not a spell that's often used, but it's notable for appearing in the Goblet of Fire, when Harry uses it against a Hungarian Horntail dragon during the First Task.
The spell is quite effective in making the dragon fall, but it's important to note that it doesn't necessarily *kill* the dragon. It's just a way to incapacitate it for a short period of time.