NTSB investigations, 2000, WA

10 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 2000, WA per year, 1982–2026: 167 cases
19828
198310
19846
19858
19863
19874
19883
19898
19907
19915
199212
19937
19948
19955
19966
19971
19989
19997
200010
20014
20027
20035
20049
20056
20062
20077

Latest 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 year(c.\"eventDate\") = 2000
    AND 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\" = 220)
  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 SEA01LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Conconully, WAThe pilot's failure to maintain clearance from the trees while flying at a very low altitude in mountainous/hilly terrain. Factors include, forested mountainous/hilly terrain, flight at a very low altitude, and an encounter with a downdraft.Oct 30, 2000 · CGDNN · DestroyedNTSB SEA01LA009Accident · No injuriesLimited investigationFinal reportHallett HALLETT-1 · Yelm, WAThe pilot's failure to abort the takeoff when it became questionable as to whether the aircraft would be able to clear an object just off the departure end of the runway, and the pilot's failure to maintain clearance from the object as he attempted to…Oct 21, 2000 · N8331H · Substantial damageNTSB SEA01FA001Accident · 1 fatalField investigationFinal reportCessna 208B · Lummi Island, WAThe pilot's attempted flight into known adverse weather conditions, and his subsequent failure to maintain altitude above, or clearance with, trees. Factors contributing to the accident included low ceilings, fog, the pilot's low-altitude flight, rising…Oct 9, 2000 · N941FE · Substantial damageNTSB SEA00LA192Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Columbia River, WAClearance from a transmission power line was not maintained. The power line was a factor.Sep 27, 2000 · N5111A · Substantial damageNTSB SEA00LA175Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Wapato, WAThe pilot's failure to maintain clearance from the trees off the approach end of the runway, and his delay of the remedial action that would have allowed him to clear the trees. Factors include the pilot's failure to maintain a proper glidepath, trees off the…Sep 3, 2000 · N87351 · Substantial damageNTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…Jul 21, 2000 · N8228R · Substantial damageNTSB SEA00LA105Accident · No injuriesLimited investigationFinal reportSchmidt SEA REY · Northport, WAThe pilot's loss of directional control due to his inadequate remedial action in correcting for engine torque during the aborted landing. Factors include trees near the area where the pilot was attempting to land.Jun 16, 2000 · N304WW · Substantial damageNTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.Jun 5, 2000 · N6549K · Substantial damageNTSB SEA00LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Auburn, WAThe pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…Apr 12, 2000 · N9301U · Substantial damageNTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.Feb 7, 2000 · N7780V · Substantial damage