NTSB investigations, WA
99 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 7 |
| 1988 | 13 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 3 |
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\" = 240)
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" = 240) 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 LAX08MA007Accident · 10 fatalMajor investigationFinal reportCessna 208B · Naches, WAThe pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…NTSB SEA07CA183Accident · No injuriesData collectionFinal reportCessna 172N · Greenwater, WAThe in-flight encounter with a sudden windshift during the takeoff initial climb, to which the certified flight instructor responded by aborting the takeoff and landing off the end of the runway. The ditch was a contributing factor.NTSB SEA07FA148Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Quilcene, WAThe pilot's continued flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. Factors contributing to the accident included the low clouds which obscured the rising, mountainous terrain.NTSB SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.NTSB SEA06FA147Accident · 1 fatalField investigationFinal reportCessna 421C · Carson, WAThe pilot's failure to maintain aircraft control while maneuvering. Icing conditions, clouds and the pilot's continued flight into known adverse weather were factors.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 SEA05FA013Accident · 1 fatalField investigationFinal reportCessna 172P · Olympia, WAThe pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.NTSB SEA04FA169Accident · 1 fatalField investigationFinal reportCessna A185F · Toutle, WAThe pilot's continued flight into known adverse weather conditions. Inadequate preflight planning/preparation, trees, a low ceiling and no suitable terrain available for the landing were factors.NTSB SEA04FA154Accident · 1 fatalField investigationFinal reportCessna 182P · Port Angeles, WAThe pilot's VFR flight into IMC and his failure to maintain clearance from trees. Trees, mountainous terrain, dark night conditions, clouds and VFR flight into IMC were factors.NTSB SEA04LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Mazama, WAThe pilot's inadequate compensation for the weather conditions and his failure to maintain the initial takeoff climb, which resulted in a collision with trees during an emergency landing. Contributing factors were the unfavorable wind and high density…NTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.NTSB SEA03LA037Accident · No injuriesLimited investigationFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.NTSB SEA03LA019Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-135 P1 · Loon Lake, WAThe pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions.NTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…NTSB SEA01FA070Accident · 2 fatalField investigationFinal reportCessna 182P · Fairfield, WAThe pilot's failure to maintain altitude and/or clearance over trees, resulting in a collision with trees, separation of a wing and uncontrolled collision with terrain. Factors included the pilot's inadequate preflight planning and preparation, dark night…NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB SEA99LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Eatonville, WAInadequate inflight planning/preparation and terrain clearance not maintained. Mountainous terrain, cloudy conditions and delayed remedial action are factorsNTSB SEA99FA126Accident · 2 fatalField investigationFinal reportCessna T-337 G-P · Snoqualmie Pass, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering below low ceilings. Factors include low ceilings and inadequate in-flight planning.NTSB SEA99LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Bellingham, WAInadequate preflight planning/preparation, and the pilot's failure to maintain altitude. VFR flight into IMC conditions and cloudy weather conditions were factors.NTSB SEA98LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from terrain. Clouds and mountainous terrain were a factor.NTSB SEA97LA113Accident · No injuriesLimited investigationFinal reportCessna 207 · Roche Harbor, WAThe pilot's inadequate remedial action upon encountering a downdraft on final approach. The downdraft was a factor.NTSB SEA97LA050Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Lopez, WAThe pilot's improper decision to initiate flight into marginal VFR conditions at night which led to inadvertent flight into instrument meteorological conditions, and his failure to maintain adequate clearance from terrain. Factors contributing to the accident…NTSB SEA97LA030Accident · No injuriesLimited investigationFinal reportCessna 421B · Olympia, WAinoperative deicing equipment, due to multiple wing boot holes and malfunctioning control/shuttle valves; subsequent build-up of airframe (wing) ice; and failure of the pilot to maintain adequate airspeed during the flare for landing. Factors relating to the…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 SEA95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sekiu, WAThe pilot's continued flight into adverse weather necessitating a landing on a highway. The weather was a factor.NTSB SEA95FA093Accident · 2 fatalField investigationFinal reportCessna 152 · Snoqualmie Pass, WAThe pilot's attempt to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance with the terrain.NTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.NTSB SEA93FA026Accident · 6 fatalField investigationFinal reportBeech A60 · Snoqualmie Pass, WAFailure of the pilot to maintain control of the aircraft, his failure to prevent the aircraft from exceeding the never exceed speed (vne), and subsequent exceeding of the design stress limits of the aircraft. Factors related to the accident were: weather…NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.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 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 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 SEA91FA119Accident · 2 fatalField investigationFinal reportStinson 108-2 · Gold Bar, WAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to remain clear of the obstacles (trees). The adverse weather condition (fog) was a related factor.NTSB SEA91FA061Accident · 3 fatalField investigationFinal reportCessna 172M · Bellingham, WAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or cleareance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and terrain conditions.NTSB SEA91FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Bellingham, WAVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or clearance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and…NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB SEA90LA155Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Chehalis, WAThe pilot's inadequate compensation for wind conditions. The gusty crosswind ws a related factor.NTSB SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.NTSB SEA90FA071Accident · 1 fatalField investigationFinal reportNorth American Navion H · Enumclaw, WAPilot's inadequate preflight planning, and inadvertent flight into IMC conditions. Factors in the accident were the low ceiling and visibility weather conditions, the mountainous/hill terrain, the pilot's lack of instrument qualification and his lack of…NTSB SEA90FA039Accident · 1 fatalField investigationFinal reportPiper PA28-180 · Castle Rock, WAThe pilot lost control of the airplane which entered a stall/spin that the pilot did not recover from.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…NTSB SEA90FA028Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Rainier, WAContinued flight by the pilot into known adverse weather conditions, and his failure to maintain sufficient altitude/clearance from wooded mountainous terrain. Factors related to the accident were: darkness and the weather/terrain conditions.NTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB SEA90FA005Accident · 1 fatalField investigationFinal reportHughes 369D · Bothell, WAThe pilot failed to determine weather conditions before the flight, his attempt to fly VFR in IMC, and his failure to maintain obstacle clearance altitude. Factors in the accident were the low ceiling, rain and fog weather conditions.NTSB SEA90FA002Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Cougar, WAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.NTSB SEA89LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Snoqualmie Pass, WAImproper in-flight planning/descision by the pilot, which resulted in the aircraft entering a box canyon with insufficient speed and altitude to maneuver out of the confined area. Factors related to the accident were: the pilot's continued flight into known…NTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.NTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.