Excellent video demonstration of a non-Newtonian fluid:

They filled a pool with a mix of cornstarch and water made on a concrete mixer truck. It becomes a non-newtonian fluid. When stress is applied to the liquid it exhibits properties of a solid.

Here's the Wikipedia entry.