Is the earth fault close to neutral end of an wye connected winding very common?

Probably not, because the potential (with respect to earth) of a point on the winding, close to its neutral end, will be relatively low. Accordingly, it is less likely that the insulation will fail -the most common cause of electrical faults.