The story
Onomatopoeic from pip + squeak. Cited as early as 1900, the term originally referred to a small artillery shell. In later uses, it became largely onomatopoeic, influenced in part by popular culture, including the comic strip Pip, Squeak and Wilfred.
Etymology from Wiktionary, CC BY-SA 4.0.