NTSB investigations, 1978, OR

19 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1978, OR per year, 1964–2026: 1,009 cases
196423
196528
196639
196753
196837
196918
197023
197118
197215
197326
197421
197520
197624
197722
197819
197932
198023
198120
198222
198313
198410
198517
19869
19877
19887
198911
199016
199110
199211
19938
199412
199515
199618
19977
199812
199911
200022
200116
200215
200313
200410
200513
20068
200714
200819
20099
201012
201113
201214
201312
20148
20159
201612
201710
201819
20199
20207
202112
202213
20236
202414
20259
202614

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\") = 1978
    AND c.\"eventStateOrRegion\" = 'OR' 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 SEA79FYM07Accident · Serious injuriesClosedCessna 414 · Baker, ORDec 11, 1978 · N41075 · Substantial damageNTSB SEA79DYM05Accident · No injuriesClosedCessna 172 · Portland, ORNov 1, 1978 · N737BZ · Substantial damageNTSB SEA79DYM03Accident · No injuriesClosedCessna 180 · Sumpter, OROct 22, 1978 · N6571A · Substantial damageNTSB SEA78FYM52Accident · Minor injuriesClosedPiper PA-28 · Hillsboro, ORSep 30, 1978 · N5795F · Substantial damageNTSB SEA78DYK25Accident · Minor injuriesClosedPiper PA-31 · Sun River, ORSep 30, 1978 · N27279 · Substantial damageNTSB SEA78FYM46Accident · No injuriesClosedCessna R182 · Troutdale, ORAug 3, 1978 · N4105C · Substantial damageNTSB SEA78DYK20Accident · No injuriesClosedBeech 35 · Crescent Lake, ORJul 15, 1978 · N3943N · Substantial damageNTSB SEA78FYM45Accident · No injuriesClosedStinson 108-3 · The Dalles, ORJul 9, 1978 · N4050C · Substantial damageNTSB SEA78FYM42Accident · Serious injuriesClosedBellanca 17-30 · Toledo, ORJul 6, 1978 · N8814V · Substantial damageNTSB SEA78FYM38Accident · No injuriesClosedPiper PA-22 · Newberg, ORJun 17, 1978 · N3651P · Substantial damageNTSB SEA78DYM35Accident · No injuriesClosedCessna 210 · Waldport, ORMay 23, 1978 · N29176 · Substantial damageNTSB SEA78DYM34Accident · No injuriesClosedPiper PA-30B · Madras, ORMay 20, 1978 · N7068Y · Substantial damageNTSB SEA78DYM30Accident · No injuriesClosedCessna 182 · Enterprise, ORMay 8, 1978 · N71354 · Substantial damageNTSB SEA78FYA06Accident · Minor injuriesClosedCessna 172 · Ontario, ORMay 2, 1978 · N73347 · Substantial damageNTSB SEA78DYK14Accident · No injuriesClosedCessna 172 · Medford, ORApr 16, 1978 · N2434Y · Substantial damageNTSB SEA78FYM25Accident · No injuriesClosedBell 47G · Kings Valley, ORApr 15, 1978 · N2919W · Substantial damageNTSB SEA78FYM24Accident · Minor injuriesClosedCessna 180 · Estacada, ORApr 8, 1978 · N4623B · Substantial damageNTSB SEA78DYM22Accident · No injuriesClosedCessna 305A · Troutdale, ORMar 17, 1978 · N5236G · Substantial damageNTSB SEA78DYK10Accident · No injuriesClosedAlon A-2 · Christmas Vly, ORFeb 11, 1978 · N6523Q · Substantial damage