NTSB investigations, 1981, PA

31 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 1981, PA per year, 1963–2026: 1,482 cases
19631
196474
196575
196684
196798
196853
196960
197054
197153
197235
197347
197454
197555
197640
197742
197849
197932
198034
198131
198225
198318
198425
198523
198617
198711
19888
198914
199016
199110
199213
199317
19948
199512
199610
199711
19989
199911
200012
20018
200211
20039
200414
20056
200611
200714
200811
200913
20104
20118
20125
201310
201410
201511
201610
20179
201811
20198
20209
202112
202213
20232
20248
20259
20265

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\" = 'PA' 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 NYC82DHA05Accident · No injuriesClosedMooney M20K · Kutztown, PADec 13, 1981 · N231RK · 2 aircraft · Minor damageNTSB NYC82FGM07Accident · No injuriesClosedCessna 340 · West Mifflin, PADec 11, 1981 · N7632Q · Substantial damageNTSB NYC82FGM04Accident · No injuriesClosedCessna 150 · Wattsburg, PANov 8, 1981 · N1945Z · Substantial damageNTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PAOct 24, 1981 · N2979H · Substantial damageNTSB NYC82FGM03Accident · No injuriesClosedBellanca 17-30A · Seven Springs, PAOct 15, 1981 · N93647 · DestroyedNTSB NYC82FGT02Accident · No injuriesClosedCessna 150K · Pottsville, PAOct 5, 1981 · N6385G · Substantial damageNTSB NYC82FGT01Accident · Serious injuriesClosedAeronca 7BCM · York, PAOct 4, 1981 · N9329H · DestroyedNTSB NYC81DHA24Accident · No injuriesClosedVeriviggen 1 · Reading, PASep 30, 1981 · N277LN · Substantial damageNTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PASep 21, 1981 · N8969L · Substantial damageNTSB NYC81FGM32Accident · No injuriesClosedCessna 310P · Pittsburgh, PASep 20, 1981 · CF-KBC · Substantial damageNTSB NYC81FGM31Accident · No injuriesClosedCessna 150J · Belle Vernon, PASep 13, 1981 · N60365 · Substantial damageNTSB NYC81FGM26Accident · No injuriesClosedPiper J3C-65 · Mt Pleasant, PAAug 20, 1981 · N98472 · Substantial damageNTSB NYC81FGT09Accident · Minor injuriesClosedCessna 172P · Brogue, PAJul 14, 1981 · N51357 · Substantial damageNTSB NYC81FGT08Accident · Serious injuriesClosedTaylorcraft BC12-D · Hanover, PAJul 10, 1981 · N39222 · Substantial damageNTSB NYC81FGM22Accident · No injuriesClosedCessna 177B · West Mifflin, PAJul 2, 1981 · N35241 · Substantial damageNTSB NYC81FHD29Accident · No injuriesClosedCessna 152 · Philadelphia, PAJun 26, 1981 · N4910B · Substantial damageNTSB NYC81IA057Incident · No injuriesClosedShorts SD3-30 · Middletown, PAJun 11, 1981 · N331CA · No damageNTSB NYC81FGT03Accident · Minor injuriesClosedCessna 172 · Palmyra, PAMay 31, 1981 · N8422X · Substantial damageNTSB NYC82FHD25Accident · No injuriesClosedBeech 55 · West Chester, PAMay 23, 1981 · N322SP · Substantial damageNTSB NYC81FHD24Accident · No injuriesClosedEnstrom F-28A · New London, PAMay 17, 1981 · N9608 · Substantial damageNTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PAMay 8, 1981 · N250K · Substantial damageNTSB NYC81FHD21Accident · No injuriesClosedBeech B-35 · New London, PAMay 1, 1981 · N5253C · Substantial damageNTSB NYC81FGM19Accident · No injuriesClosedPiper PA-28 · Clearfield, PAApr 22, 1981 · N2695T · Substantial damageNTSB NYC81FHD19Accident · No injuriesClosedPiper PA-28 · West Chester, PAApr 16, 1981 · N8754E · Substantial damageNTSB NYC81FGM17Accident · No injuriesClosedBeech B19 · Bridgeville, PAApr 12, 1981 · N18888 · Substantial damageNTSB NYC81FGM15Accident · No injuriesClosedCessna 172E · Irwin, PAApr 7, 1981 · N5718T · Substantial damageNTSB NYC81FA037Accident · No injuriesClosedPiper J3 · Canton, PAApr 2, 1981 · N21609 · Substantial damageNTSB NYC81DHA07Accident · No injuriesClosedPiper PA-38 · Easton, PAMar 23, 1981 · N2535A · Substantial damageNTSB NYC81FGM13Accident · No injuriesClosedPitts S-1 · Somerset, PAMar 22, 1981 · N70JM · Substantial damageNTSB NYC81FGM12Accident · No injuriesClosedPiper PA-28R · Indiana, PAMar 15, 1981 · N4957J · Substantial damageNTSB NYC81IA019Incident · No injuriesClosedPiper PA-32 · Coatesville, PAJan 15, 1981 · N2147N · Minor damage