If I remember correctly, Scorpio's story goes that while trying to assassinate Orion (due to his insistent philandering), he got stomped on in the process; killing both Orion and himself. The Gods who saw this were touched by Scorpio for dying in the line of duty. In response, they placed his body among the stars; in commemoration for his noble act.