I would imagine that the actual tattoo itself is a work for hire, but if the tattoo artist first created the artwork and then tattooed it onto the person, and wasn't explicitly paid for the first bit, you could argue that the tattoo is a copy (made by the copyright owner) of a copyrighted work.