Vietnam was a fractal war-a self similar pattern of bad decisions and disasters at every level. The air war over North Vietnam was no exception, as Mitchel demonstrates in this comprehensive and exhaustive account of Operation Rolling Thunder and Linebacker I & II. Mitchel takes as his analytic frames the tactical learning between the two sides during the years-long bombing into North Vietnam, and the introduction and evaluation of new weapons and tactics. The story is USAF and MiG heavy, but there's plenty of room for other parties: Navy Aviation, SAMs, electronic warfare, and command and control. As Michel describes, SAMs could be dealt with be ECM pods and electronic warfare, AAA took down a lot of planes but could be avoided by flying fast and high, and the ultimate enemy were the MiGs; deadly when guided into ambush attacks by North Vietnamese ground controllers, dangerous in a low turning fight, and ultimately only survivable by alert and aggressive pilots. This last aspect is where the USAF failed.
The book itself is calm, evenhanded, clinical in describing the results of combat encounters, but I don't have to be, and I am shocked that the USAF managed to shoot down any MiGs at all, given how bad their training and doctrine was. How bad? Guided missiles were supposed to be the weapon of the future, to the extent that the F-4 Phantom lacked an internal cannon (and lol at trying to dogfight in a Thud without an anti-air gunsight), but American guided missiles sucked. Designed and tested for use against high-altitude Soviet bombers, they were nearly useless against low-level fighters. The AIM-9 Sidewinder was the best missile, but couldn't be fired in more than a 2G turn and lost guidance when the target flew towards the sun, the ground, or into clouds. The AIM-7 Sparrow took 5 seconds to lock on and fire, required the Phantom to keep its nose pointed at the enemy until the missile hit, and just failed to launch or guide over 60% of the time. The AIM-4 Falcon was even worse, if that's imaginable. Bad missiles came on top of a lack of guns or ranging gun sights. The Phantom was plagued by bad radios-located below the co-pilots ejection seat in a compartment that drained all the moisture in the cockpit. Pilots died when they didn't hear radio calls of "Break break break!" Contrary to popular belief (or at least my prior belief), the Phantoms and Thuds were not totally outmatched in a dogfight-the MiGs were difficult to fly at the edges of the envelopes-but big smokey Phantoms against small agile MiGs stacked the deck against American aircraft.
The real killers were American training and doctrine. It took too long for effective command and control to be made available to pilots over North Vietnam, because while NSA electronic warfare planes were listening to North Vietnamese radios and could hear the MiGs making their attack runs, that data was classified and couldn't be transmitted to pilots. The Air Force put bomber and transport pilots in fighters to spread out the load of combat tours, and air to air training consisted of half dozen mock dogfights at the end of the refreshed course, compared to about one hundred air to ground training missions. Training units were rated on safety, not aggressiveness or preparation for combat, and so discouraged pilots from flying the F-4 at its limits and learning about dangerous adverse yaw flight characteristics. The 4 plane 'fighting wing' formation used by the Air Force let only the flight lead shoot, and had the other three flying formation. The three wingmen couldn't even look out for MiGs, since they had to maintain position, and basically existed to decoy missiles away from the lead. The Navy had solved many of these problems, with the famous TOP GUN air combat school and the 'loose deuce' formation, (oh, and a better variant of the Sidewinder), but for the Air Force, even worse than losing pilots over North Vietnam was admitting that the Navy was doing things better!
There were darker times in the Air Force's history. The 8th Air Force over Europe saw way higher losses. But in a war of choice, in a war where America had technical superiority, even if it was fighting under political restrictions that prevented an all out offensive against Hanoi until Linebacker II, the inability of the USAF to adapt, and develop tactics and weapons that would give it air superiority, was a major failure in leadership. The USAF learned a lot of valuable lessons, instantiated in the F-15, AWACS, and Aggressor training, but too many pilots paid the cost for that knowledge.