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 WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.Jul 6, 2021 · N456SB · Substantial damageNTSB WPR21LA251Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108-3 · Stevenson, WAA runway incursion, which resulted in a go-around, and subsequent forced landing when the airplane was not able to climb at a rate sufficient to clear approaching rising terrain.Jun 27, 2021 · N6548M · DestroyedNTSB WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.Jun 20, 2021 · N6917Z · Substantial damageNTSB WPR21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportHPH Glasflugel · Winthrop, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.Jun 20, 2021 · N974CQ · Substantial damageNTSB WPR21LA303Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Yelm, WAA total loss of engine power for reasons that could not be determined based on the available evidence.Jun 11, 2021 · N513WF · Substantial damageNTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.May 31, 2021 · N7159B · Substantial damageNTSB WPR21LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Arlington, WAThe pilot’s failure to maintain directional control during landing, with a crosswind, which resulted in a runway excursion and subsequent impact with terrain.May 7, 2021 · N31B · Substantial damageNTSB WPR21LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175B · Royal City, WAThe pilot’s failure to maintain airplane control during a landing with a tailwind which resulted in excessive ground speed, runway over run and subsequent nose over.May 3, 2021 · N8209T · Substantial damageNTSB WPR21LA172Accident · No injuriesClass 4 · LimitedFinal reportMichael J Robbins Searey · Friday Harbor, WAPartial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.Apr 22, 2021 · N888MJ · Substantial damageNTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.Apr 21, 2021 · N53331 · Substantial damageNTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…Apr 17, 2021 · N707PH · Substantial damageNTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.Apr 15, 2021 · N3023M · Substantial damageNTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.Apr 14, 2021 · N51380 · Substantial damageNTSB WPR21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 182H · Blakely Island, WAA total loss of engine power during climb for reasons that could not be determined which resulted in a forced water landing.Apr 11, 2021 · N2030X · Substantial damageNTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.Mar 29, 2021 · N665FL · Substantial damageNTSB WPR21LA149Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Port Townsend, WAThe pilot’s inadequate engine hand propping procedure which resulted in the airplane’s unexpected movement and subsequent impact with a fueling station.Mar 29, 2021 · N28461 · Substantial damageNTSB WPR21LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Everett, WAA total loss of engine power during climb, for reasons that could not be determined based on available evidence.Mar 23, 2021 · N2164Z · Substantial damageNTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.Mar 12, 2021 · N1224C · Substantial damageNTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.Feb 27, 2021 · N347JP · Substantial damageNTSB WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.Jan 27, 2021 · N9114A · Substantial damageNTSB WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.Jan 14, 2021 · N5930R · Substantial damageNTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.Jan 9, 2021 · N8612F · Substantial damageNTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.Jan 8, 2021 · N4344B · Substantial damageNTSB WPR21FA057Accident · 1 fatalClass 3 · FieldFinal reportBlevins Kamron Odyssey · Arlington, WAThe pilot’s loss of airplane control for reasons that could be determined based on available evidence.Nov 20, 2020 · N562TB · DestroyedNTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…Nov 11, 2020 · N34633 · Substantial damageNTSB WPR21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCarbon Cub · Camano, WAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to final approach.Nov 2, 2020 · N3841D · Substantial damageNTSB WPR21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Richland, WAThe pilot’s failure to maintain airplane control during landing, which resulted in a nose over.Oct 27, 2020 · N814BA · Substantial damageNTSB WPR21LA017Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Puyallup, WAA partial loss of engine power as a result of carburetor icing and the flight instructors failure to use carburetor heat.Oct 18, 2020 · N4673R · Substantial damageNTSB WPR21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Moses Lake, WAThe pilot’s failure to maintain clearance from telephone wires while on final approach for landing which resulted in a collision.Oct 18, 2020 · N9600J · Substantial damageNTSB WPR21LA015Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · South Hill, WAThe pilot’s failure to ensure that the fuel supply had been completely drained of water, which resulted in a partial loss of engine power during takeoff due to water contamination.Oct 15, 2020 · N6585L · Substantial damageNTSB WPR21LA002Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Burlington, WAThe total loss of engine power for reasons that could not be determined based on the available information.Oct 1, 2020 · N601SA · Substantial damageNTSB WPR20LA331Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Randle, WAThe pilot's failure to maintain clearance from a tree while conducting an external load operation.Sep 9, 2020 · N91TA · DestroyedNTSB WPR20CA302Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Snohomish, WAThe solo student pilot's improper landing flare, which resulted in a bounced landing and his subsequent improper go-around, which resulted in an impact with terrain.Sep 8, 2020 · N946SF · Substantial damageNTSB WPR20CA300Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Stuart Island, WAThe pilot’s improper approach airspeed and landing flare, which resulted in a hard, bounced landing and nose over.Sep 7, 2020 · N172CS · Substantial damageNTSB WPR20LA279Accident · FatalClass 4 · LimitedFinal reportCessna 150 · Quillayute, WAThe airplane’s descent into trees and subsequent impact with terrain for undetermined reasons.Aug 19, 2020 · N11513 · Substantial damageNTSB WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.Aug 16, 2020 · N62130 · Substantial damageNTSB WPR20CA274Accident · Minor injuriesClass 4 · Data collectionFinal reportUskoski Ridge Runner IV · Vancouver, WAThe pilot’s failure to maintain airplane control while maneuvering to land which resulted in an aerodynamic stall at a low altitude, which the pilot was unable to recover from.Aug 14, 2020 · N11752 · Substantial damageNTSB WPR20CA243Accident · Minor injuriesClass 4 · Data collectionFinal reportQuest Kodiac 100 · Hunts Point, WAThe pilot’s failure to retract the landing gear during a water landing, which resulted in a nose over. Contributing to the accident was the pilot’s failure to properly use a prelanding checklist.Jul 28, 2020 · N856TC · Substantial damageNTSB WPR20LA229Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · College Place, WAThe pilot’s premature retraction of the flaps which resulted in the airplane settling back onto the runway, contacting it hard, and veering off the runway.Jul 20, 2020 · N846JM · Substantial damageNTSB WPR20CA220Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Port Townsend, WAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in a nose over.Jul 13, 2020 · N185KL · Substantial damageNTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.Jul 12, 2020 · N644RS · Substantial damageNTSB WPR20LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Port Orchard, WAThe pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.Jul 8, 2020 · N22393 · Substantial damageNTSB WPR20CA192Accident · Serious injuriesClass 4 · Data collectionFinal reportNorth Wing Uum Scout X-C · Rochester, WAThe pilot’s failure to maintain adequate airspeed while on final approach in turbulent conditions, which resulted in an aerodynamic stall and subsequent hard landing.Jun 23, 2020 · N417HW · Substantial damageNTSB WPR20CA188Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lynden, WAThe pilot's failure to maintain control of the airplane during the landing approach, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, hard landing, and a landing gear collapse.Jun 14, 2020 · N1958Q · Substantial damageNTSB WPR20LA180Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Renton, WAMaintenance personnel’s inadequate post-maintenance inspections that resulted in the total loss of engine power due to a blockage in the air intake.Jun 12, 2020 · N36339 · Substantial damageNTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.Jun 4, 2020 · N87607 · Substantial damageNTSB WPR20CA151Accident · No injuriesClass 4 · Data collectionFinal reportLet L 33 Solo · Arlington, WAThe loss of lift while on final approach which resulted in a hard off-airport landing.May 11, 2020 · N355BA · Substantial damageNTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.Apr 20, 2020 · N75765 · Substantial damageNTSB WPR20LA122Accident · No injuriesClass 3 · LimitedFinal reportBuckman Bucks Special · Prescott, WADiminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…Apr 9, 2020 · N9065F · Substantial damageNTSB WPR20LA118Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar 2 · La Center, WAA loss of control for reasons that could not be determined based on the available information.Apr 6, 2020 · N90KL · Substantial damage