An American contractor for the UN who was detained at the airport in Yemen's capital Sanaa last month has died, the US state department says.