It is commonplace to speak and write about checkmate patterns. Certain recurring checkmates happen over and over again in games no matter the skill level of the players. Of course, once players rise above a certain level, checkmates become rare due to resignation either due to a checkmate threat or one player gaining an overwhelming material advantage.
Do claims about checkmate patterns stand up to data from played games? It is a simple, albeit time consuming matter to examine every game in the database that ended in checkmate. It may be possible to name every pattern in these checkmates and then list them in order of frequency.
Running on my desktop, ChessBase was able to find every game in my largest database ending in checkmate in about one minute. As I prefer quality over quantity, my largest database is smaller than many others, containing a mere 5.9 million games.
In this database, 148,127 games end in checkmate.
The last piece to move was most often the queen, and presumably this piece was always giving the check that is checkmate in all of them. Queen moves account for 59% (87,894) of the games in this selection.
The rook is the last piece to move in 24% (35,473) of the games. Most often, the rook is likely giving check and mate. However, a rook move can produce a discovered check by bishop or queen.
A little more than 7% (10,990) of the games ending in checkmate involve a knight making the last move of the game. Some of these, no doubt will be discoveries, but it's a reasonable prediction that the knight is checking the enemy king in most of them.
A bishop moves to checkmate the opponent in 6% (8,898) of the games.
Pawn moves account for slightly more than 3% (4,847) of the games. It will be interesting to study how often the pawn itself delivers the decisive check.
King moves account for a mere 25 games. More than half of these are by castling, so a rook is giving checkmate. The king cannot deliver check, but it can cut off the escape of an enemy king.
For example, in this game between two youth players from 2005, White's king moved so as to check by the rook and cover one of the escape squares.
White to move
One of the games that ended with O-O# could have gone on two moves longer with better defense. The combination strikes me as instructive. It is from Suess -- Hurme 1969, a game played as part of team world championship qualifier.
White to move