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 SEA92LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spokane, WAThe premature landing flare by the recently certificated private pilot, and her failure to properly recover from the bounced landing. A factor relating to the accident was the gusty wind conditions.NTSB SEA92LA163Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Battleground, WAThe pilot in command's delayed decision to execute a go around. Factors contributing the accident were: a tailwind, trees, and the improper use of the carburetor heat and flaps by the pilot in command.NTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.NTSB SEA92LA156Accident · Minor injuriesLimited investigationFinal reportThomsen, Horst Rotorway "EXEC" · Quilcene, WAA misjudged descent rate, and delayed corrective action. Factors include a lack of experience in this type of aircraft, and a building near the landing area.NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.NTSB SEA92LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wenatchee, WAThe failure of the pilot to maintain directional control during landing, resulting in a ground loop and aircraft impact with terrain. A factor relating to the accident was the gusty wind conditions.NTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).NTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.NTSB SEA92LA133Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Blakely Island, WAThe pilot in command's not maintaining the proper rate of descent and not maintaining directional control, and separation of the nose gear strut and overload of the right main gear strut. Factors contributing to the accident were: weather conditions: tailwind…NTSB SEA92FA130Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Prosser, WAInadequate inflight planning/preparation and airspeed was not maintained. A factor to the accident was: an uncontrolled stall/spin.NTSB SEA92LA129Accident · 1 fatalLimited investigationFinal reportWilliam Bovard Glasair · Woodland, WAInadequate airspeed. Factors to the accident were: a tailwind takeoff and poor preflight planning/preparation.NTSB SEA92LA128Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seattle, WAThe pilot's failure to follow procedures. A factor to the accident was: diverted attention.NTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.NTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.NTSB SEA92LA121Accident · No injuriesLimited investigationFinal reportMooney M20E · Freeland, WABlockage of the fuel injector servo system. Factors contributing to the accident were: fuel injection system corroded and animals in the landing area.NTSB SEA92LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Spangle, WAAltitude was not attained. A factor to the accident was: load jettison was not possible.NTSB SEA92FA116Accident · 3 fatalField investigationFinal reportCessna TR182 · Moxee City, WAThe pilot in command's inadvertently allowing the aircraft to stall. A factor contributing to the accident was: rising terrain.NTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.NTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.NTSB SEA92LA112Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wenatchee, WAThe pilot in command's inadequate visual lookout. Factors contributing to the accident were: object (fence post) and windshield dirty (foggy)NTSB SEA92LA118Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Deer Park, WAThe inadvertent activation of flight spoilers by the pilot and his failure to maintain airspeed, resulting in loss of control during takeoff. A factor relating to the accident was the presence of an irrigation sprinkler that was impacted by the aircraft…NTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.NTSB SEA92FA114Accident · 1 fatalField investigationFinal reportCessna 172B · Eatonville, WAUndetermined.NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.NTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.NTSB SEA92LA094Accident · No injuriesLimited investigationFinal reportFairchild 24W-40 · Toledo, WAThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. A factor contributing to the accident was crosswinds.NTSB SEA92LA091Accident · No injuriesLimited investigationFinal reportRockwell S2R · St. John, WAThe separation of the number 1 cylinder and remedial action by the PIC not possible. A factor contributing to the accident was: rough/uneven terrain.NTSB SEA92LA089Accident · 1 fatalLimited investigationFinal reportPilatus B-4 PC 11A · Wenatchee, WAFailure by the pilot to maintain airspeed, resulting in aircraft stall.NTSB SEA92FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Shaw Island, WAA delayed go-around, and procedures not being followed. Factors include a lack of total experience in this type of operation, trees near the runway, and an uphill runway slope.NTSB SEA92LA219Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Rockford, WAImproper use of rudder trim and poor preflight planning/preparation. Factors to the accident were: directional control was not maintained and lack of familiarity with aircraft.NTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.NTSB SEA92LA070Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Hoquiam, WAThe inadequate preflight planning and preparation by the pilot, and his failure to remove a tie down rope before takeoff.NTSB SEA92LA069Accident · No injuriesLimited investigationFinal reportCessna 150J · Tumwater, WAThe (student) pilot's improper recovery from a bounced landing. Factors contributing to the accident were excessive airspeed and the pilot's lack of total experience.NTSB SEA92LA065Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ione, WAAn inadvertent stall as a result of the pilot's failure to raise the flaps during a go-around.NTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.NTSB SEA92LA062Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Elbe, WAFuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.NTSB SEA92FA061Accident · 1 fatalField investigationFinal reportErcoupe 415-D · Winthrop, WAThe student pilot's alcoholic impairment of efficiency and judgement resulting in his failure to maintain airspeed during a go-around.NTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.NTSB SEA92FA049Accident · 2 fatalField investigationFinal reportCessna 150M · Pullman, WAPoor inflight planning/decision. Factors to the accident were bright night conditions and clearance not maintained.NTSB SEA92FA041Accident · 2 fatalField investigationFinal reportPiper PA-23-180 · Gold Bar, WAThe pilot becoming inadvertently lost/disoriented. The environmental conditions were factors in the accident.NTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.NTSB SEA92LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chehalis, WAThe failure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was the poor braking conditions on the wet grass strip.NTSB SEA92LA039Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Hansville, WAThe inadequate preflight preparation and improper inflight decision by the student pilot who was not qualified to conduct the flight. A factor relating to the accident was the adverse weather conditions.NTSB SEA92LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Tacoma, WAThe pilot's improper use of remedial action when he encountered carburetor icing. Factors include carburetor ice and carburetor icing conditions.NTSB SEA92LA058Accident · No injuriesLimited investigationFinal reportCessna 207 · Seattle, WAThe cargo door unlatched for undetermined reasons.NTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.NTSB SEA92FA026Accident · 7 fatalField investigationFinal reportCessna 172P · Snohomish, WAA visual lookout was not maintained.