NTSB investigations, 2004, OR

6 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 2004, OR per year, 1982–2026: 109 cases
19822
19832
19842
19857
19864
19872
19882
19914
19924
19933
19942
19955
19964
19977
19987
19993
20008
20014
20029
20034
20046
20057
20064
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\") = 2004
    AND c.\"eventStateOrRegion\" = 'OR' 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\" = 350)
  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 SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.Nov 14, 2004 · N80AH · Substantial damageNTSB SEA05FA004Accident · No injuriesField investigationFinal reportMaule MT-7-420 · Bend, ORLoss of engine power during takeoff climb for undetermined reasons. Rough terrain was a factor.Oct 8, 2004 · N186SB · Substantial damageNTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.Sep 4, 2004 · N505ST · Substantial damageNTSB SEA04CA107Accident · No injuriesData collectionFinal reportSteward Rocky 162F · Hood River, ORThe pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.Jun 16, 2004 · N717CS · Substantial damageNTSB SEA04LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sisters, ORThe loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.Mar 17, 2004 · N2553S · Substantial damageNTSB SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.Feb 28, 2004 · N143GJ · Substantial damage