Baselight

Air Crashes Full Data 1908 -2024

Contains record of air incidents including location, aircraft, fatalities & date

@kaggle.jogwums_air_crashes_full_data_1908_2023

Loading...
Loading...

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
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.