NTSB investigations, 2009, 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\") = 2009
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") = 2009 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 WPR10CA057Accident · No injuriesData collectionFinal reportBell 206B · Lyons, ORThe pilot's inadvertent encounter with a vortex ring state (settling with power) condition while he was descending, and his improper initial remedial action.NTSB WPR10FA012Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Fossil, ORThe pilot's failure to maintain clearance from a power pole to which he was connecting wire-pulling ropes.NTSB WPR10CA026Accident · No injuriesData collectionFinal reportCessna 180A · Condon, ORThe pilot's failure to maintain clearance from the fence post on approach.NTSB WPR10LA006Accident · Serious injuriesLimited investigationFinal reportTurpen RV-8 · Yankton, ORThe pilot's inadequate planning during an instrument approach and failure to maintain the published minimum altitudes, which resulted in controlled flight into terrain.NTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR09LA471Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Myrtle Creek, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight. Contributing to the accident was a malfunctioning fuel gage.NTSB WPR09CA477Accident · No injuriesData collectionFinal reportCessna 182 · Enterprise, ORThe pilot's failure to stop his airplane before it departed the end of the unimproved remote airstrip.NTSB WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.NTSB WPR09LA475Accident · No injuriesLimited investigationFinal reportWaco QCF-2 · Bend, ORThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB WPR09CA478Accident · No injuriesData collectionFinal reportCessna T210J · Albany, ORThe malfunction of the left main wheel brake during landing due to inadequate hydraulic fluid in the left brake pedal master cylinder due to leakage.NTSB WPR09LA446Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-1B · Creswell, ORA partial loss of engine power due to the malfunction of the engine's right magneto.NTSB WPR09CA439Accident · No injuriesData collectionFinal reportBellanca 17-30A · La Grande, ORThe pilot's improper flare, which resulted in a bounced landing.NTSB WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.NTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.NTSB WPR09CA425Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Madras, ORThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control during landing rollout.NTSB WPR09CA424Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8A · Sandy, ORThe pilot's decision to continue the landing rather than execute a go-around. Contributing to the accident was the pilot's failure to maintain proper airspeed and altitude during the approach.NTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09FA391Accident · 3 fatalField investigationFinal reportNavion Navion A · Adrian, ORThe pilot’s failure to maintain aircraft control while in cruise flight due to spatial disorientation, which resulted in an exceedence of the design stress limits of the aircraft and led to an in-flight structural failure.NTSB WPR09CA375Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe flight instructor's failure to maintain adequate main rotor RPM.NTSB WPR09CA377Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe student pilot's improper use of the collective control and the flight instructor’s delayed reaction to the student pilot’s incorrect control inputs.NTSB WPR09LA361Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Redmond, ORAn undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.NTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB WPR09CA288Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hell's Canyon, ORThe pilot's failure to maintain clearance from trees.NTSB WPR09CA271Accident · No injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 235 · Ontario, ORThe pilot's misjudged landing flare. Contributing to the accident was the pilot's lack of any experience in the make and model airplane.NTSB WPR09LA219Accident · No injuriesLimited investigationFinal reportEllumax Leasing Epic LT · Astoria, ORThe partial loss of engine power during climb to cruise due to the failure of the engine's fuel control unit. Contributing to the accident was the incorrect machining of an internal component of the fuel control unit, and the failure of the assembling…NTSB WPR09CA190Accident · Minor injuriesData collectionFinal reportAyres S2R-T34 · Cove, ORThe pilot's failure to maintain adequate clearance from rising terrain while maneuvering.NTSB WPR09LA189Accident · No injuriesLimited investigationFinal reportBeech A36TC · Roseburg, ORThe pilot's failure to follow the landing checklist, which resulted in a gear up landing. Contributing to the accident was the pilot's diverted attention.NTSB WPR09LA184Accident · No injuriesLimited investigationFinal reportSikorsky CH-54B · Corvallis, ORThe improper assembly of main rotor blade control components by the operator's maintenance personnel, which resulted in the main rotor blade's divergent path and their contact with the tail rotor drive shaft during ground operation following landing.NTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.