NTSB investigations, OK
57 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 4 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 DFW08FA038Accident · 2 fatalField investigationFinal reportCessna T210M · Tulsa, OKThe pilot's failure to maintain clearance from the power transmission line(s). Contributing to the accident were the loss of aircraft electrical power, diverted attention, and the night conditions.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB DFW07FA004Accident · 4 fatalField investigationFinal reportAero Commander 690A · Antlers, OKThe pilot's failure to reduce airspeed while operating in an area of moderate turbulence, resulting in an in-flight break up. Contributing factors were the pilot's decision to exceed the maximum takeoff weight, and the prevailing turbulence.NTSB DFW05FA242Accident · 1 fatalField investigationFinal reportAkro Tech Aviation Inc. Giles G-300 · Yukon, OKThe catastrophic separation of the canopy as result of the failure of the forward canopy hinge while performing aerobatics and the subsequent incapacitation of the pilot.NTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DFW05IA156Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace Avro 146-RJ85A · Oklahoma City, OKFailure of a high pressure hydraulic line from fatigue as a result of a manufacturing defect.NTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.NTSB FTW04LA148Accident · No injuriesLimited investigationFinal reportBruce Moore Skybolt · Altus, OKThe partial in-flight separation of the wing fabric and rib structure due to an inadequate material installed by the airplane builder.NTSB FTW04IA078Incident · No injuriesIncident investigationFinal reportBeech C90 · Oklahoma City, OKThe failure of the right main landing gear to extend due to an improperly installed attachment bolt by other maintenance personnel.NTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.NTSB FTW03FA053Accident · 1 fatalField investigationFinal reportCessna 172N · Lindsay, OKThe in-flight separation of the right wing due to the missing nut that secures the right wing's strut to fuselage fitting to the fuselage.NTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.NTSB FTW02LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Purcell, OKThe in-flight cabin fire as result of non-compliance with an AD and a Service Bulletin. A contributing factor to the accident was night conditions.NTSB FTW02LA190Accident · No injuriesLimited investigationFinal reportBeech BE-300 · Tulsa, OKThe pilot's inadequate preflight of the airplane resulting in the in-flight separation of the left engine inboard access door.NTSB FTW02IA097Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Tulsa, OKThe failure of the horizontal stabilizer control system for undetermined reasons.NTSB FTW00LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Granite, OKCorrosion failure of the fuselage support tubing below the right wing forward attach fitting due to inadequate maintenance.NTSB FTW99LA272Accident · 1 fatalLimited investigationFinal reportCessna 150F · Poteau, OKThe instructor pilot's inadequate in-flight decision making, which resulted in the continued flight with a disabled generator and subsequent total failure of the electrical system. Factors were the installation of the inadequate generator fuse by unknown…NTSB FTW99FA123Accident · 1 fatalField investigationFinal reportCessna 402C · Goldsby, OKThe fatigue failure of the right wing spar as a result of inadequate quality control during manufacture of the spar. A factor was the inadequate inspection of the right wing by maintenance personnel, which failed to detect the crack.NTSB FTW98LA234Accident · Minor injuriesLimited investigationFinal reportHarding Revolution MINI-500B · Grove, OKThe improper alignment of the main drive belt by the owner/pilot/mechanic, which resulted in the failure of the main drive belt. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98IA130Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lawton, OKthe collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the…NTSB FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.NTSB FTW97LA156Accident · No injuriesLimited investigationFinal reportRockwell 114 · Oklahoma City, OKThe exhaust manifold cracking due to the pilot's inadequate maintenance modification of the exhaust system which resulted in a fire. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA135Accident · 1 fatalField investigationFinal reportTeschendorf Cassutt Sport · Stilwell, OKfailure of the right wing spar and/or debonding of the right wing skin, which resulted in separation of the wing skin and a portion of the right wing, during high speed flight. Factors related to the accident were: previous wing damage and inadequate…NTSB FTW97LA007Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Elk City, OKThe loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.NTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.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 FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.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 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 FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.NTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.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 FTW89DPJ02Accident · 2 fatalFinal reportErcoupe 415C · Oklahoma City, OKDuring flight, the airplane appeared to go into a steep banked spiral from which it did not recover. It struck a two-car detached garage and then the ground. Inspection revealed that the fabric of both wings had been installed improperly, and part of the…NTSB FTW89FA023Accident · 2 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKThe plt was briefed on flt prctns for IFR conds, tstms & ocnl mod rime icing. Drg the climb, he told ATC he was having trouble with his vacuum & was disoriented. ATC clrd him for altitudes he could use & bgn providing no-gyro vectors. A wxcheck revealed there…NTSB FTW88DPJ13Accident · Serious injuriesFinal reportNord 1101 · Ardmore, OKImmediately after liftoff, the airplane abruptly turned left, nosed down, and struck the ground. Examination of the electrical pitch control of the propeller revealed the propeller blades to be in the high pitch, low RPM position. Due to extreme damage of the…NTSB FTW88DPJ12Accident · 1 fatalFinal reportSnyder Stolp SA-300 · Oklahoma City, OKTotal failure of the rudder control due to failure of the metal welds on the cable attachment to the rudder pedal, due to improper welding by the manufacturer.NTSB FTW88LA152Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Sallisaw, OKAcft experienced a hard landing and rolled over following a loss of control in a hover. Plt delayed cutting the throttle in order to clear a ditch. Investigation revealed that the tail rotor driveshaft coupling retaining screw had separated. The separation…NTSB FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…NTSB FTW88DPJ07Accident · Minor injuriesFinal reportNorthrop C-125A · Tulsa, OKThe pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness…NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB FTW86LA037Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Yukon, OKThe left brake locked after the aircraft rolled a short distance during landing. Aircraft slowed until about 20 mph forward speed and then flipped inverted and stopped. Post accident examination revealed the brake shoe return spring on the left brake was…NTSB FTW86LPJ06Accident · No injuriesFinal reportAerospatiale SA319B · Tulsa, OKThe main rotor blades struck the tail boom after liftoff and vibration was violent. When the plt heard metal contact he pulled off the throttle and made an autorotation landing from about 4 ft AGL.NTSB FTW85LA320Accident · No injuriesLimited investigationFinal reportCessna 172N · Sallisaw, OKThe plt stated he had an electrical failure and elected to make a precautionary landing at Sallisaw municipal arpt. Equipment was on the rwy and the plt elected to land on a grass strip next to the rwy. He touched down and during rollout thought he could not…NTSB FTW85FA131Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Stigler, OKThe plt filed a VFR flt plan after the wx improved from IFR to VFR with a chance of thunderstorms en route. Ocnl mod turbulence below 5000 ft was forcast due to strong/gusty low lvl wnds. While the acft was en route, a gnd witness heard the engs rev up more…NTSB FTW85FA112Accident · 2 fatalField investigationFinal reportCessna 402B · Altus, OKDuring an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…NTSB FTW85IA028Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Tulsa, OKDuring cruise, the crew experienced a loss of hydraulic pressure & smoke in the cockpit, then donned their oxygen masks. They used the emerg gear extension system & made a safe emerg landing. An exam revealed a cracked 2000 PSI aluminum hydraulic line had…