NTSB investigations, 2007, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1963 | 1 |
|---|---|
| 1964 | 110 |
| 1965 | 131 |
| 1966 | 140 |
| 1967 | 159 |
| 1968 | 125 |
| 1969 | 116 |
| 1970 | 118 |
| 1971 | 86 |
| 1972 | 107 |
| 1973 | 104 |
| 1974 | 109 |
| 1975 | 129 |
| 1976 | 117 |
| 1977 | 104 |
| 1978 | 118 |
| 1979 | 118 |
| 1980 | 107 |
| 1981 | 102 |
| 1982 | 95 |
| 1983 | 101 |
| 1984 | 89 |
| 1985 | 73 |
| 1986 | 100 |
| 1987 | 79 |
| 1988 | 80 |
| 1989 | 76 |
| 1990 | 78 |
| 1991 | 94 |
| 1992 | 79 |
| 1993 | 69 |
| 1994 | 67 |
| 1995 | 73 |
| 1996 | 65 |
| 1997 | 62 |
| 1998 | 67 |
| 1999 | 68 |
| 2000 | 67 |
| 2001 | 66 |
| 2002 | 66 |
| 2003 | 74 |
| 2004 | 75 |
| 2005 | 59 |
| 2006 | 49 |
| 2007 | 53 |
| 2008 | 58 |
| 2009 | 58 |
| 2010 | 51 |
| 2011 | 58 |
| 2012 | 54 |
| 2013 | 37 |
| 2014 | 47 |
| 2015 | 36 |
| 2016 | 32 |
| 2017 | 39 |
| 2018 | 47 |
| 2019 | 37 |
| 2020 | 28 |
| 2021 | 41 |
| 2022 | 35 |
| 2023 | 36 |
| 2024 | 29 |
| 2025 | 37 |
| 2026 | 29 |
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 year(c.\"eventDate\") = 2007
AND 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 year(c."eventDate") = 2007 AND 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 SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.NTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.NTSB SEA08CA039Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Yelm, WAThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing roll. Contributing factors were the rough/uneven terrain and log.NTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.NTSB SEA08LA020Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58+ · Cougar, WAThe pilot's failure to maintain clearance from a nearby tree while performing a hover-climb. Factors include his failure to maintain clearance from his long-line cable, and his likely diverted attention to the entanglement of the cable on the helicopter's…NTSB LAX08CA022Accident · No injuriesData collectionFinal reportBagnall Harold E Kitfox Lite 2 · N. Bonneville, WAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude that resulted in a stall-mush condition and collision with the water.NTSB SEA08FA013Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Sequim, WAThe pilot's misjudged distance and altitude that led to an undershoot; his failure to maintain directional control during the landing roll; and his failure to maintain clearance from trees during an attempted aborted landing.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 LAX07CA287Accident · No injuriesData collectionFinal reportCessna 150L · Woodland, WAa partial loss of engine power due to carburetor icing conditions.NTSB SEA07FA262Accident · 3 fatalField investigationFinal reportBeech A-36TC · Burlington, WAThe pilot's decision to descend below the published minimum descent altitude (MDA), and his failure to maintain clearance from vertical objects during an instrument approach. Contributing to the accident were low ceilings, inadequate preflight planning, and…NTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.NTSB LAX07LA270Accident · 1 fatalLimited investigationFinal reportHughes 369D · Ellensburg, WAThe passenger's inadequate visual lookout and failure to maintain clearance from the rotating main rotor disc while the helicopter was hovering. An uphill terrain condition was a factorNTSB LAX07CA269Accident · Minor injuriesData collectionFinal reportStinson 108-2 · Port Townsend, WAThe pilot's failure to adequately compensate for a wind conditions and maintain directional control during the touchdown and a subsequent aborted landing attempt.NTSB LAX07CA265Accident · No injuriesData collectionFinal reportCessna 182P · Fall City, WAThe pilot's failure to maintain directional control.NTSB LAX07CA264Accident · No injuriesData collectionFinal reportAeronca S15AC · Shelton, WAThe pilot's loss of control during takeoff following the inadvertent encounter with a boat's wake.NTSB LAX07CA260Accident · Serious injuriesData collectionFinal reportAyres SR2 · Goldendale, WAThe failure of the parachute wing to completely deploy, which resulted in the pilot's failure to maintain directional control during takeoff.NTSB SEA07CA238Accident · No injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Blaine, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing from the paved runway surface. Contributing factors were the crosswind and the soft ground.NTSB LAX07LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lopez Island, WAA loss of engine power due to the fatigue failure of the left idler gear. Inadequate maintenance installation of the recently installed left magneto was also causal.NTSB LAX07CA254Accident · Minor injuriesData collectionFinal reportCessna 172 · Leavenworth, WAthe pilot's failure to maintain an adequate clearance from the trees.NTSB LAX07CA252Accident · No injuriesData collectionFinal reportCessna 140 · Olympia, WAThe pilot's failure to maintain directional control during landing.NTSB SEA07CA235Accident · No injuriesData collectionFinal reportCessna 172B · Seattle, WAThe private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…NTSB SEA07CA227Accident · Minor injuriesData collectionFinal reportMapes Kitfox V · Silverdale, WAThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall and uncontrolled descent to terrain impact.NTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.NTSB LAX07LA245Accident · Minor injuriesLimited investigationFinal reportBurnham Avid Flyer · Sequim, WAa loss of engine power due to a dual ignition system failure.NTSB SEA07CA226Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Waterville, WAThe loss of engine power during takeoff for an undetermined reason. A contributing factor was the high vegetation in the field where the airplane came to rest.NTSB LAX07CA259Accident · Serious injuriesData collectionFinal reportSix Chutter SR7 · Toledo, WAA hard landing following the pilot's in-flight loss of control.NTSB SEA07FA223Accident · 4 fatalField investigationFinal reportRobinson R44 II · Easton, WAThe pilot's improper planning/decision in attempting a downwind takeoff under high density altitude conditions that resulted in a loss of control and impact with terrain. Contributing to the accident were the helicopter's gross weight in excess of the maximum…NTSB LAX07LA233Accident · Minor injuriesLimited investigationFinal reportDehavilland DHC-1B · Olympia, WAThe loss of engine power due to water-contaminated fuel, and maintenance personnel's inadequate inspection of the fuel system.NTSB SEA07FA218Accident · 2 fatalField investigationFinal reportMooney M20E · Tonasket, WAThe pilot's failure to maintain an adequate airspeed during initial climb following an aborted landing that resulted in a stall/spin. The pilot's misjudged speed and distance that resulted in a failure to attain a proper touchdown point was a factor.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 SEA07FA195Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Everett, WAThe pilot's inadequate preflight planning and inspection that led to oil exhaustion and a catastrophic engine failure. Also causal was the pilot's attempted operation of an aircraft with known deficiencies, and the lack of a current airworthiness inspection.…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 LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.NTSB LAX07CA207Accident · Minor injuriesData collectionFinal reportCessna 170 · Spanaway, WAThe pilot's failure to maintain directional control during an aborted takeoff from a short and narrow runway.NTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.NTSB SEA07CA185Accident · Minor injuriesData collectionFinal reportHammer Thorp T-18 · Everett, WAExcessive airspeed during a return for landing which resulted in an overrun. An unlatched canopy, a proper touchdown point not attained and rough terrain were factors.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 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 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 SEA07FA134Accident · 1 fatalField investigationFinal reportCessna 185 · Wilbur, WAIn-flight collision with terrain shortly after takeoff for undetermined reasons.NTSB SEA07LA249Accident · 1 fatalLimited investigationFinal reportCessna 177 · Pinecliff, WAThe pilot's failure to maintain clearance from the trees while maneuvering in mountainous terrain. Factors include the mountainous terrain, low ceilings, and trees in the area where the pilot was maneuvering.NTSB SEA07CA127Accident · No injuriesData collectionFinal reportCessna A185F · Renton, WAThe pilot's loss of aircraft control during a landing attempt, which resulted in an inadvertent ground loop.NTSB LAX07LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAA loss of engine power during cruise due to carburetor icing, and the pilot's delay in using carburetor heat.NTSB SEA07CA121Accident · No injuriesData collectionFinal reportCessna 180G · Lopez Island, WAThe pilot's failure to maintain directional control during takeoff. Geese were a factor.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 SEA07LA088Accident · No injuriesLimited investigationFinal reportJohnson Zodiac CH601 · Arlington, WAThe pilot's failure to apply carburetor heat when the engine lost power while being operated at a reduced power setting. Factors include carburetor icing condition, the pilot's failure to acquire the temperature/dew point information, and soft terrain in the…NTSB SEA07CA086Accident · No injuriesData collectionFinal reportPiper PA-22 · Enumclaw, WAThe pilot's failure to apply carburetor heat during cruise flight. Factors include ambient weather conditions that were conducive to carburetor icing, and soft, muddy terrain at the location where the pilot attempted the power-off forced landing.NTSB SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.NTSB SEA07LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Bellingham, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for a forced landing, and the trees.