NTSB investigations, WA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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' 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.
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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA06CA010Accident · Minor injuriesData collectionFinal reportMichael Moneyhan Magnum · Cougar, WAThe pilot's inadequate in-flight decision to land on the uneven terrain, which resulted in the airplane nosing over. Factors contributing to the accident included the uneven terrain and the sunglare condition.NTSB SEA06LA006Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Burlington, WAThe pilot's failure to maintain clearance from a utility pole during a precautionary landing. The utility pole was a factor.NTSB SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB SEA06CA013Accident · Serious injuriesData collectionFinal reportNorth Wing Apache ST Trike · Medical Lake, WAThe loss of engine power while maneuvering for undetermined reasons.NTSB SEA06CA008Accident · No injuriesData collectionFinal reportWilliams Challenger II · Spokane, WAThe loss of all engine power while on downwind for undetermined reasons.NTSB SEA06LA004Accident · No injuriesLimited investigationFinal reportBeech G35 · Longview, WARuddervator flutter which resulted in the buckling of the empennage. The reason for the ruddervator flutter was undetermined.NTSB SEA06CA001Accident · Minor injuriesData collectionFinal reportCessna 150D · Greenwater, WAThe pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.NTSB SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.NTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB SEA05LA192Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Chehalis, WAThe pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…NTSB SEA05LA187Accident · No injuriesLimited investigationFinal reportCessna 182E · Toutle, WAThe loss of engine power as a result of fuel exhaustion due to the pilot's failure to properly secure the fuel caps during his self-servicing and (improperly) preflighting the airplane. A contributing factor was the utility pole.NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.NTSB SEA05LA179Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Richland, WAThe oil pressure gauge line fitting coming loose from the engine, resulting in the loss of oil to the point where internal engine components were starved for oil, leading to extensive internal damage and seizing of the engine. Factors include a set of eight…NTSB SEA05LA177Accident · Serious injuriesLimited investigationFinal reportTichacek N-3 Pup · Mead, WAThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA05CA174Accident · No injuriesData collectionFinal reportNavion Navion G · Port Orchard, WAThe pilot's delay in aborting the takeoff which resulted in a runway overrun. A contributing factor was the pilot's failure to raise the flaps prior to takeoff.NTSB SEA05CA166Accident · No injuriesData collectionFinal reportLuscombe 8A · Otis Orchards, WAThe pilot's loss of directional control as a result of excessive braking while landing, which resulted in the nose over.NTSB SEA05LA161Accident · No injuriesLimited investigationFinal reportCessna A185F · Seattle, WALoss of engine power for undetermined reasons.NTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB SEA05CA154Accident · Minor injuriesData collectionFinal reportGrumman American AA1B · Camas, WAThe student pilot's failure to maintain aircraft control during landing roll. A contributing factor was the gusty cross-wind weather condition.NTSB SEA05CA143Accident · No injuriesData collectionFinal reportBeech A36 · Sequim, WAThe temporary loss of engine power for an undetermined reason during the takeoff initial climb.NTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB SEA05LA138Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Oroville, WAThe failure of the throttle cable housing, which permitted the engine's RPM to decay to the idle position. Contributing factors were the trees and the lack of suitable terrain for a forced landing.NTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…NTSB SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.NTSB SEA05LA118Accident · Minor injuriesLimited investigationFinal reportRash Vans RV-6A · Palouse, WALoss of engine power for undetermined reasons. Rising terrain was a factor.NTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.NTSB SEA05IA115Incident · No injuriesIncident investigationFinal reportPiper PA-46-350P · Tacoma, WAThe initiation and propagation of a fatigue crack, over 5,273 hours of cyclic in-flight usage, through approximately 80 percent of the aircraft's right wing spar lower cap.NTSB SEA05LA110Accident · No injuriesLimited investigationFinal reportBeech A-36 · Tacoma, WAThe malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.NTSB SEA05LA107Accident · No injuriesLimited investigationFinal reportCessna 150L · Spokane, WAThe pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.NTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB SEA05LA089Accident · No injuriesLimited investigationFinal reportAeronca 0-58B · Kennewick, WALoss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over. A factor was the unsuitable terrain.NTSB SEA05CA086Accident · No injuriesData collectionFinal reportWilliams Helicopter UH-1B · Uniontown, WAThe pilot's failure to maintain clearance from an object while maneuvering, which resulted in the main rotor blades striking a power pole. The power pole was a factor in the accident.NTSB SEA05FA072Accident · 2 fatalField investigationFinal reportStinson 10-A · Oak Harbor, WAThe pilot's failure to adequately plan the approach for landing and maintain clearance from trees during the go-around. A tailwind and trees were factors.NTSB SEA05CA069Accident · No injuriesData collectionFinal reportCessna A188B · Palouse, WAThe pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.NTSB SEA05LA068Accident · 1 fatalLimited investigationFinal reportCessna T337E · Orcas Island, WAThe loss of power for undetermined reasons which resulted in a forced landing and impact with water.NTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.NTSB SEA05LA064Accident · No injuriesLimited investigationFinal reportCessna 182Q · Shelton, WAThe pilot's improper flare which resulted in a hard landing.NTSB SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.NTSB SEA05LA044Accident · No injuriesLimited investigationFinal reportSmuz RAF 2000 GTX SE · Puyallup, WAThe pilot's misjudged flare followed by an oscillation which damaged the aircraft.NTSB SEA05LA042Accident · No injuriesLimited investigationFinal reportMaule M-7-260 · Port Angeles, WAThe pilot's improper flare. Factors contributing to the accident included the pilot's improper approach and the glassy water condition.NTSB SEA05IA040Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Seattle, WAThe flight crew's failure to maintain an adequate visual lookout while on final for a visual approach. Factors include the failure of both airport operations personnel and the local FAA Airports Inspector to insure that some form of identification marking was…NTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…NTSB SEA05CA035Accident · No injuriesData collectionFinal reportCessna 310J · Davenport, WAThe pilot's failure to maintain adequate airspeed during landing with airframe ice, which resulted in an inadvertent stall and hard landing. Factors were the icing conditions and the airframe ice.