A novel mid-field breakdown of the aerodynamic force in compressible flows