Fatal NTSB investigations, OR

15 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19832026
Fatal NTSB investigations, OR per year, 1983–2026: 15 cases
19832
19861
19891
19901
19952
19961
19973
20001
20031
20051
20071

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.\"highestInjuryLevel\" = 'Fatal'
    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\" = 130)
  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 SEA07LA217Accident · 2 fatalLimited investigationFinal reportTaylorcraft BF12 · West Linn, ORThe corrosion, fatigue fracture, and subsequent separation of the left wing lift strut attachment fitting. Also causal was the inadequate maintenance and annual inspection by the owner/pilot/mechanic.Jul 28, 2007 · N13060 · Substantial damageNTSB SEA05LA188Accident · 1 fatalLimited investigationFinal reportKirner Fisher FP404 · Prineville, ORThe design stress limits of the aircraft were exceeded resulting in a wing separation while the pilot was accomplishing maneuvers of hard banking turns, spins and steep descents.Sep 2, 2005 · UNREG · Substantial damageNTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.Nov 25, 2003 · N10BX · DestroyedNTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.Nov 17, 2000 · N3762A · DestroyedNTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…Jun 20, 1997 · N168RW · DestroyedNTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.May 24, 1997 · N83211 · DestroyedNTSB SEA97FA049Accident · 2 fatalField investigationFinal reportChampion 7-GCBC · Creswell, ORthe pilot exceeded the design stress limits of the aircraft, while recovering from a spin, which resulted in failure and separation of the right wing tip and adjacent wing fabric (skin).Jan 19, 1997 · N9677S · DestroyedNTSB SEA97FA001Accident · 3 fatalField investigationFinal reportBoeing Vertol BV-107 II · Canby, ORfailure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…Oct 4, 1996 · N196CH · DestroyedNTSB SEA96LA005Accident · 1 fatalLimited investigationFinal reportChard RV-3A · Forest Grove, ORThe pilot exceeded the design stress limit of the aircraft, followed by the failure of the right wing main spar.Oct 8, 1995 · N27RV · DestroyedNTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…Jun 25, 1995 · N719JX · DestroyedNTSB SEA90FA129Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Prineville, ORThe failure of the left intermediate exhaust pipe, in-flight engine fire and smoke in the cockpit, resulting in impairment of the pilot and his subsequent loss of control.Jul 9, 1990 · N30511 · DestroyedNTSB SEA89FA053Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lakeview, ORFailure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…Mar 4, 1989 · CFHGH · DestroyedNTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…Jan 16, 1986 · N40290 · DestroyedNTSB SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…Jun 30, 1983 · N83GL · DestroyedNTSB SEA83FYM05Accident · 1 fatalFinal reportBrantly Helicopter B-2 · Milton Freewtr., ORThe helicopter was observed to climb to about 50-75 ft AGL & then something flew off the acft. One m/r blade was found intact 240 ft from the wreckage. The outer blade was heavily damaged at the tip area. The inboard blade section had the pylon tube attached…May 4, 1983 · N5912X · Substantial damage