A complicated subject - the more I research it, the more complex it becomes!
First, the weapons and their ammunition. The standard British Hispano loadout from around 1942 onwards was an equal mix of SAP/I and HE/I. The SAP/I could penetrate no more than about 20mm armour, at short range given a favourable (ie head-on) hit. There was AP ammo (the USA made some) which pushed the performance up to over 30mm, and the British also developed a tungsten-cored shot capable of 45-65mm penetration, but this was never used.
The .50 M2 AP or M8 API were also capable of penetrating around 20mm maximum, in the most favourable conditions at up to 200m.
The 23mm VYa could penetrate 25mm/500m (striking angle not specified) - it was much more powerful than the Hispano.
The MG 151/20 was much less powerful than the Hispano. It did, on the other hand, have AP ammo in regular use which was capable of penetrating up to 24mm at short range. The 20mm ShVAK also had API ammo which was probably capable of around 20mm at short range. The 15mm MG 151 was much better and there was a Hartkern round capable of penetrating around 40mm.
These performances (with the possible exception of the VYa and MG 151/15) are clearly not good enough to penetrate the vertical armour of any medium or heavy tank. Tank roofs were only around 10-15mm thick early in the war (although the German tanks went to 25mm and even 40mm at the end). The problem is that all of these penetration figures assume a favourable striking angle. To attack the roof (unless you catch the tanks obligingly climbing up a very steep slope) this means a near-vertical dive, which you have to pull out at some considerable height to avoid crashing.
On the other hand, it wasn't always necessary to penetrate tank armour to disable the vehicle. Any of these guns was capable of knocking tracks off, and if lucky bullets might even slip through engine cooling louvres and cause havoc there. If a tank has been evacuated because of the risk of air attack, it is also possible that the hatches had been left open - again, an easy target.
So, while early generations of tanks were certainly vulnerable (the French found the Hispano quite effective against 1940 era Panzers) by 1944 the main battle tanks were fairly safe against aircraft gun attack - at least, from the RAF and USAAF. The Germans and the Soviets both fielded specialised anti-tank aircraft carrying large cannon which were certainly capable of penetrating tanks.
The German 30mm MK 101 or 103 could penetrate a realistic 40-60mm (up to 100mm at best) with Hartkernmunition, the Soviet NS-37 around 48mm/500m, the German BK 3,7 up to a mximum of 140mm at very short range with Hartkern shot, and the BK 7,5 would flatten anything it came across.
Tony Williams
Author: "Rapid Fire: The development of automatic cannon, heavy machine
guns and their ammunition for armies, navies and air forces"
Details on my military gun and ammunition website:
NOTE NEW ADDRESS
http://www.quarry.nildram.co.ukMilitary gun and ammunition discussion forum:
http://forums.delphiforums.com/autogun/messages/