The relational database is logically grouped into ten subject areas, roughly corresponding to the data sources. The data is continually updated as new data becomes available. The tables are generally implemented as supplied from the data sources with additional normalization. Referential constraints are enforced to insure data consistency and indexes are defined to enforce unique constraints and to improve performance. The database is implemented using a Postgres engine, version 8.0.2.
Very efficient, high speed keyword searches of Accident narratives is provided using a customized Key Word table.
Currently the database contains over 50 GB of data, 180 tables, 190 indexes, and over 140 million rows.
Every effort is made to insure the data is correct, but there is no guarantee regarding accuracy or timeliness. In no event should this data be used for flight operations.
Detailed table and column information, including schema modifications made by AviationDB is available. Unless otherwise indicated, the documents supplied by the data source (see below) should be used for more information.
The table below lists the names of the government agencies that provide the data, the URL where the source data can be found, the URL where documentation can be found, and the published update frequency for each subject area.
