NTSB investigations, 2000, WA

5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Cases per year

19822026
NTSB investigations, 2000, WA per year, 1982–2026: 89 cases
19827
19836
19842
19854
19869
19873
19883
19894
19905
19919
19924
19931
19946
19956
19964
19971
19983
20005
20012
20031
20051
20061
20072

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\" = 351)
  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 SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…Sep 24, 2000 · N9355F · Substantial damageNTSB SEA00LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kennewick, WAA failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…Jun 30, 2000 · N6887W · Substantial damageNTSB SEA00LA116Accident · Serious injuriesLimited investigationFinal reportDavis/Crouch Avid MK IV · Concrete, WAFracture of the engine's #1 connecting rod, resulting in a total loss of engine power. Factors were an engine overheat condition experienced at an undetermined time, and no suitable terrain for a forced landing.Jun 27, 2000 · N518DC · Substantial damageNTSB SEA00LA082Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Ephrata, WALoss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.May 4, 2000 · N8130K · Substantial damageNTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.Mar 6, 2000 · N8170W · Substantial damage