Name: Aircraft Wildlife Strikes, 1990-2015
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Aircraft Wildlife Strikes, 1990-2015

Content

The dataset contains a record of each reported wildlife strike of a military, commercial, or civil aircraft between 1990 and 2015. Each row contains the incident date, aircraft operator, aircraft make and model, engine make and model, airport name and location, species name and quantity, and aircraft damage.

Acknowledgements

The wildlife strike database was compiled from reports received from airports, airlines, and pilots and published by the Federal Aviation Association.

Tables

Database

@kaggle.faa_wildlife_strikes.database

4.58 MB
174104 rows
66 columns


CREATE TABLE database (
  "record_id" BIGINT,
  "incident_year" BIGINT,
  "incident_month" BIGINT,
  "incident_day" BIGINT,
  "operator_id" VARCHAR,
  "operator" VARCHAR,
  "aircraft" VARCHAR,
  "aircraft_type" VARCHAR,
  "aircraft_make" VARCHAR,
  "aircraft_model" VARCHAR,
  "aircraft_mass" DOUBLE,
  "engine_make" DOUBLE,
  "engine_model" VARCHAR,
  "engines" DOUBLE,
  "engine_type" VARCHAR,
  "engine1_position" VARCHAR,
  "engine2_position" DOUBLE,
  "engine3_position" VARCHAR,
  "engine4_position" DOUBLE,
  "airport_id" VARCHAR,
  "airport" VARCHAR,
  "state" VARCHAR,
  "faa_region" VARCHAR,
  "warning_issued" VARCHAR,
  "flight_phase" VARCHAR,
  "visibility" VARCHAR,
  "precipitation" VARCHAR,
  "height" DOUBLE,
  "speed" DOUBLE,
  "distance" DOUBLE,
  "species_id" VARCHAR,
  "species_name" VARCHAR,
  "species_quantity" VARCHAR,
  "flight_impact" VARCHAR,
  "fatalities" DOUBLE,
  "injuries" DOUBLE,
  "aircraft_damage" BIGINT,
  "radome_strike" BIGINT,
  "radome_damage" BIGINT,
  "windshield_strike" BIGINT,
  "windshield_damage" BIGINT,
  "nose_strike" BIGINT,
  "nose_damage" BIGINT,
  "engine1_strike" BIGINT,
  "engine1_damage" BIGINT,
  "engine2_strike" BIGINT,
  "engine2_damage" BIGINT,
  "engine3_strike" BIGINT,
  "engine3_damage" BIGINT,
  "engine4_strike" BIGINT,
  "engine4_damage" BIGINT,
  "engine_ingested" BIGINT,
  "propeller_strike" BIGINT,
  "propeller_damage" BIGINT,
  "wing_or_rotor_strike" BIGINT,
  "wing_or_rotor_damage" BIGINT,
  "fuselage_strike" BIGINT,
  "fuselage_damage" BIGINT,
  "landing_gear_strike" BIGINT,
  "landing_gear_damage" BIGINT,
  "tail_strike" BIGINT,
  "tail_damage" BIGINT,
  "lights_strike" BIGINT,
  "lights_damage" BIGINT,
  "other_strike" BIGINT,
  "other_damage" BIGINT
);