NTSB investigations, 1981, AR

20 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1981, AR per year, 1964–2026: 819 cases
196432
196528
196630
196741
196832
196926
197025
197134
197217
197324
197422
197528
197630
197718
197830
197925
198017
198120
198215
198310
198419
19859
198615
19877
198814
19898
199016
199112
199212
199310
19948
199510
199612
19973
199810
199913
20008
20013
20026
20035
20048
20056
20064
20074
20085
20095
20106
20115
201210
20138
20141
20152
20167
20173
20186
20193
20202
20211
202210
20235
20242
20255
20267

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 1981
    AND c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB FTW81IA027Incident · No injuriesClosedBeech A36 · Fayetteville, ARNov 30, 1981 · N66861 · Minor damageNTSB FTW82DPG04Accident · No injuriesClosedCessna 182G · Hughes, ARNov 18, 1981 · N3114S · Substantial damageNTSB FTW81DPG64Accident · No injuriesClosedCessna A188B · Gin City, ARSep 7, 1981 · N731VD · Substantial damageNTSB FTW81FPG63Accident · No injuriesClosedBeech C24R · Searcy, ARSep 3, 1981 · N6014L · Substantial damageNTSB FTW81DPG58Accident · No injuriesClosedGrumman G-164A · Piggott, ARAug 3, 1981 · N8370 · Substantial damageNTSB FTW81FPG56Accident · No injuriesClosedCessna 421C · Little Rock, ARJul 31, 1981 · N98777 · Substantial damageNTSB FTW81DPG44Accident · No injuriesClosedCessna 182RG · Springdale, ARJun 10, 1981 · N756CZ · Substantial damageNTSB FTW81DPG41Accident · No injuriesClosedCessna 172RG · Grady, ARJun 8, 1981 · N9568B · Substantial damageNTSB FTW81FPG39Accident · No injuriesClosedPiper PA-24 · Stuttgart, ARJun 7, 1981 · N5745P · Substantial damageNTSB FTW81DPG30Accident · No injuriesClosedGrumman G-164A · Hughes, ARMay 29, 1981 · N8911H · Substantial damageNTSB FTW81FPG32Accident · No injuriesClosedBeech 77 · Carlisle, ARMay 20, 1981 · N60430 · DestroyedNTSB FTW81DPG26Accident · No injuriesClosedBeech B58 · Benton, ARMay 13, 1981 · N6745M · Substantial damageNTSB FTW81FPG23Accident · No injuriesClosedCessna 182RG · Hickory Ridge, ARMay 3, 1981 · N4760S · Substantial damageNTSB FTW81DPG22Accident · No injuriesClosedGrumman G-164B · Coy, ARApr 29, 1981 · N8148K · Substantial damageNTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARApr 29, 1981 · N50494 · Substantial damageNTSB FTW81DPG18Accident · No injuriesClosedBeech C55 · El Dorado, ARApr 17, 1981 · N44W · Substantial damageNTSB FTW81DRG16Accident · Serious injuriesClosedCessna 210 · Lakeview, ARApr 3, 1981 · N8146G · Substantial damageNTSB FTW81DPG15Accident · No injuriesClosedCessna 401 · Jonesboro, ARMar 23, 1981 · N8434F · Substantial damageNTSB FTW81DPG11Accident · No injuriesClosedPiper PA-31 · Mountain Home, ARMar 1, 1981 · N7579L · Substantial damageNTSB FTW81DPG09Accident · Minor injuriesClosedCessna 172H · Fordyce, ARJan 29, 1981 · N1442F · Substantial damage