Dropped variable
|
190
|
PD
|
acft_ctl_class_c_flag
|
Missing, Yes, No values
|
dropped variable
|
|
191
|
|
|
|
|
|
192
|
PD
|
acft_ctl_class_d_flag
|
Missing, Yes, No values
|
Dropped variable
|
|
193
|
PD
|
acft_ctl_class_e_flag
|
Missing, Yes, No values
|
Dropped variable
|
|
194
|
PD
|
acft_ctl_class_g_flag
|
Missing, Yes, No values
|
Dropped variable
|
|
195
|
PD
|
acft_ctl_otr_desc
|
Missing Values
|
6418 missing. All filled in values correspond to a value of Y for the acft_ctl_otr_flag
|
|
196
|
PD
|
acft_ctl_otr_flag
|
Missing, Yes, No values
|
6245 missing.
|
Treat missing as N.
|
197
|
PD
|
acft_ctl_trsa_flag
|
Missing, Yes, No values
|
6222 misisng
|
Treat missing as N.
|
198
|
PD
|
acft_ctl_twr_flag
|
Missing, Yes, No values
|
5325 missing
|
Treat missing as N.
|
199
|
PD
|
acft_ctl_unk_flag
|
Missing, Yes, No values
|
6258 missing.
|
drop variable
|
200
|
PD
|
ACFT_FIRST_FLT_CODE
|
In ATQA, not in dataset
|
Tracks "first flight of day for pilot". Not in current dataset
|
|
201
|
PD
|
acft_mkmd_make_desc
|
Inconsistant Entries
|
Used in forming aircraft groupings. Keeping issue open til groups are completed
|
|
202
|
PD
|
acft_mkmd_model_desc
|
Inconsistant Entries
|
Used in forming aircraft groupings. Keeping issue open til groups are completed
|
|
203
|
PD
|
acft_phase_apch_flag
|
Y,N, Missing
|
dropped variable
|
|
204
|
PD
|
acft_phase_cmb_flag
|
Y,N, Missing
|
dropped variable
|
|
205
|
PD
|
acft_phase_crz_flag
|
Y,N, Missing
|
dropped variable
|
|
206
|
PD
|
acft_phase_dscnt_flag
|
Y,N, Missing
|
Dropped Variable
|
|
207
|
PD
|
acft_phase_lndg_flag
|
Y,N, Missing
|
Dropped Variable
|
|
208
|
PD
|
acft_phase_otr_desc
|
Missing values
|
193 non-missing values. Appear to correspond to Y on the flag variable. However, numbers differ indicating some Y have no description
|
|
209
|
PD
|
acft_phase_otr_flag
|
Y,N, Missing
|
194 Y, 4174 missing, 2066 N
|
|
210
|
PD
|
acft_phase_unkn_flag
|
Y,N, Missing
|
Dropped variable. use phase of flight instead
|
|
211
|
PD
|
acft_rule_flt_code
|
UNK and missing
|
Recoded DVFR and SVFR into VFR and converted variable to numeric
|
|
212
|
PD
|
acft_sua_desc
|
Missing Values
|
6432 missing. All non-missing values correspond to a Y value for acft_ctl_sua_flag
|
|
213
|
PD
|
acft_sua_flag
|
Missing, Yes, No values
|
6259 missing
|
|
214
|
PD
|
acft_tcas_code_
|
UNK and missing
|
271 TCUNKN, 6088 missing
|
|
215
|
PD
|
acft_tcas_invlvd_desc_
|
no entries
|
All missing
|
|
216
|
PD
|
acft_transpndr_code
|
UNK and missing
|
177 UNK, 6085 missing
|
|
217
|
PD
|
acft_type_code
|
missing
|
751 missing. Unclear how to treat missings
|
|
218
|
PD
|
acft_type_otr_desc
|
Missing
|
Non missing entires appear to correspond to OTR in the type code
|
|
219
|
PD
|
clnc_hrzntl_ft_qty
|
Missing
|
Only 5 non-missing entries. Likely not relevant varaible
|
|
220
|
PD
|
clnc_hrzntl_unkn_flag
|
Y,N,Missing
|
26 Y, 6304 Missing, 104 N. Not relevant, but seems inconsistant with missings in clnc_hrzntl_ft_qty
|
|
221
|
PD
|
clnc_no_flag
|
Y,N,Missing
|
192 Y, 6218 Missing, 24 N. Likely not relevant
|
|
222
|
PD
|
clnc_slant_ft_qty
|
Missing. Not in ATQA data dictionary
|
1 non-missing value. No description in data dictionary
|
|
223
|
PD
|
clnc_ver_ft_qty
|
Missing
|
9 non-missing values. Likely not relevant
|
|
224
|
PD
|
clnc_ver_unkn_flag_pd
|
Y,N,Missing
|
32 Y, 6301 Missing, 101 N
|
|
225
|
PD
|
dev_air_airspd_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N"
|
|
226
|
PD
|
dev_air_asp_flag
|
Many Missings
|
what do missing values indicate different from "Y" or "N"
|
|
227
|
PD
|
dev_air_atc_alt_clnc_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N"
|
|
228
|
PD
|
dev_air_atc_crs_clnc_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N"
|
|
229
|
PD
|
dev_air_carlss_flag
|
Many Missings
|
what do missing values indicate different from "Y" or "N"
|
|
230
|
PD
|
dev_air_far_otr_flag
|
Many Missings
|
what do missing values indicate different from "Y" or "N". 6291 missing
|
|
231
|
PD
|
dev_air_miss_rprt_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N". 6299 missing
|
|
232
|
PD
|
dev_air_plt_unqlfy_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N". 6298 missing
|
|
233
|
PD
|
dev_air_too_low_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N". 6301 missing
|
|
234
|
PD
|
dev_air_vfr_ifr_rqrd_flag_pd
|
Many Missings
|
what do missing values indicate different from "Y" or "N". 6297 missing
|
|
235
|
PD
|
dev_asp_viol_arsa_name
|
only one value, rest missing
|
Not in ATQA data dictionary either
|
|
236
|
PD
|
dev_asp_viol_code
|
Many Missings
|
6,091 missings. 50 values of "NONE", 35 "UNK"
|
|
237
|
PD
|
dev_asp_viol_sua_desc
|
inconsistent
|
4 entires are non-missing. Only 2 of dev_asp_viol_code have an entry of SUA
|
|
238
|
PD
|
dev_asp_viol_tca_name
|
all missing
|
All entries are missing
|
|
239
|
PD
|
dev_sfc_carlss_flag
|
Many Missings
|
4,306 missing. 2,052 N, 76 Y
|
Treat missing as N.
|
240
|
PD
|
dev_sfc_enter_flag
|
Many Missings
|
1,543 missing; Y and N values
|
Treat missing as N.
|
241
|
PD
|
dev_sfc_fltpln_flag
|
Many Missings
|
4,340 missing; Y and N values. Only N and missing on relevant set
|
|
242
|
PD
|
dev_sfc_lndg_clnc_flag
|
Many Missings
|
4,031 missing; Y and N values
|
Treat missing as N.
|
243
|
PD
|
dev_sfc_lndg_flag
|
Many Missings
|
3,967 missing, does not seem to match up with Clearance flag. Presumably you can't land on the wrong runway but have clearance for landing on that runway
|
|
244
|
PD
|
dev_sfc_otr_desc
|
Many Missings
|
Parsed variable for other common answers and created flags for : crossed hold short line and landed on closed runway
|
|
245
|
PD
|
dev_sfc_otr_flag
|
Many Missings
|
4018 missings. See dev_sfc_otr_desc
|
Treat missing as N.
|
246
|
PD
|
dev_sfc_tkof_clnc_flag
|
Many missings
|
3,851 missing; Y and N values
|
|
247
|
PD
|
dev_sfc_tkof_rwy_twy_flag
|
Many missings
|
4,209 missing; Y and N values
|
|
248
|
PD
|
dev_sfc_wx_minm_flag
|
Many missings
|
4,332; Y and N values
|
|
249
|
PD
|
dev_type_air_flag
|
Many missings
|
Does not appear to be mutually exclusive with dev_type_sfc. Spot checking a couple of events indicates they are runway incursions.
|
|
250
|
PD
|
dev_type_sfc_flag
|
Overlap with dev_type_air_flag
|
no missings, 367 are yes on this and dev_type_air_flag. All observations in dataset are Y on this variable
|
|
251
|
PD
|
ev_air_far_occ1_nbr
|
Many Missings
|
6,413 missing, only 21 filled out
|
|
252
|
PD
|
ev_air_far_occ2_nbr
|
Many Missings
|
6,424 missing, only 10 filled out
|
|
253
|
PD
|
event_detect_dev_code
|
Missings
|
321 missing
|
|
254
|
PD
|
event_detect_dev_otr_desc
|
Other without description
|
1 entry for event_detect_dev_code of other with missing value for description
|
|
255
|
PD
|
event_lcl_time
|
Missings
|
92 missing values. All other appear in 0-2359 range
|
|
256
|
PD
|
event_ri_flag
|
Missings
|
1,816 missing. How reliable is this flag?
|
|
257
|
PD
|
event_utc_time
|
Missings
|
92 missing values. All other appear in 0-2359 range. 91 coincide with missing local time. 1 entry has missing lcl, but filled in UTC. Another 1 entry has UTC filled in, but lcl missing
|
|
258
|
PD
|
fac_atc_none_flag
|
Y,N,Missing
|
42 Y, 6241 missing, 151 N
|
|
259
|
PD
|
fac_atc_otr_flag
|
Y,N,Missing
|
6 Y, 6258 Missing, 170 N. Yes corresponds to relevant entry in description field
|
|
260
|
PD
|
fac_atc_unkn_flag
|
Y,N,Missing
|
40 Y, 6258 Missing, 136 N
|
|
261
|
PD
|
fac_rprt_fsdo_id_nbr
|
Missing
|
1349 Missing. Likely not useful
|
|
262
|
PD
|
fac_rprt_loc_id_code
|
Missing
|
221 Missing
|
|
263
|
PD
|
fact_equip_com_flag
|