NTSB investigations, OK
39 cases where NTSB found Aircraft systems.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 4 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0102'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0102')) 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 CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB CEN26LA021Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Tulsa, OKThe pilot’s improper landing flare which resulted in a hard bounced landing.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN25LA201Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Pawhuska, OKThe pilot’s failure to properly configure the airplane for landing.NTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.NTSB CEN24LA308Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Tulsa, OKThe mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.NTSB CEN24LA258Accident · Minor injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · Stillwater, OKThe pilot’s failure to properly configure the landing gear before performing a water landing.NTSB CEN24LA091Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24 · Hugo, OKThe binding of a main landing gear push-pull cable, which rendered the landing gear inoperative in a partially retracted position. Contributing to the accident was the pilot’s delay in executing a landing, which led to a total loss of engine power due to fuel…NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB CEN21LA216Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS350 B2 Ecureuil · Yukon, OKThe pilot receiving instruction’s untimely and unidentified inadvertent activation of the hydraulic cut-off switch, which turned off the hydraulic system while the helicopter was at slow airspeed followed by a rapid power increase, which resulted in a loss of…NTSB CEN21LA057Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tishomingo, OKThe pilot’s improper adjustment of the engine mixture control, which resulted in a total loss of engine power. Contributing to the accident was a disconnected oil temperature connector, which was likely damaged during maintenance before the accident flight…NTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.NTSB CEN19FA104Accident · 2 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1124 · Yukon, OKThe airplane’s unairworthy thrust reverser (T/R) system due to inadequate maintenance that resulted in an asymmetric T/R deployment during an approach to the airport and the subsequent loss of airplane control.NTSB CEN18LA345Accident · No injuriesLimited investigationFinal reportCessna T210 · Tulsa, OKThe pilot's decision to take off with a known electrical problem, which resulted in the loss of electrical power, problem with the landing gear extension system, and subsequent runway excursion.NTSB CEN18LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grove, OKA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat immediately following the loss of engine power.NTSB CEN18LA070Accident · No injuriesLimited investigationFinal reportCessna 170 · Ponca City, OKThe pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.NTSB CEN17LA121Accident · No injuriesLimited investigationFinal reportBeech C90A · Rattan, OKThe loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the…NTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.NTSB CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.NTSB CEN15FA316Accident · 2 fatalField investigationFinal reportBeech V35B · Colbert, OKThe pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…NTSB CEN15CA166Accident · No injuriesData collectionFinal reportFunk B85C · Leonard, OKThe improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.NTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.NTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.NTSB CEN14FA046Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-25 · Owasso, OKThe pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…NTSB CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.NTSB CEN13FA174Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Oklahoma City, OKThe loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB CEN10CA199Accident · Serious injuriesData collectionFinal reportCessna 172 · Lawton, OKThe private pilot's failure to maintain adequate airspeed, which resulted in a stall, and the failure of both pilots to initiate a go-around. Contributing to the severity of both pilots' injuries was the lack of available shoulder harnesses.NTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.NTSB CEN09LA281Accident · No injuriesLimited investigationFinal reportCessna 551 · Stillwater, OKThe pilot's loss of control for undetermined reasons.NTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.NTSB DFW08CA079Accident · No injuriesData collectionFinal reportWilley Rotorway Exec 90 · Westport, OKAn unsuccessful precautionary landing due to an electrical system malfunction.NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…