NTSB investigations, 2013, 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\") = 2013
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") = 2013 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 CEN14CA092Accident · Minor injuriesData collectionFinal reportCessna 210E · Guymon, OKThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN14FA046Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-25 · Owasso, OKThe pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…NTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.NTSB CEN14FA010Accident · 1 fatalField investigationFinal reportCessna 177 · Clayton, OKControlled flight into terrain for reasons that could not be determined from the available evidence.NTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.NTSB CEN13LA370Accident · No injuriesLimited investigationFinal reportMooney M20J · El Reno, OKA loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations.NTSB CEN13LA390Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Boise City, OKThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN13LA322Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Covington, OKThe airplane’s failure to climb after takeoff for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.NTSB CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.NTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…NTSB CEN13CA189Accident · No injuriesData collectionFinal reportCessna 140 · El Reno, OKThe pilot's failure to maintain control during takeoff. Contributing to the accident was the check pilot's delayed remedial action.NTSB CEN13FA174Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Oklahoma City, OKThe loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…NTSB CEN13LA167Accident · No injuriesLimited investigationFinal reportCessna 172L · Idabel, OKThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN13LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Tulsa, OKThe line technician’s failure to remove the refueling mat from the helicopter fuselage following servicing, which resulted in the mat striking the tail rotor in flight, and the pilot’s inadequate preflight inspection.NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.NTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…