Are the prophets and sages infallible?

How do we reconcile the reverence for the previous generations with the fact that they may err? Even Moshe admits a mistake in this week's parsha.