Plugging USB hard drive put my Mac to sleep
This can happen if for some reason it pulls more power then the computer can handle.  If this happens only once, I wouldn't worry about it too much, however if it becomes a repeat issue, it could mean there is a problem with the power regulation, the USB port, or both.