The correct answer is situational irony.
This is because John is claiming to be "amazing" at his toothpick sculpture, yet he is in the process of cleaning up its fallen remains, indicating that it has failed in some way. The situation contrasts with his statement.