Dataset: Air Disasters(1919- OCT 2022)

About this Dataset

Air Disasters(1919- OCT 2022)

An aviation accident is defined by the Convention on International Civil Aviation Annex 13 as an occurrence associated with the operation of an aircraft, which takes place from the time any person boards the aircraft with the intention of flight until all such persons have disembarked, and in which a) a person is fatally or seriously injured, b) the aircraft sustains significant damage or structural failure, or c) the aircraft goes missing or becomes completely inaccessible.Annex 13 defines an aviation incident as an occurrence, other than an accident, associated with the operation of an aircraft that affects or could affect the safety of operation

A hull loss occurs if an aircraft is damaged beyond repair, lost, or becomes completely inaccessible.

IMPORTANT NOTE:

1 = hull-loss
2 = repairable damage

Tables

Aircraft Accidents In Oceans Unknown Aircraft Accidents

@kaggle.ramjasmaurya_aviation_accidents_history1919_april_2022.aircraft_accidents_in_oceans_unknown_aircraft_accidents

45.25 KB
1387 rows
8 columns


CREATE TABLE aircraft_accidents_in_oceans_unknown_aircraft_accidents (
  "ocean_country" VARCHAR,
  "date" VARCHAR,
  "air_craft_type" VARCHAR,
  "registration_name_mark" VARCHAR,
  "operator" VARCHAR,
  "fatilites" VARCHAR,
  "location" VARCHAR,
  "category" VARCHAR
);

Aviation Accidents In Countries Aviation Accidents

@kaggle.ramjasmaurya_aviation_accidents_history1919_april_2022.aviation_accidents_in_countries_aviation_accidents

728.19 KB
21757 rows
8 columns


CREATE TABLE aviation_accidents_in_countries_aviation_accidents (
  "country" VARCHAR,
  "date" VARCHAR,
  "air_craft_type" VARCHAR,
  "registration_name_mark" VARCHAR,
  "operator" VARCHAR,
  "fatilites" VARCHAR,
  "location" VARCHAR,
  "category" VARCHAR
);