The story
From archery, in which an arrow that has a straight shaft flies where you shoot it, while a crooked arrow will veer off.
Etymology from Wiktionary, CC BY-SA 4.0.
straight arrow
Today it means: Someone who behaves according to conventional standards; one noted for honesty and integrity. Full definition →