I somehow think this was a conspiracy by Mycroft to get Sherlock terminated from the NYPD so that he'll have no other choice other than to return to London, As Mycroft wanted two episodes ago. So, I think Mycroft might have orchestrated Bell's shooting.