NTSB investigations, 2013, WA

12 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2013, WA per year, 2008–2026: 283 cases
200826
200919
201016
201128
201223
201312
201420
201523
201615
201720
201824
201917
20209
20212
20227
20236
20243
20257
20266

Latest cases

Query with SQL
duckdb -csv -c "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\") = 2013
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR14CA019Accident · No injuriesData collectionFinal reportRobinson R44 - II · Sedro Woolley, WAThe non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…Oct 18, 2013 · N414CC · Substantial damageNTSB WPR14CA004Accident · Minor injuriesData collectionFinal reportVenables Zenith CH701 · Snohomish, WAA jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.Oct 3, 2013 · N143TZ · Substantial damageNTSB WPR13CA394Accident · No injuriesData collectionFinal reportHenderson Michael E Glastar · Sequim, WAThe pilot's improper soft field landing technique, and failure to maintain aircraft control during the landing.Aug 31, 2013 · N789MH · Substantial damageNTSB WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.Aug 5, 2013 · N234RV · Substantial damageNTSB WPR13CA361Accident · Minor injuriesData collectionFinal reportBuckeye Dream Machine · Fruitland, WAThe operation of a powered parachute by a non-certificated pilot, and the pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with a vehicle.Jul 3, 2013 · UNREG · Substantial damageNTSB WPR13LA299Accident · No injuriesLimited investigationFinal reportCessna 172 - N · Trout Lake, WAThe pilot's failure to maintain clearance from trees during takeoff from a soft field and to abort the landing when the airplane reached the runway’s midpoint at a low airspeed.Jun 28, 2013 · N75542 · Substantial damageNTSB WPR13LA287Accident · Serious injuriesLimited investigationFinal reportBell 206B · Royal City, WAThe pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.Jun 24, 2013 · N407FK · Substantial damageNTSB WPR13CA235Accident · Minor injuriesData collectionFinal reportSwanson Tiger Moth 80 · Lynden, WAThe pilot's failure to maintain clearance from trees during final approach and his obscured vision due to the sun glare.May 17, 2013 · N928VS · Substantial damageNTSB WPR13CA165Accident · No injuriesData collectionFinal reportCessna 150 · Bellingham, WAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor's delayed remedial action.Mar 23, 2013 · N7177X · Substantial damageNTSB WPR13FA141Accident · 1 fatalField investigationFinal reportMaule M5 · Woodinville, WAThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.Mar 9, 2013 · N17PR · Substantial damageNTSB WPR13CA121Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sunnyside, WAThe pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.Feb 9, 2013 · N6726J · Substantial damageNTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.Jan 24, 2013 · N18690 · Substantial damage