NTSB investigations, WA
84 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 1 |
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\" = 200)
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" = 200) 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 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 SEA06LA172Accident · No injuriesLimited investigationFinal reportMooney M20C · Eastsound, WAThe pilot's failure to maintain airspeed during final approach resulting in an inadvertent stall and hard landing.NTSB SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.NTSB SEA06LA100Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Battle Ground, WAthe pilot's excessive airspeed and exceeding the proper touchdown point during landing, which resulted in a hard landing and subsequent overrun of the runway. Factors contributing to the accident included the fence, the trees and the pilot's failure to…NTSB SEA05LA064Accident · No injuriesLimited investigationFinal reportCessna 182Q · Shelton, WAThe pilot's improper flare which resulted in a hard landing.NTSB SEA05LA044Accident · No injuriesLimited investigationFinal reportSmuz RAF 2000 GTX SE · Puyallup, WAThe pilot's misjudged flare followed by an oscillation which damaged the aircraft.NTSB SEA05LA042Accident · No injuriesLimited investigationFinal reportMaule M-7-260 · Port Angeles, WAThe pilot's improper flare. Factors contributing to the accident included the pilot's improper approach and the glassy water condition.NTSB SEA05CA035Accident · No injuriesData collectionFinal reportCessna 310J · Davenport, WAThe pilot's failure to maintain adequate airspeed during landing with airframe ice, which resulted in an inadvertent stall and hard landing. Factors were the icing conditions and the airframe ice.NTSB SEA05LA047Accident · No injuriesLimited investigationFinal reportCessna 182K · Olympia, WAThe pilot's improper flare. Factors include too high of an airspeed and an inadvertent porpoise.NTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.NTSB SEA03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Pasco, WAIcing conditions and the pilot's failure to maintain adequate airspeed during the landing. An inadvertent stall was a factor.NTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.NTSB SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.NTSB SEA02LA115Accident · No injuriesLimited investigationFinal reportSeattle Aerotech Helipower 2500 · Arlington, WAAircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.NTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.NTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…NTSB SEA99LA092Accident · No injuriesLimited investigationFinal reportHughes 369D · Shelton, WAThe pilot's failure to maintain rotor RPM during an autorotation.NTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.NTSB SEA99LA052Accident · No injuriesLimited investigationFinal reportCessna 177 · Auburn, WAThe pilot's improper flare. Contributing factors were gusty, crosswind conditions, and the student's minimal overall experience.NTSB SEA99LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bellingham, WAA hard landing due to the pilot's failure to maintain a proper descent rate. Factors include gusts and turbulence.NTSB SEA97FA188Accident · Serious injuriesField investigationFinal reportBeech 1900C · Seattle, WAA stall/mush condition resulting from an aft center of gravity which was inaccurately provided to the pilot-in-command by contractual cargo-loading personnel. Additional causes were overloading of the aircraft's landing gear and fuel leakage resulting in a…NTSB SEA97LA054Accident · No injuriesLimited investigationFinal reportCessna 182M · Vancouver, WAThe pilot-in-command's touchdown with an excessive rate of descent. Factors included gusty crossiwnds.NTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB SEA95LA228Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAfailure of the pilot to properly flare the airplane during the landing. Factors relating to the accident were: the pilot's improper approach to land, exceeding the proper touchdown point for landing, failure to go-around, while there was sufficient runway…NTSB SEA95LA124Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Renton, WAThe pilot misjudged the flare.NTSB SEA94LA243Accident · No injuriesLimited investigationFinal reportCessna 172N · Orcas, WAThe pilot's improper landing flare.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.NTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.NTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.NTSB SEA94LA027Accident · No injuriesLimited investigationFinal reportSpringer Christina Minicoupe · Spokane, WAThe pilot in command's failure to maintain a proper descent rate.NTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.NTSB SEA93LA111Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Walla Walla, WAThe premature landing flare by the pilot which resulted in a hard landing and the pilot's failure to maintain airspeed above stall speed during the balked landing.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 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 SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.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 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 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 SEA91FA124Accident · No injuriesField investigationFinal reportBell 206BII · Brewster, WAThe pilot-in-command's selection of unsuitable terrain for the emergency simulation.NTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.NTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.NTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.NTSB SEA89LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Tacoma, WAThe pilot's improper flare and improper recovery from the bounced landing. Contributing factors were the pilot's low total flight time and his inexperience in the Cessna 180 airplane.NTSB SEA89LA067Accident · No injuriesLimited investigationFinal reportCessna TU206 · Anacortes, WAThe pilot diverted his attention during the landing, which resulted in an improper flare & hard landing. His lack of recent flying experience was a related factor.NTSB SEA89LA037Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Townsend, WAImproper approach and flare technique on the part of the pilot, resulting in a hard landing. Contributing to the accident were tall trees surrounding the airstrip.