Author Topic: A look back at the past 15+ years of FSO  (Read 541 times)

Offline Devil 505

  • Aces High CM Staff
  • Plutonium Member
  • *******
  • Posts: 9227
Re: A look back at the past 15+ years of FSO
« Reply #15 on: July 20, 2025, 04:02:44 PM »
A sortie is defined as one pilot takeoff (launch) followed by one flight termination (shotdown, landed, ditched, bailed, disco).  You can get multiple sorties even in one life events when pilots are allowed to bail/replane at the start or disco/replane with CM permission.

Ok, so rearms don't factor in. Gotcha.

Quote
There were 3 B-29 events: 2012-12, 2013-12, and 2014-10 with 3 frames each.  I just did a quick scan of the html files and you are correct.  There were only 318 sortie departures listed.  I just validated that the DB has 318 sorties, so now I need to go back and find what I did wrong with a SQL JOIN.

Ketsu Go in April 2011 also had B-29's. It was the first one that used the Superfortress. Can't pull up the logs for that month for some reason.



Kommando Nowotny

FlyKommando.com

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #16 on: July 20, 2025, 04:42:23 PM »
Ok, again, my apologies for the bad data.  I've fixed the SQL and rerun the queries.  This gets the count of "Departed" either matching or closely matching the sortie count.  There are still anomalies here and there where someone shoots down a plane that hasn't taken off (late start of logging?) or just weird data like a squad being listed twice for the same side with slight variations in the squad name and no merging of the two into one.

PlaneTotal SortiesSorties With DmgTotal Landed SortiesSorties Landed With DmgChance to Make TargetChance to Destroy Target and Get Home
A-20G10073921709038.93%8.94%
Ar_23416258924535.80%27.78%
B-17G129563663242349.11%32.66%
B-24J129751058431539.32%24.29%
B-25C25731171103357445.51%22.31%
B-25H21063341430.00%6.67%
B-26B100248051130547.90%30.44%
B-29318199948162.58%25.47%
B5N29121091742911.95%3.18%
Boston_III128656445825043.86%19.44%
C-47A7422102.70%0.00%
D3A112713522176627.69%5.19%
G4M1_Model_11111833235813229.70%11.81%
He_111H136555365138140.51%27.91%
Ju_87D-3182074432716640.88%9.12%
Ju_88A-4372117831607100847.92%27.09%
Ki-677732282819929.50%12.81%
Lancaster_III12864483850.00%29.69%
Mosquito_Mk_XVI12045532837.50%23.33%
SBD-5139738636911127.63%7.95%
TBM-310531892284717.95%4.46%
Tu-2S74236823213249.60%17.79%

Offline Molsman

  • Aces High CM Retired
  • Platinum Member
  • ******
  • Posts: 5688
Re: A look back at the past 15+ years of FSO
« Reply #17 on: July 21, 2025, 12:45:38 AM »
Red

How many FSO s had late war events with the Brits having lancs and the temps and typhoons against the late war German fighters. That was my first event I ran as a Cm and was just curious that was also when we had the numbers back in the day. not Now
JG11, DerWanderZirkus, -The Flying Clowns-
              
Wait n Bleed

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #18 on: July 21, 2025, 07:35:02 AM »
Why do I feel like this is a test?

As far as I can tell, there's only been one FSO event with a Lancaster, Tempest, and Typhoon plane set.  It was Operation Clarion in April 2014, and yes, this did stretch my SQL skills.

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #19 on: July 21, 2025, 07:39:07 AM »
By the way, I show plissken as the CM for all three frames for Operation Clarion, though perhaps it was multiple people and plissken just happened to be the one dealing with the logs?

Offline icepac

  • Platinum Member
  • ******
  • Posts: 7351
Re: A look back at the past 15+ years of FSO
« Reply #20 on: July 21, 2025, 08:09:21 AM »

The stats are skewed by the bomb and bailers who have no intention of getting back home.

Offline hazmatt

  • Silver Member
  • ****
  • Posts: 1774
Re: A look back at the past 15+ years of FSO
« Reply #21 on: July 21, 2025, 09:29:03 AM »
The stats are skewed by the bomb and bailers who have no intention of getting back home.

Why would somebody bomb and bail in a 1 life event?  :headscratch:

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #22 on: July 21, 2025, 11:55:10 AM »
The stats are skewed by the bomb and bailers who have no intention of getting back home.

Don't think so.  There appears to be a consistent fluctuation of bailing pilots throughout the history of FSO that stays consistent even after we started multi-life.


Offline Spikes

  • Aces High CM Staff
  • Plutonium Member
  • *******
  • Posts: 15869
    • Twitch: Twitch Feed
