Hi BaliHai,
From the editors of Electrical Apparatus Magazine they offer a book answering some of the most frequently asked questions about electromechanical maintenance, repair, and application called Let's Solve Your Problems. This paperback answers real questions posed by real people in manufacturing plants and repair shops around the U.S. and abroad. As a repair shop plant manager I use this frequently for reference. A good winding failure chart for failures in three phase stator windings that has pictures of the most common winding failures like, single phased, phase to phase, turn to turn,unbalanced voltage, overload, locked rotor, winding grounded in the slot, etc.. with detailed pictures can be purchased from EASA, Electrical Apparatus Service Association. I use a bearing failure chart from SKF bearing mfg that has descriptive bearing failures.
I hope this helps! To purchase Let's Solve Your Problem call 312-321-9440 the cost is around $29.95 To purchase EASA winding failure chart call 314-993-2220 and to get skf bearing failure charts contact your nearest skf bearing distributor.
Motorhead1