Answer by taking a quote from the following article:

Pinhead is a fictional character from the Hellraiser series, first appearing as an unnamed figure in the Clive Barker novella The Hellbound Heart. The name "Pinhead" is derived from a sobriquet given to him by the crew of the first Hellraiser film; he is first credited as such in Hellbound: Hellraiser II. Nearly thirty years after The Hellbound Heart was published, the character was given the designations the Hell Priest and the Cold Man in the sequels that followed, The Scarlet Gospels and Hellraiser: The Toll. Pinhead is one of the leaders of the Cenobites, formerly humans but transformed into creatures which reside in an extradimensional realm, who travel to Earth through a puzzle box called the Lament Configuration in order to harvest human souls.

Described by Doug Bradley as stronger than Jason Voorhees and Michael Myers, Pinhead is an extremely powerful being, and as such, has several supernatural abilities. His preferred method of attack is by summoning hooks and chains to mutilate victims, often pulling said victims in several directions to tear them apart. These chains are subject to his total mental control and he may direct them at will. The chains may even change shape after having attached to a victim. Pinhead is highly resistant to damage and direct assault, being able to resist both gunshots and futuristic energy weapons. His magic is also used for creating objects out of thin air, teleporting, creating explosions at distances and deceiving opponents with illusions. He is capable of creating other cenobites from both living and dead victims.  In order to act in the physical world, Pinhead needs to have been purposely summoned through the Lament Configuration, though this in itself is not usually enough for Pinhead to target the puzzle-solver: in Hellbound: Hellraiser II, Pinhead stops the Cenobites from torturing an emotionally traumatised girl who was manipulated as a proxy into opening the Configuration, remarking "...it is not hands that call us, it is desire." In Hell on Earth, he temporarily eliminates these restraints when he is separated from the part of him that is Elliot Spencer, wreaking havoc indiscriminately upon every human subject he encounters until he is finally defeated when Spencer willingly merges with Pinhead once again, the combination binding Pinhead as Spencer keeps his extremes in check. During this incident his powers were apparently expanded beyond their normal limits allowing him to physically warp reality to his will.  Pinhead at first has no memory of his human past, though is reminded of it in Hellbound: Hellraiser II, which results in what screenwriter Peter Atkins described as him being "spiritually weakened" and subsequently killed by the Chanard Cenobite.

What were Pinhead's limitations?
Peter Atkins described as him being "spiritually weakened" and subsequently killed by the Chanard Cenobite.