I remember it particularly from A New Hope when Luke shoots a Stormtrooper in the Death Star and he falls into a chasm and in Return of the Jedi when a hooligan from Jabba’s barge falls into the Sarlacc Pit. Then I started hearing it elsewhere just recently. I mean really hearing it. Like, hey, I know that scream. Most recently I heard it used in the final episode of Netflix’s Sense8.
Here’s a montage of the stock sound, from the first uses of it in The Charge at Feather River to Star Wars: The Phantom Menace. In fact, it appears that George Lucas should be credited for it even becoming a thing. His repeated use of it becomes a running joke over the course of his films. I suspect its use in a film like Reservoir Dogs is due to Tarantino’s love for referencing other filmmakers, just as Lucas was likely showing his own love for a previous generation’s filmmakers in his use of it.