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 ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA167Occurrence · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Page, AZThe fueler’s inadvertent addition of diesel exhaust fluid (DEF) to the FSII reservoir on the fuel truck, and its subsequent mixture with the JET A that was used to fuel the airplane, resulting in a total loss of power to the right engine and a partial loss of…NTSB ERA23LA206Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · West Palm Beach, FLThe loss of engine power due to fuel exhaustion.NTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…NTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.NTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB ERA23FA188Accident · 1 fatalClass 3 · FieldFinal reportMiller Glenn F RV-12 · Climax, NCThe airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…NTSB ERA23LA191Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Danbury, CTThe flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 421C · Leesburg, VASeparation of the left man landing gear scissor hardware, which resulted in a loss of directional control and subsequent runway excursion during landing.NTSB CEN23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Wade, OKThe total loss of engine power due to fuel contamination.NTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.NTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.NTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.NTSB WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.NTSB ERA23LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Miami, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA23FA136Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-150 · Blue Ridge, GAA loss of engine power due to fuel starvation due to the improper positioning of the fuel selector.NTSB WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.NTSB WPR23LA115Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Mulino, ORThe pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Buckhannon, WVA total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.NTSB CEN23LA133Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Hilbert, WIThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.NTSB CEN23LA101Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7ACA · Bayport, MNThe pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.NTSB ERA23LA122Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 500 · Sylacauga, ALThe pilot’s failure to assure there was an adequate amount of fuel onboard to complete the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA121Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Brinkman Lancair 4P · Hartford, CTThe pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…NTSB ERA23LA119Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Miami, FLThe pilot’s mismanagement of fuel supply, which resulted in fuel starvation.NTSB ERA23LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Buford, GAWater contamination in the fuel system that was not observed during the preflight inspection, resulting in a total loss of engine power and forced landing.NTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…NTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.NTSB ANC23LA013Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL-65 · Wasilla, AKThe pilot's failure to remove all water from the fuel tank, which resulted in fuel contamination and a subsequent partial loss of engine power.NTSB CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23FA074Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fayetteville, ARThe pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.NTSB CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.NTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.NTSB ERA23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Rockingham, NCThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.NTSB ERA23LA083Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-44 · Hawkinsville, GAThe pilot’s inadequate in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna TP206A · Maricopa, AZA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s improper fuel management.NTSB ANC23LA006Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Bethel, AKThe total loss of engine power during cruise flight due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…NTSB ERA23LA051Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Virus SW · Cross City, FLThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent deployment of the ballistic parachute recovery system.NTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.NTSB ERA23LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Tanner, ALThe pilot’s inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA053Accident · Minor injuriesClass 4 · LimitedFinal reportSchmidt Randall M Bushby Mustang II · Statesboro, GAA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.NTSB ERA23LA049Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Greenville, SCThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.