NTSB investigations, WA
62 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 1 |
| 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\" = 310)
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" = 310) 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 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 SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB SEA04LA129Accident · No injuriesLimited investigationFinal reportLogston Starduster SA100DL · Arlington, WAThe pilot's failure to maintain clearance during taxi from another aircraft standing on the runway resulting in a collision. The aircraft standing on the runway was a factor.NTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.NTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.NTSB SEA02LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Quincy, WAThe pilot's failure to maintain the proper descent rate during the descent for landing. A proper glide path was not attained, inadequate remedial action, and a fence were factors.NTSB SEA02LA049Accident · No injuriesLimited investigationFinal reportBoeing 757-200 · Seattle, WAThe failure of the deicing truck driver to insure that the deicing basket boom remained clear of the aircraft structure as he backed away from the position he had been in while performing deicing procedures.NTSB SEA02LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAThe student pilot misjudged the distance from a fence during taxi. The flight instructors inadequate supervision and the fence were factors.NTSB SEA01LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Seattle, WAPilot's failure to maintain an adequate visual lookout during taxi. A fence was a factor.NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB SEA01LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Seattle, WAThe pilot's failure to visually detect the barricade, resulting in a collision with the barricade. Factors included the barricade, and inadequate information on the ATIS broadcast.NTSB SEA00LA191Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Auburn, WAThe pilot's failure to adequately secure the aircraft prior to a manual engine start. A contributing factor was the excessive throttle setting on start.NTSB SEA00LA180Accident · No injuriesLimited investigationFinal reportCessna 172L · Everett, WAThe other pilot's improper use (inadvertent release) of the brakes. Contributing factors were, a standing aircraft and the other pilot's diverting his attention from outside his aircraft.NTSB SEA00LA089Accident · Serious injuriesLimited investigationFinal reportGifford TR-4 · Wenatchee, WAThe pilot's improper decision to attempt to close the canopy (entry door) after it inadvertently opened in flight, instead of making a precautionary landing with it open. Factors include the pilot's failure to follow all items on the checklist, his failure to…NTSB SEA99LA160Accident · No injuriesLimited investigationFinal reportCessna 172M · Tahola, WAThe pilot's inadequate directional control and his failure to maintain clearance from trees along the side of the landing area. Factors include a landing area surrounded by tall trees.NTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.NTSB SEA98IA153Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135 · Moses Lake, WAAircraft control was not maintained.NTSB SEA98LA151Accident · No injuriesLimited investigationFinal reportCurtiss-Wright 12W · Woodland, WAThe pilot in command misjudged clearance from high vegetation when he landed. Factors include inadequate mowing of high vegetation by airport personnel, providing insufficient clearance for the wingspan of landing airplanesNTSB SEA98LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-30 · Everett, WAThe pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.NTSB SEA98LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Shores, WAThe pilot's failure to maintain clearance from a light standard (utility pole) just off the edge of the parking ramp. Factors include a light standard placed near the edge of the parking ramp.NTSB SEA97LA095Accident · No injuriesLimited investigationFinal reportCessna 172N · Pullman, WAThe pilot's failure to maintain clearance from a fuel truck parked near his taxi route. Factors include a dark night and a vehicle parked near the pilot's route of taxi.NTSB SEA97LA077Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8 · Wenatchee, WAfailure of the ground marshaller to marshal the airplane into a correct parking place on the ramp, her failure to verify clearance between the right wing of the airplane and the ground de-ice cart, and failure of the flight crew to ensure clearance of the…NTSB SEA97LA045Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Richland, WAfailure of the pilot to see-and-avoid an ultralight aircraft that was taxiing and had stopped in front of him.NTSB SEA97IA040Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Seattle, WAThe failure of the left wing walker to verify the clearance between the left wing and the fuel truck during taxi, and his delay in signaling the lead marshaller to alert the pilot to stop the aircraft prior to impact. Factors contributing to the incident…NTSB SEA96LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Spanaway, WAfailure of the pilot to use all available runway, including the overrun area, to stop the airplane. Factors relating to the accident were: the wet runway, and the pilot's inability to see the overrun from the runway due to the sloping terrain.NTSB SEA95LA203Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20B · Ephrata, WAThe pilot's failure to maintain clearance from from the fence post. The sunglare was a factor.NTSB SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.NTSB SEA93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ilwaco, WAThe pilot's inadequate pre-flight planning, and his attempt to take off with the aircraft over gross weight.NTSB SEA93LA127Accident · No injuriesLimited investigationFinal reportCessna 210L · Lynden, WADirectional control not being maintained. Factors include a high touchdown speed, light rain, and a wet landing surface.NTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.NTSB SEA91LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Everett, WAThe student pilot's failure to maintain directional control. A factor related to the accident was: the taxiway marker's lack of frangibility due to its construction.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB SEA91LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Pullman, WAThe pilot's failure to maintain runway alignment. Factors include high vegetation growing close to the runway.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB SEA91LA093Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Elma, WAThe pilot used inadequate starting procedures. Factors to the accident were: the pilot did not use proper assistance and the passenger's inadvertent control interference.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB SEA90LA014Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot failed to adequately compensate for tailwind conditions when landing on a short wet runway.NTSB SEA89LA146Accident · No injuriesLimited investigationFinal reportAbbott Gyroplane · Newport, WAThe pilot's selection of unsuitable terrain and the delay in aborting the takeoff.NTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.NTSB SEA88LA116Accident · No injuriesLimited investigationFinal reportTeratron Tierra 2 · Kent, WAPlt was intentionally taxiing on grass between paved runway and taxiway for better tailwheel control. The acft struck an unseen obstruction in dusk conditions.NTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.NTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.NTSB SEA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAPlt was following taxi line and failed to note parked acft left wing intruding into taxi lane. Contact between left wing tips resulted.NTSB SEA88LA027Accident · No injuriesLimited investigationFinal reportCessna 172M · Tacoma, WAThe Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor…NTSB SEA87LA138Accident · No injuriesLimited investigationFinal reportCessna 185 · Lake Chelan, WADuring takeoff from the water the plt noticed a log protruding out of the water. The acft struck the log and the plt rotated prematurely, became airborne, and then descended striking the water hard.NTSB SEA87LA136Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lester, WADuring landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway.