NTSB investigations, 1981, LA

18 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 1981, LA per year, 1964–2026: 585 cases
196417
196517
19669
196716
196828
196914
197011
197116
197212
197318
197418
197520
197621
197718
197818
197914
198010
198118
198215
19838
198414
19859
198611
198710
198812
19898
199012
19918
19922
19938
19949
19958
19968
19978
19985
19996
20006
200110
200211
20033
20046
20056
20062
20075
20085
20095
20101
20114
20122
201310
20146
20152
20164
20175
20183
20193
20202
20217
20224
20237
20241
20256
20263

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 = 450)
  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 FTW82DA023Accident · 1 fatalClosedPiper PA-28 · Garden City, LANov 28, 1981 · N1363T · DestroyedNTSB FTW82DRJ04Accident · Minor injuriesClosedGrumman G-164A · Elm Grove, LANov 4, 1981 · N8819H · Substantial damageNTSB FTW81FRD44Accident · Serious injuriesClosedCessna A188B · Port Barre, LASep 12, 1981 · N5632G · DestroyedNTSB FTW81DRJ34Accident · No injuriesClosedCallair A-5 · Cottonport, LASep 4, 1981 · N9991C · Substantial damageNTSB FTW81FRJ33Accident · No injuriesClosedCessna T188C · Monroe, LAAug 25, 1981 · N1997J · DestroyedNTSB FTW81FRJ31Accident · 1 fatalClosedCessna 188B · Winnsboro, LAAug 24, 1981 · N21685 · DestroyedNTSB FTW81DRJ29Accident · No injuriesClosedGrumman G-164 · Bastrop, LAAug 14, 1981 · N10292 · DestroyedNTSB FTW81DRJ28Accident · No injuriesClosedCessna A188B · Bastrop, LAAug 7, 1981 · N731BR · DestroyedNTSB FTW81DRD39Accident · No injuriesClosedGrumman G-164B · Mowata, LAAug 7, 1981 · N6510K · Substantial damageNTSB FTW81DRD36Accident · No injuriesClosedBoeing A75-N1 · Plaquemine, LAAug 1, 1981 · N55670 · Substantial damageNTSB FTW81FRJ26Accident · Serious injuriesClosedAeronca 7AC · Bastrop, LAJul 24, 1981 · N84865 · Substantial damageNTSB FTW81DRJ21Accident · No injuriesClosedGrumman G-164B · Shreveport, LAJul 14, 1981 · N6626Q · Substantial damageNTSB FTW81FA120Accident · 1 fatalClosedSoloy 47G-2A · Vivian, LAJul 10, 1981 · N166 · DestroyedNTSB FTW81FRD19Accident · 1 fatalClosedPitts S1C · Leroy, LAJun 11, 1981 · N70ST · DestroyedNTSB FTW81FRD28Accident · No injuriesClosedGrumman G-164A · Morse, LAJun 4, 1981 · N7699 · Substantial damageNTSB FTW81DRJ17Accident · No injuriesClosedAyers S2R · Jonesville, LAJun 2, 1981 · N8935Q · Substantial damageNTSB FTW81DRJ16Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 27, 1981 · N612U · DestroyedNTSB FTW81DRD22Accident · No injuriesClosedGrumman G-164B · Swords, LAApr 28, 1981 · N48592 · Substantial damage