Name: Plane Crash Dataset (03.04.2023)
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Plane Crash Dataset (03.04.2023)

Plane Crash Dataset providing information about Aviation Accidents in period 1908 - 2023. The data is beeing published in https://www.planecrashinfo.com/ by Richard Kebabjian, I DO NOT OWN this data. I collected data in more accesable csv format using Power Query in web scraping purpose.

Tables

Data Ready

@kaggle.kamilkarczmarczyk_plane_crash_dataset_03042023.data_ready

1 MB
5,028 rows
17 columns

CREATE TABLE data_ready (
  "date" VARCHAR,
  "time" VARCHAR  -- Time:,
  "location" VARCHAR  -- Location:,
  "ac_type" VARCHAR  -- AC Type:,
  "operator" VARCHAR  -- Operator:,
  "route" VARCHAR  -- Route:,
  "cn_ln" VARCHAR  -- Cn / Ln:,
  "flight" VARCHAR  -- Flight #:,
  "is_military" VARCHAR,
  "military_country" VARCHAR,
  "aboard_all" VARCHAR,
  "aboard_passengers" VARCHAR,
  "fatalities_all" VARCHAR,
  "fatalities_passengers" VARCHAR,
  "ground" DOUBLE  -- Ground:,
  "registration" VARCHAR  -- Registration:,
  "summary" VARCHAR  -- Summary:
);