DOI: 10.21949/1529865
title: Estimate the Rate of Failure to Disclose Medical Conditions on FAA Medical Certification Exams [supporting datasets]
title: Estimated Rate of Failure to Disclose Medical Conditions During FAA Aeromedical Exams

description: Existing FAA databases can be used to estimate the rate of discrepancies between medical conditions reported during medical certification exams and conditions identified on autopsy after fatal aircraft accidents involving the same pilot. This may serve as a surrogate measure for how fully pilots disclose their medical conditions during FAA medical certification exams. The Civil Aerospace Medical Institute (CAMI) Medical ANalysis TRAcking registry (MANTRA) is an application used to store autopsy and civilian aviator aeromedical records data from fatal aircraft mishaps and is hosted at CAMI in Oklahoma City. MANTRA data is entered as both free text, discrete ICD codes, and line item words (for medications). Toxicological findings from ToxFlo, which is the application used by the toxicology lab for sample analyses, are used in conjunction with autopsy findings and aviator aeromedical records in an effort to identify aeromedical hazards. It is possible to perform the analysis of the accuracy of a self-reported medical history by direct comparison of both the autopsy and toxicology reports with the pilot’s medical records for each accident. MANTRA and ToxFlo databases will be searched by ICD and CPT codes and medication name as markers for specific diseases. Cases with these findings will be identified, and the relevant pilot records will be reviewed retrospectively to determine whether they reported these conditions during their medical exams. The rate of failure to accurately report will be calculated for select medical conditions. 

The size of the zip file is 325 KB. The .csv, Comma Separated Value, file is a simple format that is designed for a database table and supported by many applications. The .csv file is often used for moving tabular data between two different computer programs, due to its open format. The most common software used to open .csv files are Microsoft Excel and RecordEditor, (for more information on .csv files and software, please visit https://www.file-extensions.org/csv-file-extension). The .xlsx and .xls file types are Microsoft Excel files, which can be opened with Excel, and other free available spreadsheet software, such as OpenRefine. The .txt file type is a common text file, which can be opened with a basic text editor. The most common software used to open .txt files are Microsoft Windows Notepad, Sublime Text, Atom, and TextEdit (for more information on .txt files and software, please visit https://www.file-extensions.org/txt-file-extension).  File extension .json is associated to JavaScript Object Notation file format, a lightweight, text-based, language-independent data interchange format. JSON defines a small set of formatting rules for the portable representation of structured data. It is used by various applications as alternative option to XML file format. The data in a json file are stored in simple text file format and the content is viewable in any simple text editor (for more information on .json files and software, please visit https://www.file-extensions.org/json-file-extension).