I have tried to get an overview of the composition of Starfleet at the end of the 24th century (>2379). For this I looked at the main star ship classes in operation and assessed their role and importance in the fleet. (By this I only mean major original designs and not kitbashes.) I have based this on a qualitative summary of frequencies of reference and appearance since the start of the Dominion War (DW) in 2373 (sources are Memory Alpha and screencaps at TrekCore). In addition, I have included the non-cannon Luna Class as it is original and features heavily in the post series books after 2379, but you are free to disregard this.
Widespread presence in the DW battles and in the Endgame fleet shows that a ship will be generally common in the 2380s with a high probability. During the war, Starfleet was desperate, throwing everything at the Dominion it could muster. This explains the excessive use of Mirandas, even though they weren’t really up to heavy combat. As far as we know, they were old and had low range armaments. They came across as mere canon fodder in most cases. If Starfleet had more new or stronger ships it would have used them. This means that the ships not featured or only rarely seen in this period are not very common and play only a minor role in the fleet. An additional clue comes from the defence fleet seen in Endgame. This fleet approaches what one could call a random sample of the ship classes in operation for this period. It was a coincidental assortment of about 30 vessels that were close to sector 001. They assembled at short notice at earth to fend of a potential Borg incursion.
I argue that the composition of Starfleet will not change much for the rest of the 24th century, as new classes take decades to be realised and to be produced en masse.
Starfleet Core Designs (referenced or seen >10 times with >5 incarnations).
Class ranked by frequency with a description of type and function (plus qualitative description of frequency).
1. Excelsior: multipurpose cruiser, outdated armaments, e.g. old fashioned phasers (ubiquitous, large numbers seen in every fleet battle and in many standard operations, ~3 seen in Endgame).
2. Miranda: short range destroyer with limited combat ability (not quite as common as the Excelsior but not far behind, ~4 seen in Endgame).
3. Galaxy: large multipurpose deep space explorer, has good combat utility, probably suffers from low manoeuvrability (many featured in all major battles of the DW and ~8 seen in Endgame).
4. Nebula: heavy cruiser, multipurpose deep space explorer, modular pod, can serve as a dedicated warship (frequency is only slightly lower than the Galaxy, ~4 seen in Endgame).
5. Akira: cruiser, main function is combat, maybe with additional utility (several seen in all major battles of the DW and a few seen during other operations but markedly less than the former classes, 1 seen in Endgame).
6. Saber: frigate, heavily armed for its size, main function is probably combat (seen in all major battles of the DW and ~1 seen in Endgame).
6. Steamrunner: frigate, probably focused on combat (seen in all major battles of the DW ~2 in Endgame).
7. Defiant: frigate, excessively armed for its size, main function is combat (less common than the other classes, but judging by its frequency on Voyager (all AQ episodes with starships), its use is probably more widespread than DS9 would let us believe, ~3 seen in Endgame).
8. Luna: heavy cruiser, multi purpose explorer and warship non-canon relaunch-era design (according to the Titan novels this is a highly popular design, several ships referenced to be of this type).
Rare (seen only once or twice)
Intrepid: light cruiser, multipurpose explorer, not a warship (only 2 seen on screen).
Nova: frigate, main function research and short range exploration (only 2 seen on screen, 1 seen in Endgame).
Prometheus: cruiser, main function combat (only a prototype during the DW, might have become popular later on, 1 seen in Endgame).
Sovereign: Battleship and Explorer (only 2 confirmed incarnations).
Retired (not seen in recent Star Trek)
Norway: Only seen in First Contact, the CGI model was lost
Oberth: Not seen since Generations
Ambassador: Not seen since Redemption, part 2
Constellation: Same as Ambassador
Constitution: Not seen since The Undiscovered Country, might have been at the battle of Wolf 359
The list of core ship classes shows three main functional groups: short range operations (supply, logistics etc), followed by long range exploration and, finally, combat. The Miranda is clearly in the first category. The Excelsior is a jack of all trades, the Galaxy and Nebula are in the middle category and also useful in combat, the rest seem to function mainly as warships.
My impression is that a large percentage of the fleet is made up of Miranda variants and Excelsior class star ships. Together they probably form the backbone of the fleet. However, the Galaxy class also appears to be very strong in numbers as well as the Nebula class. This leaves the Akira, Sabre, Defiant and Steamrunner classes which are mainly or entirely in the combat category. Surprisingly, their numbers appear much smaller than the first 4 classes and if one includes the Luna class, we get an additional major design that focuses on multipurpose operations.
Therefore, the complaint that Starfleet has become too militaristic seems unwarranted to me. If anything it comes across as being committed to its primary mission to seek out new worlds and all that. This is strongly underlined by the sheer amount of Galaxy, Nebula and Excelsior class vessels a trend that is backed up by the emergence of the Luna class. Granted the combat focused classes are all fairly new, only emerging in the early 70s and thus their numbers are impressive and might be a hint of what is coming. But with the DW out of the way is there a need for this? Then again the Borg threat isn’t really over, only weakened by what Voyager did in Endgame.
What surprised me was the rather small number of core classes (8-9). For some reason I always thought this list would be longer and include both the Intrepid and Sovereign. If not seen in the flesh, I always thought they were at least referenced like when Sisko orders Galaxy wing X to attack target Y or seen on tactical displays etc. However, this does not seem to be the case, which leads me to the conclusion that Starfleet was unhappy with these designs. Maybe the cost/effectiveness ratio for the Sovereign was bad. The warship role being better performed by the smaller and much cheaper frigates and cruisers specialised for this role and the explorer role performed successfully by both the tested and widespread Galaxy and Nebula classes. The Intrepid on the other hand was maybe too expensive when compared against the Excelsior with not enough utility gain. Thus, the need for and benefit of these classes might have been low. (Obviously, there are real world explanations, like the producers wanted to keep the shows seperate but that's not the type of rationale I'm looking for here.)
So what do you think is this a reasonable assertion of the composition of Starfleet in this time period?
Widespread presence in the DW battles and in the Endgame fleet shows that a ship will be generally common in the 2380s with a high probability. During the war, Starfleet was desperate, throwing everything at the Dominion it could muster. This explains the excessive use of Mirandas, even though they weren’t really up to heavy combat. As far as we know, they were old and had low range armaments. They came across as mere canon fodder in most cases. If Starfleet had more new or stronger ships it would have used them. This means that the ships not featured or only rarely seen in this period are not very common and play only a minor role in the fleet. An additional clue comes from the defence fleet seen in Endgame. This fleet approaches what one could call a random sample of the ship classes in operation for this period. It was a coincidental assortment of about 30 vessels that were close to sector 001. They assembled at short notice at earth to fend of a potential Borg incursion.
I argue that the composition of Starfleet will not change much for the rest of the 24th century, as new classes take decades to be realised and to be produced en masse.
Starfleet Core Designs (referenced or seen >10 times with >5 incarnations).
Class ranked by frequency with a description of type and function (plus qualitative description of frequency).
1. Excelsior: multipurpose cruiser, outdated armaments, e.g. old fashioned phasers (ubiquitous, large numbers seen in every fleet battle and in many standard operations, ~3 seen in Endgame).
2. Miranda: short range destroyer with limited combat ability (not quite as common as the Excelsior but not far behind, ~4 seen in Endgame).
3. Galaxy: large multipurpose deep space explorer, has good combat utility, probably suffers from low manoeuvrability (many featured in all major battles of the DW and ~8 seen in Endgame).
4. Nebula: heavy cruiser, multipurpose deep space explorer, modular pod, can serve as a dedicated warship (frequency is only slightly lower than the Galaxy, ~4 seen in Endgame).
5. Akira: cruiser, main function is combat, maybe with additional utility (several seen in all major battles of the DW and a few seen during other operations but markedly less than the former classes, 1 seen in Endgame).
6. Saber: frigate, heavily armed for its size, main function is probably combat (seen in all major battles of the DW and ~1 seen in Endgame).
6. Steamrunner: frigate, probably focused on combat (seen in all major battles of the DW ~2 in Endgame).
7. Defiant: frigate, excessively armed for its size, main function is combat (less common than the other classes, but judging by its frequency on Voyager (all AQ episodes with starships), its use is probably more widespread than DS9 would let us believe, ~3 seen in Endgame).
8. Luna: heavy cruiser, multi purpose explorer and warship non-canon relaunch-era design (according to the Titan novels this is a highly popular design, several ships referenced to be of this type).
Rare (seen only once or twice)
Intrepid: light cruiser, multipurpose explorer, not a warship (only 2 seen on screen).
Nova: frigate, main function research and short range exploration (only 2 seen on screen, 1 seen in Endgame).
Prometheus: cruiser, main function combat (only a prototype during the DW, might have become popular later on, 1 seen in Endgame).
Sovereign: Battleship and Explorer (only 2 confirmed incarnations).
Retired (not seen in recent Star Trek)
Norway: Only seen in First Contact, the CGI model was lost
Oberth: Not seen since Generations
Ambassador: Not seen since Redemption, part 2
Constellation: Same as Ambassador
Constitution: Not seen since The Undiscovered Country, might have been at the battle of Wolf 359
The list of core ship classes shows three main functional groups: short range operations (supply, logistics etc), followed by long range exploration and, finally, combat. The Miranda is clearly in the first category. The Excelsior is a jack of all trades, the Galaxy and Nebula are in the middle category and also useful in combat, the rest seem to function mainly as warships.
My impression is that a large percentage of the fleet is made up of Miranda variants and Excelsior class star ships. Together they probably form the backbone of the fleet. However, the Galaxy class also appears to be very strong in numbers as well as the Nebula class. This leaves the Akira, Sabre, Defiant and Steamrunner classes which are mainly or entirely in the combat category. Surprisingly, their numbers appear much smaller than the first 4 classes and if one includes the Luna class, we get an additional major design that focuses on multipurpose operations.
Therefore, the complaint that Starfleet has become too militaristic seems unwarranted to me. If anything it comes across as being committed to its primary mission to seek out new worlds and all that. This is strongly underlined by the sheer amount of Galaxy, Nebula and Excelsior class vessels a trend that is backed up by the emergence of the Luna class. Granted the combat focused classes are all fairly new, only emerging in the early 70s and thus their numbers are impressive and might be a hint of what is coming. But with the DW out of the way is there a need for this? Then again the Borg threat isn’t really over, only weakened by what Voyager did in Endgame.
What surprised me was the rather small number of core classes (8-9). For some reason I always thought this list would be longer and include both the Intrepid and Sovereign. If not seen in the flesh, I always thought they were at least referenced like when Sisko orders Galaxy wing X to attack target Y or seen on tactical displays etc. However, this does not seem to be the case, which leads me to the conclusion that Starfleet was unhappy with these designs. Maybe the cost/effectiveness ratio for the Sovereign was bad. The warship role being better performed by the smaller and much cheaper frigates and cruisers specialised for this role and the explorer role performed successfully by both the tested and widespread Galaxy and Nebula classes. The Intrepid on the other hand was maybe too expensive when compared against the Excelsior with not enough utility gain. Thus, the need for and benefit of these classes might have been low. (Obviously, there are real world explanations, like the producers wanted to keep the shows seperate but that's not the type of rationale I'm looking for here.)
So what do you think is this a reasonable assertion of the composition of Starfleet in this time period?