NTSB investigations, 2002, WA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

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 year(c.\"eventDate\") = 2002
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
  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.

NTSB SEA02FA060Accident · No injuriesField investigationFinal reportBoeing S-307 · Seattle, WALoss of all engine power due to fuel exhaustion that resulted from the flight crew's failure to accurately determine onboard fuel during the pre-flight inspection. A factor contributing to the accident was a lack of adequate crew communication regarding the…Mar 28, 2002 · N19903 · Substantial damageNTSB SEA02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · NAS Whidbey, WAThe pilot's improper decision to taxi behind a standing large military turbo-prop aircraft, which he knew may be performing periodic engine test runs, without first initiating communications to insure that the engine power on the standing aircraft would…Mar 18, 2002 · N25455 · Substantial damageNTSB SEA02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Deer Park, WALoss of directional control while landing. A drainage ditch was a factor.Mar 17, 2002 · N77301 · Substantial damageNTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.Mar 14, 2002 · N8065A · Substantial damageNTSB SEA02LA051Accident · No injuriesLimited investigationFinal reportBell/Garlick UH-1H · Dayton, WAA loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.Mar 8, 2002 · N116DR · Substantial damageNTSB 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.Mar 2, 2002 · N589UA · Substantial damageNTSB SEA02LA045Accident · No injuriesLimited investigationFinal reportGunderson Floatmaster · Elma, WALoss of engine power for undetermined reasons. Soft terrain was a factor.Feb 27, 2002 · N2425D · Substantial damageNTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.Feb 26, 2002 · N168B · Substantial damageNTSB SEA02LA042Accident · No injuriesLimited investigationFinal reportCessna 172 · Concrete, WAThe pilot's failure to maintain adequate clearance/altitude while reversing course and turning towards rising, tree covered terrain in downdraft conditions. Contributing factors were trees, rising terrain, downdrafts and the pilot's in-flight decision to turn…Feb 20, 2002 · C-FISS · Substantial damageNTSB SEA02FA036Accident · Serious injuriesField investigationFinal reportAero Commander 520 · Puyallup, WAThe pilot's failure to maintain aircraft control during takeoff. Trees were a factor.Feb 2, 2002 · N520SE · Substantial damageNTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.Jan 28, 2002 · N23849 · Substantial damageNTSB SEA02FA030Accident · Serious injuriesField investigationFinal reportAgusta A109A II · Baring, WAThe sequential non-mechanical total loss of power in both engines 1 and 2 for undetermined reasons and the pilot's failure to maintain adequate rotor RPM to prevent a hard landing. Contributing factors were the tripped "RPM WARN" circuit breaker which…Jan 20, 2002 · N55NW · Substantial damageNTSB SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.Jan 13, 2002 · N704NY · Substantial damageNTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.Jan 13, 2002 · N2669J · DestroyedNTSB SEA02LA026Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Renton, WAThe flight instructor's failure to ensure that adequate altitude/clearance above the ground was maintained during hovering flight, resulting in an inadvertent ground contact and subsequent loss of control of the helicopter. A factor was the flight…Jan 11, 2002 · N7185A · Substantial damageNTSB SEA02LA024Accident · No injuriesLimited investigationFinal reportHughes 369E · Grand Coulee, WAThe net gunner's improper decision to fire the net gun at an angle that allowed the net to become entangled in the main rotor system. A factor was foreign object damage to the main rotor blades.Jan 8, 2002 · N369ET · Substantial damage