There are tons of mistakes you can make in your SEO. From blackhat use, to
greyhat (you know, the keyword stuffing you did when you didn't know better
)
use, to bad neighborhood linking, etc... the list goes on and on.
But the biggest mistake I see for SEO is a simple one: it's neglecting to
stay in tune of the market trend pertaining to your specific niche.