A man being investigated by counter terror police over a crossbow and firearm attack has died in hospital.