NTSB investigations, 1981, GA

27 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1981, GA per year, 1962–2026: 1,134 cases
19621
19631
196430
196542
196652
196762
196831
196938
197032
197147
197245
197328
197441
197517
197635
197720
197836
197920
198026
198127
198217
198318
198413
198517
19867
198716
19888
19898
199011
19919
19924
19938
19948
19958
199610
199711
199816
19998
20005
20018
200213
200312
200415
200511
200610
200717
200818
200913
201017
20119
20127
20139
20147
201511
201613
201714
201812
201911
202011
202112
202211
202312
202413
20258
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\" = 'GA' 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 ATL82FKG07Accident · No injuriesClosedGrumm Amer AA-5B · Blue Ridge, GANov 8, 1981 · N1508R · Substantial damageNTSB ATL82FKG04Accident · No injuriesClosedPiper PA-28 · Swainsboro, GAOct 29, 1981 · N702FL · DestroyedNTSB ATL82FKG02Accident · No injuriesClosedPiper PA-28 · Stone Mountain, GAOct 16, 1981 · N15101 · Substantial damageNTSB ATL81DLA15Accident · No injuriesClosedGrumman G-164B · Pelham, GASep 26, 1981 · N6670K · Substantial damageNTSB ATL81FKG47Accident · No injuriesClosedChampion 7AC · Stone Mountain, GASep 13, 1981 · N3118E · Substantial damageNTSB ATL81DKG48Accident · No injuriesClosedPiper PA-18 · Williamson, GASep 12, 1981 · N4083Z · Substantial damageNTSB ATL81DKG45Accident · No injuriesClosedBeech 58 · Savannah, GAAug 31, 1981 · N124P · Substantial damageNTSB ATL81FKG39Accident · No injuriesClosedPiper PA-36 · Kildare, GAJul 29, 1981 · N57865 · Substantial damageNTSB ATL81FKG35Accident · No injuriesClosedCessna 172G · Louisville, GAJul 26, 1981 · N65WB · Substantial damageNTSB ATL81FKG33Accident · No injuriesClosedCessna 182 · Abbeville, GAJul 18, 1981 · N7379Q · Substantial damageNTSB ATL81FLA09Accident · No injuriesClosedMooney M20C · Thomasville, GAJul 17, 1981 · N5832Q · Substantial damageNTSB ATL81DKG34Accident · Minor injuriesClosedCessna 140 · Dahlonega, GAJul 17, 1981 · N72966 · DestroyedNTSB ATL81DKG32Accident · Serious injuriesClosedPiper PA-22 · Griffin, GAJul 14, 1981 · N3919P · Substantial damageNTSB ATL81FKG28Accident · No injuriesClosedPiper PA-18 · Carrollton, GAJun 20, 1981 · N5589J · Substantial damageNTSB ATL81FKG26Accident · No injuriesClosedPiper PA-28 · Reynolds, GAJun 14, 1981 · N7309F · DestroyedNTSB ATL81DKG23Accident · No injuriesClosedCessna A188B · Albany, GAJun 11, 1981 · N9822G · Substantial damageNTSB ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GAMay 29, 1981 · N76ES · Substantial damageNTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GAMay 21, 1981 · N5714E · DestroyedNTSB ATL81DLA06Accident · No injuriesClosedCessna 150G · Waycross, GAMay 1, 1981 · N2994J · Substantial damageNTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GAApr 24, 1981 · N3572R · Substantial damageNTSB ATL81DLA05Accident · No injuriesClosedPiper PA-28 · Brunswick, GAApr 20, 1981 · N7993W · Substantial damageNTSB ATL81FKG13Accident · No injuriesClosedBeech H18 · Atlanta, GAApr 17, 1981 · N7998K · Substantial damageNTSB ATL81FKG12Accident · Minor injuriesClosedPiper PA-28 · Dalton, GAApr 10, 1981 · N9431J · Substantial damageNTSB ATL81FKG11Accident · No injuriesClosedBeech E55 · Atlanta, GAMar 18, 1981 · N7237R · Substantial damageNTSB ATL81FLA02Accident · Minor injuriesClosedHughes 269B · Valdosta, GAMar 1, 1981 · N9557F · Substantial damageNTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GAFeb 23, 1981 · N15X · Substantial damageNTSB ATL81FKG09Accident · No injuriesClosedCessna 182L · Statesboro, GAFeb 19, 1981 · N3149R · Substantial damage