NTSB investigations, 2017, ID

15 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2017, ID per year, 1964–2026: 745 cases
196429
196518
196620
196718
196819
196914
197021
197114
197212
19739
197417
197517
19769
19779
19789
197913
19809
19819
19826
19838
198411
198510
198613
19875
19888
19891
19908
19916
19928
199311
199411
19955
199612
19974
199812
199914
20009
20019
200219
200315
200413
20059
200611
200719
200810
200913
201019
20118
201218
201311
20147
201510
20169
201715
201811
201917
20207
202117
202211
202311
202415
20256
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\") = 2017
    AND c.\"eventStateOrRegion\" = 'ID' 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 GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.Oct 26, 2017 · N927D · Substantial damageNTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.Aug 19, 2017 · N136BJ · Substantial damageNTSB GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.Aug 19, 2017 · N7677M · Substantial damageNTSB GAA17CA471Accident · No injuriesData collectionFinal reportChampion 7ACA · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s use of excessive braking, which led to a nose-over.Aug 5, 2017 · N1227G · Substantial damageNTSB GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.Jul 27, 2017 · N302DM · Substantial damageNTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 26, 2017 · N208SS · Substantial damageNTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.Jul 14, 2017 · N1796A · Substantial damageNTSB WPR17LA162Accident · No injuriesLimited investigationFinal reportCessna A185E · Nampa, IDThe pilot’s failure to maintain directional control of the tailwheel airplane during the landing roll.Jul 11, 2017 · N185LC · Substantial damageNTSB GAA17CA396Accident · No injuriesData collectionFinal reportChampion 7KCAB · Cottonwood, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 8, 2017 · N5195X · Substantial damageNTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.Jun 12, 2017 · N305CM · Substantial damageNTSB GAA17CA320Accident · No injuriesData collectionFinal reportCessna 182 · Elk City, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the wing’s angle of attack while on short final, which resulted in an aerodynamic stall.Jun 2, 2017 · N5011D · Substantial damageNTSB GAA17CA309Accident · No injuriesData collectionFinal reportMaule MX7 · Payette, IDThe pilot's failure to maintain directional during the landing.May 30, 2017 · N789JR · Substantial damageNTSB GAA17CA245Accident · No injuriesData collectionFinal reportCessna 185 · Marsing, IDThe pilot’s improper landing flare, which resulted in a bounced landing, the failure of the right main landing gear wheel, and a ground loop.Apr 23, 2017 · N4017Y · Substantial damageNTSB GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.Feb 25, 2017 · N4404T · Substantial damageNTSB GAA17CA116Accident · No injuriesData collectionFinal reportCessna 170 · Coeur D'Alene, IDThe pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.Jan 14, 2017 · N3210A · Substantial damage