NTSB investigations

203 cases where the defining event was Fuel contamination.

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '193')
  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.

NTSB ERA12LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Punta Gorda, FLThe partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.Oct 5, 2011 · N11280 · Substantial damageNTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.Sep 1, 2011 · UNREG · Substantial damageNTSB WPR11LA369Accident · No injuriesLimited investigationFinal reportCessna 140 · Wilkeson, WAA partial loss of engine power during takeoff due to water contamination in the fuel system.Aug 4, 2011 · N2199N · Substantial damageNTSB CEN11LA529Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Opelousas, LAThe loss of engine power due to fuel contamination.Jul 30, 2011 · N231EH · Substantial damageNTSB ERA11LA418Accident · No injuriesLimited investigationFinal reportFloyd Joseph B RV6 · Hartford, KYA loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.Jul 24, 2011 · N164BF · Substantial damageNTSB WPR11FA331Accident · 2 fatalField investigationFinal reportMooney M20F · Winslow, AZA loss of engine power due to fuel system contamination, and the pilot’s subsequent failure to maintain an adequate airspeed, which resulted in a loss of control.Jul 17, 2011 · N3534X · Substantial damageNTSB WPR11LA289Accident · Serious injuriesLimited investigationFinal reportLemond FLY Fisher · West Glacier, MTA total loss of engine power during takeoff due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.Jun 26, 2011 · N397JL · Substantial damageNTSB WPR11FA166Accident · 5 fatalField investigationFinal reportBeech 200 · Long Beach, CAThe pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of the fuel,…Mar 16, 2011 · N849BM · Substantial damageNTSB WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.Feb 26, 2011 · N5351C · Substantial damageNTSB ERA11LA142Accident · No injuriesLimited investigationFinal reportKennedy Michael M Lancair 320 · Dawsonville, GAThe pilot’s inadequate preflight inspection and failure to detect water-contaminated fuel, which resulted in a loss of engine power.Feb 13, 2011 · N351E · Substantial damageNTSB ERA11LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe pilot’s inadequate preflight inspection (removal of water contamination from the fuel system), which resulted in a total loss of engine power.Feb 10, 2011 · N25HD · Substantial damageNTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.Dec 23, 2010 · N40283 · Substantial damageNTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.Dec 2, 2010 · N9145H · Substantial damageNTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.Nov 27, 2010 · N4541L · Substantial damageNTSB ERA11LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Hobe Sound, FLA partial loss of engine power due to fuel contamination in the carburetor.Nov 16, 2010 · N8306B · Substantial damageNTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.Oct 13, 2010 · N5743Q · Substantial damageNTSB ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.Sep 18, 2010 · N38FA · Substantial damageNTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.Sep 4, 2010 · N812KT · Substantial damageNTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.Aug 31, 2010 · N175SP · Substantial damageNTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.Aug 27, 2010 · N8919R · Substantial damageNTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.Aug 23, 2010 · N8734Y · Substantial damageNTSB ERA10LA374Accident · Serious injuriesLimited investigationFinal reportMulloy Charles Zodiac 601XL · Enochville, NCLoss of engine power due to fuel contamination, and the pilot’s inadequate preflight of the fuel system.Jul 24, 2010 · N601CX · Substantial damageNTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.Jun 24, 2010 · N6540C · Substantial damageNTSB CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.May 30, 2010 · N2723U · DestroyedNTSB CEN10LA256Accident · No injuriesLimited investigationFinal reportCessna P206B · Spring Branch, TXA loss of engine power due to fuel contamination.May 17, 2010 · N50LP · Substantial damageNTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.Apr 20, 2010 · N87792 · Substantial damageNTSB CEN10FA122Accident · 2 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to detect water contaminated fuel, which resulted in a loss of engine power shortly after takeoff. Contributing to the accident were the worn and loose fuel caps, which allowed water to enter the fuel tanks.Feb 17, 2010 · N8501Y · Substantial damageNTSB WPR10LA119Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · La Quinta, CAA loss of engine power during cruise flight due to water contamination in the fuel.Jan 25, 2010 · N243SC · Substantial damageNTSB ERA10LA111Accident · No injuriesLimited investigationFinal reportStinson 108 · Bayport, NYA total loss of engine power during cruise flight due to fuel contamination.Jan 9, 2010 · N97223 · Substantial damageNTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.Dec 15, 2009 · N9547D · Substantial damageNTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.Oct 25, 2009 · N57PH · DestroyedNTSB ANC09CA091Accident · No injuriesData collectionFinal reportHelio H-295 · Koliganek, AKA loss of engine power during cruise flight due to water in the fuel, and the pilot's inadequate preflight inspection.Sep 2, 2009 · N6468V · Substantial damageNTSB ERA09LA448Accident · 2 fatalLimited investigationFinal reportKociemba Robert H T-Bird II · Keymar, MDThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination.Aug 8, 2009 · N90458 · Substantial damageNTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.Jul 11, 2009 · N2871E · Substantial damageNTSB ERA09LA352Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Islesboro, MEA loss of engine power due to fuel contamination.Jun 15, 2009 · N33243 · Substantial damageNTSB CEN09LA341Accident · Minor injuriesLimited investigationFinal reportHuston Charles D Pitts S-12 · Spicewood, TXA total loss of engine power due to fuel starvation as a result of the presence of an unidentified contaminant in the fuel system which clogged the fuel flow sensor. Contributing to the accident was the manufacturer’s installation of the fuel flow sensor…Jun 5, 2009 · N922TP · Substantial damageNTSB CEN09LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Shelbyville, INThe loss of engine power during cruise flight due to fuel contamination. Also causal was the pilot's decision to conduct the flight with known contaminants in the fuel.Mar 13, 2009 · N338WS · Substantial damageNTSB ERA09LA184Accident · 1 fatalLimited investigationFinal reportKevin Eldredge Stewart · Ocala, FLA loss of engine power due to contamination and clogging of the fuel system by a post-assembly fuel tank sealant.Mar 6, 2009 · N551X · Substantial damageNTSB ERA09LA182Accident · 1 fatalLimited investigationFinal reportMoore Glenn Moronca · Burgaw, NCA partial loss of engine power due to fuel contamination as a result of the pilot's operation of the airplane with a deteriorated fuel tank.Mar 5, 2009 · N404AF · Substantial damageNTSB CEN09LA134Accident · Serious injuriesLimited investigationFinal reportInman J D Kolb Mark III · Ozark, ARThe loss of engine power due to fuel contamination. Contributing to the accident was the pilot maintaining a high angle of attack during takeoff, which resulted in an inadvertent stall when the engine failed.Jan 7, 2009 · N313JD · Substantial damageNTSB WPR09LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Coolidge, AZA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.Oct 23, 2008 · N7822T · Substantial damageNTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.Oct 12, 2008 · N734BL · Substantial damageNTSB MIA08LA197Accident · Serious injuriesLimited investigationFinal reportBerrie Kolb Mark III · East Haddam, CTThe pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.Sep 20, 2008 · N350RB · Substantial damageNTSB DFW08CA235Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Patterson, LAThe loss of engine power due to fuel contamination. Contributing to the accident was the unsuitable muddy terrain for the forced landing.Sep 18, 2008 · N425LS · Substantial damageNTSB DEN08LA150Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Atkinson, NEThe total loss of engine power due to water contamination and corrosion within the fuel system at an undetermined time and from an undetermined source.Sep 4, 2008 · N2036U · Substantial damageNTSB MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.Aug 23, 2008 · N65436 · Substantial damageNTSB LAX08CA228Accident · No injuriesData collectionFinal reportSchweizer G-164B · Alturas, CAA total loss of engine power due to fuel starvation, which resulted from a fuel system contamination and a clogged fuel filter. Contributing to the accident was the rough terrain.Jul 13, 2008 · N3633B · Substantial damageNTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.Jul 8, 2008 · N8647G · DestroyedNTSB DEN08LA121Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Point Lookout, MOA fuel flange seal leak and water in the fuel resulting in a loss of engine power during takeoff. Contributing to the accident was an inadequate preflight.Jul 6, 2008 · N53661 · Substantial damageNTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.Apr 30, 2008 · N28403 · Substantial damage