Active NC works best with low-frequency, constant sounds like planes or machinery droning, they can't react quickly enough for high-frequency, transient sounds.
That said, most NC headphones also seal very well against your ears and have good passive NC in the first place, so if you're comfortable spending a bit more it may be worth it to invest in ANC headphones. If you have a shop near you you could try them out yourself.