NTSB investigations, OR

5 cases where NTSB found Modification/alteration.

Cases per year

20082026
NTSB investigations, OR per year, 2008–2026: 5 cases
20082
20151
20171
20181

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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02062030'))
  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 WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.Mar 20, 2018 · N925DP · Substantial damageNTSB WPR17LA082Accident · Minor injuriesLimited investigationFinal reportOTT 601XL-B · The Dalles, ORA partial loss of engine power due to the reverse bending fatigue failure of the propeller hub bolts, which resulted from the bolts not fitting tightly into the propeller hub holes. Also causal was the pilot's decision to use improper bolts for this type of…Mar 31, 2017 · N610TT · Substantial damageNTSB WPR15LA228Accident · No injuriesLimited investigationFinal reportHudson Zodiac CH 601 XLB · Hubbard, ORA severe propeller vibration due to the pilot's improper installation of the propeller spacer assembly, which necessitated an engine shutdown, an off-airport landing, and a collision with a sprinkler system.Aug 2, 2015 · N234S · Substantial damageNTSB WPR09LA052Accident · Serious injuriesLimited investigationFinal reportAdkins Ridge Runner II · Mulino, ORThe pilot's failure to attain an adequate airspeed that resulted in a stall/mush during the initial climb. Contributing to the accident were the pilot's lack of experience in this make and model airplane and the improper adjustment of the propeller pitch.Nov 29, 2008 · N825PB · Substantial damageNTSB SEA08LA140Accident · Minor injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA loss of engine power due to the pilot's modification of the induction system, and the pilot's failure to maintain an adequate airspeed while maneuvering to a landing area following the power loss.May 26, 2008 · N4GJ · Substantial damage