__STYLES__
In this project, I am attempting to complete the project using PostgreSQL. The dataset used is the accident_2021_database <<< — Download dataset.
I have placed all the queries I used on the following GitHub repository.
The primary goal of this project is to analyze traffic safety data for 2021 to provide valuable recommendations to the National Highway Traffic Safety Administration. This analysis will provide in-depth insight into the factors that cause accidents, incident patterns, as well as critical areas that require more attention in efforts to develop new, more effective regulations.
The main objective of this project is to carry out an in-depth analysis of accident data that occurred throughout 2021 and develop concrete and effective recommendations to reduce the number of accidents on the road. By carefully analyzing the data, this project aims to provide guidance to NHTSA in designing new regulations that are more effective and focused on traffic safety. Some specific goals that can be achieved through this project include:
By formulating these goals, the “Traffic Safety Project 2021” project will provide strong guidance and recommendations to NHTSA to design new regulations that have the potential to significantly reduce the number of road accidents
Summary
Conclusion
We did not carry out the cleaning process for abnormalities in the data because based on the existing data we could not find patterns regarding the hours of the day and night in certain seasons, and time constraints
Dominance of Accidents in Sunny and Daytime Weather: The highest number of accidents occurred in sunny and daytime conditions. This is an important finding that suggests other factors may be more influential in causing accidents.
Summary
Highlights
Of the 35,451 accident cases that occurred, the top 10 states accounted for 51.9%. The most accident cases were in the state of Texas, followed by California and Florida which accounted for 28.5% of the total accidents that occurred.
Summary
Highlights
Community mobility which results in accidents increases from 06 to 13 and begins to decline from 14 to 22 with a high number of accidents, especially at 11–16 with the peak occurring at 13. There needs to be increased prevention balanced with increased preparedness. accident handling
Persentase Kecelakaan
f: =countif(numberof drunk driver ,”>0")/count(totalkecelakaan)*100
f: 9141/35451*100
f: =countif(numberof drunk driver,”=0")/count(totalkecelakaan)*100
f: 26310/35451 * 100
The percentage of accidents due to drunkenness is influenced by light conditions
Summary
The following is detailed data on the percentage of accidents due to drunkenness or soberness which are influenced by light conditions
The number of accident fatalities in 2021 based on the category of drunk or not drunk drivers
Summary
Highlights
In 2021, the number of accidents caused by drunk drivers accounted for 25.78% of the total 100% of incidents. This means that there are still many vehicle drivers who do not comply with safety rules while driving so that this action causes harm both to themselves and to others. In fact, 10,138 people died as a result of this incident.
The incident that occurs most often is when it is dark without any street lighting and the driver is drunk. These two things have a big potential to cause traffic accidents because the driver’s concentration decreases and their response slows down.
In fact, this incident could have been avoided if the driver had full awareness of the dangers of consuming alcohol or other prohibited substances which could cause a loss of consciousness. Therefore, it is important to avoid driving after consuming alcohol and always look for safe alternatives such as using public transportation, taxis, or relying on friends or family to take you home. The safety of yourself and others must always be a top priority.
Summary
Based on existing data, it shows that 14,845 accidents occurred in villages and 20,123 accidents occurred in cities. So it can be concluded that the number of accidents in urban areas is higher than the number of accidents in rural areas
From the percentage data presented, 57.5% of total accidents occurred in cities, while 42.5% occurred in rural areas. From this percentage we can see the comparison of the percentage level of accidents in each location which is related to the total number of accidents.
With a higher number of accidents and a larger percentage of accidents in the city, this shows that the accident problem in this area is more severe. It is very important to take appropriate and effective preventive measures based on an analysis of the causes and variables that influence the frequency of accidents in the city.
Even though accidents in villages are lower than in cities, it is very important to maintain and monitor safety in these areas. By analyzing the factors that cause accidents in villages, it can help prevent an increase in accidents in the future.
Other areas (Not Reported, Unknown, Traffic Not in State Inventory) were ignored due to the small number (483 accidents out of a total of 35,451 or 1.36%)
Highlight
The highest total accidents were in urban areas with a total of 20123 accidents with a percentage rate of 57.5%, while the lowest accident rate was in rural areas with a total of 14845 accidents with a percentage of 42.5%.
Summary Chart
Based on existing data, it shows that the highest number of accidents by day occurred on Sunday (Sunday) with 6327 cases and the second on Saturday (Saturday) with 5812 cases, so it can be concluded that the highest number of accidents occurred on weekends/holidays.
Highlight
The highest number of accidents occur on weekends (Saturday-Sunday), this is because many people use private vehicles to go on holiday or visit relatives/friends, so the traffic volume becomes busy, which can increase the risk of accidents occurring.
Summary Chart
Highlight
With high levels of drunk driving occurring at 15–18 with a peak occurring at 17, and almost equal accidents occurring between drunk and not drunk drivers at 18–20, there needs to be more massive prevention against drunk drivers at that time.
Based on the findings in the accident data for 2021, we are making recommendations to the National Highway Traffic Safety Administration
There is a need for comprehensive training and communication with field personnel regarding the definition and limitations of light conditions (such as Dark — Not Lighted, Dark — Lighted, Dusk, Dawn, Dark — Unknown Lighting, Reported as Unknown, Not Reported, Other). This will ensure better and more accurate analysis of accident data.
2. Driver Education and Awareness Campaigns
Given that clear weather and daytime lighting conditions are associated with the highest number of accidents, the NHTSA can develop driver awareness campaigns that specifically focus on safe driving habits during favorable weather and lighting conditions. Education on maintaining safe following distances, using headlights during the daytime, and the dangers of excessive speed in clear weather can help reduce accidents.
3. Infrastructure Lighting
Considering the increased accidents in poorly lit dark conditions, the NHTSA can collaborate with relevant agencies to enhance lighting on roads with inadequate illumination. Sufficient lighting can improve visibility and reduce the risk of accidents.
4. Avoid Driving Under the Influence
The use of dangerous additives or consuming alcoholic beverages can impair concentration and significantly increase the risk of accidents, posing serious threats to the safety of the driver, passengers, and other road users. In 2021, NHTSA data recorded 10,138 fatalities caused by drunk drivers. This alarming figure urges the NHTSA to launch extensive public awareness campaigns and education programs using mass media, social media, advertising, or educational initiatives to raise awareness about the dangers of impaired driving.