NTSB investigations, 2003, 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
Latest 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\") = 2003
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") = 2003 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 FTW04LA046Accident · No injuriesLimited investigationFinal reportBell 206B · Henryetta, OKThe pilot's inadequate visual look out and failure to maintain clearance from guy wire while maneuvering for landing.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.NTSB FTW04LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Henryetta, OKA loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.NTSB FTW04LA003Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Pauls Valley, OKThe loss of engine power for undetermined reasons.NTSB FTW03LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wayne, OKA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. Factors were the lack of suitable terrain for the forced landing.NTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.NTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.NTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.NTSB FTW03LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bristow, OKThe pilot's premature retracting of the flaps, and his failure to maintain airspeed which resulted in an inadvertent stall.NTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB FTW03LA167Accident · No injuriesLimited investigationFinal reportManweiler Acro Sport II · Bartlesville, OKThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion. A related factor was the lack of suitable terrain.NTSB FTW03LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Guymon, OKThe pilot's inadequate compensation for the crosswind, and his failure to maintain directional control. A factor was the crosswind.NTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.NTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.NTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.NTSB FTW03LA140Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ardmore, OKThe pilot's failure to maintain directional control during liftoff. A contributing factor was the inadvertent encounter of propeller blast from the other airplane starting at the time of takeoff.NTSB FTW03LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…NTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.NTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.