Bomber Command thinks it dropped 1,239+1,051 (Night + Day) 2,000 pound AP, 25,589+3,051 2,000 pound HC, 37+0 2,000 pound MC, 281+58 2,000 pound M2, 4+0 2,000 pound GP, 7+0 1,900 pound RDX, 1,861+280 1,900 pound GP, unlike the relevant 1,000 and 500 pound bombs the 2,000 pound bombs are not labelled USA.
The night bombers dropped 7 types of 1,000 pound and 6 types of 500 pound bombs, MC types made up 51.3% of 1,000 pound and 34.8% of 500 pound bombs. Day it was 30.3% 1,000 pound MC, 29.7% 500 pound MC. 242,278 long tons HE by day, 510,759.4 by night.
I do not have the mission reports for 2nd Schweinfurt, 14 October 1943, only the summary
Schweinfurt/Kugelfisher, 165.7 short tons HE, average bomb load 4,091.4 pounds
Schweinfurt/VKF 1, 63 short tons HE, 74.1 short tons incendiary, average bomb load 4,495.1 pounds
Schweinfurt/VKF 2, 166.5 short tons HE, 13.5 short tons incendiary, average bomb load 4,186.1 pounds
Which comes to 395.2 short tons HE 87.6 short tons incendiary, total short 482.8 tons Americas Pursuit of Precision Bombing, MacFarlane, is obviously only counting HE.
For the 8th Air Force average bomb load per effective sortie was 5,139.4 pounds per B-17 and 5,321 for the B-24. 15th Air Force 5,276.1 pounds for B-17, 4,462.4 pounds for B-24. Bomber Command reports the average Stirling bomb load was 6,622.2 pounds, Halifax 7,538.6, Lancaster 10,064.5 pounds. The Halifax III carried a higher average bomb load than the mark II and V.
The fact is even the Mosquito mark XVIs did not always carry such a 4,000 pound load, the Bomber Command War Diaries note the last RAF aircraft to bomb Berlin in WWII was a Mosquito XVI on 21 April 1945 and it dropped a load of four 500 pound bombs.
The usual conditions apply to the bomb tonnages mentioned below, they are good put not perfect.
Figures for Mosquito raids where the target is given as Berlin by month, fields are month, number of effective sorties, number lost, bomb tonnage in short tons, average bomb load, that is bomb tonnage divided by effective sorties. Richard Davis figures. The Canadian built Mosquito bombers were restricted to 2,000 pounds internally.
Mar-44 / 52 / 0 / 49 / 1895.38
Apr-44 / 54 / 0 / 65 / 2410.07
May-44 / 108 / 0 / 153 / 2824.89
Jun-44 / 212 / 5 / 376 / 3545.96
Jul-44 / 250 / 4 / 415 / 3316.10
Aug-44 / 240 / 1 / 371 / 3088.40
Sep-44 / 194 / 4 / 294 / 3026.31
Oct-44 / 300 / 4 / 400 / 2668.59
Nov-44 / 251 / 1 / 370 / 2948.59
Dec-44 / 165 / 1 / 227 / 2755.88
Jan-45 / 367 / 1 / 490 / 2672.13
Feb-45 / 815 / 3 / 1,070 / 2625.33
Mar-45 / 1,618 / 7 / 2,077 / 2567.83
Apr-45 / 995 / 4 / 1,426 / 2866.97
Totals / 5,621 / 35 / 7,783 / 2769.26
So the Mosquitoes were carrying 4,000 pound bombs to Berlin, but that was clearly a minority of the sorties. If you assume the loads were either 2,000 or 4,000 pounds then around 40% of the sorties carried the heavier load. The above figures are from 125 nights of raids, minimum average bomb load for a given night was 1,629 pounds (on 15 nights the average was below 2,000 pounds, 10 of these nights were in 1945), maximum nightly average bomb load was 3,689 pounds with 11 nights having an average of 3,400 pounds or greater and all bar 1 of these in June and July 1944, the other the following September.
One explanation for the less than 2,000 pounds average bomb load is siren tours, one or two bombs per city times several cities.
Also, given the usual size of the Mosquito raids, particularly in 1944, an error of 1 aircraft credited with attacking per night would often be able to shift the average 5 to 10%. The average number of Mosquito sorties per raid on Berlin in the March 1944 to April 1945 period is 45.
Average bomb loads US aircraft attacking Berlin, basically the tonnage of bombs credited as dropping on the target divided by the aircraft credited with bombing the target, Richard Davis figures. Note that many to most of these raids had bombers attacking targets other than "Berlin", the usual targets of opportunity or different aiming points, which explains some of the differences between despatched and attacking figures.
Berlin 6 March 1944, 730 bombers despatched, 351 credited with attacking the government area, average bomb load 4,784 pounds. Other formations attacked Potsdam, Spandau and Templehof, all up 19 targets attacked, mostly targets of opportunity.
Berlin 8 March 1944, 623 bombers despatched, 468 credited with attacking Berlin/Erkner VKF, average bomb load 4,535.9 pounds
Berlin on 9 March 1944, 361 B-17s despatched, 332 credited with attacking, average bomb load 4,630 pounds.
Berlin on 22 March 1994, 474 B-17s and 214 B-24s despatched 621 bombers credited with attacking Berlin, average bomb load 4,425 pounds (around 80 bombers attacked other targets, including 32 the Berlin/Basdorf industrial area)
Berlin on 29 April 1944, 446 B-17s and 233 B-24s despatched, 581 bombers credited with attacking Berlin, average bomb load 4,900 pounds.
Berlin on 7 May 1944, 600 B-17s despatched, 525 credited with attacking Berlin, average bomb load 4,810 pounds. The B-24s sent to Osnabruck average bomb load 5,435 pounds.
Berlin on 8 May 1944, 500 B-17s despatched, 384 credited with attacking Berlin, average bomb load 4,765 pounds. The B-24s sent to Brunswick average bomb load 4,790 pounds.
Berlin on 19 May 1944, 588 B-17s despatched, 493 credited with attacking Berlin, average bomb load 4,325 pounds. The B-24s sent to Brunswick average bomb load 5,710 pounds, or around 1,000 pounds more than 11 days earlier
Berlin on 24 May 1944, 616 B-17s despatched, 459 credited with attacking Berlin, average bomb load 4,500 pounds.
Berlin on 21 June 1944, 866 B-17s and 366 B-24s despatched, to many targets, 560 bombers credited with attacking Berlin, average bomb load 4,900 pounds.
Targets in Berlin kept being attacked but generally smaller formations July to November 1944.
Berlin 5 December 1944, 451 B-17 despatched, 174 credited with attacking Berlin/Tegel-Rheinmetal, average bomb load 4,921.8 pounds, 214 credited with attacking Berlin Gas works, average bomb load 4,807.5 pounds,
Berlin on 3 February 1945, 1,093 B-17s despatched, 934 credited with attacking Berlin, average bomb load 4,890 pounds (interestingly the 215 bombers who used H2X to sight their bombs had an average load of around 70 pounds more, which is a warning to treat the figures as a guide, not absolute).
Berlin on 26 February 1945, 840 B-17s and 367 B-24s despatched, to many targets around Berlin, 1,089 bombers credited with attacking 3 targets in Berlin, average bomb load 5,100 pounds. Interestingly the Alexander Platz rail station strike, all B-17, had the highest average of 5,810 pounds, the North rail station strike, all B-24, the lowest at 4,480 pounds. Strike assignments from Freeman, Mighty 8th War Diary. If this is correct presumably this was done to allow the B-24s to fly that little bit higher. This hints at the possibility that, on average, the B-24 carried fewer bombs to Berlin than the B-17, in 1945 anyway.
Berlin on 18 March 1945, 982 B-17s and 347 B-24s despatched, 1,219 bombers credited with attacking. The raid list has 7 entries, for the targets attacked, by between 25 and 498 bombers, bomb load averages from 3,860 to 5,170 pounds, overall average bomb load 5,052 pounds.
Berlin on 28 March 1945, 446 B-17s despatched, 403 credited with attacking, average bomb load 5,155 pounds. By March 1945 many groups were flying with 9 crew, leaving one gunner behind and there was widespread removal of some gun turrets as well. The advantages of air superiority.
Using Richard Davis figures the 8th Air Force dropped 570,338 short tons of HE, 96,774.5 short tons incendiary, 19,983.8 tons fragmentation bombs, total 686,933.3 tons, or 14.1% incendiary overall. For Berlin or Berlin/(target) it was 14,079 HE, 8,978 incendiary, 60.4 fragmentation, or 38.8% incendiary, this would usually reduce average bomb loads.
Bomber Command day bomb raids, 5.6% incendiary, night raids 26.2% overall. Night raids by year, percentage of incendiaries
1940 8.2
1941 12.9
1942 43.6
1943 47.1
1944 18.4 (day 4.3%, overall 13.5%)
1945 19.0 (day 9.2%, overall 15.1%)
Bomber command dropped around 74% of its total wartime tonnage in 1944 and 1945.