Suppose I have a global coordinate system on a manifold, which is affine with respect to an affine connection on that manifold. The connection is flat and torsion free, and the connection coefficients are 0 w.r.t to the coordinate system. What additional properties of the connection would result in all geodesics being straight lines in the coordinate system? What about only locally? Note that the connection is not necessarily a Levi-Civita connection. I'm new to differential geometry so please excuse any mistakes in terminology.
The geodesics are straight lines, in geodesic normal coordinates, just when the associated projective connection is flat. See Kobayashi and Nagano, On projective connections, Journal of Mathematics and Mechanics, vol. 13, no. 2, 1964. If an affine connection is projectively flat, then the Weyl and Cotton tensors vanish, as these are projective connection invariants. In dimensions 3 or higher, these conditions force the affine connection to be that of a constant curvature Riemannian metric. Indeed, Beltrami proved that a projectively flat affine connection is locally that of a constant curvature Riemannian metric.