Dataset: Brazil: Total Aeronautical Occurrences 2010 - 2021

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:

https://painelsipaer.cenipa.fab.mil.br/QvAJAXZfc/opendoc.htm?document=SIGAER%2Fgia%2Fqvw%2Fpainel_sipaer.qvw&host=QVS%40cirros31-37&anonymous=true

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

354.39 KB
7567 rows
53 columns


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
);