NTSB investigations, 1994, OK
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 | 14 |
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\") = 1994
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") = 1994 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 FTW95LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oklahoma City, OKThe loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.NTSB FTW95FA071Accident · 3 fatalField investigationFinal reportCessna 182G · Muskogee, OKFailure of the pilot to maintain control of the airplane due to spatial disorientation after inadvertently flying into adverse weather. Factors related to the accident were: darkness, the low ceiling, the pilot's inadequate evaluation of the weather, and his…NTSB FTW95LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKThe pilot's improper recovery from a bounced landing. Factors were the improper flare and the resultant loss of directional control.NTSB FTW95LA057Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lawton, OKThe pilot's failure to attain sufficient airspeed during takeoff resulting in a stall. Factors were the pilot's selection of the downwind runway and his failure to use all availabble runway.NTSB FTW95LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-24APF · Tulsa, OKThe pilot's failure to maintain vref during approach and his improper flare touchdown that resulted in an excessive pitch up attitude following touchdown.NTSB FTW95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Haskell, OKThe total loss of engine power due to contaminated fuel. Factors were the improper maintenance procedures resulting in fuel contamination, the pilot's inadequate preflight inspection, and the lack of suitable terrain available for the forced landing.NTSB FTW95LA026Accident · Serious injuriesLimited investigationFinal reportGeorge Spacewalker 1 · Mountain View, OKThe pilot's failure to maintain minimum required airspeed for flight.NTSB FTW95FA001Accident · 1 fatalField investigationFinal reportMcmurtrie Jurca MJ-10 · Bartlesville, OKAn inadvertent pilot-induced stall at too low an altitude to effect a safe recovery. Factors were the malfunctioning propeller system and the uncommanded feathering of the propeller.NTSB FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.NTSB FTW94LA304Accident · No injuriesLimited investigationFinal reportMooney, Dan Rotorway Exec 90 · Owasso, OKThe flight instructor's inadequate supervision of the student. A factor was the student's failure to maintain adequate rotor RPM.NTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB FTW94LA289Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Ardmore, OKThe partial loss of power due to a cylinder head separation. Factors were the lack of suitable terrain for the forced landing and the low ceiling.NTSB FTW94LA283Accident · 2 fatalLimited investigationFinal reportWalton Skybolt · Collinsville, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.NTSB FTW94LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Tulsa, OKLoss of engine power following fuel starvation caused by improper tank selection by the pilot. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA273Accident · 3 fatalField investigationFinal reportCessna 310 · Pryor, OKFailure of the pilot to maintain minimum control airspeed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: an oil leak from a fatigue crack in the engine crankcase, and inadequate maintenance.NTSB FTW94LA250Accident · No injuriesLimited investigationFinal reportLet L-23 · Stillwater, OKThe certified flight instructor's failure to maintain flying speed.NTSB FTW94LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Owasso, OKThe pilot's failure to attain the proper touchdown point.NTSB FTW94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Tulsa, OKThe loss of engine power for undetermined reasons. The lack of terrain suitable for a forced landing was a factor.NTSB FTW94FA220Accident · 2 fatalField investigationFinal reportSIAI-Marchetti F.260 · Dover, OKFailure of the pilot to maintain adequate altitude while performing an aerobatic demonstration. Factors related to the accident were: the pilot's inadequate training, his lack of experience in the type of operation, and insufficient FAA oversight of this type…NTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.NTSB FTW94IA198Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Caddo, OKThe fuel nozzle drain leak due to a defective o-ring.NTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.NTSB FTW94LA193Accident · No injuriesLimited investigationFinal reportBell 47H-1 · Tulsa, OKThe pilot's failure to maintain rotor RPM, his delayed landing flare, and the improper touchdown.NTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.NTSB FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.NTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.NTSB FTW94LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Tulsa, OKThe pilot's failure to compensate for wind conditions. A factor was the gusting cross wind.NTSB FTW94LA107Accident · No injuriesLimited investigationFinal reportCessna 210L · Haskell, OKWas the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA094Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Duncan, OKThe pilot's selection of the wrong engine for shut down. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA075Accident · Serious injuriesLimited investigationFinal reportCessna T-210J · Hobart, OKThe pilot's continued VFR flight into IMC. Factors were the weather, the pilot's failure to obtain a weather briefing for the flight, and the dark night conditions.NTSB FTW94FA074Accident · 1 fatalField investigationFinal reportAeronca 7AC · Tulsa, OKWas the inadvertent stall. Factors were the pilots failure to use carburetor heat when weather conditions existed that were conducive to carburetor icing, and his abrupt maneuver to avoid a light pole.NTSB FTW94LA072Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student pilot's improper braking technique and the resultant failure to maintain directional control. A factor was the pilot not obtaining an ATC clearance prior to takeoff.