NTSB investigations, 1981, LA

20 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 1981, LA per year, 1963–2026: 714 cases
19632
196436
196531
196640
196733
196834
196923
197023
197113
197221
197321
197417
197525
197621
197736
197827
197924
198029
198120
198215
198317
198412
198510
19868
19877
19884
19898
19904
19916
19925
19938
19941
19954
19964
19973
19983
19995
20005
20015
20025
20031
20046
20053
20063
20072
20081
20091
20104
20119
201210
20132
20141
20157
20165
20172
20185
20194
20205
20214
20233
202414
20255
20262

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\" = 'LA' 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 FTW82DRD04Accident · No injuriesClosedStinson 108-3 · Thibodaux, LANov 8, 1981 · N923C · Substantial damageNTSB FTW82DRJ02Accident · Minor injuriesClosedCessna 182 · Farmerville, LAOct 16, 1981 · N759SR · Substantial damageNTSB FTW82DRD02Accident · No injuriesClosedCessna A185F · Patterson, LAOct 16, 1981 · N5513E · Substantial damageNTSB FTW81DRD50Accident · No injuriesClosedCessna A185F · Leeville, LASep 28, 1981 · N33CT · Substantial damageNTSB FTW81DRD48Accident · No injuriesClosedTom Cat 47-MK6 · Ramah, LASep 19, 1981 · N9098T · Substantial damageNTSB FTW81DRD47Accident · No injuriesClosedGrum Amer AA-5A · Opelousas, LASep 19, 1981 · N9811U · Substantial damageNTSB FTW81DRD49Accident · No injuriesClosedCessna 185 · Grand Isle, LASep 16, 1981 · N53064 · Substantial damageNTSB FTW81DRD46Accident · Minor injuriesClosedCessna A185F · Intracstl Cy, LASep 15, 1981 · N767RC · DestroyedNTSB FTW81DRJ35Accident · No injuriesClosedBeech D18S · Simsboro, LASep 12, 1981 · N123J · Substantial damageNTSB FTW81DRD43Accident · No injuriesClosedCessna A185F · Morgan City, LASep 5, 1981 · N95DM · Substantial damageNTSB FTW81DRD37Accident · No injuriesClosedCessna 180J · Dulac, LAAug 18, 1981 · N42025 · Substantial damageNTSB FTW81DRJ27Accident · No injuriesClosedAir Tractor AT-301 · Monroe, LAJul 28, 1981 · N4407S · Substantial damageNTSB FTW81DRJ25Accident · No injuriesClosedRockwell S2R · Boyce, LAJul 24, 1981 · N4866X · DestroyedNTSB FTW81DRJ23Accident · No injuriesClosedGrumman G-164B · Hebert, LAJul 22, 1981 · N6793Q · Substantial damageNTSB FTW81DRJ20Accident · No injuriesClosedPiper PA-24 · Many, LAJun 24, 1981 · N8136P · Substantial damageNTSB FTW81DRD25Accident · No injuriesClosedCessna 185F · Westwego, LAMay 21, 1981 · N61741 · Substantial damageNTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LAApr 23, 1981 · N8985L · Substantial damageNTSB FTW81DRD17Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAApr 3, 1981 · N6787Q · Substantial damageNTSB FTW81DRD13Accident · No injuriesClosedCessna 180H · Belle Chase, LAMar 11, 1981 · N9739G · Substantial damageNTSB FTW81DA025Accident · No injuriesClosedBell 222 · Patterson, LAJan 21, 1981 · N5754B · Substantial damage