A look back at the past 15+ years of FSO

[Devil 505]

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.

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.

[RedBeard]

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.

Plane	Total Sorties	Sorties With Dmg	Total Landed Sorties	Sorties Landed With Dmg	Chance to Make Target	Chance to Destroy Target and Get Home
A-20G	1007	392	170	90	38.93%	8.94%
Ar_234	162	58	92	45	35.80%	27.78%
B-17G	1295	636	632	423	49.11%	32.66%
B-24J	1297	510	584	315	39.32%	24.29%
B-25C	2573	1171	1033	574	45.51%	22.31%
B-25H	210	63	34	14	30.00%	6.67%
B-26B	1002	480	511	305	47.90%	30.44%
B-29	318	199	94	81	62.58%	25.47%
B5N2	912	109	174	29	11.95%	3.18%
Boston_III	1286	564	458	250	43.86%	19.44%
C-47A	74	2	21	0	2.70%	0.00%
D3A1	1271	352	217	66	27.69%	5.19%
G4M1_Model_11	1118	332	358	132	29.70%	11.81%
He_111H	1365	553	651	381	40.51%	27.91%
Ju_87D-3	1820	744	327	166	40.88%	9.12%
Ju_88A-4	3721	1783	1607	1008	47.92%	27.09%
Ki-67	773	228	281	99	29.50%	12.81%
Lancaster_III	128	64	48	38	50.00%	29.69%
Mosquito_Mk_XVI	120	45	53	28	37.50%	23.33%
SBD-5	1397	386	369	111	27.63%	7.95%
TBM-3	1053	189	228	47	17.95%	4.46%
Tu-2S	742	368	232	132	49.60%	17.79%

[Molsman]

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

[RedBeard]

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.

[RedBeard]

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?

[icepac]

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

[hazmatt]

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? 

[RedBeard]

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.

[Spikes]

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.