Well, that got me curious and after Google searching, there appears to be a number of explanations.
The one description that dated back to the 1600's that seems to be likely
The derivation of this little phrase is the sizzling, whistling sound made by steam escaping from very hot food, which is similar to the sound of high-pitched musical pipes.
An early citation is given in Philemon Holland's translation of Pliny's Historie of the world, 1601:
"Beanes... fried all whole as they be, and so cast piping hot into sharp vineger."