PDA

View Full Version : CWGC Statistics (Air Forces Only)



Jagan
20th May 2016, 22:50
(this is an offshoot of this thread (http://www.rafcommands.com/forum/showthread.php?20247-CWGC-WW2-Air-Forces-Casualties-Query-Tool-amp-Statistics&p=118496#post118496) - 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
20th May 2016, 22:56
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
20th May 2016, 23:03
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)http://www.rafcommands.com/database/g.png (http://www.google.com/search?q=Air+Corporal+TREVELLEION++312686+JOHANNES BURG+%28WEST+PARK%29+CEMETERY)
1943-06-22 (http://www.rafcommands.com/database/wardead/index.php?srname=Trev&qcntry=&cur=0&qunit=&srnum=&qaward=&qdate=1943-06-22)

South Africa (http://www.rafcommands.com/database/wardead/index.php?srname=Trev&qcntry=South%20Africa&cur=0&qunit=&srnum=&qaward=&qdate=1943-06-22)





Warrant Officer Class II
John LOVE (211782)http://www.rafcommands.com/database/g.png (http://www.google.com/search?q=Warrant+Officer+Class+II+LOVE+John+211782 +LYDENBURG+CEMETERY)
1947-12-31 (http://www.rafcommands.com/database/wardead/index.php?srname=&qcntry=&cur=0&qunit=&srnum=&qaward=&qdate=1947-12-31)

South Africa (http://www.rafcommands.com/database/wardead/index.php?srname=&qcntry=South%20Africa&cur=0&qunit=&srnum=&qaward=&qdate=1947-12-31)
Lydenburg Cemetery (http://www.rafcommands.com/database/wardead/index.php?srname=&qcntry=&cur=0&qunit=&srnum=&qaward=LYDENBURG%20CEMETERY&qdate=1947-12-31)





Squadron Leader
Alexander Wilson HOGG (1806)http://www.rafcommands.com/database/g.png (http://www.google.com/search?q=Squadron+Leader+HOGG+Alexander+Wilson+180 6+WELLINGTON+%28KARORI%29+CEMETERY)
1943-05-27 (http://www.rafcommands.com/database/wardead/index.php?srname=Hogg&qcntry=&cur=0&qunit=&srnum=&qaward=&qdate=1943-05-27)

New Zealand (http://www.rafcommands.com/database/wardead/index.php?srname=Hogg&qcntry=New%20Zealand&cur=0&qunit=&srnum=&qaward=&qdate=1943-05-27)
Wellington (Karori) Cemetery (http://www.rafcommands.com/database/wardead/index.php?srname=Hogg&qcntry=&cur=0&qunit=&srnum=&qaward=WELLINGTON%20(KARORI)%20CEMETERY&qdate=1943-05-27)

Jagan
20th May 2016, 23:11
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
21st May 2016, 01:36
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
21st May 2016, 01:42
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/wardead/index.php?qname=CONNELL&qcntry=Australia&qdate=1942 but seem the parent unit is not recorded as RAAF Nursing Services.

malcolm_raf
21st May 2016, 08:44
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
21st May 2016, 08:50
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
21st May 2016, 14:14
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 (http://www.rafcommands.com/database/wardead/index.php?qname=&qnum=&qdate=&qunit=158&qcntry=&qmem=&cur=0) - 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
21st May 2016, 15:38
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/showthread.php?9321-430702-Unaccounted-airmen-2-7-1943

Col.

Resmoroh
21st May 2016, 16:35
Hello All,
The most illuminating info in the thread is at Post#3. The Age at Death. The plotted curve shows a max at age 21. As I approach my declining years I find that the policepersons, doctors, pharmacists, council officials, etc, etc, are beginning to look more like 5th Formers out on a days “work experience” than experienced practioners!, and yet it was folk like this who went and did what had to be done at the time.
At the going down of the sun, and in the morning, we will remember them!
Peter Davies

Phil Listemann
22nd May 2016, 08:53
Morning All,

What the CWGC has to offer is basically good and an unavoidable tool but as said, a lot of shortcomings, like there is no Czechowslovaks nor French for example. Personnally I prefer to focus more on the nationality than the Air Force in which the airman enlisted in. Thousands Americans served the RCAF or the RAF, like Irishmen from Eire, or also many Kiwis enlisted in the RAAF instead of the RNZAF (1500), and not to forget thousands of aimen coming from the Dominions who enlisted in the RAF, mainly before the war. We also can find Mexicans in the RCAF. Sadly, and that's a major negative point, there are many cases (too many actually) the place and date of birth or the names of the parents are missing.
Phil

Errol Martyn
22nd May 2016, 11:02
Hello All,
The most illuminating info in the thread is at Post#3. The Age at Death. The plotted curve shows a max at age 21. As I approach my declining years I find that the policepersons, doctors, pharmacists, council officials, etc, etc, are beginning to look more like 5th Formers out on a days “work experience” than experienced practioners!, and yet it was folk like this who went and did what had to be done at the time.
At the going down of the sun, and in the morning, we will remember them!
Peter Davies

From an appendix in Volume Three of my For Your Tomorrow - A record of New Zealanders who have died while serving with the RNZAF and Allied Air Services since 1915 (Volume Three: Biographies & Appendices):

WWII New Zealand aircrew only deaths by age. Includes those who served in RNZAF, RAAF, Fleet Air Arm, etc but excludes those who died as a result of a non-aircraft event.

Age 18 10
Age 19 90
Age 20 308
Age 21 475
Age 22 493
Age 23 501
Age 24 436
Age 25 360
Age 26 315
Age 27 242
Age 28 197
Age 29 171
Age 30 119
Age 31 96
Age 32 72
Age 33 51
Age 34 40
Age 35 19
Ages 36-43 19

Total 4014

57.5% died before their 25th birthday.
All but 89.5% died before their 30th.
Average age = 24.5 years
(compared with 26 years for WWI deaths)

Of these:
born 1896 to prior to WWI 683 (17%)
born WWI (4.8.14-11.11.18) 1328 (33%)
born after WWI to 1925 2003 (50%)

Thus one third were born in one world war only to die in the next.

Errol

Jagan
22nd May 2016, 13:37
Aircrew commemoration by country. Again probably not an effective way of analysis as we know several missing casualties (And those cremated) in Burma are actually commemorated on the Singapore memorial.

Total %age Cumulative Country
53866 43.3% 43.3% United Kingdom
16812 13.5% 56.8% Germany
8234 6.6% 63.5% France
6142 4.9% 68.4% Netherlands
5100 4.1% 72.5% Egypt
3924 3.2% 75.7% Canada
3203 2.6% 78.2% Belgium
3127 2.5% 80.8% Singapore
2709 2.2% 82.9% Australia
2702 2.2% 85.1% Malta
2461 2.0% 87.1% Italy
2070 1.7% 88.7% India
1263 1.0% 89.8% South Africa
1105 0.9% 90.7% Indonesia
933 0.8% 91.4% Denmark
770 0.6% 92.0% Papua New Guinea
669 0.5% 92.6% Libya
524 0.4% 93.0% Myanmar
489 0.4% 93.4% New Zealand
446 0.4% 93.7% Algeria
444 0.4% 94.1% Zimbabwe
427 0.3% 94.4% Norway
423 0.3% 94.8% Tunisia
379 0.3% 95.1% Poland
378 0.3% 95.4% United States of America
359 0.3% 95.7% Bangladesh
345 0.3% 96.0% Israel and Palestine (including Gaza)
341 0.3% 96.2% Serbia
326 0.3% 96.5% New Caledonia
319 0.3% 96.7% Malaysia
317 0.3% 97.0% Greece
300 0.2% 97.2% Iraq
267 0.2% 97.5% Sri Lanka
233 0.2% 97.6% Pakistan
208 0.2% 97.8% Japan
204 0.2% 98.0% Hungary
196 0.2% 98.1% Kenya
164 0.1% 98.3% Thailand
158 0.1% 98.4% Ireland, Republic of
155 0.1% 98.5% Sudan
134 0.1% 98.6% Gibraltar
132 0.1% 98.7% Austria
110 0.1% 98.8% Iceland
99 0.1% 98.9% Sweden
82 0.1% 99.0% Cyprus
81 0.1% 99.0% Romania
79 0.1% 99.1% China, (including Hong Kong)
78 0.1% 99.2% Nigeria
76 0.1% 99.2% Ghana
75 0.1% 99.3% Yemen
74 0.1% 99.3% Eritrea
65 0.1% 99.4% Sierra Leone
63 0.1% 99.4% Spain
53 0.0% 99.5% Bahamas
52 0.0% 99.5% Gambia
45 0.0% 99.6% Azores
43 0.0% 99.6% Lebanese Republic
38 0.0% 99.6% Morocco
38 0.0% 99.7% Czech Republic
35 0.0% 99.7% Switzerland
33 0.0% 99.7% Portugal
33 0.0% 99.7% Syria
27 0.0% 99.8% Iran
26 0.0% 99.8% Tanzania
26 0.0% 99.8% Luxembourg
24 0.0% 99.8% Ethiopia
24 0.0% 99.8% Bulgaria
21 0.0% 99.9% Albania
14 0.0% 99.9% Trinidad and Tobago
14 0.0% 99.9% Faroe Islands
14 0.0% 99.9% Madagascar
11 0.0% 99.9% Fiji
11 0.0% 99.9% Turkey (including Gallipoli)
11 0.0% 99.9% Zambia
10 0.0% 99.9% Liberia
10 0.0% 99.9% Russian Federation
10 0.0% 99.9% Bermuda
10 0.0% 99.9% Equatorial Guinea
8 0.0% 100.0% Djibouti
7 0.0% 100.0% Jamaica
7 0.0% 100.0% Brazil
7 0.0% 100.0% Somalia (including Somaliland)
6 0.0% 100.0% Guyana
5 0.0% 100.0% Mauritania
4 0.0% 100.0% Uganda
4 0.0% 100.0% Chad
3 0.0% 100.0% St. Vincent
3 0.0% 100.0% Namibia
2 0.0% 100.0% San Marino
2 0.0% 100.0% Seychelles
1 0.0% 100.0% Samoa
1 0.0% 100.0% Panama
1 0.0% 100.0% Mali
1 0.0% 100.0% Puerto Rico
1 0.0% 100.0% Argentina
1 0.0% 100.0% Senegal
1 0.0% 100.0% Croatia
1 0.0% 100.0% Congo (Democratic Republic)
124339

Jagan
22nd May 2016, 13:49
Continent wise (Covers 99.9%)




Europe
91514
73.70%


Mediterranean
12823
10.33%


Asia
8890
7.16%


North America
4524
3.64%


Pacific
3968
3.20%


Rest of Africa
2453
1.98%




Total 124172




Mediterranean includes African and asian countries touchning the med sea. Pacific is Australia, NZ, Japan.. Anything E of Indonesia.