Deep piercing wounds such as those made by a nail or splinter are called?

A Puncture Wound.

That website elaborates on how it can be a small hole in the skin, to a deep gash and etc.

http://www.emedicinehealth.com/puncture_wound/article_em.htm