Accidents & Incidents¶

Introduction¶

Downloadable data sets of aviation accident data are available for public use. Data sets for 1962 through 1981 (see the PRE1982.zip file) and from 1982 to the present (see the avall.zip file) are available for download. Coding manuals, data definitions, and other metadata for different generations of the census are also available for download.

Data Source Characteristics¶

Data files:
- avall.zip
- Pre2008.zip
- up99MMM.zip
Format: zip / MS Access
Size: about 150 MB
Update frequency: on the 1st, 8th, 15th and 22nd of each month
URL: Accident Data
Website hints: see

Data Target Characteristics¶

Database management system: PostgreSQL
Database name: io_avstats_db
Database tables:
- aircraft
- dt_aircraft
- dt_events
- dt_flight_crew
- engines
- events
- events_sequence
- findings
- flight_crew
- flight_time
- injury
- narratives
- ntsb_admin
- occurrences
- seq_of_events

Data Processing¶

Repository: io-avstats
Script: run_io_avstats_dev
Tasks:
- l_n_a (Load NTSB MS Access database data into PostgreSQL)
- u_p_d (Complete processing of a modifying MS Access file)

Processing Steps:¶

The selected ZIP file is downloaded; avall.zip, Pre2008.zip or upd99MMM.zip.
The downloaded file is unzipped.
The unzipped MS Access files are loaded into the PostgreSQL database.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:¶

database_commit_size = 10000
download_timeout = 10
download_url_ntsb_prefix = "https://data.ntsb.gov/avdata/FileDirectory/DownloadFile?fileID=C%3A%5Cavdata%5C"
download_work_dir = "data/download"
razorsql_jar_file_windows = "C:\\Program Files\\RazorSQL\\razorsql.jar"
razorsql_java_path_windows = "C:\\Program Files\\RazorSQL\\jre11\\bin\\java"
razorsql_profile = "IO-AVSTATS"
razorsql_reference_dir = "data/RazorSQL"
razorsql_reference_file = "2024.01.22_avall.sql"

Contact Information¶

Email: data@ntsb.gov