I personally have a 2006 with over 100k on it and so far so good (knocking on wood). But like I have heard of tranny problems in pilots as well, but then again it's really the luck of the draw for any car.

Wish I could help more. Good luck with your decision!

-Lee