All the Nation tri memberships (England, Scotland, and even Wales) do offer international personal injury insurance. Triarthlon Scotland is 15 quid cheaper than the other two ??????
For international marathons I've always used Global Travel Insurance which does cover you for 'extreme' sports. I made a claim once and after much arguing and throwing my toys around they did eventually pay! 