NTSB investigations, WA
63 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 3 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
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\" = 340)
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" = 340) 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 SEA06CA171Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Greenacres, WAThe pilot's selection of an unsuitable landing runway which resulted in a runway overrun and collision with a fence. A contributing factor was the wet runway condition.NTSB SEA06CA127Accident · No injuriesData collectionFinal reportCessna 182K · Center Island, WADistance/speed misjudged by the pilot during landing. Rough uneven terrain was a factor.NTSB SEA06CA027Accident · Minor injuriesData collectionFinal reportCessna TP206A · Snohomish, WAThe pilot's higher than normal airspeed on landing which resulted in a runway overrun. Contributing factors were the fog and the wet runway surface.NTSB SEA05CA174Accident · No injuriesData collectionFinal reportNavion Navion G · Port Orchard, WAThe pilot's delay in aborting the takeoff which resulted in a runway overrun. A contributing factor was the pilot's failure to raise the flaps prior to takeoff.NTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.NTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.NTSB SEA03LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Sullivan Lake, WAThe pilot-in-command's downwind landing. A contributing factor was the tailwind condition.NTSB SEA03LA135Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Arlington, WAThe pilot's failure to maintain proper approach speed and landing touch down point resulting in a runway overrun. A factor was the tailwind condition.NTSB SEA03FA106Accident · 1 fatalField investigationFinal reportDowner RC-3 · Yelm, WAThe failure of the pilot to abort the takeoff roll. Factors contributing to the accident included the failure of the aircraft to accelerate for undetermined reasons and the trees.NTSB SEA03LA084Accident · No injuriesLimited investigationFinal reportCessna 172 N · Center Island, WAThe pilot did not attain the proper touchdown point during landing. The pilot's diverted attention, deer near the runway, and trees were factors.NTSB SEA02LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Vancouver, WAThe pilot's delayed remedial action during the landing sequence. Factors include a wet runway surface.NTSB SEA02LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · South Prairie, WAThe pilot's improper touchdown point. Factors include a wet landing surface.NTSB SEA01TA050Accident · No injuriesFinal reportBeech 200 · Olympia, WAThe pilot's failure to attain the proper touchdown point for landing. A factor was weather conditions below published approach minimums.NTSB SEA01LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Waldron Island, WAThe pilot's improper distance/speed during the approach, which lead to an overrun during the landing roll and subsequent collision with trees. A factor was the trees beyond the upwind end of the runway.NTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.NTSB SEA99LA140Accident · No injuriesLimited investigationFinal reportCessna T210J · Sequim, WAThe pilot's failure to adequately compensate for the changing wind conditions. Factors include a berm located off the east end of the runway and a tailwind.NTSB SEA98LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Whidbey Airpark, WAThe pilot misjudged her altitude and airspeed. Factors include a wet runway surface and high vegetation off the end of the runway.NTSB SEA98LA041Accident · No injuriesLimited investigationFinal reportCessna 175 · Port Townsend, WAThe pilot's misjudged distance and speed during landing. A factor was the wet grass runway.NTSB SEA98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vashon, WAA misjudged soft field takeoff. Factors include wet grass.NTSB SEA97LA220Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stuart Island, WAThe pilot's improper decision to land on a wet grass runway with a ten knot tailwind. Factors were the wet runway surface and tailwind.NTSB SEA97LA175Accident · No injuriesLimited investigationFinal reportCessna T210H · Stehekin, WAThe pilot's misreading of the windsock and subsequent downwind landing. Factors in the accident were the sunglare and tailwind.NTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…NTSB SEA97LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · College Place, WAThe certified flight instructor's improper in-flight decision to continue the landing attempt and not perform a go-around, her failure to attain the proper touchdown point, and her failure to apply proper remedial action. A contributing factor was the…NTSB SEA96LA177Accident · No injuriesLimited investigationFinal reportCessna U206F · Crane Island, WAthe pilot's failure to correctly judge the surface winds in the vicinity of the runway. Factors relating to the accident were: a tailwind during landing, a short runway with a wet surface, and an embankment/drop-off at the end of the airstrip.NTSB SEA96LA080Accident · No injuriesLimited investigationFinal reportCessna 150 · Spiden Island, WAthe pilot's selection of an unsuitable airstrip for the landing and subsequent takeoff, and his delay in aborting the takeoff, which resulted in an overrun and collision with an embankment and trees. Factors relating to the accident were: the short, wet,…NTSB SEA96LA056Accident · No injuriesLimited investigationFinal reportCessna 172P · Cashmere, WAthe pilot's selection of the wrong runway for landing, by not observing a procedure to land uphill during calm wind conditions, and his subsequent failure to retract the flaps during landing roll, as recommended by the airplane's short-field landing…NTSB SEA95LA107Accident · No injuriesLimited investigationFinal reportCessna 172B · Sinclair Island, WAThe pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.NTSB SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.NTSB SEA94LA102Accident · No injuriesLimited investigationFinal reportCessna 172L · Colville, WAThe pilot's failure to attain a proper touchdown point, and his excessive airspeed at the point of touchdown. Factors include the student pilot's lack of recent experience, and a ravine off the end of the runway.NTSB SEA94LA049Accident · Minor injuriesLimited investigationFinal reportGrumman American AA1B · Lacey, WAThe pilot in command's failure to attain the proper touchdown point. Factors contributing to the accident were tailwinds and wet terrain.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.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 SEA91LA259Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Granite Falls, WAThe pilot's decision to not perform a go-around and a misjudged distance.NTSB SEA91LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Mead, WAImproper preflight planning by the pilot, and the pilot's delay in aborting the takeoff. Factors related to the accident were: the high temperature and unfavorable wind condiiton.NTSB SEA91FA039Accident · 1 fatalField investigationFinal reportCessna 140 · Port Orchard, WAThe pilot's failure to initiate an aborted takeoff at a time that left adequate runway remaining to bring the aircraft to a stop.NTSB SEA90LA034Accident · No injuriesLimited investigationFinal reportCessna 177B · Friday Harbor, WAFailure of the pilot to attain the proper touchdown point or go-around. Factors related to the accident concerned the runway condition.NTSB SEA89LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Alderwood Manor, WAImproper planning/decision by the pilot. The tailwind and high obstructions were related factors.NTSB SEA89LA009Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Skykomish, WAThe plt made an apch over tall trees to land on a 2050 ft strip. The acft touched down on wet turf with about 500 ft of rwy remaining. The plt was unable to stop the acft on the remaining rwy. Subsequently, it contd off the departure end & went into a large…NTSB SEA88LA192Accident · No injuriesLimited investigationFinal reportCessna 207 · Center Island, WAThe plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &…NTSB SEA88LA170Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Toledo, WAThe pilot aborted the first takeoff due to the engine not developing full power. After another run up, the pilot elected to make another takeoff. The pilot aborted midfield, by retarding the power and applying heavy braking, due to the aircraft not developing…NTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…NTSB SEA88LA001Accident · No injuriesLimited investigationFinal reportBritish Aerospace BA-3101 · Kennewick, WAWhile on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain.NTSB SEA87LA177Accident · Serious injuriesLimited investigationFinal reportCanton Rutan Long · Port Townsend, WADuring takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip…NTSB SEA87LA160Accident · No injuriesLimited investigationFinal reportCessna TR182 · Eatonville, WAThe plt rprtd that drg a lndg, the apch was a little high & the acft touched down long on the turf/gravel rwy. He thought there was sufficient rwy remaining to stop & did not initiate a go-around. However, he said 'braking on dry grass & moss was not…NTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…NTSB SEA85LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Bellingham, WAThe plt, who was unfamiliar with the area, was given directions & traffic pattern info to the meadows mist arpt, a a pvt/charted strip near Bellingham, WA. She came upon a similar grass strip in that area with a parked acft on it. Thinking this uncharted…NTSB SEA85LA175Accident · No injuriesLimited investigationFinal reportCessna 150C · Chesaw, WAThe student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over.