As film cameras became more sophisticated -- even inexpensive point-and-shoot models -- they had mechanisms that prevented double exposures. And with today's digital cameras, I don't think it's even possible to accidentally create a double exposure.
Double exposures were often used to hoax ghost photos. The trickery was done either in the camera or later in the film darkroom by combining multiple negatives. One of the most notorious practioners of this hoaxing was William Mumler, who in the 19th century created many such photos, sometimes with famous people as ghosts. In the photo on this page, you'll see one of his more famous multiple exposures depicting the widowed Mary Todd Lincoln and the "ghost" of President Abe.

