Brazil: Total Aeronautical Occurrences 2010 - 2021
Data of aeronautical occurrences of Brazilian civil aviation.
@kaggle.liamarguedas_brazil_total_aeronautical_occurrences_2010_2021
Loading...
Loading...
Loading...
Loading...
About this Dataset
Brazil: Total Aeronautical Occurrences 2010 - 2021
The database of aeronautical occurrences is managed by the Center for Investigation and Prevention of Aeronautical Accidents (CENIPA). This database contains the aeronautical occurrences notified to CENIPA in the years 2010 to 2021 that occurred on Brazilian soil.
Among the information available are data on the aircraft involved, fatalities, location, date, time of events and taxonomic information typical of accident investigations (AIG). The privacy of individuals/legal entities involved is protected, as provided for by the Access to Information Law (Law No. 12,527, of November 18, 2011).
This database consists of preliminary information from the CENIPA-05 form (Aeronautical Occurrences Notification Form) and consolidated from published investigation reports. Another way of viewing this data is through SIPAER Panel at:
available on the CENIPA website.
Data from the Prevention Management Programs administered by CENIPA (Laser Ray Emission and Balloon Risk) are not included in this database. These programs have their own data collection forms with an exclusive focus on risk management, while the data collected by the CENIPA-05 form has a main focus on accident investigation (AIG).
Data Dictionary
| Column Name | Meaning |
|---|---|
| ocorrencia_classificacao | Classification of the occurrence (e.g., Incident, Accident) |
| ocorrencia_latitude | Latitude coordinates of the occurrence location |
| ocorrencia_longitude | Longitude coordinates of the occurrence location |
| ocorrencia_cidade | City where the occurrence took place |
| ocorrencia_uf | State or province where the occurrence occurred |
| ocorrencia_pais | Country where the occurrence took place |
| ocorrencia_aerodromo | Aerodrome (airport) code or identifier |
| ocorrencia_dia | Date of the occurrence (day) |
| ocorrencia_hora | Time of the occurrence (hour and minute) |
| investigacao_aeronave_liberada | Indicates if the aircraft was released for investigation |
| investigacao_status | Status of the investigation |
| divulgacao_relatorio_numero | Report number of the released investigation |
| divulgacao_relatorio_publicado | Indicates if the investigation report was published or released |
| divulgacao_dia_publicacao | Date of publication of the investigation report (day) |
| total_recomendacoes | Total number of recommendations resulting from the investigation |
| total_aeronaves_envolvidas | Total number of aircraft involved in the occurrence |
| ocorrencia_saida_pista | Indicates if the occurrence involved an aircraft runway excursion |
| ocorrencia_tipo | Type of the occurrence |
| ocorrencia_tipo_categoria | Category of the occurrence type |
| taxonomia_tipo_icao | ICAO (International Civil Aviation Organization) type taxonomy |
| recomendacao_numero | Recommendation number resulting from the investigation |
| recomendacao_dia_assinatura | Date when the recommendation was signed (day) |
| recomendacao_dia_encaminhamento | Date when the recommendation was forwarded (day) |
| recomendacao_dia_feedback | Date of feedback regarding the recommendation (day) |
| recomendacao_conteudo | Content or details of the recommendation |
| recomendacao_status | Status of the recommendation (e.g., Open, Closed) |
| recomendacao_destinatario_sigla | Abbreviation of the recommendation recipient |
| recomendacao_destinatario | Recipient of the recommendation |
| aeronave_matricula | Aircraft registration number |
| aeronave_tipo_veiculo | Type of aircraft (e.g., airplane, helicopter) |
| aeronave_fabricante | Manufacturer of the aircraft |
| aeronave_modelo | Model or type of the aircraft |
| aeronave_tipo_icao | ICAO aircraft type classification |
| aeronave_motor_tipo | Type of aircraft engines |
| aeronave_motor_quantidade | Number of aircraft engines |
| aeronave_pmd | Maximum takeoff weight of the aircraft |
| aeronave_pmd_categoria | Category of maximum takeoff weight |
| aeronave_assentos | Number of passenger seats in the aircraft |
| aeronave_ano_fabricacao | Year of aircraft manufacture |
| aeronave_pais_fabricante | Country where the aircraft was manufactured |
| aeronave_pais_registro | Country where the aircraft is registered |
| aeronave_registro_categoria | Category of aircraft registration |
| aeronave_registro_segmento | Segment of aviation for which the aircraft is registered |
| aeronave_voo_origem | Origin airport or location of the flight |
| aeronave_voo_destino | Destination airport or location of the flight |
| aeronave_fase_operacao | Phase of flight or operation of the aircraft |
| aeronave_tipo_operacao | Type of flight operation (e.g., commercial, private) |
| aeronave_nivel_dano | Level of damage sustained by the aircraft |
| aeronave_fatalidades_total | Total number of fatalities in the aircraft |
| fator_nome | Name of the factor contributing to the occurrence |
| fator_aspecto | Aspect or characteristic of the contributing factor |
| fator_condicionante | Condition or circumstance related to the factor contributing to the occurrence |
| fator_area | Area or domain to which the contributing factor is related |
src-files table relationship
Tables
Brazil Total Aeronautical Occurrences 2010–2021
@kaggle.liamarguedas_brazil_total_aeronautical_occurrences_2010_2021.brazil_total_aeronautical_occurrences_2010_2021
- 362.89 kB
- 7,567 rows
- 53 columns
Loading...
Loading...
CREATE TABLE brazil_total_aeronautical_occurrences_2010_2021 (
"ocorrencia_classificacao" VARCHAR,
"ocorrencia_latitude" VARCHAR,
"ocorrencia_longitude" VARCHAR,
"ocorrencia_cidade" VARCHAR,
"ocorrencia_uf" VARCHAR,
"ocorrencia_pais" VARCHAR,
"ocorrencia_aerodromo" VARCHAR,
"ocorrencia_dia" TIMESTAMP,
"ocorrencia_hora" VARCHAR,
"investigacao_aeronave_liberada" VARCHAR,
"investigacao_status" VARCHAR,
"divulgacao_relatorio_numero" VARCHAR,
"divulgacao_relatorio_publicado" VARCHAR,
"divulgacao_dia_publicacao" TIMESTAMP,
"total_recomendacoes" BIGINT,
"total_aeronaves_envolvidas" BIGINT,
"ocorrencia_saida_pista" VARCHAR,
"ocorrencia_tipo" VARCHAR,
"ocorrencia_tipo_categoria" VARCHAR,
"taxonomia_tipo_icao" VARCHAR,
"recomendacao_numero" VARCHAR,
"recomendacao_dia_assinatura" TIMESTAMP,
"recomendacao_dia_encaminhamento" TIMESTAMP,
"recomendacao_dia_feedback" VARCHAR,
"recomendacao_conteudo" VARCHAR,
"recomendacao_status" VARCHAR,
"recomendacao_destinatario_sigla" VARCHAR,
"recomendacao_destinatario" VARCHAR,
"aeronave_matricula" VARCHAR,
"aeronave_tipo_veiculo" VARCHAR,
"aeronave_fabricante" VARCHAR,
"aeronave_modelo" VARCHAR,
"aeronave_tipo_icao" VARCHAR,
"aeronave_motor_tipo" VARCHAR,
"aeronave_motor_quantidade" VARCHAR,
"aeronave_pmd" BIGINT,
"aeronave_pmd_categoria" BIGINT,
"aeronave_assentos" DOUBLE,
"aeronave_ano_fabricacao" DOUBLE,
"aeronave_pais_fabricante" VARCHAR,
"aeronave_pais_registro" VARCHAR,
"aeronave_registro_categoria" VARCHAR,
"aeronave_registro_segmento" VARCHAR,
"aeronave_voo_origem" VARCHAR,
"aeronave_voo_destino" VARCHAR,
"aeronave_fase_operacao" VARCHAR,
"aeronave_tipo_operacao" VARCHAR,
"aeronave_nivel_dano" VARCHAR,
"aeronave_fatalidades_total" BIGINT,
"fator_nome" VARCHAR,
"fator_aspecto" VARCHAR,
"fator_condicionante" VARCHAR,
"fator_area" VARCHAR
);