If you dig a hole from long island NY straight through the earth's core where would you come out?

You would never come out. The Earths core temperature would destroy any implement.

Any magma disturbed would fill in any hole, and the Earths gravity would not allow any progress away from the core.