Aww, poor little guy
One of my yorkies gets scared outside too. Is yours food motivated? If so, you might want to try bringing a jar of meat baby food with you and letting him lick from it as soon as he gets outside and/or when there is a scary noise. After a while, he'll start to associate going outside with getting yummy food, and he'll have a positive response to going outside. Good luck!