NTSB investigations, 1992, OK
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1992
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") = 1992 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 FTW93FA061Accident · 3 fatalField investigationFinal reportBeech C24R · Tulsa, OKThe pilot's disregard of and descent below the published decision height. Factors were his failure to maintain proper glide path and localizer alignment.NTSB FTW93LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Norman, OKThe pilot's failure to refuel the airplane and power loss due to fuel exhaustion. Factors were the dark night and lack of suitable terrain.NTSB FTW93LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Tryon, OKPower loss due to fuel starvation and the pilots improper selection of the off position on the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.NTSB FTW93LA024Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot's failure to properly judge his level off altitude while maneuvering.NTSB FTW92FA232Accident · 1 fatalField investigationFinal reportCessna 310R · Idabel, OKThe pilot's descent below the minimum descent altitude. Factors were the pilot's improper IFR procedure, low ceiling, and dark night conditions.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.NTSB FTW92IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Oklahoma City, OKHydraulic fluid exhaustion due to the chafed 'a' system hydraulic line and the improper installation by unknown maintenance personnel of the 'b' system line.NTSB FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.NTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.NTSB FTW92LA171Accident · No injuriesLimited investigationFinal reportCessna R172K · Eufaula, OKThe pilot's inadequate compensation for the wind conditions. The turbulent winds near the end of the runway were a factor in the accident.NTSB FTW92FA169Accident · 1 fatalField investigationFinal reportRockwell 690B · Konawa, OKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent spiral and subsequent rapid descent. The design stress limits of the airframe were exceeded resulting in an overload failure of the empennage. Factors related to the…NTSB FTW92DPJ03Accident · 1 fatalFinal reportCessna 188A · Idabel, OKPower loss for undetermined reasons. A factor was lack of unsuitable terrain for the forced landing.NTSB FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.NTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.NTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.NTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.NTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW92LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · Stilwell, OKThe pilot inadvertently pushed the nose down during the flare/landing. A factor was the pilot misjudged the flare/landing.NTSB FTW92LA134Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Mooreland, OKThe failure of the number 3 cylinder for undetermined reasons. A factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.NTSB CHI92FA127Accident · 1 fatalField investigationFinal reportCessna 172P · Kellyville, OKAn inadvertent stall and misjudgement of an emergency procedure by the pilot in trying to stretch the forced landing approach to make it to the airstrip.NTSB FTW92LA113Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lawton, OKThe pilots'decision to fly into marginal VFR weather. A factor was the guy wire and fog.NTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.NTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.NTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.NTSB FTW92FA098Accident · 1 fatalField investigationFinal reportCessna 172M · Oklahoma City, OKInadvertent stall during aborted landing. Factors were the tailwind, the pilot's selection of the wrong runway for existing wind conditions and his long landing.NTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.NTSB FTW92LA096Accident · Minor injuriesLimited investigationFinal reportBurnett Teenie II · Edmond, OKPartial engine power loss due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.NTSB FTW92LA072Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Oklahoma City, OKThe propeller hydraulic control pitch setting being incorrect for undetermined reasons. A factor in the accident was the pilot's failure to identify and correct the pitch setting as the propeller went to a higher setting.NTSB FTW92FA067Accident · 2 fatalField investigationFinal reportCessna 150M · Covington, OKThe pilot failed to maintain proper object clearance. A factor was his decision to perform the low pass.NTSB FTW92FA064Accident · 2 fatalField investigationFinal reportCessna 182 · Bartlesville, OKThe pilot's failure to maintain terrain clearance. A factor was the dark night.NTSB FTW92FA061Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Oklahoma City, OKThe second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.