Eagle, that's too bad man. I also failed one sector on the aptitude tests a week ago, except this was for the RAAF. Check out the thread titled "RAAF Aptitude Test Results" on the Military forum. I had a bunch of guys give me some really good advice, and maybe you could use some of it.
I know it feels pretty bad man. But hey, it'd feel even worse if I were to fail again in one year because I allowed doubts to get in my head about my own abilities. Soldier on....or shall I say, pilot on!!