NTSB investigations, WA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.NTSB SEA97LA025Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Leavenworth, WAFatigue failure of the vertical stabilizer spar cap and subsequent loss of the rotorcraft's vertical stabilizer. Factors include inadequate inspection or trouble-shooting of the aircraft tail cone and vertical stabilizer at and after the time sheet-metal…NTSB SEA97LA010Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Prosser, WAfailure of the pilot to maintain clearance from the terrain, while en route to an apple orchard that he intended to spray. A factor relating to the accident was: the turbulent wind condition over the hills.NTSB SEA97FA006Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cle Elum, WAThe pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…NTSB SEA97FA005Accident · 1 fatalField investigationFinal reportCessna T210M · Everett, WAThe pilot's impairment of judgment and performance due to the recent excessive use of potent prescription drugs, the pilot's descent below the published decision height, and the pilot's failure to execute a missed approach. Factors contributing to the…NTSB SEA97LA004Accident · No injuriesLimited investigationFinal reportCrouch Avid Mark IV · Stanwood, WAfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of engine power. A factor relating to the accident was: the pilot's failure to attain the proper touchdown point on suitable terrain during the…NTSB SEA97FA003Accident · No injuriesField investigationFinal reportEnstrom F-28C · Spokane, WAa loss of engine power for undetermined reasons.NTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.NTSB SEA96LA215Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, WAinadequate visual lookout by the pilot of the Piper J3, and failure of the flight instructor in the Bellance to ensure that clearance was maintained from the other moving aircraft. Factors relating to the accident were: the inherent visual restrictions…NTSB SEA96FA214Accident · 1 fatalField investigationFinal reportMudry CAP 10B · Fairchild Afb, WAloss of control due to a jammed aileron pushpull tube, due to improper installation/routing of electrical wire bundles through the right aileron bellcrank mechanism by unknown person(s).NTSB SEA96FA201Accident · 1 fatalField investigationFinal reportBeech D50 · Seattle, WAfailure of the pilot to follow proper emergency procedures (properly configure the airplane and feather the appropriate propeller) after loosing power in one engine, which resulted in his inability to maintain altitude until reaching an airport. Factors…NTSB SEA96LA200Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Waitsburg, WAthe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane after encountering a whirlwind during the landing.NTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.NTSB SEA96LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Paterson, WAfailure of the student pilot to maintain directional control of the airplane during a landing, which resulted in an uncontrolled ground loop/swerve. Factors relating to the accident were: the gusty crosswind condition, and soft terrain beside the runway.NTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…NTSB SEA96FA186Accident · 1 fatalField investigationFinal reportLet L-13 · Shelton, WAfailure of the operator to provide its pilots with information essential for an accurate determination of the glider's weight and balance, the resultant operation of the glider with a center-or-gravity that exceeded the aft limit, and the pilot's inadvertent…NTSB SEA96LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAfailure of the engine magneto drive, which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB SEA96LA177Accident · No injuriesLimited investigationFinal reportCessna U206F · Crane Island, WAthe pilot's failure to correctly judge the surface winds in the vicinity of the runway. Factors relating to the accident were: a tailwind during landing, a short runway with a wet surface, and an embankment/drop-off at the end of the airstrip.NTSB SEA96FA175Accident · 2 fatalField investigationFinal reportMooney M20E · Purdy, WAThe noninstrument-rated pilot's continuation of VFR flight into instrument meteorological conditions which led to pilot spatial disorientation and loss of control of the aircraft. Factors were: pilot self-induced pressure, night conditions, low ceilings, and…NTSB SEA96LA181Accident · No injuriesLimited investigationFinal reportBeech 35 · Spokane, WAfailure (cracking) of the aft fuselage bulkhead for undetermined reason(s).NTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.NTSB SEA96FA171Accident · 2 fatalField investigationFinal reportCessna 340A · Richland, WAThe pilot-in-command's allowing the aircraft's airspeed to decrease below the single-engine minimum control speed (Vmc) resulting in a stall/spin condition. Factors contributing to the accident were the pilot-in-command's allowing the left engine to be shut…NTSB SEA96LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Kettle Falls, WAthe pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.NTSB SEA96LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stehekin, WAthe pilot's improper planning/decision, and his failure to ensure that the airplane would remain clear of trees during the takeoff. Factors relating to the accident were: high density altitude, and the proximity of trees to the runway.NTSB SEA96LA161Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Sunnyside, WAinadequate preflight by the pilot, and subsequent fuel exhaustion. Factors relating to the accident were: darkness, and high vegetation (brush and small trees) in the emergency landing area.NTSB SEA96LA159Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Pullman, WAfailure of the pilot to maintain terrain clearance during a swath run. Factors relating to the accident were: unfavorable (variable) wind conditions, low airspeed, and uneven terrain.NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.NTSB SEA96LA160Accident · No injuriesLimited investigationFinal reportCessna 182A · Toledo, WAloss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.NTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.NTSB SEA96FA130Accident · 1 fatalField investigationFinal reportHughes 269C · Eldon, WAfatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.NTSB SEA96LA124Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Gardiner, WAthe pilot's inadequate compensation for wind conditions and failure to maintain the proper altitude/clearance from obstruction(s), while on final approach. Factors relating to the accident were: the downdraft, and the obstruction (tree).NTSB SEA96LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Roche Harbor, WAthe pilot's inadequate compensation for wind conditions and failure to attain a proper touchdown point for landing. Factors relating to the accident were: downdraft conditions and soft/uneven terrain short of the runway.NTSB SEA96LA128Accident · 1 fatalLimited investigationFinal reportBailey Antares MA30 · Woodland, WAfailure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.NTSB SEA96LA117Accident · Minor injuriesLimited investigationFinal reportHead Pitts S-1C · Everett, WAthe pilot's inadequate fuel management, which resulted in fuel starvation. The aircraft's lack of a fuel quantity gauge and trees in the forced landing area were related factors.NTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.NTSB SEA96LA109Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Richland, WAthe pilot's failure to perform a go-around and his subsequent excessive use of the aircraft brakes. The short airstrip length and the pilot's excessive airspeed for the approach were related factors.NTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.NTSB SEA96LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Seattle, WAAn intentional plan or decision by the pilot to ditch the airplane in Puget Sound.NTSB SEA96LA105Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Puyallup, WAthe pilot's improper recovery from a bounced landing, and failure to maintain runway alignment during a go-around. The pilot's improper flare for landing was a related factor.NTSB SEA96LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12 · Walla Walla, WAthe pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…NTSB SEA96LA090Accident · Serious injuriesLimited investigationFinal reportMiller MA-5 Charger · Kennewick, WAfailure of the pilot to maintain adequate airspeed, during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's lack of total and recent flight experience.NTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.NTSB SEA96LA080Accident · No injuriesLimited investigationFinal reportCessna 150 · Spiden Island, WAthe pilot's selection of an unsuitable airstrip for the landing and subsequent takeoff, and his delay in aborting the takeoff, which resulted in an overrun and collision with an embankment and trees. Factors relating to the accident were: the short, wet,…NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.NTSB SEA96LA075Accident · No injuriesLimited investigationFinal reportRyan Navion · Kent, WAthe pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.NTSB SEA96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Lynnwood, WAa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.