CWGC Statistics (Air Forces Only)

[Jagan]

(this is an offshoot of this thread - where I talk about a new database i have built)

Having it in a database allows various 'querying'.. Just in case anyone is wondering..Those commemorated by branch/air arm (including German and Italian Axis war dead)

Total Branch
67,286 Royal Air Force Volunteer Reserve
17,360 Royal Canadian Air Force
15,275 Royal Air Force
11,073 Royal Australian Air Force
3,779 Royal New Zealand Air Force
2,667 South African Air Force
1,944 German Air Force
1,458 Polish Air Force
899 Royal Indian Air Force
787 Royal Air Force (Auxiliary Air Force)
731 Women's Auxiliary Air Force
165 Air Transport Auxiliary
144 R.A.F. Iraq Levies
116 Royal Air Force (RAFO)
109 Royal Air Force Ferry Command
73 Rhodesia Air Askari Corps
59 Royal Netherlands Navy Air Service
59 Women's Auxiliary Australian Air Force
51 Greek Air Force
40 Royal Canadian Air Force (Women's Division)
39 Women's Auxiliary Air Force (S.A.A.F.)
37 Netherlands Air Force
32 Royal Air Force Transport Command
30 U.S. Army Air Forces
28 West African Air Corps
21 Civilian Technical Corps
15 Norwegian Air Force
13 Malayan Volunteer Air Force
10 New Zealand Women's Auxiliary Air Force
7 Southern Rhodesia Air Force
7 Princess Mary's R.A.F. Nursing Service
7 Burma Volunteer Air Force
6 Italian Air Force
5 Southern Rhodesia Women's Auxiliary Air Service
4 Royal Australian Air Force Nursing Service
2 Belgian Air Force
1 Burma Air Force
124,339 Grand Total

[Jagan]

Some RAF Units lost 100s.. Here are the ones that lost more than 500 personnel each

115 Sqdn	951
103 Sqdn	910
101 Sqdn	910
9 Sqdn	883
12 Sqdn	874
102 Sqdn	822
78 Sqdn	813
57 Sqdn	813
50 Sqdn	809
61 Sqdn	804
44 Sqdn	802
106 Sqdn	797
51 Sqdn	781
7 Sqdn	779
49 Sqdn	761
207 Sqdn	750
15 Sqdn	750
77 Sqdn	748
83 Sqdn	744
10 Sqdn	737
166 Sqdn	730
149 Sqdn	698
156 Sqdn	690
158 Sqdn	676
76 Sqdn	625
97 Sqdn	600
218 Sqdn	592
35 Sqdn	574
100 Sqdn	537
90 Sqdn	525
75 Sqdn	506

48,722 of the killed do not have a parent unit mentioned.

[Jagan]

Distribution by Age:

Age	Total
16	8
17	81
18	887
19	5695
20	11313
21	14073
22	12108
23	9459
24	6738
25	5446
26	4772
27	4296
28	3712
29	3346
30	2796
31	2318
32	2004
33	1577
34	1231
35	962
36	697
37	606
38	486
39	479
40	373
41	308
42	282
43	209
44	177
45	148
46	127
47	115
48	97
49	92
50	67
51	79
52	66
53	41
54	46
55	35
56	38
57	38
58	33
59	25
60	15
61	11
62	12
63	14
64	5
65	5
67	1
69	4
70	1
71	1
73	1
No Age	26783
	124339

The oldest who died include (73,71,70 years respectively)

Air Corporal

TREVELLEION (312686)

1943-06-22

South Africa

Warrant Officer Class II

John LOVE (211782)

1947-12-31

South Africa

Lydenburg Cemetery

Squadron Leader

Alexander Wilson HOGG (1806)

1943-05-27

New Zealand

Wellington (Karori) Cemetery

[Jagan]

Senior most ranking who died

rank	initials	surname	Age	Died	honours_awards
Air Vice Marshal	C H B	BLOUNT		1940-10-23	C B, O B E, M C
Air Vice Marshal	C D	BREESE	51	1941-03-05	C B, A F C, Twice Mentioned in Despatches
Air Vice Marshal	A C	MAUND	51	1942-12-13	C B, C B E, D S O
Air Vice Marshal	W A	McCLAUGHRY	48	1943-01-04	C B, D S O, M C, D F C
Air Vice Marshal	A H	ORLEBAR	46	1943-08-04	C B E, A F C and Bar
Air Vice Marshal	C W H	PULFORD	50	1942-03-10	C B, O B E, A F C
Air Vice Marshal	R P M	WHITHAM	47	1943-03-23	C B, O B E, M C
Air Vice Marshal	O T	BOYD	54	1944-08-05	C B, O B E, M C, A F C
Air Chief Marshal	C S	BURNETT	62	1945-04-09	K C B, C B E, D S O
Air Vice Marshal	J B	COLE-HAMILTON	51	1945-08-22	C B, C B E
Air Vice Marshal	G G	DAWSON	48	1944-11-14	C B, C B E
Air Marshal	P R M	DRUMMOND	50	1945-03-27	K C B, D S O and Bar, O B E, M C,
Air Vice Marshal	W R	KENNY	58	1944-04-11	D F C
Air Chief Marshal	T L	LEIGH-MALLORY	52	1944-11-14	K C B, C B, D S O
Air Marshal	F J	LINNELL	52	1944-11-03	K B E, C B, Twice Mentioned in Despatches
Air Vice Marshal	R B	MANSELL	48	1945-01-22	C B
Air Vice Marshal	J R	SCARLETT-STREATFEILD	36	1945-05-10	C B E, Mentioned in Despatches

[COL BRUGGY]

Jagan,

With the greatest of respect, the figures you are using are based on online CWGC data, which has been shown at times to be incomplete or incorrect. A good example of this are your figures for the RAAF Nursing Service deaths. You qoute 4 deaths for the RAAFNS, there were actually 5 deaths. The one that you have not picked up on, is: (N504)103 Sister Joan CONNELL RAAFNS, who passed away from illness at No.2 RAAF Hospital, on 17-5-1942. If you check the Graves Registration Report and the Register entry, you will see l'm correct.

https://www.awm.gov.au/people/rolls/R1704391/

There are many errors, still, on the CWGC database ie, incorrect units, dates etc. An error in one entry creates a need to correct an entry elsewhere. A useful tool, but not the final word.

Col.

[Jagan]

Colin, absolutely. I have no doubt errors exist. even that lone entry for Burma Air Force is suspect - it must be BVAF. l read about a few additions that others (like on ww2talk.com ) have managed to get added into the DB. 60-70 years after the event!

Though in this case, Sister Connell's name is there in the db http://www.rafcommands.com/database/...lia&qdate=1942 but seem the parent unit is not recorded as RAAF Nursing Services.

[malcolm_raf]

Hi Jagan

Another example, I notice you show 676 casualties for 158 Sqn, however the 158 Sqn Memorial at Lissett has 851 names on it.

Malcolm

[PeteT]

Malcolm

This will be a problem with all squadrons as many of the Commonwealth personnel do not have the unit shown as "nn Sqdn" on their CWGC record

Regards

Pete

[Jagan]

Malcolm, i may have filtered out non-RAF personnel from it during my direct queries A direct search on the site is showing up 797 names - the consistency in unit names is missing.. 158 Sqdn at one point and 158 (RAF) Sqdn at another. Still some 60 names short from your total.

This inconsistency can be found in another places. A search on 1 Sqdn would bring up 1 Sqdn RAF, 1 Sqdn RIAF, 1 Sqdn SAAF and show them in one page. I may have to provide an ability to filter based on parent unit (RAF, IAF, SAAF) etc to provide an accurate result.

[COL BRUGGY]

Hello,

No.158 Sqn RAF Casualties (Roll of Honour)

RAF --- 684
RAAF --048
RCAF --098
RNZAF-021
Total --851

See:
In Brave Company - 158 Squadron Operations.
Chorley,W R.
Sixpenny Handley:Chorley,1990(2nd rev.ed.)
pp.xi-xxv.

NB. One error I have found in Chorley's RoH - J E R LAVIGNE (+9-1-43), is listed as RAF, he was RCAF (corrected in BCL9/274). One error on the CWGC, is: 174704 F/O Sidney HODGES DFC (+12-11-45), the CWGC have him listed as 128 Sqn - he was 158 Sqn.

At least six 158 Sqn ground staff were killed in an accident on 2-7-1943 (no unit mentioned on CWGC). http://www.rafcommands.com/forum/sho...irmen-2-7-1943

Col.