Final NTSB investigations, WA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 WPR18LA214Accident · Minor injuriesLimited investigationFinal reportBell 206 · Basin City, WAThe pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.Aug 7, 2018 · N607RA · DestroyedNTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…Aug 3, 2018 · N56039 · Substantial damageNTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.Jul 27, 2018 · N152LT · Substantial damageNTSB GAA18CA519Accident · No injuriesData collectionFinal reportCessna 150 · Everett, WAA total loss of engine power due to carburetor icing during final approach, which resulted in a hard landing short of the runway and the nose landing gear collapsing.Jul 22, 2018 · N45586 · Substantial damageNTSB GAA18CA443Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Chelan Falls, WAThe pilot's improper approach over a river, which resulted in a collision with a dock.Jul 22, 2018 · N825PW · Substantial damageNTSB WPR18LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMicrolites Ptyltd Dragonfly B · Buckley, WAA total loss of engine power for reasons that could not be determined based on the available information.Jul 19, 2018 · N7008Z · Substantial damageNTSB WPR18CA213Accident · No injuriesData collectionFinal reportCessna E162 · Burlington, WAThe student pilot’s failure to maintain pitch control during an aborted takeoff.Jul 14, 2018 · N5202B · Substantial damageNTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.Jul 13, 2018 · N24442 · Substantial damageNTSB WPR18LA190Accident · Minor injuriesLimited investigationFinal reportAutogyro Calidus · Tacoma, WAThe pilot's failure to properly configure the gyrocopter for takeoff, which resulted in it developing high speed and led to a subsequent loss of control.Jul 7, 2018 · N623AG · Substantial damageNTSB GAA18CA384Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Chelan, WAThe pilot's improper approach, which resulted in the airplane landing long and a subsequent runway overrun.Jun 27, 2018 · N1266C · Substantial damageNTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.Jun 20, 2018 · N9130T · Substantial damageNTSB GAA18CA380Accident · No injuriesData collectionFinal reportJabiru J250 · Ferndale, WAThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident were the pilot’s lack of experience and training in the accident airplane make and model.Jun 18, 2018 · N722BL · Substantial damageNTSB GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.Jun 17, 2018 · N11YB · Substantial damageNTSB GAA18CA352Accident · No injuriesData collectionFinal reportBell 206 · Orondo, WAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Jun 17, 2018 · N2762P · Substantial damageNTSB GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.Jun 10, 2018 · N352AM · Substantial damageNTSB GAA18CA328Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arlington, WAThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 7, 2018 · N3202H · Substantial damageNTSB WPR18LA151Accident · 1 fatalLimited investigationFinal reportCessna 150M · Bainbridge Island, WAThe pilot's failure to maintain clearance from the water and his distraction by using the tablet for navigation, which resulted in his failure to detect that the airplane had entered a descent.May 28, 2018 · N6AF · Substantial damageNTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…May 25, 2018 · N111DR · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damageNTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.May 17, 2018 · N182EW · Substantial damageNTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.May 14, 2018 · N4144L · DestroyedNTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.May 2, 2018 · N734QQ · Substantial damageNTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.Apr 28, 2018 · N35VM · Substantial damageNTSB GAA18CA237Accident · Minor injuriesData collectionFinal reportStinson 108 · Eliza Island, WAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.Apr 27, 2018 · N6933M · Substantial damageNTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.Apr 22, 2018 · N964TA · Substantial damageNTSB GAA18CA177Accident · No injuriesData collectionFinal reportCessna 152 · Snohomish, WAThe pilot’s decision to land with a tailwind and in his failure to maintain pitch control of the airplane in gusting wind conditions.Mar 12, 2018 · N6509L · Substantial damageNTSB WPR18LA109Accident · Minor injuriesClass 3 · LimitedFinal reportLyons Robert Navajo HKS · Arlington, WAThe pilot's loss of directional control during landing. Contributing to the accident was the pilot's failure to attain a proper touchdown point, which required his use of heavy braking to stop on the remaining runway and exacerbated the uneven braking…Mar 11, 2018 · N1762C · Substantial damageNTSB WPR18FA104Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · La Center, WAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.Mar 11, 2018 · N4511Y · DestroyedNTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.Mar 10, 2018 · N74445 · Substantial damageNTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 9, 2018 · N9463C · Substantial damageNTSB WPR18LA098Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon A36 · Enumclaw, WAA total loss of engine power due to oil starvation as a result of a loose oil line B-nut.Mar 4, 2018 · N207PC · Substantial damageNTSB GAA18CA184Accident · No injuriesData collectionFinal reportPiper PA32 · Camas, WAThe pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation.Mar 4, 2018 · N3756W · Substantial damageNTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.Feb 13, 2018 · N123JN · DestroyedNTSB WPR18FA074Accident · 1 fatalField investigationFinal reportHughes 369D · Pomeroy, WAA loss of control following the gunner's failure to ensure that the net maintained clearance from the tail rotor.Jan 27, 2018 · N369TH · Substantial damageNTSB GAA18CA104Accident · Minor injuriesData collectionFinal reportGeldermann Bert E Lancair Legacy · Friday Harbor, WAThe pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.Jan 15, 2018 · N145JG · Substantial damageNTSB DCA18IA081Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pullman, WAthe flight crew's misidentification of the taxiway as the landing runway due to the failure of the runway lighting that caused only the taxiway lights to be illuminated.Dec 30, 2017 · N412QX · No damageNTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.Dec 8, 2017 · N4801D · Substantial damageNTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 7, 2017 · N2351U · Substantial damageNTSB WPR18LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Everett, WAThe flight instructor’s inadequate preflight inspection, during which he failed to ensure that water was sufficiently drained from the fuel system, which resulted in total loss of engine power and a subsequent forced landing and impact with objects.Dec 3, 2017 · N714TD · Substantial damageNTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.Nov 11, 2017 · N141WC · Substantial damageNTSB ENG18IA003Incident · No injuriesClass 3 · IncidentFinal reportAirbus A330-243 · Seattle, WAThe loss of control of the left-hand engine and the subsequent thermal damage to the left wing on landing during engine reverse operation was due to a blockage of the variable stator vane torque motor filter that resulted in the engine’s electronic engine…Nov 7, 2017 · N375HA · Minor damageNTSB WPR18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Port Townsend, WAA total loss of engine power for undetermined reasons.Oct 30, 2017 · N72339 · Substantial damageNTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.Oct 28, 2017 · N6582P · Substantial damageNTSB GAA18CA029Accident · Serious injuriesData collectionFinal reportSix Chuter West Legend XL · Mabton, WAThe pilot’s failure to see and avoid transmission wires.Oct 26, 2017 · N781SC · Substantial damageNTSB WPR18FA016Accident · 1 fatalField investigationFinal reportRobinson R22 · Arlington, WAThe pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.Oct 24, 2017 · N8537J · Substantial damageNTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.Oct 24, 2017 · N19EC · Substantial damageNTSB GAA18CA013Accident · No injuriesData collectionFinal reportCessna 172RG · Auburn, WAThe failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Oct 15, 2017 · N5159U · Substantial damageNTSB GAA18CA014Accident · No injuriesData collectionFinal reportHimsl Vincent S Vans RV-8 · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll in crosswind conditions.Oct 14, 2017 · N8432 · Substantial damageNTSB GAA18CA001Accident · No injuriesData collectionFinal reportPiper J3C · Yakima, WAThe flight instructor's failure to maintain directional control during the takeoff roll.Oct 3, 2017 · N48694 · Substantial damageNTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…Sep 30, 2017 · N9549W · Destroyed