Get noise like power steering fluid is gone from transmission in gear only

If your transmission is making a clicking noise when in gear and is not moving, it could be indicative of a serious problem. Here are a few potential causes to consider:

1. Transmission fluid: Check the transmission fluid level and condition. Low fluid levels or dirty/deteriorated fluid can cause inadequate lubrication and lead to transmission issues. If the fluid is low, you may have a leak that needs to be addressed.
2. Clutch or torque converter: If you have a manual transmission, a faulty clutch could prevent power from being transferred effectively from the engine to the transmission. In an automatic transmission, a malfunctioning torque converter can cause similar symptoms. A slipping or worn-out clutch or torque converter may require replacement or repair.
   
3. Broken or worn gears: Internal components of the transmission, such as gears or synchros, may be damaged or worn out. This can cause the transmission to make clicking or grinding noises and result in a loss of power transmission.

A loud whining noise on acceleration in a 2010 Mazda Tribute could be a sign of a few different issues. Here are some potential causes:

1. Power steering pump: A whining noise can be an indication of a failing power steering pump. The noise may increase when the steering wheel is turned.
2. Alternator: If the whining noise increases with engine speed, the alternator may be failing. This is because the alternator is responsible for charging the battery and powering the car's electrical system.
3. Transmission: A whining noise during acceleration could also be a sign of transmission issues, such as low transmission fluid levels, worn bearings, or a damaged gear.
4. Differential: A whining noise that increases with speed could also be a sign of a failing differential. This is the part of the car that transfers power from the engine to the wheels.

It's important to have a professional mechanic diagnose and fix the issue to prevent further damage to your vehicle.

Try changing the fluid and the filter (inside transmission pan) and see if that helps.

you likely have a leak in your power steering system and is now low. When the fluid gets low it gets air in it causing the whine. It is likely your steering gear or high pressure hose (or both) that is leaking. Once the leak is repaired it is recommended to flush out your power steering fluid to DEX6 Transmission fluid.

If you are stopped and can turn the wheel back and forth, it is not the power steering.

Sounds like the transmission

Check this link for location.

Along side the battery , infront of the brake fluid holding tank
http://www.carcarekiosk.com/video/2010_Lincoln_MKZ_3.5L_V6/transmission_fluid/check_fluid_level

Standard Differential, Rear 8.8 and 9.75 RG......GL-5
All TEMPS......75W-140 [3]
SEVERE GEAR 75W-140 Synthetic EP Lubricant (SVOQT)
80W-140 Synthetic Long Life Gear Lube (FGO05)
Limited Slip Differential, Rear 8.8 and 9.75 RG......GL-5*
All TEMPS......75W-140 [4] [3]
SEVERE GEAR 75W-140 Synthetic EP Lubricant (SVOQT)
80W-140 Synthetic Long Life Gear Lube (FGO05)
Differential, Front 8.8 RG......GL-5
All TEMPS......80W-90
SAE 80W-90 Synthetic Gear Lube (AGLQT)
SEVERE GEAR 75W-90 Synthetic EP Lubricant (SVGQT)
75W-90 Synthetic Long Life Gear Lube (FGRQT)
SEVERE GEAR 75W-110 Synthetic EP Lubricant (SVTQT)
Transfer Case,......MA
Synthetic Multi-Vehicle Automatic Transmission Fluid (ATFQT)
Torque-Drive Synthetic Transmission Fluid (ATD1G)
Fluids
Power Steering Fluid......MA
Synthetic Multi-Vehicle Automatic Transmission Fluid (ATFQT)
Power Steering Fluid......MA
Torque-Drive Synthetic Transmission Fluid (ATD1G)
Brake Fluid......HB
AMSOIL Brake Fluid DOT-3 (BF3SN)
Clutch Fluid......HB
AMSOIL Brake Fluid DOT-3 (BF3SN)

power steering pump probably went out.. if you can easily get at the belt and are any kind of mechanically inclined, remove the drive belt to the p/s pump and then start the car if the noise is gone then its probably part of the power steering pump

the noise you hear is the power stearing unit working

This is a suggestion, but may not be the answer. Further information will be required to accurately diagnose your situation, which may be two separate problems.

The whining noise you hear while driving and turning can be attributed to 2 different things:

1. Power steering pump/apparatus. If you've run the pump low on fluid, its bearings may be wrecked. This will cause additional strain on the engine, lowering your fuel economy. You can note this situation by the feel of the steering. Is it hard to steer while sitting still or at parking lot speeds?

2. Transmission internal gear sets/clutches. If the whining noise occurs only when in forward or reverse gears, and not in park, it is probably something along the input shaft of the transmission, which could include clutch packs, torque converter, and bearings. If the noise goes away when in Park, and steering the wheel while sitting still doesn't make it come back, disregard option #1.

Based on the situation, I'm going to choose to elaborate on #2, as I presume this is your problem.

Since you note that the problem is there when you drive and when you turn, I'm recommending transmission service. At the very least, check your fluid level.

When is the last time your transmission was checked/serviced? More than likely, you've either lost some fluid and it's running low (which can/should cause other problems as well), or the fluid isn't getting where it's supposed to be getting. Either situation will cause severely increased fuel use.

Dealer, but did you check the Power steering fluid level??or any leaks. There are two hose that connect to the gear box from the power steering pump. if the pump is low on fluid you lose your power steering, if the hose has a leak or it blew and lost the power steering fluid then you lost your power steering again. 
Check the fluid level to the power steering pump and any leaks or broken hose to the gear box.
Keep me posted, be glad to help and good luck.