Only if you disregard how natural gas is made. Fracking, and fugitive gas, and transport costs you don't seem to care about make CNG and LNG highly suspect.

Not to mention while CNG is better than gasoline which is way better than diesel. Small internal combustion engines produce large amounts of air pollution.

And there's no cost to mining coal? It also can't be transported through a pipeline like gas can.