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 WPR25LA184Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180E · Rockford, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…NTSB WPR25LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Willow Creek, MTThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB ERA25LA273Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · New Port Richey, FLThe pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.NTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.NTSB CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB ERA25LA210Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV-12 · Abingdon, VAThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA200Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Florida City, FLThe commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.NTSB ERA25LA194Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Hastings, FLThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA25FA185Accident · 1 fatalClass 3 · FieldFinal reportMX Aircraft Tech PTY MXS · Hampton, VAA counterweight plug that loosened during the accident flight, jammed the elevator, and resulted in loss of control during landing.NTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB ERA25LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Lakin, WVThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.NTSB WPR25LA131Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Green Valley, AZThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.NTSB ERA25LA162Accident · Serious injuriesClass 4 · LimitedFinal reportRuys Nicholas G RV-8 · Bennettsville, SCThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.NTSB CEN25LA143Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12-ET · Ruston, LAThe pilot’s improper fuel planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an autorotation.NTSB ERA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Chamblee, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during approach due to fuel exhaustion.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Farlinville, KSA loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.NTSB CEN25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · Greenville, MSThe pilots’ inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing into wooded terrain. Contributing to the accident was the flight…NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR25FA090Accident · No injuriesClass 3 · FieldFinal reportBeech B24R · Skull Valley, UTThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were multiple distractions that diverted the flight instructor’s attention from the proper monitoring and…NTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.NTSB CEN25LA091Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Ennis, TXThe pilot’s improper fuel planning which resulted in the total loss of engine power due to fuel exhaustion.NTSB ANC25LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 182F · Anchorage, AKThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.NTSB CEN25LA082Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Plainview, TXFuel starvation due to fuel migration during the pilot induced slipping maneuver.NTSB CEN25LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Bentonville, ARThe pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA080Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Omaha, NEThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA097Accident · No injuriesClass 4 · LimitedFinal reportJonathan C Eggers Challenger II · Conway, SCThe pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB WPR25LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Gallup, NMThe pilot’s improper fuel management, which resulted in a total loss of engine power.NTSB CEN25LA065Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28 · New Braunfels, TXThe pilot’s improper in-flight fuel planning which resulted in a total loss of engine power due to fuel starvation and a subsequent off-field landing on rough terrain.NTSB ANC25LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 182B · Waimea, HIThe pilot’s inadequate monitoring of the fuel status while en route, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Mesa, AZThe pilot’s improper fuel tank selection during takeoff, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…NTSB CEN25LA060Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Victoria, TXThe pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150L · Meridian, MSThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate verification of his student’s preflight planning.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 WPR25LA046Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Gillette, WYA loss of engine power due to fuel starvation resulting from a loose B-nut at the engine-driven fuel-pump inlet.NTSB CEN25LA035Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC-1 · East Troy, WIThe pilot’s inadequate fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inaccurate fuel gauge.NTSB CEN25LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Van, TXThe mechanic’s improper maintenance of the engine’s air induction scat duct, which collapsed during the flight and resulted in a loss of engine power.NTSB ERA25LA010Accident · No injuriesClass 4 · LimitedFinal reportDitsler Paul A Dakota Hawk · Nicklesville, GAThe pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.NTSB WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.NTSB WPR25LA004Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · El Monte, CAA total loss of engine power due to contaminated fuel.NTSB ERA25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Moore Haven, FLThe pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.NTSB ERA25LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa Bay, FLA total loss of engine power in flight due to fuel starvation. Contributing to the accident was the inadequate preflight fuel planning by the student pilot and flight instructor, and the improper inflight fuel management by the student pilot.NTSB CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.