NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB SEA07LA039Accident · Serious injuriesLimited investigationFinal reportAveryt Vans RV-4 · Grants Pass, ORThe pilot's failure to maintain adequate airspeed during performance of a go-around, resulting in an inadvertent stall and subsequent in flight collision with the ground. A contributing factor was the in-flight loss of a portion of one propeller blade.NTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.NTSB SEA07LA030Accident · No injuriesLimited investigationFinal reportCessna P210N · Burns, ORThe pilot's failure to put the landing gear down for landing.NTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.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 SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.NTSB SEA07CA008Accident · Minor injuriesData collectionFinal reportBeech E-55 · Ontario, ORThe dual loss of engine power due to fuel exhaustion as a result of the pilot's failure to adequately determine the amount of fuel aboard the airplane during his preflight preparation. A contributing factor was the pilot's misjudgment of distance/speed during…NTSB SEA07LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lebanon, ORThe pilot's failure to maintain directional control during the landing roll, resulting in the aircraft departing the runway and impacting a Visual Approach Slope Indicator (VASI) standard. The VASI standard near the side of the runway was a factor.NTSB SEA06CA174Accident · No injuriesData collectionFinal reportCessna 180 · Arock, ORThe pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…NTSB SEA06LA169Accident · 1 fatalLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Elmira, ORThe pilot's failure to maintain an airspeed above stall speed (Vs) while turning to avoid trees along the side of the runway during the initial climbout after takeoff. Factors include, a variable wind that became a tailwind, and trees growing near the side of…NTSB SEA06FA168Accident · Minor injuriesField investigationFinal reportAviat A-1B · Owyhee, ORThe pilot inadvertently landing with the parking brake engaged, which resulted in a nose over.NTSB SEA06LA163Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · North Plains, ORThe glider pilot's misjudgment of distance/speed during approach, which resulted in excessive speed at touchdown, and his failure to maintain directional control during the landing roll. A contributing factor was the glider pilot's lack of experience in the…NTSB SEA06FA159Accident · 3 fatalField investigationFinal reportRobinson R44 II · Warrenton, ORThe pilot's intentional flight into instrument meteorological conditions while maneuvering which resulted in an in flight collision with terrain/water.NTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.NTSB SEA06CA176Accident · No injuriesData collectionFinal reportCessna 185 · Cove, ORThe pilot’s failure to maintain directional control during the takeoff roll. Factors include wet grass and trees.NTSB SEA06FA142Accident · 1 fatalField investigationFinal reportHawker Siddeley MK-58A Hunter · Hillsboro, ORLoss of aircraft control for undetermined reasons during the takeoff sequence.NTSB SEA06CA137Accident · No injuriesData collectionFinal reportHughes 369A · Medford, ORThe pilot's misinterpretation of the wind direction (in-flight planning) and subsequent improper descent rate to the ground during a landing attempt. A factor was the tailwind conditions.NTSB SEA06CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Hood River, ORA loss of lift, which resulted in a forced landing. Trees in the landing area were a contributing factor.NTSB SEA06FA119Accident · 4 fatalField investigationFinal reportCessna 180 · Agness, ORThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent collision with rocky terrain. A contributing factor was the sun glare.NTSB SEA06TA118Accident · No injuriesFinal reportCessna 206H · Aurora, ORThe failure of both the pilot of the aircraft traveling on a taxi lane and the operator of the automobile driving on a taxi lane to maintain an adequate visual lookout and their failure to see and avoid one another.NTSB SEA06CA107Accident · No injuriesData collectionFinal reportTaplin Avid Flyer · Grants Pass, ORThe partial loss of engine power for undertermined reasons, resulting in a forced landing and substantial damage to the airplane. A contributing factor was the transmission wire.NTSB SEA06CA102Accident · No injuriesData collectionFinal reportHughes 369A · Banks, ORThe pilot's failure to maintain rotor rpm while performing a simulated autorotation, which resulted in a hard landing. A contributing factor was the pilot's incorrect interpretation of the examiner's instruction to add power.NTSB SEA06IA105Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Portland, ORThe inadvertent deployment of the off-wing escape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel.NTSB SEA06CA099Accident · Minor injuriesData collectionFinal reportCessna 152 · Klamath Falls, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Soft terrain was a contributing factor.NTSB SEA06CA092Accident · No injuriesData collectionFinal reportCessna 182F · Canby, ORThe pilot's misjudgment of altitude resulting in an undershoot. A factor was the berm.NTSB SEA06CA084Accident · No injuriesData collectionFinal reportBeech P-35 · Bandon, ORThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.NTSB SEA06LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include gusty crosswinds.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB SEA06FA067Accident · 1 fatalField investigationFinal reportKaman K-1200 · Dayville, ORThe improper overhaul of the reduction gear box assembly and improper installation of the N1 seal and nut assembly lockcup by maintenance personnel, which resulted in failure of the reduction gear box and a total loss of engine power. A contributing factor…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 SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.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 SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…NTSB SEA06LA057Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Cottage Grove, ORFuel starvation while on approach for landing resulting in a loss of engine power, and an inadequately accomplished annual inspection. Incorrect hardware which impeded the movement of the fuel selector valve, improper fuel management and not identifying the…NTSB SEA06CA056Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ORThe student pilot's delayed use of carburetor heat in carburetor icing conditions while maneuvering. Soft terrain was a factor.NTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.NTSB SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…