Rational and irrational singular quartic threefolds