This project analyzes civil aviation accident data from the National Transportation Safety Board (NTSB) between 1962 and 2023. The objective is to provide actionable insights that guide safe investment decisions as a company expands into the aviation sector. Through data cleaning, analysis, and interactive visualization, this project identifies patterns in accident severity across different aircraft makes, engine types, and flight purposes.
Stakeholder:
Head of the company’s new Aviation Division
Business Objective:
To identify the safest aircraft for purchase and operation by evaluating historical accident data. The analysis focuses on determining which aircraft types, engine configurations, and flight purposes are associated with higher or lower safety risks.
Key Business Questions:
- Which aircraft manufacturers are most commonly associated with fatal accidents?
- Are certain types of flight operations (e.g., personal vs. commercial) more dangerous?
- Do specific engine types correlate with higher accident severity?
- Provider: National Transportation Safety Board (NTSB)
- Dataset: Civil Aviation Accidents and Incidents (1962–2023)
- Access: Provided via course materials
The dataset includes fields such as:
Aircraft MakeEngine TypePurpose of FlightInjury SeverityEvent DateLocation, among others
After initial inspection, the dataset was cleaned to remove null values in critical fields and grouped logically to support analysis of fatality patterns.
These visualizations were created using Tableau to support both exploratory analysis and business decision-making:
-
Top 10 Aircraft Makes by Fatal Accidents
Identifies the aircraft makes with the highest frequency of fatal incidents. -
Fatality Rate by Flight Purpose
Displays the percentage of incidents by injury severity across flight types (e.g., personal, commercial, business). -
Injury Severity Distribution by Engine Type
Shows which engine types are associated with more or less severe outcomes.
Explore my dashboard for more visual information. https://public.tableau.com/app/profile/abigael.musyoka/viz/AnalysingAircraftsGuideforSaferInvestmentDecisions-OpulentAbby/AviationSafetyRiskDashboardAnalyzingaircraftmakepurposeandenginetypetoguidesaferinvestmentdecisions_?publish=yes
- Aircraft make is a significant factor in accident fatality counts — certain manufacturers appear disproportionately in fatal incidents.
- Personal-use flights have notably higher fatality rates compared to commercial and business flights.
- Reciprocating/single-engine aircraft show a higher frequency of fatal or serious injuries compared to turbofan or multi-engine configurations.
- Prioritize investment in aircraft with strong safety records and low fatal incident history.
- Focus operations on commercial or business flight categories to reduce risk exposure.
- Favor multi-engine or turbofan aircraft over single-engine designs where possible.
README.md # This project overview aviation_clean.csv # Cleaned dataset used for Tableau aviation_notebook_final.ipynb # Final Jupyter Notebook with analysis presentation.pdf # Business-facing slide deck .gitignore # Files to ignore in version control
This repository includes a clean commit history showing the progression from data cleaning to visualization and dashboard development.
- Clear and descriptive commit messages
- Regular updates throughout the project timeline -Prepared for individual or group collaboration
A .gitignore file is included at the root to prevent unnecessary files from being pushed, such as:
- System files (e.g.,
.DS_Store) - Environment files
- Large raw data files
The base file was adapted from GitHub’s recommended Python .gitignore.
Created by: ABIGAEL NZIVU MUSYOKA
Dashboard: [View Tableau Public Dashboard]https://public.tableau.com/app/profile/abigael.musyoka/viz/AnalysingAircraftsGuideforSaferInvestmentDecisions-OpulentAbby/AviationSafetyRiskDashboardAnalyzingaircraftmakepurposeandenginetypetoguidesaferinvestmentdecisions_?publish=yes