NTSB investigations, 2011, WA

23 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2011, WA per year, 1964–2026: 1,419 cases
196444
196551
196648
196770
196833
196930
197033
197117
197218
197333
197425
197531
197628
197719
197829
197932
198028
198125
198226
198322
198429
198517
198617
198727
198827
198919
199013
199125
199221
199325
199422
199515
199616
199719
199817
199921
200018
200119
200220
200323
200423
200519
200612
200715
200818
200923
201017
201123
201218
201318
201422
20159
201613
201713
201818
201913
202011
202119
202211
202315
202410
202512
202615

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\") = 2011
    AND c.\"eventStateOrRegion\" = 'WA' 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 WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.Nov 11, 2011 · N180LV · Substantial damageNTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.Oct 10, 2011 · N132LL · Substantial damageNTSB WPR11CA464Accident · No injuriesData collectionFinal reportCessna 180 · Orcas Island, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Sep 24, 2011 · N9361C · Substantial damageNTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.Sep 2, 2011 · N5099A · Substantial damageNTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.Aug 27, 2011 · N2719N · Substantial damageNTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.Aug 21, 2011 · N675DH · Substantial damageNTSB WPR11LA405Accident · No injuriesLimited investigationFinal reportJuneau Stol CH-701 · Snohomish, WAThe pilot's improper landing flare, which resulted in a stall and a hard landing.Aug 18, 2011 · N701BZ · Substantial damageNTSB WPR11LA384Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Oakesdale, WAThe pilot's decision to land with a high tailwind, which resulted in a nose-over.Aug 15, 2011 · N6628Q · Substantial damageNTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2011 · N3135J · Substantial damageNTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.Jul 19, 2011 · N601FD · Substantial damageNTSB WPR11CA336Accident · No injuriesData collectionFinal reportStearman C3-B · Spokane, WAThe pilot's failure to maintain directional control on landing. Contributing to the accident was the touch down in a slide-slip.Jul 16, 2011 · N3440 · Substantial damageNTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.Jul 11, 2011 · N6YM · Substantial damageNTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.Jul 5, 2011 · N5175D · Substantial damageNTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.Jul 2, 2011 · N23TT · DestroyedNTSB WPR11CA261Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAThe pilot's failure to maintain clearance from power lines while maneuvering.Jun 15, 2011 · N8376K · Substantial damageNTSB WPR11CA247Accident · No injuriesData collectionFinal reportSieber Paul P Nieuport 11 · Bellingham, WAThe pilot's failure to maintain directional control during landing rollout.Jun 4, 2011 · N118PS · Substantial damageNTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.May 25, 2011 · N8712D · Substantial damageNTSB WPR11LA234Accident · Minor injuriesLimited investigationFinal reportHoskins Zenith · Puyallup, WAThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the accident airplane.May 24, 2011 · N34NH · Substantial damageNTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.Apr 8, 2011 · N423ES · Substantial damageNTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.Mar 31, 2011 · N7302A · Substantial damageNTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.Mar 11, 2011 · N671AV · Substantial damageNTSB WPR11CA110Accident · No injuriesData collectionFinal reportWalker Louie H Super 18 Cuby · Toutle, WAThe pilot's excessive braking during the landing roll, which resulted in the airplane nosing over onto its back. Contributing to the accident was the pilot's decision to land on a sandbar that he had not adequately inspected and his improper airspeed while on…Jan 26, 2011 · N92LW · Substantial damageNTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…Jan 22, 2011 · N142HF · Substantial damage