NTSB investigations, WA
190 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 13 |
| 1984 | 10 |
| 1985 | 5 |
| 1986 | 14 |
| 1987 | 13 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 10 |
| 1992 | 14 |
| 1993 | 7 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 9 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 10 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 5 |
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\" = 250)
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" = 250) 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 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 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 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 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 SEA06CA189Accident · Minor injuriesData collectionFinal reportNorthwing Apache Sport · Brewster, WAThe pilot's failure to maintain control of the aircraft during the landing, resulting in its impact with terrain. A factor was the wind gust condition.NTSB SEA06LA134Accident · 3 fatalLimited investigationFinal reportTaylor Royal T · Davenport, WAThe pilot's failure to maintain aircraft control while maneuvering, resulting in a collision with terrain.NTSB SEA06CA086Accident · No injuriesData collectionFinal reportSchmidt RV7A · Northport, WAThe pilot's failure to maintain directional control during the landing flare/touchdown. Factors contributing to the accident included the gusty wind and soft terrain conditions which resulted in the aircraft nosing over during the landing roll.NTSB SEA06LA064Accident · No injuriesLimited investigationFinal reportSessi Midget Mustang SK-1 · Everett, WAThe pilot did not abort the takeoff and subsequently did not maintain aircraft control during the initial takeoff climb. The installation of the wrong propeller assembly and inadequate maintenance were factors.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.NTSB SEA05CA027Accident · Minor injuriesData collectionFinal reportBreit Zodiac (CH-601-HDS) · Everett, WAThe pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.NTSB SEA05LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Oak Harbor, WAThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain.NTSB SEA04TA163Accident · 1 fatalFinal reportBell 206B · Mead, WAThe reversal of the reel machine during a sock line pull which resulted in a loss of control while hovering out of ground effect. Factors were the failure of company management to develop adequate procedures for conducting sock line pulls, the inadequate…NTSB SEA04CA132Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Waitsburg, WAThe pilot's failure to maintain aircraft control and his inadequate compensation for the wind conditions during the landing. Gusts and high vegetation were factors.NTSB SEA04LA090Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, WALoss of control for undetermined reasons.NTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.NTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.NTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.NTSB SEA03LA134Accident · No injuriesLimited investigationFinal reportArcher S-18T · Arlington, WAThe pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.NTSB SEA03LA132Accident · Serious injuriesLimited investigationFinal reportHanks Avid Flyer · Toledo, WAThe pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.NTSB SEA03CA112Accident · No injuriesData collectionFinal reportCessna 177 · Woodland, WAThe pilot's premature liftoff and his failure to maintain/obtain airspeed and directional control during takeoff.NTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.NTSB SEA03LA072Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Ephrata, WAThe pilot's failure to maintain aircraft control while on final approach for landing. Low airspeed was a factor.NTSB SEA03LA050Accident · No injuriesLimited investigationFinal reportHiperlight SNS-8 · South Prairie, WAThe failure of the pilot to maintain control of the aircraft during the crosswind turn resulting in an inadvertent spin entry, followed by his intentional stall to a landing resulting in a hard landing and subsequent nose over.NTSB SEA03FA041Accident · 2 fatalField investigationFinal reportGrubert KIS TRI-R TR-1 · Puyallup, WAThe pilot-in-command's failure to maintain adequate flying airspeed during the turn from crosswind to downwind resulting in an inadvertent stall/spin and subsequent collision with terrain (ground).NTSB SEA02LA150Accident · No injuriesLimited investigationFinal reportHughes 269A · Covington, WAAircraft control not maintained while hovering.NTSB SEA02LA126Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Deer Park, WALoss of control for undetermined reasons.NTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…NTSB SEA02FA106Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics LA-4-200 · Puyallup, WAFailure to maintain aircraft control during a go-around. Trees were a factor in the accident.NTSB SEA02LA076Accident · Serious injuriesLimited investigationFinal reportCook RS-15 · Richland, WAAirspeed was not maintained while maneuvering. An inadvertent stall, remedial action was not attained, and the student pilot's lack of total experience were factors.NTSB SEA02FA036Accident · Serious injuriesField investigationFinal reportAero Commander 520 · Puyallup, WAThe pilot's failure to maintain aircraft control during takeoff. Trees were a factor.NTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.NTSB SEA02LA012Accident · 1 fatalLimited investigationFinal reportThurston Pitts S-1S · Eatonville, WAThe pilot's unsuccessful corrective action (recovery) from an inverted spin. A contributing factor was the pilot's encounter with the inverted spin maneuver.NTSB SEA02FA002Accident · 3 fatalField investigationFinal reportCessna 172N · Decatur Island, WAThe pilot's failure to maintain airspeed during a low altitude turn, resulting in a stall. The pilot exceeding the aircraft's maximum gross takeoff weight was a factor.NTSB SEA01LA160Accident · Serious injuriesLimited investigationFinal reportShank Kitfox Model II · Battle Ground, WAThe pilot's failure to maintain adequate airspeed during climbout.NTSB SEA01FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Puyallup, WAThe pilot's failure to maintain adequate airspeed during departure resulting in a stall. Trees were a factor in the accident.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.NTSB SEA01FA089Accident · 2 fatalField investigationFinal reportRobinson R44 · Gorst, WAAn abrupt application of the tail rotor/anti-torque pedal by an unknown pilot resulting in tail rotor contact with the tail boom. Tail rotor blades and empennage assembly separation, and trees were factors.NTSB SEA00LA169Accident · Serious injuriesLimited investigationFinal reportClearwaters RAF 2000 · Leahy, WAA loss of control for undetermined reasons.NTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.NTSB SEA00FA023Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK. I · Washougal, WAThe pilot's failure to ensure attainment of adequate airspeed prior to initiating a steep turn at low altitude, resulting in an accelerated stall. A factor contributing to the occurrence of the accident was the aircraft's low altitude. Factors contributing to…NTSB SEA99LA151Accident · 1 fatalLimited investigationFinal reportRotordyne 200 · Kent, WAThe owner/builder's failure to properly torque the rotor blade retaining bolts.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB SEA99LA110Accident · Minor injuriesLimited investigationFinal reportParks RV-6 · Hunters, WAThe pilot's failure to maintain adequate airspeed during an attempted go-around.NTSB SEA99LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WACompensation for wind conditions was inadequate. Gusting wind conditions was a factor.