NTSB investigations, WA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA92FA024Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Everett, WAFuel starvation due to improper procedures by the pilot-in-command. Factors include lack of familiarity with the aircraft, non-functioning flight compartment lights, and non-suitable terrain.NTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.NTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.NTSB SEA92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe loss of control on takeoff by the pilot due to the improper flap setting, the premature liftoff and his failure to attain proper climb airspeed after takeoff.NTSB SEA92TL#03Accident · No injuriesClass 3Final reportBell 206L-3 · Kent, WANTSB SEA92LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA24-180 · Marysville, WAThe slippage of the accessary drive gear due to improper maintenance by other maintenance personnel. Factors include a forced landing in unsuitable terrain.NTSB SEA92LA010Accident · No injuriesLimited investigationFinal reportCessna 172C · Colville, WAThe pilot's delayed go-around. Factors contributing to the accident was the pilot's misjudgement of distance and speed during the approach.NTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.NTSB SEA92LA015Accident · No injuriesLimited investigationFinal reportCessna 177A · Trout Lake, WAAn inadequate compensation for wind, and proper climb rate not being maintained. Factors include inadequate preflight planning, the pilot's over-confidence in his own ability and the ability of the aircraft, lack of experience in this type of operation, and a…NTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.NTSB SEA91LA259Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Granite Falls, WAThe pilot's decision to not perform a go-around and a misjudged distance.NTSB SEA91LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Malaga, WAThe instructor pilot's failure to insure adequate terrain clearance during the go-around maneuver. Factors contributing to the accident were 1) rising terrain, 2) high density altitude condition, and 3) the instructor pilot's delay of the go-around.NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB SEA91LA249Accident · No injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe separation of the mixture control cable (core) resulting from separation of the adel clamp assembly and improper adjustment by maintenance personnel.NTSB SEA91LA243Accident · No injuriesLimited investigationFinal reportDonald W. Sorrels Vans RV-6 · Kennewick, WAThe loss of power due to the pilot/builder's improper adjustment of the engine idle speed. A factor relating to the accident was the soft terrain at the accident site.NTSB SEA91LA250Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Redmond, WAThe pilot's failure to maintain the proper rate of descent. A factor contributing to the accident was unfavorable winds.NTSB SEA91LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ellensburg, WAThe pilot's failure to maintain terrain clearance. Contributing to the accident was the pilot's overconfidence in the aircraft's ability, and flight in a box canyon where remedial action was not possible.NTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.NTSB SEA91LA236Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kent, WAFailure of the pilot to maintain directional control and proper runway alignment during the landing and go-around (aborted landing). Factors related to the accident were: the pilot's improper flare and improper recovery from a bounced landing, which resulted…NTSB SEA91LA245Accident · No injuriesLimited investigationFinal reportCessna 210 · Arlington, WAThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to utilize the landing checklist.NTSB SEA91LA244Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Metaline Falls, WAThe pilot's inadvertent use of the parking brake. A factor contributing to the accident was the absence of the parking brake on the landing checklist.NTSB SEA91LA227Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A · Chehalis, WATotal loss of engine power on initial takeoff climb due to the fatigue fracture of the number one piston connecting rod resulting in a forced landing and in flight collision with trees.NTSB SEA91LA226Accident · No injuriesLimited investigationFinal reportRyan Navion · Chelan, WAPoor in flight planning/decision by the pilot in command. Factors to the accident were: down drafts, proper alignment was not maintained and inadequate remedial action.NTSB SEA91LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Mead, WAImproper preflight planning by the pilot, and the pilot's delay in aborting the takeoff. Factors related to the accident were: the high temperature and unfavorable wind condiiton.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB SEA91LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Everett, WAThe student pilot's failure to maintain directional control. A factor related to the accident was: the taxiway marker's lack of frangibility due to its construction.NTSB SEA91LA210Accident · 1 fatalLimited investigationFinal reportWeyerts Rans S-10 · Stanwood, WAAn undetermined loss of engine power and the pilot's allowing the airspeed to decelerate below the stall speed during the subsequent forced landing.NTSB SEA91LA209Accident · No injuriesLimited investigationFinal reportCessna 172M · Oak Harbor, WAThe pilot's allowing the airspeed to decay below the stall speed. Factors contributing to the accident were the pilot's failure to maintain directional control and the pilot's lack of total recent experience.NTSB SEA91FA184Accident · 1 fatalField investigationFinal reportBell 206B · Toutle, WAFailure of the pilot to maintain airspeed and correct for the right yawing condition. Factors to the accident were: inadequate compensation for wind conditions, diverted attention, and lack of total expereince in type of aircraft.NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.NTSB SEA91LA192Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, WAA delayed go-around, and airspeed not being maintained. Factors include the pilot's overconfidence in the aircraft's ability, the pilot's lack of total experience in this type of operation, misjudged clearance, and the use of improper procedure.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB SEA91LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Pullman, WAThe pilot's failure to maintain runway alignment. Factors include high vegetation growing close to the runway.NTSB SEA91LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Walla Walla, WAThe student pilot's poor compensation for wind conditions. Factors were downdrafts and the student pilots lack of experience in this type of operation.NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.NTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.NTSB SEA91LA168Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Naches, WAThe pilot's poor in-flight decision. Factors include high density altitude, high winds and downdrafts.NTSB SEA91LA173Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Toledo, WADirectional control was not maintained.NTSB SEA91LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Sequim, WAThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was a hidden obstruction.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB SEA91LA158Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Benton City, WAThe pilot's disregard of the airplane's performance capability. Contributing to the accident was high density altitude.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB SEA91LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Richland, WAPartial engagement of the parking brake (locking the right brake) for an undetermined reason.NTSB SEA91FA143Accident · Serious injuriesField investigationFinal reportSikorsky S-64E · Index, WAThe control interference by the mechanic when he inadvertently raised the collective pitch and the copilot's failure to attend the flight controls. Factors relating to the accident were the motion sickness of the mechanic, inadequate collective pitch control…NTSB SEA91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakima, WAThe loss of control by the private pilot and failure of the instructor pilot to perform remedial action.NTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.NTSB SEA91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Wenatchee, WAThe pilot's failure to maintain a proper altitude. Contributing to the accident was sun glare.NTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.NTSB SEA91LA122Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Friday Harbor, WAThe pilot's poor preflight planning/preparation. Contributing to the accident were: the pilot did not maintain a proper clearance from an object, the pilot misjudged the wind conditions, and delayed remedial action.NTSB SEA91FA121Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12-D · Naches, WAThe in flight physical incapacitation of the pilot in command.