NTSB investigations, 1981, GA

21 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 1981, GA per year, 1963–2026: 865 cases
19631
19648
196518
196614
196722
196820
196924
197022
197131
197229
197315
197426
197518
197616
197730
197822
197922
198024
198121
198227
198312
198418
198518
198616
198712
198811
198912
199019
199116
199213
19936
19949
199511
199610
199716
199814
19997
200012
200117
200210
200317
20048
20058
200616
200718
20086
200911
20107
20118
20126
20138
20145
20155
20167
20175
20184
20196
20207
20219
202210
20237
202411
20253
20264

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\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 ATL82FKG08Accident · Minor injuriesClosedPiper PA-32 · Jefferson, GADec 10, 1981 · N4066W · Substantial damageNTSB ATL82FA017Accident · 1 fatalClosedPiper PA-28 · Savannah, GANov 14, 1981 · N8569E · Substantial damageNTSB ATL82FLA02Accident · No injuriesClosedMooney M20C · Folkston, GAOct 16, 1981 · N9244V · Substantial damageNTSB ATL82DA007Accident · No injuriesClosedCessna 340 · Waycross, GAOct 14, 1981 · N2701A · 2 aircraft · Minor damageNTSB ATL82FKG01Accident · Serious injuriesClosedHughes 369D · Savannah, GAOct 7, 1981 · N444HM · Substantial damageNTSB ATL81FA118Accident · Serious injuriesClosedHughes 369A · Atlanta, GASep 30, 1981 · N3766Z · Substantial damageNTSB ATL81FA112Accident · 3 fatalClosedCessna 172K · Philomath, GASep 4, 1981 · N758EQ · DestroyedNTSB ATL81FLA12Accident · No injuriesClosedCessna 404 · St Simons Is, GAAug 11, 1981 · N2684L · DestroyedNTSB ATL81DKG38Accident · No injuriesClosedCessna A188B · Pitts, GAAug 4, 1981 · N8900G · Substantial damageNTSB ATL81FA105Accident · 1 fatalClosedGrum Amer AA-5B · Baxley, GAAug 1, 1981 · N28401 · DestroyedNTSB ATL81FA093Accident · 1 fatalClosedCessna 411 · Columbus, GAJul 9, 1981 · N7007R · DestroyedNTSB ATL81FA092Accident · 3 fatalClosedPiper PA-28 · Eatonton, GAJul 8, 1981 · N6452J · 2 aircraft · DestroyedNTSB ATL81FA091Accident · Minor injuriesClosedCessna 150H · Toccoa, GAJul 7, 1981 · N22353 · DestroyedNTSB ATL81FKG30Accident · No injuriesClosedCessna 172N · Lexington, GAJul 6, 1981 · N2776E · Substantial damageNTSB ATL81FA089Accident · Minor injuriesClosedCessna 152 · Decatur, GAJul 6, 1981 · N67312 · DestroyedNTSB ATL81DLA07Accident · Minor injuriesClosedCessna 152 · Folkston, GAJun 16, 1981 · N89808 · DestroyedNTSB ATL81FKG17Accident · No injuriesClosedPiper PA-39 · Macon, GAApr 28, 1981 · N8959Y · Substantial damageNTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GAApr 23, 1981 · N53045 · Substantial damageNTSB ATL81DKG14Accident · No injuriesClosedCessna 150 · Oglethorpe, GAApr 18, 1981 · N6441T · DestroyedNTSB ATL81DLA04Accident · No injuriesClosedCessna 177 · Homerville, GAApr 17, 1981 · N2247Y · Substantial damageNTSB ATL81FA040Accident · 1 fatalClosedCessna 180K · Statesboro, GAFeb 1, 1981 · N2954K · Destroyed