NTSB investigations, 2019, WA

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 2019
    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 WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.Dec 5, 2019 · N52458 · Substantial damageNTSB WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.Oct 23, 2019 · N615RJ · Substantial damageNTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.Oct 11, 2019 · N612RF · Substantial damageNTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.Aug 21, 2019 · N7186P · Substantial damageNTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…Aug 15, 2019 · N525SG · DestroyedNTSB WPR19LA200Accident · No injuriesClass 3 · LimitedFinal reportBeech 33 · Battleground, WAA failure of the throttle control assembly for reasons that could not be determined based on available evidence, which resulted in a runway overrun and impact with an obstacle.Jul 20, 2019 · N873BC · Substantial damageNTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.Jun 30, 2019 · N4238M · Substantial damageNTSB GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.Jun 4, 2019 · N8685S · Substantial damageNTSB WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.May 6, 2019 · N825PW · DestroyedNTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.Apr 29, 2019 · N90LK · Substantial damageNTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.Apr 28, 2019 · N68825 · Substantial damageNTSB WPR19LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Copalis, WAAn off-airport landing under circumstances that could not be determined based on the available information, which resulted in substantial damage to the airplane.Mar 30, 2019 · N215T · DestroyedNTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.Mar 15, 2019 · N767CC · Substantial damageNTSB GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Mar 9, 2019 · N4100Z · Substantial damageNTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…Mar 8, 2019 · N64RA · DestroyedNTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.Jan 27, 2019 · N4087V · Substantial damageNTSB WPR19LA066Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA23 · Ellensburg, WAThe instrument rated pilot’s loss of control due to spatial disorientation.Jan 17, 2019 · N14372 · Destroyed