Re: A look back at the past 15+ years of FSO
« Reply #23 on: July 21, 2025, 02:18:47 PM »
By the way, I show plissken as the CM for all three frames for Operation Clarion, though perhaps it was multiple people and plissken just happened to be the one dealing with the logs?
Yeah the name on the logs is who ran them in the arena. It's a bit strange because Operation Clarion isn't in our site at all, but there seems to be a few monthly articles missing (I don't see FSO setups for Feb, March, or April of 2014). There can be a variety of reasons for this but usually it happens when someone updates/modifies an article rather than creates a copy or something, or it gets categorized wrong in Joomla.
i7-12700k | Gigabyte Z690 GAMING X | 64GB G.Skill DDR4 | EVGA 1080ti FTW3 | H150i Capellix

FlyKommando.com

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #24 on: Yesterday at 12:42:07 AM »
I've had to make some choices in how to handle data normalization that is going to affect upcoming stats.  In particular, there are a lot of cases where there are multiple variations of a squad name.

Over the past 15+ years of data, there are 244 unique squad names used.  Out of this, 32 were generated by me as virtual squad names to distinguish a single squad that was split to fly both sides (some Allies, some Axis).  Most of the variations appear to be reformed squads.

There are two variations of reformed squads that I can see.  One is where the squad creator has disappeared and didn't set permissions for someone else to take over squad membership maintenance.  The squad was either disbanded when the account was dropped or the members left the squad and joined a new one.  Most likely it was the latter case and the new squad had to choose a variation of the squad name to preserve uniqueness.  I think there may even be a case where a squad reformed in mid-frame (two variations of a squad name showing in the logs and weird landing without taking off timed events shown).

The second type of reformed squad is a squad split.  In this case, one or more members drop or are kicked from a squad and decide to form a variation of the squad as a new faction.

Of the 244 squads, 107 or about 44% appear to be reformed squads.  This is based on manually comparing squad names.  A more thorough analysis would be to look at what squads pilots are associated with over time, but for now, I'm going to assume I've chosen right.

For future stats, I do not plan to merge squad variations down to one.  Technically, they are different, either through change in leadership or faction or virtual existence as a collection of members.  For the most part, I don't think this will matter a lot, except when looking at squad and member longevity.

If anyone cares about this, speak up.

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #25 on: Yesterday at 07:09:01 AM »
Most Inviting Squads

SquadMember Count
CLAIM_JUMPERS361
Arabian_Knights200
"162ndFG""Purple*Hearts"""190
LCA185
~~~THE_UNFORGIVEN~~~170
Kommando_Nowotny146
49th_Fighter_Group144
!68th_Lightning_Lancers!115
"JG54_""Grunherz"""96
G3-MF96


These squads have had the most pilots join their ranks over the life of the squad. 

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #26 on: Yesterday at 07:28:42 AM »
Squad Hoppers

PilotSquad Count
MrCrowly15
DrBone12
shifty12
Zoney11
Vlkyrie111
Stampf11
LilMak10
FBGoetz10
FBGrit10
10thMD10

These are the pilots with the most squads that they have been a member of.  We don't know why they move from squad to squad.  It may be squads reforming or it may be the pilot looking for a different mix of people to fly with.

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #27 on: Yesterday at 07:42:39 AM »
An Air Force of Their Own

SquadFrame DateMember Count
CLAIM_JUMPERS11/06/0937
Rolling_Thunder01/15/1030
LCA10/02/0928
VF_15_Satans_Playmates_II03/05/1026
JG2_Richthofen06/19/0925
III./JG11_Sonder_Black_Hearts03/14/1425
"412th_FNVG_""Volunteers"""02/10/1725
LCA_~Tainan_Kokutai~07/19/1324
332nd_Flying_Mongrels06/12/0924
Nightmares_VMF-10102/19/1023

These squads have had the most members participating in a single Frame.  Some were large enough that they could fill an entire country/side of an event these days.
« Last Edit: Yesterday at 07:46:18 AM by RedBeard »

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #28 on: Yesterday at 08:32:08 AM »
Longest Running

SquadStarting DateEnding DateYears in Use
327th_Steel_Talons06/05/0906/20/2516.1
9GIAP_VVS_RKKA06/05/0906/20/2516.1
Arabian_Knights06/05/0906/20/2516.1
CLAIM_JUMPERS06/05/0906/06/2516.0
367th_FG_Dynamite_Gang12/04/0906/20/2515.6
Kommando_Nowotny04/09/1006/20/2515.2
"162ndFG""Purple*Hearts"""02/01/1306/20/2512.4
Anti-Horde10/04/1312/06/2411.2
~~~THE_UNFORGIVEN~~~06/05/0905/15/2011.0
"VF-17_""Jolly_Rogers"""05/17/1310/20/2310.4
364th_C-Hawks07/22/1606/20/258.9
JG11_Sonderstaffel09/23/1606/20/258.7
JG54_Grunherz09/23/1606/20/258.7
~Air_Raiders~06/05/0912/01/178.5
Duxford_Wing_RAF06/05/0911/17/178.5

These are the longest running squads and there are some that go back even further.  The logs I was able to use only go back as far as June '09.  Also, I haven't imported this month's logs into the data yet.  I'm not sure what happened to the CLAIM JUMPERS in June, but they appear to be back this month.

I thought about trying to form a query for longest continuously participating, but the only way I can think of at the moment requires using a program to manually verify a squad was participating in all three frames for each month over a given period of time.

Offline RedBeard

  • Copper Member
  • **
  • Posts: 196
Re: A look back at the past 15+ years of FSO
« Reply #29 on: Yesterday at 09:41:47 AM »
Most FSO Experience

PilotStarting DateEnding DateFrame Count
Steely06/12/0906/20/25523
Dantoo06/12/0906/20/25523
AKQwik06/12/0906/20/25503
JoeJoe06/05/0906/20/25499
RedBrd06/05/0906/20/25480
AKWxMan06/12/0906/20/25475
68hobo07/10/0905/09/25473
Devil5O507/08/1106/20/25470
jaeger106/05/0906/20/25462
Snibbo06/05/0906/20/25458

These are pilots with the most FSO experience.  This shows when they started participating and the last frame they participated in along with how many frames they have flown in.

Again, this is limited by the log data I have.