NTSB investigations
2,052 cases where NTSB found Fluids/misc hardware.
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\", '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."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 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 CEN22LA225Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Roanoke, TXInadequate maintenance of the airplane’s brake system that resulted in a hole in the brake line, the loss of brake fluid, and the subsequent loss of brake functionality.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.NTSB CEN22LA190Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · Houston, TXThe fixed-base operator’s incorrect fueling of the airplane, which resulted in a total loss of power in both engines.NTSB CEN22LA189Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Blanket, TXThe pilot’s failure to properly manage fuel while enroute, which resulted in a loss of engine power due to fuel starvation and a subsequent forced landing.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ERA22LA200Accident · Serious injuriesClass 4 · LimitedFinal reportTitan T51 · Perry, FLThe pilot’s inadequate preflight inspection of the fuel quantity, which resulted in fuel exhaustion, a subsequent total loss of engine power, and an off-airport landing.NTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.NTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.NTSB CEN22LA180Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Huntsville, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tuscon, AZThe loss of directional control during the landing roll, due to missing hardware which resulted in the separation of the nose landing gear torque links.NTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA130Accident · No injuriesClass 4 · LimitedFinal reportParadise Aircraft USA P1 · Glendale, AZA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight fuel inspection.NTSB WPR22LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Lancaster, CAA total loss of engine power due to the pilot’s inadequate fuel management which resulted in fuel starvation and subsequent collision with a fence during landing.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 ERA22LA146Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Waco, GAThe failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.NTSB CEN22LA135Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Monee, ILThe loss of engine power due to fuel starvation for undetermined reasons during a departure climb that resulted in a forced landing and impact with terrain.NTSB CEN22LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Campbellton, TXThe pilot’s fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with trees during a forced landing.NTSB ERA22LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-150 · Savannah, GAThe student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Washington, NCThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB WPR22FA094Accident · Minor injuriesClass 3 · FieldFinal reportDassault Mirage F1 CR · Glendale, AZA loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s…NTSB ERA22LA112Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195 · Palm Coast, FLThe pilot’s inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…NTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.NTSB WPR22LA046Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV10 · Hurricane, UTThe total loss of engine power due to a loose fuel line at the fuel servo outlet port.NTSB ANC22LA007Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe improper installation of an avionics wire harness over a fuel line, which resulted in chafing of the wire harness, arcing, and a subsequent fire.