NTSB investigations, OR
89 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 2 |
Where
Open the mapLatest 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 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.
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 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB LAX07LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monmouth, ORThe failure of the main drive belt tension assembly shaft due to high cycle, low stress fatigue.NTSB SEA07LA022Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Lyons, ORA severing of the helicopter's cyclic and collective rods by one of the load lifting slings following the failure of the other sling. A contributing factor was the hard landing due to the fact that an autorotation was not possible.NTSB SEA06LA065Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Dexter, ORThe pilot's failure to identify the overspeed of the helicopter's main rotors due to a turbine governor malfunction, and his failure to take the appropriate actions described in the Flight Manual's emergency procedures section. Factors include the malfunction…NTSB SEA06CA062Accident · No injuriesData collectionFinal reportPiper PA-18A · Shady Cove, ORThe pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.NTSB SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.NTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.NTSB SEA05CA191Accident · No injuriesData collectionFinal reportGleason Sky Star Kitfox · Klamath Falls, ORThe binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.NTSB 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.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB SEA05LA058Accident · Minor injuriesLimited investigationFinal reportRotorway Exec 162F · Coos Bay, ORThe disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…NTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…NTSB SEA04LA153Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Redmond, ORUnknown malfunction of the landing gear system for undetermined reasons that resulted in a gear collapse during landing.NTSB SEA04TA147Accident · No injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORThe improper installation of the throttle linkage clevis to the throttle control arm by unknown maintenance personnel. Contributing factors were the nylon lock nut separating from its' bolt, which permitted the throttle cable to disconnect from the throttle…NTSB 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.NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.NTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.NTSB SEA02LA137Accident · No injuriesLimited investigationFinal reportBell 206B · Elsie, ORThe shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).NTSB SEA02LA120Accident · No injuriesLimited investigationFinal reportWelborn Pulsar XP · Prineville, ORThe disconnection of the throttle cable on landing resulting in the aircraft's engine going to full throttle and the pilot's subsequent failure to maintain directional control after securing the engine during the landing event.NTSB SEA02LA095Accident · No injuriesLimited investigationFinal reportCessna 441 · Medford, ORThe overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.NTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.NTSB SEA01IA161Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Portland, ORImproper tension of the right control yoke chain; a worn right aileron spring tab hinge bearing; improper tension of the left aileron spring tab aft spring and worn contact stud; improper tension of the right aileron spring tab and a worn contact stud; a worn…NTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.NTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…NTSB SEA01LA049Accident · No injuriesLimited investigationFinal reportAero Commander AC-690 · Eugene, ORan undetermined malfunction of the nose gear system which resulted in the failure of the nose gear to fully extend and lock prior to landing.NTSB 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.NTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.NTSB SEA00LA118Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Bend, ORImproper preflight preflight planning/preparation by the pilot-in-command. Factors included a worn tailwheel tire and the VASI lighting system.NTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…NTSB SEA00LA097Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene, ORInadequate quality control by the manufacturer during the manufacturing process, which led to the total failure of a fastener, and the separation of the tail rotor blade balance weight. An adhesive debond between the adhesive and the surface was a factor.NTSB SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…NTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.NTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.NTSB SEA98LA162Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Hillsboro, ORThe disengagement of the pilot seat forward and aft movement locking pin, followed by the pilot's seat sliding to the rear of the seat track.NTSB SEA98LA058Accident · No injuriesLimited investigationFinal reportCessna 195A · Bend, ORSeparation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.NTSB SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.NTSB SEA98LA017Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Canby, ORThe pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.NTSB 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…NTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.NTSB SEA97LA096Accident · Minor injuriesLimited investigationFinal reportHendrix Talon XP · Redmond, ORincomplete installation (omission of the aft control stick and interlink tube) of the flight control system, resulting in failure of the combined (torque) elevator and aileron rod and a disconnection of the forward flight control stick from the ailerons and…NTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.NTSB 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).NTSB 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…NTSB SEA96LA206Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ashland, ORinadequate inspection of the airplane by maintenance personnel,and a worn exhaust clamp, which resulted in a disconnected exhaust pipe, exhaust leak, burning and shorting of electrical wiring associated with the voltage regulator, and a cabin fire.NTSB SEA96TA192Accident · No injuriesFinal reportBell UH-1H · Pendleton, ORundetermined malfunction/failure of a flight control or hydraulic system. Rough terrain in the emergency landing area was a related factor.NTSB SEA96LA188Accident · Minor injuriesLimited investigationFinal reportJonas Exec 90 · Hermiston, ORslippage of the drive belts, while hover taxiing in ground effect, which resulted in loss of power to the rotor system; and inadequate remedial action by the pilot, which led to a roll over during touch down (forced landing). A factor relating to the accident…NTSB SEA96LA164Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hillsboro, ORblockage of the vents to both wing fuel tanks, after unknown personnel failed to remove tape (protective covering) from the vents, which resulted in collapsed fuel tanks (and wing damage).NTSB SEA96IA074Incident · No injuriesIncident investigationFinal reportDornier DO 328-100 · Eugene, ORdelamination of the wing de-icing boot, due to the boot reaching its life limit.