NTSB investigations, 1968, OR

37 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1968, 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\") = 1968
    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 SEA69D0181Accident · No injuriesClosedHiller UH-12E · Brightwood, ORDec 21, 1968 · N3820 · Substantial damageNTSB SEA69D0177Accident · No injuriesClosedMooney M20E · Albany, ORDec 8, 1968 · N9336M · Substantial damageNTSB SEA69D0176Accident · No injuriesClosedCessna 150 · Chemult, ORDec 2, 1968 · N6915S · Substantial damageNTSB SEA69D0167Accident · No injuriesClosedPiper PA-22 · Cascade Locks, ORNov 9, 1968 · N4512A · Substantial damageNTSB SEA69F0163Accident · No injuriesClosedPiper PA-16 · Oregon City, OROct 27, 1968 · N6855K · Substantial damageNTSB SEA69D0160Accident · No injuriesClosedCessna 140 · Mulino, ORSep 27, 1968 · N2497N · Substantial damageNTSB SEA69F0131Accident · No injuriesClosedCessna 172G · Sublimity, ORSep 7, 1968 · N4121L · Substantial damageNTSB SEA69D0119Accident · No injuriesClosedCessna 120 · Waldport, ORAug 16, 1968 · N72560 · Substantial damageNTSB SEA69F0118Accident · No injuriesClosedPiper PA-28 · Winchestr By, ORAug 15, 1968 · N4472J · Substantial damageNTSB SEA69D0110Accident · Minor injuriesClosedPiper PA-22 · Reedsport, ORAug 7, 1968 · N4917Z · Substantial damageNTSB SEA69F0105Accident · Minor injuriesClosedStinson 108-1 · Ten Mile, ORJul 7, 1968 · N8510K · DestroyedNTSB SEA69F0051Accident · Minor injuriesClosedCessna 177 · Sweethome, ORJul 1, 1968 · N3172T · DestroyedNTSB SEA69D0068Accident · No injuriesClosedRepublic RC-3 · The Dalles, ORJun 30, 1968 · N6272K · Substantial damageNTSB SEA69D0028Accident · No injuriesClosedMooney M20C · Jefferson, ORJun 16, 1968 · N3487X · Substantial damageNTSB SEA69D0027Accident · No injuriesClosedBeech 35-B33 · Albany, ORJun 15, 1968 · N1396Z · Substantial damageNTSB SEA69F0025Accident · No injuriesClosedBrantly B-2 · Albany, ORJun 13, 1968 · N5963X · Substantial damageNTSB SEA69F0064Accident · No injuriesClosedPiper PA-20 · Redmond, ORJun 8, 1968 · N7725K · Substantial damageNTSB SEA69D0050Accident · No injuriesClosedCessna 150 · Springfield, ORMay 31, 1968 · N6716F · Substantial damageNTSB SEA69D0045Accident · No injuriesClosedPiper PA-18 · Carver, ORMay 27, 1968 · N5881D · Substantial damageNTSB SEA69D0058Accident · No injuriesClosedBeech 23 · Eugene, ORMay 23, 1968 · N2329L · Substantial damageNTSB SEA69D0002Accident · No injuriesClosedCessna 182 · Pendleton, ORMay 21, 1968 · N3474R · Substantial damageNTSB SEA69D0056Accident · No injuriesClosedBeech A23A · Grants Pass, ORMay 8, 1968 · N2355W · Substantial damageNTSB SEA69F0019Accident · Minor injuriesClosedPiper PA-28 · Paisley, ORApr 30, 1968 · N8925J · DestroyedNTSB SEA68F0299Accident · No injuriesClosedPiper PA-22 · Hood River, ORApr 17, 1968 · N610A · Substantial damageNTSB SEA68D0282Accident · No injuriesClosedPiper PA-24 · Vale, ORApr 14, 1968 · N8852P · Substantial damageNTSB SEA68F0290Accident · No injuriesClosedCessna 172 · Bend, ORApr 7, 1968 · N7831X · Substantial damageNTSB SEA68D0305Accident · No injuriesClosedPiper PA-22 · Spray, ORApr 6, 1968 · N9672D · Substantial damageNTSB SEA68D0307Accident · No injuriesClosedCessna 182 · Baker, ORApr 3, 1968 · N2709G · DestroyedNTSB SEA69F0010Accident · No injuriesClosedStearman PT-13 · Condon, ORMar 30, 1968 · N49377 · Substantial damageNTSB SEA69D0044Accident · No injuriesClosedCessna 172 · Ashland, ORMar 29, 1968 · N1718F · Substantial damageNTSB SEA68D0279Accident · No injuriesClosedCessna 172 · Mulino, ORMar 17, 1968 · N4197L · Substantial damageNTSB SEA68D0288Accident · No injuriesClosedPiper PA-28 · Millican, ORMar 16, 1968 · N6475W · Substantial damageNTSB SEA68D0285Accident · No injuriesClosedCessna 150 · Florence, ORMar 14, 1968 · N7112F · Substantial damageNTSB SEA68D0271Accident · No injuriesClosedCessna 140 · Beaver Creek, ORMar 3, 1968 · N76167 · Substantial damageNTSB SEA68F0266Accident · No injuriesClosedPiper PA-22 · Crescent Lk, ORFeb 29, 1968 · N7021D · Substantial damageNTSB SEA68D0276Accident · No injuriesClosedLuscombe 8E · Progress, ORFeb 26, 1968 · N1284K · Substantial damageNTSB SEA68F0261Accident · No injuriesClosedCessna 182 · Springfield, ORFeb 11, 1968 · N2993Y · Substantial damage