The increased dependence on patient safety studies using the MAUDE database underscores the critical need to define and standardize the methods for extracting and analyzing event reports. The lack of reproducible methods leads to an inconsistent understanding of reported events and diminishes their effectiveness in informing clinicians. Thus, an ETL pipeline combined with LLMs was proposed to standardize the identification and interpretation of the reports. Using endoscopic clip reports as an example, the ETL-LLM method demonstrates the effectiveness of extracting and analyzing categorical and narrative reports, helping uncover insights related to patient complications, surgical procedures, and device uses. This innovative and transparent method of examining MAUDE underscores its potential to inform clinicians promptly and encourages more research on patient safety through open-access databases.