NTSB investigations, 1990, OK
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
| 1964 | 108 |
|---|---|
| 1965 | 105 |
| 1966 | 100 |
| 1967 | 134 |
| 1968 | 100 |
| 1969 | 99 |
| 1970 | 81 |
| 1971 | 102 |
| 1972 | 56 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 60 |
| 1976 | 66 |
| 1977 | 72 |
| 1978 | 63 |
| 1979 | 66 |
| 1980 | 64 |
| 1981 | 79 |
| 1982 | 63 |
| 1983 | 64 |
| 1984 | 65 |
| 1985 | 47 |
| 1986 | 42 |
| 1987 | 45 |
| 1988 | 38 |
| 1989 | 40 |
| 1990 | 29 |
| 1991 | 30 |
| 1992 | 36 |
| 1993 | 23 |
| 1994 | 32 |
| 1995 | 42 |
| 1996 | 35 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 36 |
| 2000 | 31 |
| 2001 | 24 |
| 2002 | 26 |
| 2003 | 22 |
| 2004 | 23 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 28 |
| 2008 | 25 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 19 |
| 2012 | 18 |
| 2013 | 23 |
| 2014 | 11 |
| 2015 | 17 |
| 2016 | 21 |
| 2017 | 20 |
| 2018 | 15 |
| 2019 | 15 |
| 2020 | 18 |
| 2021 | 17 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 19 |
| 2025 | 19 |
| 2026 | 13 |
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\") = 1990
AND c.\"eventStateOrRegion\" = 'OK' 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") = 1990 AND c."eventStateOrRegion" = 'OK' 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 FTW91LA026Accident · No injuriesLimited investigationFinal reportCessna 205 · Medford, OKThe pilot's use of improper starting procedures which resulted in the loss of control of the airplane. A factor in the accident was the airplane's encounter with rough terrain during the unmanned taxi.NTSB FTW91LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Eufaula, OKA restriction in the movement of the right rudder pedal. The restriction resulted from a passenger's inadvertent placement of an object on the cockpit's floor.NTSB FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB FTW91GA001Accident · No injuriesFinal reportMcdonnell Douglas 369E · Anadarko, OKFailure of the pilot to maintain proper visual lookout prior to and during departure.NTSB DEN90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Marietta, OKThe loss of directional control by the pilot. The selection of unsuitable terrain is a factor.NTSB FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.NTSB FTW90LA174Accident · Minor injuriesLimited investigationFinal reportCessna C172N · Marietta, OKFailure of the pilot to attain the proper climb rate after takeoff resulting in the aircraft colliding with trees at the departure end of the runway. Contribuing to the accident was the pilot in commands failure to account for high density altitude.NTSB FTW90FA160Accident · 4 fatalField investigationFinal reportAerospatiale/Socata TB-10 · Ada, OKImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed for a climb profile. Factors related to the accident were: the pilot allowed the weight and balance of the aircraft to exceed the certified limits, his use of…NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB FTW90DPJ10Accident · No injuriesFinal reportHomebuilt Midget Mustang M1 · Bristow, OKFuel starvation induced power loss, a compromised fuel vent system, and improper installation of the plumbing in the fuel vent system.NTSB FTW90GA146Accident · 1 fatalFinal reportRobinson R22B · Tahlequah, OKThe pilot's failure to maintain adequate altitude.NTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.NTSB FTW90FA120Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Oklahoma City, OKFailure of the pilot to recover from the aerobatic maneuver and subsequent stall/spin, due to inadequate altitude. Fatigue may have been a related factor.NTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.NTSB FTW90DPJ08Accident · 1 fatalFinal reportDe Havilland Venom 112 MK4 · Muskogee, OKThe pilot's premature rotation and the subsequent stall. A factor was the pilot's lack of experience in the airplane.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB FTW90DPJ06Accident · 1 fatalFinal reportStits SA-3A Playboy · Bartlesville, OKAn inadvertent stall.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.NTSB FTW90FA093Accident · 1 fatalField investigationFinal reportMooney M-20J · Inola, OKThe pilot's decision to conduct the flight into known adverse weather and his inability to maintain control of the airplane due to spatial disorientation. Factors were the dark night conditions and thunderstorms.NTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.NTSB FTW90LA089Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Durant, OKPilot's failure to maintain adequate airspeed (vso) and subsequent stall of the aircraft at an altitude from which recovery was not possible. A factor in the accident was the pilot's improper procedures for the landing approach.NTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB FTW90FA062Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Coalgate, OKFlight into known adverse weather conditions by the non-instrument rated pilot, and his subsequent spatial disorientation, which resulted in a loss of aircraft control. Factors related to the accident were: inoperative instrument panel lights, dark night,…NTSB FTW90LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Glencoe, OKThe power loss due to carburetor ice, which resulted from the pilot's failure to engage carburetor heat in a timely manner. A factor in this accident was the pilot's lack of total experience.