From Wikipedia:
Despite its popularity in zoos, and cuddly portrayal as gentle giants in fiction, elephants are among the world's most potentially dangerous animals. They can crush and kill any other land animal, even the rhinoceros. They can experience unexpected bouts of rage, and can be vindictive. In Africa, groups of young teenage elephants attack human villages in what is thought to be revenge for the destruction of their society by massive cullings done in the 1970s and 80s. In India, male elephants attack villages at night, destroying homes and killing people regularly. In the Indian state of Jharkhand, 300 people were killed by elephants between 2000 and 2004, and in Assam, 239 people have been killed by elephants since 2001. In India, elephants kill up to 200 humans every year, and in Sri Lanka around 50 per year.
Musth
Main article: Musth
Adult male elephants naturally periodically enter the state called musth (Hindi for "madness"), sometimes spelt "must" in English.
Other causes
At least a few elephants have been suspected to be drunk during their attacks. In December 1998, a herd of elephants overran a village in India. Although locals reported that nearby elephants had recently been observed drinking beer which rendered them "unpredictable", officials considered it the least likely explanation for the attack. An attack on another Indian village occurred in October 1999, and again locals believed the reason was drunkenness, but the theory was not widely accepted. Purportedly drunk elephants raided yet another Indian village again on December 2002, killing six people, which led to killing of about 200 elephants by locals.
So yeah I guess drunk elephant rage is not so likely, but village razing rage is likely. So elephants should be made into a skulking civ so that hey might sen ambushes to you:)