NTSB investigations, 2017, OR

10 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2017, 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\") = 2017
    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 WPR18LA005Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 24-250 · Hillsboro, ORThe student's pilot’s failure to maintain adequate airspeed during approach and subsequent exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall and a subsequent hard landing. Contributing to the accident was…Oct 5, 2017 · N7892P · Substantial damageNTSB GAA17CA541Accident · No injuriesData collectionFinal reportRudberg Todd W Vans Acft RV8 · Manzanita, ORThe airplane’s collision with two elks during landing.Sep 17, 2017 · N232TB · Substantial damageNTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.Aug 24, 2017 · N6447M · Substantial damageNTSB GAA17CA507Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Hillsboro, ORThe student pilot’s failure to maintain airplane control while landing in crosswind conditions and the flight instructor’s delayed remedial action.Aug 24, 2017 · N599CC · Substantial damageNTSB GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.Aug 4, 2017 · N9829B · Substantial damageNTSB GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.Jul 23, 2017 · N10AR · Substantial damageNTSB GAA17CA363Accident · No injuriesData collectionFinal reportPiper PA 22 · Pendleton, ORThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jun 24, 2017 · N2473P · Substantial damageNTSB GAA17CA288Accident · No injuriesData collectionFinal reportAeronca 7AC · Lebanon, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.May 15, 2017 · N3046E · Substantial damageNTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.Apr 4, 2017 · N7822D · Substantial damageNTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.Mar 12, 2017 · N5440H · Substantial damage