Will a knock sensor code fail a nys inspection?

That will cause you to fail an emissions inspection. Anything which triggers the CEL will, because everything which triggers it will adversely impact the emissions system on that vehicle.