Name: Plane Crashes Dataset
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Plane Crashes Dataset

Introduction

This dataset provides a comprehensive and detailed look into aviation accidents that occurred from 1908 to 2024. It includes data on all fatal civil and commercial aviation accidents, military transport incidents, helicopter and airship crashes, as well as notable incidents involving the deaths of famous individuals. This database is an invaluable tool for researchers, aviation safety analysts, historians, and aviation enthusiasts seeking to understand the causes and circumstances of these tragic events.

Interesting Questions to Explore with the Dataset

What is the trend in fatal aviation accidents over time?
Plot accidents by year to visualize upward or downward trends.
Which aircraft models have the highest number of recorded accidents?
Identify aircraft models and analyze their safety records.
Is there a relationship between certain operators and the frequency of aviation accidents?
Compare different airlines and operators to determine potential safety issues.
Which countries have the highest number of aviation accidents, and what factors might influence this?
Conduct a geographic analysis of accidents to identify high-risk areas and underlying causes.
What are the most common causes of aviation accidents over the decades?
Analyze accident summaries to identify common patterns and recurring causes.

Dataset Benefits

Safety Research and Analysis:
Helps improve aviation safety practices by identifying common causes and patterns in accidents.
Policy Development:
Informs regulators and aviation bodies about critical areas needing attention and improvement.
Aviation Historiography:
Provides a rich source of information for historians and aviation enthusiasts.
Education and Public Awareness:
Educates the community and future aviation professionals on the importance of aviation safety.

Source: https://www.planecrashinfo.com/database.htm

Tables

Accident Details Compiled

@kaggle.luiscfrancisco_plane_crashes_dataset.accident_details_compiled

999.49 kB
5,078 rows
14 columns

CREATE TABLE accident_details_compiled (
  "n" VARCHAR  -- -,
  "date" VARCHAR,
  "time" VARCHAR,
  "location" VARCHAR,
  "operator" VARCHAR,
  "flight" VARCHAR  -- Flight #,
  "route" VARCHAR,
  "ac_type" VARCHAR,
  "registration" VARCHAR,
  "cn_ln" VARCHAR  -- Cn / Ln,
  "aboard" VARCHAR,
  "fatalities" VARCHAR,
  "ground" VARCHAR,
  "summary" VARCHAR
);