A new economical type of pre-cast flashboard spur dike with consolidation piles is introduced, of which the main anti-overturning component is the consolidation pile. The overturning resistance characteristics of the consolidation piles were intensively investigated by indoor experiment and 3-D scanning technology on a fine sand foundation bed. The results show that the grouting agent can react with the ambient soil and a large rigid bulbous body around the toe of the pile forms after the consolidation of the injected grouting agent, which can significantly improve the anti-overturning force of the pile. The toppling process of the consolidation pile can be divided into four different stages, including slight-tilting stage, tilting stage, toppling stage, and out-pulling stage. The anti-overturning force is mainly affected by the structural geometry, penetration depth, soil properties, grout volume and injection rate of the grouting agent. Formulas of the critical horizontal anti-overturning force and critical angle of inclination were proposed based on dimensional analysis and experimental data fitting.