According to NY law if one spouse dies and the property was in both names who becomes sole owner of property?

That depends on how the title was described in the acquisition deed. If the couple acquired as joint tenants with the right of survivorship or as tenants by the entirety the surviving spouse will automatically become the sole owner of the property.