NTSB investigations, 2023, 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\") = 2023
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") = 2023 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 WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB WPR24LA036Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Estacada, ORThe pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.NTSB WPR24LA031Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK27-2 · Pendleton, ORThe operator’s use of an insufficiently charged battery that resulted in a total loss of engine power and subsequent impact with terrain.NTSB WPR24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Baker City, ORThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.NTSB WPR24FA004Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Newberg, ORThe pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.NTSB WPR23LA328Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Hillsboro, ORThe student pilot’s failure to maintain airplane control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR23LA303Accident · Minor injuriesClass 3 · LimitedFinal reportAldinger Albert John Cozy Mark III · McDermitt, ORThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Dune City, ORThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and impact with terrain.NTSB WPR23LA267Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Coquille Bay, ORThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with terrain.NTSB WPR23LA261Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6G · La Grande, ORThe pilot's failure to maintain clearance from trees during an airstrip overfly, which resulted in impact damage to the left wing.NTSB WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB WPR23LA243Accident · No injuriesClass 3 · LimitedFinal reportKitfox 2 · Cave Junction, ORThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.NTSB WPR23LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Bend, ORThe pilot’s failure to maintain clearance from the fuel station, resulting in a ground collision and fire.NTSB WPR23LA184Accident · No injuriesClass 3 · LimitedFinal reportRans S-21 · Creswell, ORA total loss of engine power caused by fatigue cracking and fracture of the crankshaft due to severe wear of the bearings.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB WPR23LA150Accident · No injuriesClass 3 · LimitedFinal reportCompagnie Daher TBM 700 · Ashland, ORThe pilot’s failure to maintain adequate airspeed during an attempted go around, which resulted in a runway excursion and impact with terrain.NTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.NTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.NTSB WPR23LA115Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Mulino, ORThe pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR23LA097Accident · No injuriesClass 3 · LimitedFinal reportKaman Aerospace K-1200 · Sweet Home, ORImproper installation of the hardware retaining the adjustment screw in the N2 topping governor lever and roller assembly, which resulted in a partial loss of engine power.