New York is the latest addition to states where 1940 U.S Census records are searchable by name via Ancestry.com. Records are free to search.
Additional info/links in this blog post.
Other states with records searchable by name (as of June 6, 2012):
But wait, that’s not all!
More Records: New York State Archives Partners with Ancestry.com