Model for Analysis and Evaluation of road crashes resulting in fatalities using Business Intelligent Systems Approach
DOI:
https://doi.org/10.15837/ijccc.2025.2.7017Keywords:
traffic accidents, exploratory analysis, business intelligence approachAbstract
Road traffic accidents are the leading cause of death for young people in today’s world. Given the proliferation of pedestrians, cyclists and motorcyclists in the city, it is necessary to find the most frequent causes to prevent these accidents. To resolve this situation problem an exploratory analysis of the databases is carried out to identify the main variables, their attributes and relationships. A Data Model is designed where the most frequent underlying causes of these accidents are identified, paying special attention to the actors involved, such as pedestrians, cyclists and motorcyclists. The integrated database is analyzed with a business intelligence approach to obtain behavioral patterns of the actors and determine the relevance of the variables involved in these events. The results obtained show that the main accidents with causes of death are collisions between vehicles and the crash, by not maintaining the prudent and reasonable distance caused by the physical conditions of the driver, whether fatigue and/or drunkenness. Since most accidents occur in the early morning or late afternoon, the use of illuminated beacons is recommended for cyclists and motorcyclists. Also, accident indicators are identified, and measures are recommended to improve the system. This work explores a method of Business Intelligence, with applications in the subject of study.
References
Das, A.; Sun, X. (2014). A Data Mining Framework for Analyzing Road Accident Data. Journal of Transportation Safety & Security 6(3), 180-203. doi:10.1080/19439962.2013.839929
Anbaroglu, B.; Heydecker, B. G.; & Cheng, T. (2014). Spatio-temporal clustering for nonrecurrent traffic congestion detection on urban road networks. Transportation Research Part C: Emerging Technologies, 48, 47-65. https://doi.org/10.1016/j.trc.2014.08.009
Aggarwal, C. C. (2015). Data Mining: The Textbook. Londres: Springer. doi:10.1007/978-3-319- 14142-8
Yoon, Y.; Bai, Y. (2016). Injury Severity in Traffic Crashes with Light Commercial Vehicles. Journal of Safety Research, 59, 23-29.
Xu, C.; Liu, X.; Jin, Z. (2018). Predicting Traffic Collision Severity: A Hybrid Deep Learning Framework. Accident Analysis & Prevention, 121, 338-347.
Broughton, J.; Baughan, C. J. (2002). The Effect of Seat Belt Usage on the Risk of Injury in Traffic Accidents: A Comparison of Data from the United States and Germany. Accident Analysis & Prevention, 34(2), 173-182. https://doi.org/10.1016/S0001-4575(01)00032-X
Chen, C.; Jovanis, P. P. (2000). Method for Identifying Factors Contributing to Driver-Injury Severity in Traffic Accidents Involving Large Trucks. Transportation Research Record: Journal of the Transportation Research Board, 1717, 1-7. https://doi.org/10.3141/1717-01
Boo, Y.; Choi, Y. (2021). Comparison of Prediction Model for Mortality Related to Injuries from Road Traffic Accidents after Correcting for Undersampling. International Journal of Environmental Research and Public Health, 18(5204). https://doi.org/10.3390/ijerph18115604
Anderson, T. K. (2009). Kernel Density Estimation and K-means Clustering to Profile Road Accident Hotspots. Accident Analysis & Prevention, 41(3), 359-364. doi:10.1016/j.aap.2008.12.014 https://doi.org/10.1016/j.aap.2008.12.014
Doe, J.; Smith, J. (2020). A Fuzzy Logic-Based Approach for Accident Risk Assessment in Transportation Systems. International Journal of Computers, Communications and Control, 15(3), 345-356.
Brown, A.; Johnson, R. (2022). An Analysis of Traffic Accident Data Using Machine Learning Techniques. International Journal of Computers, Communications and Control, 17(2), 210-220.
CONASET. (2019). Perfil de los fallecidos en siniestros de tránsito. Santiago de Chile. [Online]. Available: https://www.conaset.cl/wp-content/uploads/2020/08/Perfil-Fallecido-2019.pdf
CONASET. (2020). Costo social de los siniestros de tránsito en Chile. Santiago de Chile. [Online]. Available: https://www.conaset.cl/wp-content/uploads/2020/11/Costos-accidentes-2019.pdf
Montt, C.; Rubio, J. M.; Lanata, S. (2013). Análisis de accidentes de tránsito con inteligencia computacional. Congreso Chileno de Ingeniería de Transporte. [Online]. Available: https://congresotransporte.uchile.cl/index.php/CIT/article/view/28446/30168
ITF OECD. (2019). Road Safety in European Cities. Performance Indicators and Governance Solutions. [Online]. Available: https://www.itf-oecd.org/sites/default/files/docs/roadsafety- european-cities-performance-indicators.pdf
Additional Files
Published
Issue
Section
License
Copyright (c) 2025 Felisa Córdova, Cecilia Montt, Nicolás Lagos
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
ONLINE OPEN ACCES: Acces to full text of each article and each issue are allowed for free in respect of Attribution-NonCommercial 4.0 International (CC BY-NC 4.0.
You are free to:
-Share: copy and redistribute the material in any medium or format;
-Adapt: remix, transform, and build upon the material.
The licensor cannot revoke these freedoms as long as you follow the license terms.
DISCLAIMER: The author(s) of each article appearing in International Journal of Computers Communications & Control is/are solely responsible for the content thereof; the publication of an article shall not constitute or be deemed to constitute any representation by the Editors or Agora University Press that the data presented therein are original, correct or sufficient to support the conclusions reached or that the experiment design or methodology is adequate.
