NYC area can mean many things...
If by NYC you mean Brooklyn and Queens, Republic is closer than the other places mentioned so far... And much easier to get to. There are at least two active flight schools out there, not to mention SUNY Farmingdale's offering of professional aviation degrees. There's also Islip, too, if that's not too far out.
If you are in the Bronx, White Plains is closer.