Dataset: Air Crashes Full Data 1908 -2024

About this Dataset

Air Crashes Full Data 1908 -2024

This dataset was obtained from the online database for air crashes from ( https://www.planecrashinfo.com ). Having used it over several years for teaching students about power BI and pythons get data, and data visualization capabilities. It has been made available for others to easily access.
It will also be used for students projects going forward. It is intended to be updated yearly

Tables

Aircrahesfulldataupdated 2024

@kaggle.jogwums_air_crashes_full_data_1908_2023.aircrahesfulldataupdated_2024

218 KB
5035 rows
12 columns


CREATE TABLE aircrahesfulldataupdated_2024 (
  "year" BIGINT,
  "quarter" VARCHAR,
  "month" VARCHAR,
  "day" BIGINT,
  "country_region" VARCHAR,
  "aircraft_manufacturer" VARCHAR,
  "aircraft" VARCHAR,
  "location" VARCHAR,
  "operator" VARCHAR,
  "ground" BIGINT,
  "fatalities_air" BIGINT,
  "aboard" BIGINT
);

Aircrashesfulldata

@kaggle.jogwums_air_crashes_full_data_1908_2023.aircrashesfulldata

212.25 KB
5030 rows
12 columns


CREATE TABLE aircrashesfulldata (
  "year" BIGINT,
  "quarter" VARCHAR,
  "month" VARCHAR,
  "day" BIGINT,
  "country_region" VARCHAR,
  "aircraft_manufacturer" VARCHAR,
  "aircraft" VARCHAR,
  "location" VARCHAR,
  "operator" VARCHAR,
  "sum_of_ground" BIGINT,
  "sum_of_fatalities_air" BIGINT,
  "sum_of_aboard" BIGINT
);