NTSB investigations
1,934 cases where NTSB found Fluids.
Cases, newest first
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010710')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010710')) 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 WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB ERA22LA406Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177B · Ivanhoe, NCThe pilot's inadequate preflight and inflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…NTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.NTSB ERA22LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Orlando, FLThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA308Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 195 · El Cajon, CAThe pilot’s failure to verify the fuel quantity prior to departure, which led to a loss of engine power due to fuel exhaustion.NTSB CEN22FA383Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Hanna City, ILA total loss of engine power due to fuel exhaustion.NTSB ANC22LA068Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180 · Sutton-Alpine, AKA total loss of engine power due to fuel exhaustion.NTSB ERA22FA351Accident · 2 fatalClass 3 · FieldFinal reportSmith Aerostar 600 · South Haven Charter Township, MIA loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.NTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA353Accident · Serious injuriesClass 3 · LimitedFinal reportSonex Sonex · River Falls, WIThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA271Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · San Jose, CAThe pilot’s inadequate preflight inspection and fuel management, which resulted in fuel starvation, a total loss of engine power, and an impact with terrain.NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB WPR22LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Huntington Beach, CAA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel at an altitude too low for recovery. Contributing was the pilot’s delayed decision to switch fuel tanks.NTSB ERA22LA330Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Kenton, OHThe pilot’s inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB ERA22LA329Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Plant City, FLA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight fuel planning.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 CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB CEN22LA341Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421B · Riverdale, NEA total loss of engine power as a result of fuel exhaustion.NTSB CEN22LA324Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Grain Valley, MOThe loss of engine power due to fuel exhaustion.NTSB CEN22LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Kendleton, TXThe pilot’s improper in-flight planning and fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR22LA243Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Oxnard, CAFuel starvation due to an inappropriately maintained and modified fuel selector valve.NTSB DCA22LA179Incident · No injuriesClass 4 · LimitedFinal reportBoeing 767-332 · New York, NYThe failure of maintenance personnel to close the drain mast heater circuit breakers which resulted in the formation of ice in the forward drain mast, an improper flow of wastewater into the main landing gear wheel well, and the formation of ice on one or…NTSB ERA22LA298Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Akron, OHThe pilots’ improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22FA298Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · St. Jacob, ILThe inadequate maintenance of the airplane fuel system that resulted in fuel exhaustion and a loss of engine power.NTSB WPR22LA247Accident · Serious injuriesClass 3 · LimitedFinal reportBeech H35 · LaCrosse, WAThe pilot’s failure to monitor and manage the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB CEN22LA305Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · East Troy, WIThe pilot’s improper fuel management that resulted in fuel exhaustion and a loss of engine power.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 WPR22LA231Accident · Serious injuriesClass 3 · LimitedFinal reportJames C Geyman RV-9A · Missoula, MTThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the pilot’s failure to activate the auxiliary fuel boost pump, which inhibited a successful engine restart.NTSB ERA22LA291Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Warm Springs, GAThe loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.NTSB ERA22LA276Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Laurinburg, NCThe pilot’s decision to depart with insufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion on final approach for landing.NTSB CEN22LA260Accident · Minor injuriesClass 3 · LimitedFinal reportSmith Miniplane DSA-1 · Union, NEThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22LA266Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Sarasota, FLThe pilot’s inadequate preflight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a loss of engine power on approach.NTSB WPR22LA213Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Auburn, WAA total loss of engine power due to fuel starvation.NTSB ERA22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportWhittridge Twinstarr · Indian Trail, NCA blockage of the fuel filter inlet by a piece of debris, which resulted in fuel starvation and a total loss of engine power.NTSB WPR22LA203Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Hillsboro, ORA missing fuel filler cap O-ring, which resulted in a total loss of engine power due to water contamination in the fuel.NTSB CEN22LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s inadequate fuel management that resulted in a loss of engine power due to fuel starvation.NTSB ERA22FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201 · Panama City, FLMaintenance personnel’s failure to follow the avionics installation guidance for the oil pressure sensor, which resulted in the high-cycle fatigue failure of an line, oil starvation, and the subsequent loss of engine power. Contributing to the accident was…NTSB WPR22LA204Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Snohomish, WAThe total loss of engine power during takeoff due to fuel starvation and the pilot’s improper fuel tank selection and inadequate preflight inspection.NTSB ERA22LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Ellington, CTThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency landing, and runway excursion.NTSB ERA22LA258Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D1 · Pittsboro, NCThe student pilot, and flight instructor’s, inadequate preflight inspection, during which they failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB CEN22LA229Accident · No injuriesClass 4 · LimitedFinal reportFahey William J CH750 Cruzer · San Antonio, TXThe loss of engine power due to fuel starvation. Contributing to the fuel starvation was a faulty experimental fuel gauge.NTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.NTSB CEN22LA220Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA-1B · River Falls, WIThe student pilot’s and flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.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 WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.