A painting by famed Spanish artist Francisco de Goya was stolen as it was being transported to a US exhibition at New York City's Guggenheim Museum.