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.
Cases, newest first
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' 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 SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.NTSB SEA92LA079Accident · No injuriesLimited investigationFinal reportHughes 269C · Silverton, ORInadequate preflight planning and preparation. A factor to the accident was: visual lookout was not maintained.NTSB SEA92LA074Accident · 1 fatalLimited investigationFinal reportMoore Sonerai 1 · Harrisburg, ORThe pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…NTSB SEA92LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Scappoose, ORThe loss of engine power, cause undetermined. A factor relating to the accident was the lack of suitable terrain for a forced landing.NTSB SEA92LA067Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Miltonfreewater, ORThe inadequate prelight preparation by the pilot in his failure to ensure the filler hose was removed before attempting to takeoff.NTSB SEA92LA063Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Eugene, ORAn improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.NTSB SEA92LA056Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Dufur, ORThe pilot in command's misjudgment of clearance with the power lines. Factors contributing to the accident were: object (transmission wire) and safety system (not installed).NTSB SEA92LA055Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Oxbow, ORFailure of the pilot to maintain a proper visual lookout. A factor in the accident was the pilot's poor judgement in operating at low altitude along the river.NTSB SEA92LA052Accident · No injuriesLimited investigationFinal reportCessna 150L · Mulino, ORCarburetor ice and improper use of the carburetor heat. Factors to the accident were: carburetor icing conditions and an inadequate weather evaluation.NTSB SEA92LA047Accident · Minor injuriesLimited investigationFinal reportKna,Ken,Dac,Wel Tern Sailplane · Cottage Grove, ORThe pilot's inadequate preflight of the sailplane. Factors contributing to the accident were improper tow equipment and lack of total glider experience.NTSB SEA92LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Hood River, ORPoor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB SEA92LA027Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Klamath Falls, ORPilot factor in that he failed to follow IFR procedures. Factors to the accident were generator failure, operation with known deficiencies with equipment, and poor inflight planning.NTSB SEA92LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ontario, ORCarburetor icing and the pilot's failure to use carburetor heat. A factor contributing to the accident was the transmission wires.NTSB SEA92LA006Accident · Minor injuriesLimited investigationFinal reportCessna C-150M · Woodburn, ORA seized engine exhaust valve. Factors include rough terrain and a collapsed nose gear.NTSB SEA92LA005Accident · No injuriesLimited investigationFinal reportHughes 269B · Hillsboro, ORThe failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.NTSB SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.NTSB SEA91FA255Accident · 3 fatalField investigationFinal reportLake LA-250 · Sisters, ORImproper planning/decision by the pilot(s), and failure to attain sufficient altitude to remain clear of obstructions. Factors related to the accident were: the pilot(s) failure to use all available runway, high density altitude, rising terrain and trees…NTSB SEA91LA257Accident · No injuriesLimited investigationFinal reportCessna 172E · Burns, ORThe pilot's delay in computing aircraft fuel consumption and his failure to land at an alternate airport along the route of flight. Factors relating to the accident were the tree by the landing area and the improper maintenance adjustment of the right magneto.NTSB SEA91LA253Accident · No injuriesLimited investigationFinal reportCessna 172N · Chiloquin, ORThe loss of engine power in flight due to improper maintenance inspections. A factor relating to the accident was the rough terrain at the accident site.NTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.NTSB SEA91LA233Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miltonfreewater, ORPilot factor in that the pilot failed to insure there was adequate clearance from obstacles for a safe takeoff. A factor to the accident was: the pilot's poor preflight planning/preparation.NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.NTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.NTSB SEA91FA229Accident · 2 fatalField investigationFinal reportCessna 150L · Yamhill, ORInadequate inflight planning/decisions. Factors to the accident were: an uncontrolled stall, a tail wind, remedial action was not performed, and poor compensation for wind conditions.NTSB SEA91LA231Accident · No injuriesLimited investigationFinal reportCessna 310F · Corvallis, ORA disconnected air induction line, and the pilot's inflight decision to execute a 180 degree turn back to the airport. His lack of experience in multi-engine aircraft, his overall lack of familiarity and lack of recent experience in the type aircraft were…NTSB SEA91FA223Accident · 3 fatalField investigationFinal reportAerospatiale 350 B1 · Walton, ORThe pilot's failure to maintain clearance from terrain.NTSB SEA91LA225Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Joseph, ORA deer that ran onto the runway.NTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.NTSB SEA91LA217Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Shady Cove, ORImproper re-installation of an oil line by maintenance personnel, which resulted in an oil leak from a loose line and subsequent seizure of the engine. Uneven terrain in the emergency landing area was a related factor.NTSB SEA91LA212Accident · No injuriesLimited investigationFinal reportCessna U206F · Nimrod, ORThe fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.NTSB SEA91LA166Accident · No injuriesLimited investigationFinal reportWaco UBF · Lincoln City, ORImproper planning/decision by the pilot, and his delay in aborting the takeoff. The tailwind & proximity of trees/brush were related factors.NTSB SEA91LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boring, ORFuel exhaustion and improper inflight decision by the pilot in command followed by rough terrain during the forced landing. Factors contributing to the accident were a fuel system leak and the pilot's failure to refuel en route.NTSB SEA91FA203Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Scappoose, ORThe pilot's misjudgment of altitude, while performing an aerobatic maneuver, and his failure to maintain ground clearance.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB SEA91LA198Accident · Serious injuriesLimited investigationFinal reportChance Vought F4U-4 · Chiloquin, ORThe loss of power due to engine failure, for undetermined reasons.NTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.NTSB SEA91LA193Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORFuel starvation due to the improper use of the fuel selector switch by the pilot and his failure to extend the landing gear for the forced landing.NTSB SEA91LA169Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Bend, ORPoor preflight planning/preparation by the pilot in command. Factors to the accident were: high density altitude, excessive climb rate, inadequate remedial action, and lack of total flight expereince.NTSB SEA91LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Medford, ORAn intentional porpoise. Factors include the pilot's psychological condition.NTSB SEA91FA156Accident · 2 fatalField investigationFinal reportChampion 7AC · Burns, ORImproper inflight planning/decision by the student pilot (pilot-in-command), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: physical impairment of the student pilot/owner/operator from carbon…NTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.NTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB SEA91LA137Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Warrenton, ORThe pilot failed to maintain proper rotor speed during a simulated autorotation.NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.NTSB SEA91LA130Accident · Minor injuriesLimited investigationFinal reportHughes 269A-1 · Canby, ORA hard landing after an undetermined loss of power. Factors include an excessive emergency descent rate.NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.