I have a 91 Explorer with the same symptoms. When I turn right enough to take some weight off the right front tire, the noise goes away or is greatly reduced. It is the bearings in my case. This has happened to me before. The inner chase of the inner bearing begins to rotate on the spindle. Tightening the bearings will helps short term, but in my case it was only a temporary fix. Eventually the inner chase will wear into the spindle. I had to replace the spindle.
Unfortunately the problem is back again, so it's time to do something about it before I need another spindle. I bought a new set of bearings and replaced them. The problem went away, but slowly came back again . . . but there was something different about these bearing from the start.
I have owned this Explorer since it was new and have nearly 250K miles on it now. I have replaced the front bearings before and was always sold two different bearings -- meaning the inner bearing is different than the outer bearing. Now when I go to buy the bearings I am told that they are only listing one bearing, so they sell me the same bearing for the inner bearing as they do for the outer. I've been to two stores and both have told me the same thing. I am wondering if there is supposed to be a difference (although I never could physically tell a difference) between the inner and outer bearings, and by using the same bearing for both inner and outer, is that causing this problem now? Anyone know if the inner and outer bearings are supposed to be two different bearings? Does anyone know how to keep that inner chase from turning on the spindle? It wore right into the first spindle to where I could not get the bearing off . . . the inner chase would rotate on the spindle, but in would not come off.