NTSB investigations, WA
145 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 12 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 11 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 10 |
| 1996 | 4 |
| 1997 | 9 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 5 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 SEA07TA212Accident · No injuriesFinal reportHughes 369D · Omak, WAThe pilot's failure to maintain clearance from the surface of a pond that he was using as a water bucket refill site, which resulted in a tail rotor strike to the water's surface and a torsional overload failure of the tail rotor drive shaft.NTSB SEA07LA213Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Spokane, WAThe locking/seizing of a main landing gear brake mechanism during the landing roll.NTSB LAX07LA215Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roche Harbor, WAThe pilot's failure to perform the emergency landing gear extension procedure prior to landing. A contributing factor in the accident was the failure of the electrical system.NTSB SEA07CA159Accident · Serious injuriesData collectionFinal reportNelson Murphy SR3500 Moose · Roche Harbor, WAThe jamming of the left brake during landing. A factor was the kit manufacturer's design of the brake system.NTSB SEA07LA093Accident · No injuriesLimited investigationFinal reportChampion 7ECA · East Wenatchee, WASeparation of the left main landing gear shock absorbing strut during takeoff. A missing screw was a factor.NTSB SEA07CA032Accident · No injuriesData collectionFinal reportRiley D-16A · Point Roberts, WAthe pre-existing crack in the nose wheel fork, which allowed separation of the nose wheel during the takeoff roll, resulting in collapse of the nose landing gear.NTSB SEA06LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Auburn, WAThe failure of the landing gear's normal retraction/extension assembly due to an overload condition.NTSB SEA06CA157Accident · No injuriesData collectionFinal reportPiggott Bearhawk · Port Angeles, WAThe loss of directional control as a result of the disconnected tail wheel steering system, which led to an inadvertent ground loop during the landing roll.NTSB SEA06CA149Accident · No injuriesData collectionFinal reportMaule M-7-235C · Auburn, WAThe loss of directional control [not possible] during landing roll as a result of the disconnected tail wheel steering assembly [for undetermined reasons], which led to an inadvertent ground loop during the landing roll.NTSB SEA06LA133Accident · No injuriesLimited investigationFinal reportNanchang China CJ-6 · Brewster, WAThe failure of the engine's three planetary gears for undetermined reasons. A factor contributing to the accident was the tree orchard.NTSB SEA06CA078Accident · No injuriesData collectionFinal reportCessna 170B · Shelton, WAThe main landing gear wheel failure during the takeoff ground roll. A related factor was directional control of the aircraft was not possible after the wheel failure.NTSB SEA06CA051Accident · No injuriesData collectionFinal reportErcoupe 415-C · Arlington, WAThe pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…NTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…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 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 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 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 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 SEA05FA022Accident · 1 fatalField investigationFinal reportCessna 185F · Renton, WAThe pilot's failure to maintain aircraft control when the flaps became jammed/stuck in their full-down position during a takeoff from a touch-and-go landing. Factors include a worn/disconnected flap latch mechanism, and the flaps being unable to be retracted.NTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.NTSB SEA04LA162Accident · No injuriesLimited investigationFinal reportUniversal Moulded Pdts. Monocoach · Pullman, WAThe failure of a landing gear oleo retaining nut safety clip (snap ring) at an unknown point in time, leading to the partial separation of the landing gear strut while in flight, and the full collapse of the strut during the subsequent landing. Factors…NTSB SEA04LA050Accident · 2 fatalLimited investigationFinal reportCessna 170 · Herron, WAThe failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.NTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.NTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…NTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…NTSB SEA03LA128Accident · No injuriesLimited investigationFinal reportMooney M20-J · Renton, WAIn-flight failure of the electric landing gear motor during the initial takeoff climb.NTSB SEA03LA098Accident · No injuriesLimited investigationFinal reportCessna R182 · Kent, WAThe failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…NTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.NTSB SEA02LA116Accident · No injuriesLimited investigationFinal reportBeech G35 · Yakima, WAEmpennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.NTSB SEA02IA092Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11F · Seatac, WAFailure of the copilot's forward (R1) windshield anti-ice controller resulting in a continuous over voltage condition, followed by the subsequent overheating and shattering of the windscreen.NTSB SEA02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAThe failure of the brake system during the landing roll. An intentional ground loop and a dirt bank were factors.NTSB SEA01LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Olympia, WAThe inability of the landing gear to fully extend due to the failure of a hydraulic hose in the nose gear extension system.NTSB SEA01LA141Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Sultan, WAThe separation/loss of the bolt and castle nut which connected the elevator bellcrank to the control stick pushrod resulting in a disconnect between the cockpit and the control surface and ultimately, the pilot's total loss of pitch control.NTSB SEA01LA088Accident · No injuriesLimited investigationFinal reportMaule Air M-7-235 · Everett, WAA system failure for undetermined reasons while on final approach. The pilot's failure to maintain control of the aircraft was a factor.NTSB SEA01LA075Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Seattle, WAthe reverse rigging of the aileron flight control system resulting in aileron deflections opposite that of the pilot's inputs which lead to an uncontrolled descent into the terrain. Factors include the pilot's failure to detect the misrigged ailerons during…NTSB SEA01LA067Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Carr Inlet, WAFatigue fracture of the propeller attaching bolts resulting in the total separation of the propeller assembly from the crankshaft flange.NTSB SEA01LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Renton, WAThe worn condition of the hydraulic pump gears which resulted in a continuous running pump, subsequent pump motor overheat and eventually the tripping of the pump motor circuit breaker. An additional cause was the pilot's failure to verify that the landing…NTSB SEA01IA039Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Seattle, WAA malfunctioning relay in the aircraft's flight management system (FMS) switching matrix and associated false "on course" indication on the captain's course deviation indicator (CDI), resulting in proper localizer course alignment not being obtained or…NTSB SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.NTSB SEA00LA197Accident · No injuriesLimited investigationFinal reportBell 206BII · Newhalem, WADebonding between the elastomeric material and the center plate of the transmission isolation mount.NTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…NTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.NTSB SEA00IA069Incident · No injuriesIncident investigationFinal reportCessna 182P · Tacoma, WAFlap attachment failure. Restricted movement of the aileron was a factor.NTSB SEA00LA065Accident · No injuriesLimited investigationFinal reportAero Design Eleven 12 · Spokane, WACracking of the weld between the tailwheel stinger housing and longitudinal cross tube, resulting in separation of the tube/tail wheel assembly from the airframe.NTSB SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB SEA99LA171Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Usk, WAFatigue failure of the 90-degree gearbox attachment studs, resulting in separation of the tailrotor and 90-degree gearbox from the vertical fin.NTSB SEA99LA143Accident · No injuriesLimited investigationFinal reportCessna 210B · Port Angeles, WAThe failure of maintenance personnel to detect cracked main landing gear saddles during required inspection, and subsequent fatigue fracture of the left main landing gear saddle resulting in separation of the saddle and disabling of the left main gear.NTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.