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%