NTSB investigations, 1989, OK
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1989
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") = 1989 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 FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB FTW90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Stroud, OKNTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.NTSB FTW90LA034Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Shawnee, OKFailure of the pilot to maintain adequate airspeed during the turn after takeoff, which resulted in a stall. The obstructions (trees) were a factor.NTSB FTW90DPJ02Accident · 1 fatalFinal reportLogan, B.A. Windrose · Norman, OKThe inadvertent stall and the pilot's improper emergency recovery procedures. A factor was the power loss for undetermined reasons.NTSB FTW90LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot inadvertently became lost and disoriented and delayed in obtaining help from the flight service station, which resulted in fuel exhaustion.NTSB FTW90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Marietta, OKThe pilot's use of the wrong runway for takeoff. Factors related to the accident were: the tailwind and rising terrain beyond the departure end of the runway.NTSB FTW90DPJ01Accident · Minor injuriesFinal reportZimmerman Moni Motorglider · Oklahoma City, OKPower loss due to the deteriorated muffler baffle which was not discovered in the recent annual inspection. A factor was the pilot's failure to properly analyze and correct for the headwind.NTSB FTW90LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Edmond, OKInadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).NTSB FTW89IA168Incident · No injuriesIncident investigationFinal reportCessna 152 · Bethany, OKFailure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…NTSB FTW89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe pilot's loss of control during an attempted go around.NTSB FTW89LA160Accident · No injuriesLimited investigationFinal reportCessna 210P · Bethany, OKA loose fuel line connection, due to inadequate maintenance, which resulted in fuel starvation. Factors related to the accident were: darkness and the obstructions (hay bale & approach light pole) in the emergency landing area.NTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…NTSB FTW89LA149Accident · No injuriesLimited investigationFinal reportMooney M20F · Davis, OKThe pilot's failure to maintian directional control and properly flare the airplane during landing.NTSB FTW89LA147Accident · No injuriesLimited investigationFinal reportMooney M20K · Marietta, OKThe pilot's delay in aborting the landing (going around) and his improper raising of the flaps at an inadequate airspeed.NTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.NTSB FTW89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Granite, OKThe pilot did not maintain directional control.NTSB FTW89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Okmulgee, OKFailure of the nose gear extension assembly and the pilot's improper precautionary landing procedures that included securing the engines prior to a point where a safe landing was assured.NTSB FTW89DPJ08Accident · Serious injuriesFinal reportGrumman G-164 · Guymon, OKFailure of the upper right engine mount (firewall attach bolt) due to fatigue, and failure of the lower right mounting bolt for an unknown reason, which allowed overload failure of the two remaining mounting bolts and separation of the engine.NTSB FTW89DPJ07Accident · 2 fatalFinal reportBeech T-34 · Haskell, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: a leak in the pitot system, failure of the pilot to obtain adequate maintenance/inspection of the pitot system, and his lack of…NTSB FTW89DPJ06Accident · No injuriesFinal reportPiper PA-18A · Eva, OKThe pilot's failure to maintain visual lookout. A factor was the pilot's limited visual perception due to the ground vehicle.NTSB FTW89LA112Accident · Minor injuriesLimited investigationFinal reportSwift GC-1B · Luther, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The proximity of the trees were a factor.NTSB FTW89LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Bristow, OKThe pilot's improper fuel management and failure of the inflight restart attempt.NTSB FTW89DPJ05Accident · No injuriesFinal reportNord Stampe SV4C · Bartlesville, OKTotal failure of the engine connecting rod.NTSB FTW89FA107Accident · Serious injuriesField investigationFinal reportPitts S-1S · Henryetta, OKAn engine power loss due to the separation and departure of an exhaust stack. The stack failed due to poor weld. Factor(s) was: the terrain conditions of the selected forced landing site.NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.NTSB FTW89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Edmond, OKImproper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.NTSB FTW89FA096Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boise City, OKAn inadvertent stall resulting from the pilot's failure to maintain control of the aircraft and to maintain sufficient airspeed. The dark night and adverse wind conditions were contributing factors.NTSB FTW89LA095Accident · Serious injuriesLimited investigationFinal reportAeronca 65-TAC · Pryor, OKThe failure of the pilot to maintain airspeed during a low pass over the airport after pulling up to clear wires which resulted in a stall.NTSB FTW89LA094Accident · No injuriesLimited investigationFinal reportCessna 177B · Harrah, OKFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve; and his improper planning/decision (indecision) concerning an attempted go-around. The pilot's lack of experience in the type of aircraft…NTSB FTW89DPJ04Accident · Minor injuriesFinal reportFields Rotorway Exec · Oklahoma City, OKThe pilot's failure to maintain proper altitude during the hover taxi.NTSB FTW89LA092Accident · No injuriesLimited investigationFinal reportBell 47L · Tulsa, OKInadequate supervision of the student by the instructor in that he allowed the student to overpower his control inputs after an unexpected gust of wind moved the tail of the helicopter.NTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…NTSB FTW89LA088Accident · No injuriesLimited investigationFinal reportCessna 182 · Owasso, OKInadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor.NTSB FTW89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eufaula, OKThe pilot's improper positioning of the fuel selector, which resulted in a loss of power due to fuel starvation, and his failure to followed the emergency procedure. A factor related to the accident was: rough terrain in the emergency landing area.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB FTW89LA069Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Catoosa, OKCarburetor ice and improper use of carburetor heat. Factors related to the occurrence were: carburetor icing conditions and rough/uneven terrain.NTSB FTW89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Henryetta, OKThe loss of engine power from fuel starvation due to inadequate inflight planning/decision.NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.NTSB FTW89LA040Accident · No injuriesLimited investigationFinal reportBeech V35B · Pawhuska, OKFuel tank selector valve being inadvertently switched off and the pilot's emergency procedures inadequate in discoveringand correcting the problem. This resulted in the fuel starvation related power loss. Contributing to the accident was the rough terrain on…