Transmission Not Go Into Gear problems of the 2006 Mazda Tribute

I was at a stoplight, and started to hit the gas, but nothing happened. The car would not go into gear. I finally got the car to work for about 200 feet, and then the same thing happened. I started my car again, and again it went for 200 feet before storpping and stalling. I took the car to a mechanic who informed me that my transmisson had failed, and there is a high failure rate with my car and its transmission. I did research online, and discovered several Mazda owners with the same issue.