tightening by hand probably will lead to your wheel falling off a lot more.

Look up videos on how to tighten a cog/lockring.