Most commonly, the rollers inside get gummed up and cease to spin reliably (or at all). A rolling ball is unfortunately a great device for conveying crud directly into the mouse's interior. A periodic clean usually takes care of this.

Other failures are relatively rare. I haven't seen too many other than an occasional bad IR LED or a broken cable connection. As others said, these mice are fairly robust.