🔥 Project Summary
This project is a comprehensive aviation data dashboard built using Python, Pandas, Gradio, and custom-scraped datasets. Over the course of several days, I scraped, cleaned, and merged decades worth of aviation incident records and airline information to deliver a polished and fully functional data product. The dashboard enables users to explore airline details, investigate historical incidents, and view insightful stats — all in real time.
🚀 Features
- 1. 🧭 Airlines Info Search
- Search airlines by name or country
- View details such as IATA/ICAO codes, fleet size, average age, hub airports, and more
- Clean, structured HTML output from CSV-backed data
- 2. 🔍 Aviation Incidents Lookup
- Filter incidents by:
- Year
- Plane model
- Country
- Displays matching records from 1900s to 2024, thanks to a custom-scraped and cleaned dataset of thousands of incidents
- Returns critical details: fatalities, flight routes, operator, summary, and more
- Filter incidents by:
- 3. 📊 Insights & Stats Section
- Auto-generated from real-world data, this section includes:
- Top 5 Most Dangerous Airlines (incident count + fatalities)
- Top 5 Deadliest Years in Aviation
- Top 5 Deadliest Planes
- Top 5 Most Dangerous Countries for Air Travel
- Top 5 Biggest Airlines by Fleet Size
- Each insight is dynamically computed and returned in a clean, readable table format.
- Auto-generated from real-world data, this section includes:
🛠️ Tools & Skills Demonstrated
| Skill/Tool | How It Was Used |
|---|---|
| Python | Core language for logic, data wrangling, and scripting |
| Pandas | Merging datasets, groupby analysis, filtering, and cleaning large CSVs |
| Web Scraping (Selenium) | Scraped historical aviation incident data from online archives over 3 days |
| Data Cleaning | Harmonized column formats, handled missing values, merged multiple sources |
| Gradio | Created an interactive, tab-based web UI for user input and data visualization |
| CSV Merging | Combined datasets from multiple decades with format discrepancies |
| Index/Column Management | Ensured consistency across merged datasets for stable analysis & display |
| Live Stats Computation | Generated insights using real-time filtered views on large datasets |
| Version Control | Structured project across multiple modules for easy scaling and deployment |
Check out the live demo of Skytrace!
Click the link below to explore the demo: