NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB FTW96LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pawnee, OKThe pilot's failure to maintain adequate clearance from the terrain.NTSB FTW96FA063Accident · 2 fatalField investigationFinal reportBalloon Works Firefly 7-15 · Oklahoma City, OKThe pilot's failure to maintain obstacle clearance during low altitude straight and level flight.NTSB FTW96LA068Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Collinsville, OKThe pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.NTSB FTW96FA058Accident · 3 fatalField investigationFinal reportCessna 172P · Hallett, OKThe flight instructor's intentional low altitude flight maneuver. Factors were the static wire and the bright night condition.NTSB FTW96LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Oklahoma City, OKThe student pilot's failure to use carburetor heat resulting in loss of engine power due to carburetor icing. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB FTW96LA034Accident · No injuriesLimited investigationFinal reportCessna T210F · Tulsa, OKthe pilot's failure to secure a cellular telephone which jammed the rudder pedals.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB FTW96LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Kingston, OKthe pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA395Accident · Serious injuriesLimited investigationFinal reportSinclair 1100R · Guthrie, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.NTSB FTW95LA368Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oklahoma City, OKThe failure of the low side of the turbine governor. A factor the lack of suitable terrain for the forced landing.NTSB FTW95LA357Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's failure to maintain clearance. A factor was the fence at the end of the airstrip.NTSB FTW95LA334Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · 0wasso, OKThe pilot's delayed decision to abort the takeoff. The pilot's failure to properly calculate the performance data prior to takeoff was a factor.NTSB FTW95LA318Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Muskogee, OKThe pilot's evasive manuever to take off with insufficient runway available for attaining takeoff airspeed. Factors which contributed to the accident were: the unauthorized use of the airplane, the pilot's anxiety, and the dark night.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.NTSB FTW95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Guymon, OKThe pilot's failure to maintain airspeed. The high density altitude was a factor.NTSB FTW95LA244Accident · 1 fatalLimited investigationFinal reportWalter W. Bell Lazer Edge · El Reno, OKThe pilot's failure to maintain control resulting in an inadvertent stall/spin. Factors were the pilot's performance of aerobatic maneuvers at the low altitude.NTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.NTSB FTW95LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Guthrie, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA212Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Owasso, OKThe failures of the landing gear hydraulic pump and the emergency gear extension system as result of inadequate maintenance by maintenance personnel.NTSB FTW95LA201Accident · 1 fatalLimited investigationFinal reportHarding 1500-R-MINI-MAX · Braggs, OKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to obtain or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall.NTSB FTW95LA200Accident · No injuriesLimited investigationFinal reportBeech D55 · Norman, OKThe pilot's inadvertent retraction of the landing gear, resulting in a gear up landing.NTSB FTW95FA181Accident · 2 fatalField investigationFinal reportBell 47D1 · Ardmore, OKInflight collision with a power transmission array static line when the flight instructor and dual (private pilot) student failed to maintain adequate visual lookout.NTSB FTW95LA178Accident · No injuriesLimited investigationFinal reportCessna 182D · Overbrook, OKThe pilot's failure to maintain flying speed, resulting in an inadvertent stall. A factor was the crosswinds.NTSB FTW95LA175Accident · No injuriesLimited investigationFinal reportBriggs Glasair III · Crescent, OKTotal non-mechanical power loss due to a fuel system vapor lock. A factor was the uneven terrain on which the forced landing was made.NTSB FTW95LA169Accident · No injuriesLimited investigationFinal reportStembridge Spezio · Duncan, OKThe pilot's improper compensation for the wind conditions. A factor was gusty winds.NTSB FTW95LA168Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Tulsa, OKThe pilot's improper emergency procedure preventing emergency gear extension. A factor was the loss of electrical alternator power for undetermined reasons.NTSB FTW95LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Catoosa, OKThe pilot's failure to maintain terrain and obstacle clearance.NTSB FTW95LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hobart, OKThe pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.NTSB FTW95LA172Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Elk City, OKThe pilot's failure to maintain proper altitude during a hovering turn. A factor was the low temperature.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB FTW95FA114Accident · 2 fatalField investigationFinal reportRockwell 690A · Guthrie, OKThe pilot's failure to maintain adequate airspeed due to airframe ice, which resulted in a loss of control. Factors contributing to the accident were the pilot's continued flight into adverse weather, his failure to obtain weather information either before or…NTSB FTW95LA107Accident · No injuriesLimited investigationFinal reportCessna 150F · Commerce, OKFuel exhaustion as a result of the pilot failing to perform an adequate preflight inspection of the airplane. The lack of suitable terrain on which to make a forced landing was a factor.NTSB FTW95LA092Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Miami, OKThe pilot's failure to maintain control of the airplane during takeoff due to his attention being diverted. Factors were the passenger's seat belt buckle blocking the gear up latching mechanism, and his lack of familiarity with the airplane.NTSB FTW95LA078Accident · No injuriesLimited investigationFinal reportCessna 310Q · Guthrie, OKThe pilot's flight into known adverse weather resulting in an inadvertent stall. A factor was icing conditions.