US hostage Luke Somers killed in Yemen in failed rescue attempt, his sister says.