NTSB investigations, OK
49 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 4 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 1 |
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\", '0107'))
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", '0107')) 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 CEN26LA073Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International 114 · Stroud, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of power due to fuel exhaustion.NTSB CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.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 CEN24FA057Accident · 2 fatalClass 3 · FieldFinal reportBeech A23-24 · Oklahoma City, OKA total loss of engine power due to multiple connecting rod failures from oil starvation associated with an extensive before takeoff oil system leak, the source of which could not be identified due to postaccident fire damage.NTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Wade, OKThe total loss of engine power due to fuel contamination.NTSB CEN22LA343Accident · No injuriesClass 3 · LimitedFinal reportBeech E33A · Zena, OKThe pilot’s inadequate preflight inspection and fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150E · Harrah, OKThe flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.NTSB CEN22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Marshall, OKThe pilot’s failure to manage fuel, which resulted in a loss of engine power to both engines due to fuel starvation.NTSB CEN22LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Heavner, OKA total loss of engine power due to oil exhaustion which resulted from improper engine maintenance.NTSB CEN20LA301Accident · No injuriesClass 3 · LimitedFinal reportVans RV4 · Idabel, OKThe pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.NTSB CEN20LA292Accident · No injuriesClass 3 · LimitedFinal reportBeech A23-24 · Burns Flat, OKThe mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.NTSB CEN20CA249Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Lahoma, OKThe loss of engine power due to fuel exhaustion and the pilot’s improper fuel planning before the flight.NTSB CEN20LA053Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Ada, OKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation, and the pilot’s inadequate preflight inspection and preflight fuel planning.NTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.NTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…NTSB CEN18LA125Accident · Minor injuriesLimited investigationFinal reportCub Crafters PA18 150 · Beggs, OKThe pilot's failure to verify that the fuel selector was properly set before takeoff, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-236 · Tishomingo, OKThe pilot’s inadequate preflight fuel planning and in-flight fuel monitoring and his decision to take off with an unverified amount of fuel, which resulted in fuel exhaustion and a subsequent impact with trees during an attempted forced landing.NTSB GAA17CA472Accident · No injuriesData collectionFinal reportMooney M20 · Skiatook, OKThe pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…NTSB CEN17LA286Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Walters, OKMaintenance personnel’s installation of an improper vacuum pump gasket, which resulted in oil starvation to the engine and a subsequent total loss of engine power.NTSB CEN17LA251Accident · No injuriesLimited investigationFinal reportCody Hawkins JA30 Superstol · Ponca City, OKContamination of the fuel system, resulting in a partial loss of engine power and subsequent off-airport landing.NTSB CEN17LA242Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Grove, OKAn unporting of fuel in the right wing while maneuvering in the airport traffic pattern, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.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 CEN17FA085Accident · 1 fatalField investigationFinal reportCessna 172 · Jay, OKThe pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…NTSB CEN17LA019Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Mc Alester, OKA total loss of engine power during initial climb due to fuel starvation.NTSB CEN16LA217Accident · Minor injuriesLimited investigationFinal reportBellanca 17 30 · Westport, OKA total loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB CEN16LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sand Springs, OKA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB CEN16LA162Accident · No injuriesLimited investigationFinal reportCessna 150J · Bixby, OKA total loss of engine power for reasons that could not be determined, as the fuel state of the airplane at the time of the accident could not be verified, and postaccident examination of the engine did not provide adequate information.NTSB GAA16CA177Accident · Minor injuriesData collectionFinal reportBeech A23 · Hulbert, OKThe pilot's inadequate fuel planning, which resulted in fuel exhaustion, and collision with terrain.NTSB CEN16LA090Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Overbrook, OKThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.NTSB CEN15LA205Accident · Minor injuriesLimited investigationFinal reportPitts Model 12 · Burneyville, OKThe partial loss of engine power due to contamination of the fuel system.NTSB CEN15LA180Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Verdigris, OKThe fuel pump gear manufacturer’s allowance of set-up gears made from a nonconforming material to be put in the production inventory system, the installation of a nonconforming gear in the accident airplane’s production fuel pump, and the gear’s failure,…NTSB CEN14LA526Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Hobart, OKA loss of engine power due to fuel exhaustion, which resulted from the pilot's erroneous preflight fuel calculations and inadequate in-flight fuel management.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 CEN14LA218Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wann, OKThe pilot's inadequate preflight inspection and planning and inflight fuel management, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing in an area of unsuitable terrain.NTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.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 CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12LA134Accident · Minor injuriesLimited investigationFinal reportAero Commander 500-B · Bartlesville, OKThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…NTSB CEN10FA382Accident · 3 fatalField investigationFinal reportCessna 421 · Tulsa, OKThe pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB CEN09LA501Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Oklahoma City, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.