Aircraft Incident_Iriarte Leonardo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ACCIDENTES, FALLAS Y SECUESTROS DE AERONAVES\n",
    "\n",
    "Base de datos extraída de [Kaggle](https://www.kaggle.com/datasets/deepcontractor/aircraft-accidents-failures-hijacks-dataset), compartida por el usuario DEEP CONTRACTOR, actualizada por última vez hace 2 años aproximadamente.\n",
    "\n",
    "La base de datos especifica datos sobre accidentes y secuestros en todo el mundo de aviones de pasajeros (más de 12 pasajeros), aviones corporativos y aviones de transporte militar desde 1919 hasta 2021.\n",
    "\n",
    "El csv archivo fue descargado y re subido a una cuenta Google Drive personal, se encuentra en el siguiente siguiente link:\n",
    "[Aircraft Inicident Dataset](https://drive.google.com/file/d/1WrnGcWClZBeUkcIT_erMRAeBTzCmxmL-/view?usp=sharing)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Incident_Date</th>\n",
       "      <th>Aircaft_Model</th>\n",
       "      <th>Aircaft_Operator</th>\n",
       "      <th>Aircaft_Nature</th>\n",
       "      <th>Incident_Category</th>\n",
       "      <th>Incident_Cause(es)</th>\n",
       "      <th>Incident_Location</th>\n",
       "      <th>Aircaft_Damage_Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>...</th>\n",
       "      <th>Onboard_Crew</th>\n",
       "      <th>Onboard_Passengers</th>\n",
       "      <th>Onboard_Total</th>\n",
       "      <th>Fatalities</th>\n",
       "      <th>Aircaft_First_Flight</th>\n",
       "      <th>Aircraft_Phase</th>\n",
       "      <th>Departure_Airport</th>\n",
       "      <th>Destination_Airport</th>\n",
       "      <th>Ground_Casualties</th>\n",
       "      <th>Collision_Casualties</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aircaft_Registration</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ZS-NRJ</th>\n",
       "      <td>03-JAN-2022</td>\n",
       "      <td>British Aerospace 4121 Jetstream 41</td>\n",
       "      <td>SA Airlink</td>\n",
       "      <td>Domestic Non Scheduled Passenger</td>\n",
       "      <td>Accident | repairable-damage</td>\n",
       "      <td>Airplane - Engines, Airplane - Engines - Prop/...</td>\n",
       "      <td>near Venetia Mine...</td>\n",
       "      <td>Substantial</td>\n",
       "      <td>Monday 3 January 2022</td>\n",
       "      <td>08:10</td>\n",
       "      <td>...</td>\n",
       "      <td>Fatalities: 0 / Occupants: 3</td>\n",
       "      <td>Fatalities: 0 / Occupants: 4</td>\n",
       "      <td>Fatalities: 0 / Occupants: 7</td>\n",
       "      <td>0</td>\n",
       "      <td>1995-05-19  (26 years 8 months)</td>\n",
       "      <td>Landing (LDG)</td>\n",
       "      <td>Johannesburg-O.R. Tambo International Airport ...</td>\n",
       "      <td>Venetia Mine Airport (FAVM) , South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HR-AYY</th>\n",
       "      <td>04-JAN-2022</td>\n",
       "      <td>British Aerospace 3101 Jetstream 31</td>\n",
       "      <td>LANHSA</td>\n",
       "      <td>Domestic Scheduled Passenger</td>\n",
       "      <td>Accident | repairable-damage</td>\n",
       "      <td>Airplane - Undercarriage, Airplane - Undercarr...</td>\n",
       "      <td>Roatán-Juan ...</td>\n",
       "      <td>Substantial</td>\n",
       "      <td>Tuesday 4 January 2022</td>\n",
       "      <td>ca 12:00</td>\n",
       "      <td>...</td>\n",
       "      <td>Fatalities: 0 / Occupants:</td>\n",
       "      <td>Fatalities: 0 / Occupants:</td>\n",
       "      <td>Fatalities: 0 / Occupants: 19</td>\n",
       "      <td>0</td>\n",
       "      <td>1985</td>\n",
       "      <td>Landing (LDG)</td>\n",
       "      <td>La Ceiba-Goloson International Airport (LCE/MH...</td>\n",
       "      <td>Roatán-Juan Manuel Gálvez International Airpor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EP-CAP</th>\n",
       "      <td>05-JAN-2022</td>\n",
       "      <td>Boeing 737-4H6</td>\n",
       "      <td>Caspian Airlines</td>\n",
       "      <td>Domestic Scheduled Passenger</td>\n",
       "      <td>Accident | repairable-damage</td>\n",
       "      <td>Airplane - Undercarriage, Airplane - Undercarr...</td>\n",
       "      <td>Isfahan-Shah...</td>\n",
       "      <td>Substantial</td>\n",
       "      <td>Wednesday 5 January 2022</td>\n",
       "      <td>17:07</td>\n",
       "      <td>...</td>\n",
       "      <td>Fatalities: 0 / Occupants:</td>\n",
       "      <td>Fatalities: 0 / Occupants:</td>\n",
       "      <td>Fatalities: 0 / Occupants: 116</td>\n",
       "      <td>0</td>\n",
       "      <td>1992-09-18  (29 years 4 months)</td>\n",
       "      <td>Landing (LDG)</td>\n",
       "      <td>Mashhad Airport (MHD/OIMM) , Iran</td>\n",
       "      <td>Isfahan-Shahid Beheshti Airport (IFN/OIFM) , Iran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RA-64032</th>\n",
       "      <td>08-JAN-2022</td>\n",
       "      <td>Tupolev Tu-204-100C</td>\n",
       "      <td>Cainiao, opb Aviastar-TU</td>\n",
       "      <td>Cargo</td>\n",
       "      <td>Accident | hull-loss</td>\n",
       "      <td>Cargo - Fire/smoke, Result - Damaged on the gr...</td>\n",
       "      <td>Hangzhou-Xia...</td>\n",
       "      <td>Destroyed</td>\n",
       "      <td>Saturday 8 January 2022</td>\n",
       "      <td>04:40</td>\n",
       "      <td>...</td>\n",
       "      <td>Fatalities: 0 / Occupants: 8</td>\n",
       "      <td>Fatalities: 0 / Occupants: 0</td>\n",
       "      <td>Fatalities: 0 / Occupants: 8</td>\n",
       "      <td>0</td>\n",
       "      <td>2002-07-18  (19 years 6 months)</td>\n",
       "      <td>Standing (STD)</td>\n",
       "      <td>Hangzhou-Xiaoshan International Airport (HGH/Z...</td>\n",
       "      <td>Novosibirsk-Tolmachevo Airport (OVB/UNNT) , Ru...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>12-JAN-2022</td>\n",
       "      <td>Beechcraft 200 Super King Air</td>\n",
       "      <td>private</td>\n",
       "      <td>Illegal Flight</td>\n",
       "      <td>Criminal occurrence (sabotage, shoot down) | h...</td>\n",
       "      <td>Result - Damaged on the ground</td>\n",
       "      <td>Machakilha, ...</td>\n",
       "      <td>Damaged beyond repair</td>\n",
       "      <td>Wednesday 12 January 2022</td>\n",
       "      <td>c. 02:00</td>\n",
       "      <td>...</td>\n",
       "      <td>Fatalities: 0 / Occupants: 0</td>\n",
       "      <td>Fatalities: 0 / Occupants: 0</td>\n",
       "      <td>Fatalities: 0 / Occupants: 0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Standing (STD)</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Incident_Date                        Aircaft_Model  \\\n",
       "Aircaft_Registration                                                      \n",
       "ZS-NRJ                 03-JAN-2022  British Aerospace 4121 Jetstream 41   \n",
       "HR-AYY                 04-JAN-2022  British Aerospace 3101 Jetstream 31   \n",
       "EP-CAP                 05-JAN-2022                       Boeing 737-4H6   \n",
       "RA-64032               08-JAN-2022                  Tupolev Tu-204-100C   \n",
       "NaN                    12-JAN-2022        Beechcraft 200 Super King Air   \n",
       "\n",
       "                              Aircaft_Operator  \\\n",
       "Aircaft_Registration                             \n",
       "ZS-NRJ                              SA Airlink   \n",
       "HR-AYY                                  LANHSA   \n",
       "EP-CAP                        Caspian Airlines   \n",
       "RA-64032              Cainiao, opb Aviastar-TU   \n",
       "NaN                                    private   \n",
       "\n",
       "                                        Aircaft_Nature  \\\n",
       "Aircaft_Registration                                     \n",
       "ZS-NRJ                Domestic Non Scheduled Passenger   \n",
       "HR-AYY                    Domestic Scheduled Passenger   \n",
       "EP-CAP                    Domestic Scheduled Passenger   \n",
       "RA-64032                                         Cargo   \n",
       "NaN                                     Illegal Flight   \n",
       "\n",
       "                                                      Incident_Category  \\\n",
       "Aircaft_Registration                                                      \n",
       "ZS-NRJ                                     Accident | repairable-damage   \n",
       "HR-AYY                                     Accident | repairable-damage   \n",
       "EP-CAP                                     Accident | repairable-damage   \n",
       "RA-64032                                           Accident | hull-loss   \n",
       "NaN                   Criminal occurrence (sabotage, shoot down) | h...   \n",
       "\n",
       "                                                     Incident_Cause(es)  \\\n",
       "Aircaft_Registration                                                      \n",
       "ZS-NRJ                Airplane - Engines, Airplane - Engines - Prop/...   \n",
       "HR-AYY                Airplane - Undercarriage, Airplane - Undercarr...   \n",
       "EP-CAP                Airplane - Undercarriage, Airplane - Undercarr...   \n",
       "RA-64032              Cargo - Fire/smoke, Result - Damaged on the gr...   \n",
       "NaN                                      Result - Damaged on the ground   \n",
       "\n",
       "                         Incident_Location    Aircaft_Damage_Type  \\\n",
       "Aircaft_Registration                                                \n",
       "ZS-NRJ                near Venetia Mine...            Substantial   \n",
       "HR-AYY                     Roatán-Juan ...            Substantial   \n",
       "EP-CAP                     Isfahan-Shah...            Substantial   \n",
       "RA-64032                   Hangzhou-Xia...              Destroyed   \n",
       "NaN                        Machakilha, ...  Damaged beyond repair   \n",
       "\n",
       "                                           Date      Time  ...  \\\n",
       "Aircaft_Registration                                       ...   \n",
       "ZS-NRJ                    Monday 3 January 2022     08:10  ...   \n",
       "HR-AYY                   Tuesday 4 January 2022  ca 12:00  ...   \n",
       "EP-CAP                 Wednesday 5 January 2022     17:07  ...   \n",
       "RA-64032                Saturday 8 January 2022     04:40  ...   \n",
       "NaN                   Wednesday 12 January 2022  c. 02:00  ...   \n",
       "\n",
       "                                      Onboard_Crew  \\\n",
       "Aircaft_Registration                                 \n",
       "ZS-NRJ                Fatalities: 0 / Occupants: 3   \n",
       "HR-AYY                  Fatalities: 0 / Occupants:   \n",
       "EP-CAP                  Fatalities: 0 / Occupants:   \n",
       "RA-64032              Fatalities: 0 / Occupants: 8   \n",
       "NaN                   Fatalities: 0 / Occupants: 0   \n",
       "\n",
       "                                Onboard_Passengers  \\\n",
       "Aircaft_Registration                                 \n",
       "ZS-NRJ                Fatalities: 0 / Occupants: 4   \n",
       "HR-AYY                  Fatalities: 0 / Occupants:   \n",
       "EP-CAP                  Fatalities: 0 / Occupants:   \n",
       "RA-64032              Fatalities: 0 / Occupants: 0   \n",
       "NaN                   Fatalities: 0 / Occupants: 0   \n",
       "\n",
       "                                       Onboard_Total Fatalities  \\\n",
       "Aircaft_Registration                                              \n",
       "ZS-NRJ                  Fatalities: 0 / Occupants: 7          0   \n",
       "HR-AYY                 Fatalities: 0 / Occupants: 19          0   \n",
       "EP-CAP                Fatalities: 0 / Occupants: 116          0   \n",
       "RA-64032                Fatalities: 0 / Occupants: 8          0   \n",
       "NaN                     Fatalities: 0 / Occupants: 0          0   \n",
       "\n",
       "                                 Aircaft_First_Flight  Aircraft_Phase  \\\n",
       "Aircaft_Registration                                                    \n",
       "ZS-NRJ                1995-05-19  (26 years 8 months)   Landing (LDG)   \n",
       "HR-AYY                                           1985   Landing (LDG)   \n",
       "EP-CAP                1992-09-18  (29 years 4 months)   Landing (LDG)   \n",
       "RA-64032              2002-07-18  (19 years 6 months)  Standing (STD)   \n",
       "NaN                                               NaN  Standing (STD)   \n",
       "\n",
       "                                                      Departure_Airport  \\\n",
       "Aircaft_Registration                                                      \n",
       "ZS-NRJ                Johannesburg-O.R. Tambo International Airport ...   \n",
       "HR-AYY                La Ceiba-Goloson International Airport (LCE/MH...   \n",
       "EP-CAP                                Mashhad Airport (MHD/OIMM) , Iran   \n",
       "RA-64032              Hangzhou-Xiaoshan International Airport (HGH/Z...   \n",
       "NaN                                                                   ?   \n",
       "\n",
       "                                                    Destination_Airport  \\\n",
       "Aircaft_Registration                                                      \n",
       "ZS-NRJ                       Venetia Mine Airport (FAVM) , South Africa   \n",
       "HR-AYY                Roatán-Juan Manuel Gálvez International Airpor...   \n",
       "EP-CAP                Isfahan-Shahid Beheshti Airport (IFN/OIFM) , Iran   \n",
       "RA-64032              Novosibirsk-Tolmachevo Airport (OVB/UNNT) , Ru...   \n",
       "NaN                                                                   ?   \n",
       "\n",
       "                     Ground_Casualties Collision_Casualties  \n",
       "Aircaft_Registration                                         \n",
       "ZS-NRJ                             NaN                  NaN  \n",
       "HR-AYY                             NaN                  NaN  \n",
       "EP-CAP                             NaN                  NaN  \n",
       "RA-64032                           NaN                  NaN  \n",
       "NaN                                NaN                  NaN  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "url = 'https://drive.google.com/uc?export=download&id=1WrnGcWClZBeUkcIT_erMRAeBTzCmxmL-'\n",
    "df = pd.read_csv(url, index_col=2)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(23519, 22)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Aircaft_Model',\n",
       " 'Aircaft_Registration',\n",
       " 'Aircaft_Operator',\n",
       " 'Aircaft_Nature',\n",
       " 'Incident_Category',\n",
       " 'Incident_Cause(es)',\n",
       " 'Incident_Location',\n",
       " 'Aircaft_Damage_Type',\n",
       " 'Date',\n",
       " 'Time',\n",
       " 'Arit',\n",
       " 'Aircaft_Engines',\n",
       " 'Onboard_Crew',\n",
       " 'Onboard_Passengers',\n",
       " 'Onboard_Total',\n",
       " 'Fatalities',\n",
       " 'Aircaft_First_Flight',\n",
       " 'Aircraft_Phase',\n",
       " 'Departure_Airport',\n",
       " 'Destination_Airport',\n",
       " 'Ground_Casualties',\n",
       " 'Collision_Casualties']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Aircaft_Model           object\n",
       "Aircaft_Registration    object\n",
       "Aircaft_Operator        object\n",
       "Aircaft_Nature          object\n",
       "Incident_Category       object\n",
       "Incident_Cause(es)      object\n",
       "Incident_Location       object\n",
       "Aircaft_Damage_Type     object\n",
       "Date                    object\n",
       "Time                    object\n",
       "Arit                    object\n",
       "Aircaft_Engines         object\n",
       "Onboard_Crew            object\n",
       "Onboard_Passengers      object\n",
       "Onboard_Total           object\n",
       "Fatalities               int64\n",
       "Aircaft_First_Flight    object\n",
       "Aircraft_Phase          object\n",
       "Departure_Airport       object\n",
       "Destination_Airport     object\n",
       "Ground_Casualties       object\n",
       "Collision_Casualties    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Aircaft_Model               0\n",
       "Aircaft_Registration     1561\n",
       "Aircaft_Operator            0\n",
       "Aircaft_Nature              0\n",
       "Incident_Category           0\n",
       "Incident_Cause(es)          0\n",
       "Incident_Location         932\n",
       "Aircaft_Damage_Type       768\n",
       "Date                        0\n",
       "Time                    14316\n",
       "Arit                        0\n",
       "Aircaft_Engines         12883\n",
       "Onboard_Crew                0\n",
       "Onboard_Passengers          0\n",
       "Onboard_Total               0\n",
       "Fatalities                  0\n",
       "Aircaft_First_Flight     5488\n",
       "Aircraft_Phase              0\n",
       "Departure_Airport           0\n",
       "Destination_Airport         0\n",
       "Ground_Casualties       23172\n",
       "Collision_Casualties    23227\n",
       "dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Definición de columnas:\n",
    "\n",
    "01. INCIDENT_DATE: Fecha del accidente/incidente.\n",
    "02. AIRCRAFT_REGISTRATION: Registro de la aeronave.\n",
    "03. AIRCRAFT_OPERATOR: Empresa operadora de la aeronave.\n",
    "04. AIRCRAFT_NATURE: Tipo de utilidad de aeroave.\n",
    "05. INCIDENT_CATEGORY: Categoría o tipo de accidente/incidente.\n",
    "06. INCIDENT_CAUSE(ES): Causa/s del accidente/incidente.\n",
    "07. INCIDENT_LOCATION: Breve descripción de la zona donde ocurrió el accidente/incidente.\n",
    "08. AIRCRAFT_DAMAGE_TYPE: Tipo de daños en la aeronave.\n",
    "09. DATE: Fecha del accidente/incidente (especifica el día de la semana)\n",
    "10. TIME: Hora del accidente/incidente.\n",
    "11. ARIT: -término desconocido- la información de la columna duplica la de INCIDENT_DATE.\n",
    "12. AIRCRAFT_ENGINES: Tipo de motores de la aeronave.\n",
    "13. ONBOARD_CREW: Tripulación a bordo, cuantifica el total de muertes sobre el total de ocupaciones.\n",
    "14. ONBOARD_PASSENGERS: Pasajeros a bordo, cuantifica el total de muertes sobre el total de ocupaciones.\n",
    "15. ONBOARD_TOTAL: Total de personas a bordo, cuantifica el total de muertes sobre el total de ocupaciones.\n",
    "16. FATALITIES: Total de muertes.\n",
    "17. AIRCRAFT_FIRST_FLIGHT: Primer vuelo realizado por la aeronave.\n",
    "18. AIRCRAFT_PHASE: Fase de vuelo (por ej: aterrizando, en ruta, en ascenso, etc).\n",
    "19. DEPARTURE_AIRPORT: Aeropuerto de salida.\n",
    "20. DESTINATION_AIRPORT: Aeropuerto de destino.\n",
    "21. GROUND_CASUALTIES: Víctimas en suelo.\n",
    "22. COLLISION_CASUALTIES: Víctimas por colisión."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}