Skip to content

NTSB investigations, OR

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 SEA93LA129Accident · Minor injuriesLimited investigationFinal reportCessna T210K · Forest Grove, ORLoss of engine power due to fuel exhaustion, resulting from inadequate preflight planning/preparation by the PIC.Jun 13, 1993 · N8120G · Substantial damage NTSB SEA93LA113Accident · Minor injuriesLimited investigationFinal reportMurphy Barracuda · Yoncalla, ORThe engine oil filter vibrating loose resulting in oil starvation, and the pilot in command's misjudgment of winds. A factor contributing to the accident was unfavorable winds.May 20, 1993 · N54265 · Substantial damage NTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.May 11, 1993 · N435BW · Substantial damage NTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.Apr 24, 1993 · N9637P · Substantial damage NTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damage NTSB SEA93FA084Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Estacada, ORFailure of the pilot to maintain proper clearance (and/or altitude) from moutainous terrain. Factors related to the accident were: darkness, clouds, low ceilings, and the high (mountainous) terrain in the area of the accident site.Mar 29, 1993 · N63888 · Destroyed NTSB SEA93LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Jordan Valley, ORThe pilot continued the VFR flight into IMC and failed to maintain clearance from obstacles on the ground. Factors relating to the accident were the clouds, low ceiling, and rain.Mar 26, 1993 · N3986J · Destroyed NTSB DEN93FA033Accident · 3 fatalField investigationFinal reportHiller UH-12E · Applegate, ORThe pilot initiating flight into known adverse weather. Factors were: low ceiling, fog, and turbulence.Mar 16, 1993 · N5344V · Destroyed NTSB SEA93IA073Incident · No injuriesIncident investigationFinal reportHughes 269B · Mcminnville, ORAn inflight loss of control, and inadequate remedial action. Factors include a tailwind, and gusts.Mar 5, 1993 · N9474F · Minor damage NTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.Feb 28, 1993 · N12698 · Substantial damage NTSB SEA93LA064Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Bend, ORRotor RPM was not maintained. Factors to the accident were: low ceiling and poor inflight planning.Feb 7, 1993 · N4085M · Substantial damage NTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.Feb 5, 1993 · N2019N · Substantial damage NTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.Feb 4, 1993 · N5849J · Substantial damage NTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.Feb 2, 1993 · N11096 · Substantial damage NTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.Jan 31, 1993 · N56843 · Substantial damage NTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.Jan 16, 1993 · N161RS · Substantial damage NTSB SEA93FA035Accident · 2 fatalField investigationFinal reportCessna 421C · Wilsonville, ORThe pilot-in-command's failure to maintain control of the aircraft.Dec 13, 1992 · N98489 · Destroyed NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.Dec 5, 1992 · N2216E · Destroyed NTSB SEA93LA030Accident · No injuriesLimited investigationFinal reportHughes 369HS · Scotts Mills, ORThe pilot in command's misjudged descent. Factors include the pilot in command's lack of experience in this type of operation.Nov 27, 1992 · N9228F · Substantial damage NTSB LAX93IA029Incident · No injuriesIncident investigationFinal reportPiper PA-31T-620 · Medford, ORFatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.Nov 5, 1992 · N131AF · No damage NTSB SEA93T#A01Accident · No injuriesClass 3Final reportBeech 58 · Bates, ORNov 2, 1992 · N358K · Destroyed NTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.Oct 30, 1992 · N66135 · Destroyed NTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.Oct 24, 1992 · N16221 · Substantial damage NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.Oct 23, 1992 · N5131V · Substantial damage NTSB SEA93LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sisters, ORThe pilot's poor inflight decision. Factors include mountainous/hilly terrain, trees, high density altitude, and downdrafts.Oct 20, 1992 · N19092 · Substantial damage NTSB SEA93LA004Accident · 1 fatalLimited investigationFinal reportCarlson Midget Mustang · Baker, ORAn inadvertent stall/spin by the pilot in command. A factor contributing to the accident was the pilot in command's lack of recent experience.Oct 4, 1992 · N111C · Destroyed NTSB SEA93LA001Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot in command's failure to maintain proper altitude during the hover. Factors contributing to the accident were the pilot in command's lack of total experience in rotorcraft and his diversion of attention while hovering.Oct 1, 1992 · N7400F · Substantial damage NTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.Sep 29, 1992 · N8274C · Substantial damage NTSB SEA92LA208Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gates, ORThe excessive application of the brakes by the pilot in command. Factors contributing to the accident were the tailwind and the pilots visual (mis)perception of runway gradient.Sep 20, 1992 · N39039 · Substantial damage NTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.Sep 13, 1992 · N7057Y · Substantial damage NTSB SEA92LA202Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Cave Junction, ORThe pilot's poor visual lookout. Factors include a static wire in the area of flight.Sep 9, 1992 · UNREG · Substantial damage NTSB SEA92LA194Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · The Dalles, ORA misjudged approach. Factors to the accident were: inaccurate fuel consumption calculations and fuel exhaustion.Sep 2, 1992 · N1005B · Substantial damage NTSB SEA92LA182Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Miltonfreewater, ORAn inadvertent stall while maneuvering in mountainous terrain. Factors include lack of experience in this type of operation.Aug 15, 1992 · N85425 · Substantial damage NTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.Aug 12, 1992 · N2328Q · Substantial damage NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damage NTSB SEA92T#A05Accident · No injuriesClass 3Final reportBell 206L · Enterprise, ORJul 30, 1992 · N5741X · Substantial damage NTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.Jul 27, 1992 · N5639W · Substantial damage NTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.Jul 11, 1992 · N5988E · Destroyed NTSB SEA92LA143Accident · Minor injuriesLimited investigationFinal reportBorgaes Avid Flyer "C" · Chiloquin, ORPower loss for undetermined reasons and nose gear separation due to overload. A factor contributing to the accident was: terrain condition - dirt bank.Jul 4, 1992 · N1572T · Substantial damage NTSB SEA92LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Corbett, ORThe failure of the float attach fitting, and the separation of the floats from the aircraft.Jun 23, 1992 · N6470M · Substantial damage NTSB SEA92IA136Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 1000 · Portland, ORThe partial failure of the horizontal stabilizer trim drive system, the restricted movement of the stabilizer, and the overtorque of a system component.Jun 22, 1992 · CGTAH · No damage NTSB SEA92LA124Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Klamath Falls, ORThe pilot's poor inflight planning/decision. Factors to the accident were: clearance was not maintained and inadequate remedial action.Jun 10, 1992 · N3627S · Destroyed NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damage NTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.May 23, 1992 · N61167 · Substantial damage NTSB SEA92LA108Accident · No injuriesLimited investigationFinal reportCessna A188A · Redmond, ORProper clearance from objects was not maintained. Factors to the accident were: sunglare, wires, and visual lookout was not possible.May 21, 1992 · N9990G · Substantial damage NTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.May 16, 1992 · N9000E · Destroyed NTSB SEA92LA104Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B-2B · Hood River, ORThe delayed remedial action of the pilot (CFI). Factors include lack of total experience in type of aircraft, and lack of total experience in type of operation.May 14, 1992 · N5972X · Substantial damage NTSB SEA92LA092Accident · No injuriesLimited investigationFinal reportCessna 150F · Gold Beach, ORFailure of the pilot to maintain airspeed on final approach, resulting in aircraft stall, loss of control and impact with terrain. A factor relating to the accident was the lack of experience by the pilot.May 7, 1992 · N8791G · Substantial damage NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.May 4, 1992 · N5096E · Substantial damage NTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…May 2, 1992 · N5469V · Substantial damage