Consumers turned pessimistic on the economy in September, bringing a four-month win streak to an abrupt halt.