NTSB investigations, 1992, 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 per year
| 1962 | 1 |
|---|---|
| 1964 | 74 |
| 1965 | 88 |
| 1966 | 121 |
| 1967 | 121 |
| 1968 | 84 |
| 1969 | 80 |
| 1970 | 68 |
| 1971 | 77 |
| 1972 | 75 |
| 1973 | 84 |
| 1974 | 71 |
| 1975 | 77 |
| 1976 | 81 |
| 1977 | 95 |
| 1978 | 88 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 75 |
| 1982 | 82 |
| 1983 | 65 |
| 1984 | 70 |
| 1985 | 56 |
| 1986 | 51 |
| 1987 | 40 |
| 1988 | 41 |
| 1989 | 45 |
| 1990 | 49 |
| 1991 | 51 |
| 1992 | 48 |
| 1993 | 39 |
| 1994 | 46 |
| 1995 | 56 |
| 1996 | 60 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 43 |
| 2000 | 56 |
| 2001 | 47 |
| 2002 | 39 |
| 2003 | 48 |
| 2004 | 40 |
| 2005 | 54 |
| 2006 | 38 |
| 2007 | 47 |
| 2008 | 40 |
| 2009 | 31 |
| 2010 | 40 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 31 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 23 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 42 |
| 2020 | 23 |
| 2021 | 36 |
| 2022 | 24 |
| 2023 | 23 |
| 2024 | 30 |
| 2025 | 20 |
| 2026 | 23 |
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 year(c.\"eventDate\") = 1992
AND 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 year(c."eventDate") = 1992 AND 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 SEA93FA035Accident · 2 fatalField investigationFinal reportCessna 421C · Wilsonville, ORThe pilot-in-command's failure to maintain control of the aircraft.NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.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.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.NTSB SEA93T#A01Accident · No injuriesClass 3Final reportBeech 58 · Bates, ORNTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.NTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.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.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.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.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.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.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.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.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.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.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.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB SEA92T#A05Accident · No injuriesClass 3Final reportBell 206L · Enterprise, ORNTSB 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.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.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.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.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.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.NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.NTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.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.NTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.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.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.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.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…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.