NTSB investigations, WA
32 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 2 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 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\" = 430)
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" = 430) 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 DCA07IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Seattle, WAthe flight crew's failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the incident was the flight crew's self-induced pressure to heed the takeoff clearance during a period of increased workload.NTSB SEA05IA040Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Seattle, WAThe flight crew's failure to maintain an adequate visual lookout while on final for a visual approach. Factors include the failure of both airport operations personnel and the local FAA Airports Inspector to insure that some form of identification marking was…NTSB SEA04CA068Accident · No injuriesData collectionFinal reportYakovlev Yak 54 · Friday Harbor, WAThe pilot's failure to properly align with the runway. Factors include rough/uneven terrain, inadequate preflight planning and diminished forward visibility.NTSB SEA04IA045Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Seattle, WAThe First Officer's misidentification of the parallel taxiway as the active runway, resulting in the need for a sidestep maneuver while on short final for a full-stop landing. Factors include sun-glare from wet paved surfaces, a visual illusion created by the…NTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…NTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…NTSB SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.NTSB SEA00LA177Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, WADamage to aircraft under unknown circumstances.NTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB SEA99LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Omak, WAThe pilot's failure to properly secure the aircraft before hand-propping.NTSB SEA96FA071Accident · Minor injuriesField investigationFinal reportCessna U206E · Renton, WAthe pilot's initiation of a flight with a known disqualifying heart condition, and his subsequent inflight incapacitation from a heart attack. A factor relating to the accident was: the inability of the non-rated passenger (unqualified person) to attain a…NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.NTSB SEA92LA058Accident · No injuriesLimited investigationFinal reportCessna 207 · Seattle, WAThe cargo door unlatched for undetermined reasons.NTSB SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.NTSB SEA89LA038Accident · No injuriesLimited investigationFinal reportCessna 180A · Arlington, WAThe pilot attempted to hand-prop the engine without properly securing it.NTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.NTSB SEA88IA121Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-73F · Seattle, WACrew noted inflight indications of loss of hydraulic fluid, then carried out standard procedures per crew manual. Emerg hyd sys used to lower flaps for lndg. Acft landed with four right brakes locked. The tires blew and the wheels were ground flat.…NTSB SEA87LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Vancouver, WADuring a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during…NTSB SEA86IA240Incident · No injuriesIncident investigationFinal reportCameron D-50 · Seattle, WAThe acft plt and gnd crew were conducting gnd handling and mooring procedures. The plan was to ascend about 10 ft AGL over the fld. The fld was in a depression surrounded by tall trees and se of a 400 ft AGL radio twr. During lift off the gnd crew held the…NTSB SEA86LA199Accident · No injuriesLimited investigationFinal reportSchweizer 2-22EK · Easton, WAThe instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The…NTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…NTSB SEA85FA182Accident · 2 fatalField investigationFinal reportConsolidated-Vultee PBY-6A · Northport, WAWater bomber acft landed on lake with dump doors partially open during landing phase of water pickup run. Mechanically operated dump door locks were applied before dump doors were closed. Plt controlled dump doors from pilots control wheel, co-pilot operated…NTSB SEA85LA151Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Hoquiam, WAThe helicopter was being used during an external load operation to move large blocks of wood. However, while hovering, the sling broke. Subsequently, a block of wood struck a company employee on the head while he was working on the ground. The employee was…NTSB SEA85FA103Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Seattle, WAAfter liftoff, the plt requested an immediate return for landing stating he, 'smelled smoke/something hot'. Downwind for the precautionary landing was flown at 200 ft AGL, a slow airspeed and close to the runway with a crosswind blowing the acft toward the…NTSB SEA84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Wenatchee, WAThe plt made a low pass over a herd of elk in hilly terrain. He reported that after encountering a downdraft, he decided he could not climb out of the valley & landed with full flaps. The density alt was aprx 5400 ft.NTSB SEA84LA080Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26C · Mount Vernon, WAThe sailplane encountered deteridrating thermals & elected to make an off airport landing as he did not think he could reach the airport. He overshot the selected field in his attempt to miss some wires at the apch end of the field despitethe use of spoilers…NTSB SEA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Arlington, WAThe acft nosed over while taxiing unoccupied after being hand propped for a start by the pilot. The pilot stated that hewas unable to start the acft normally so he hand propped it with no one in the cockpit. The unoccupied acft taxied from the ramp across the…