Final NTSB investigations
330 cases where the sequence of events included Fuel related.
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '190' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '190' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.NTSB ERA23LA275Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Pence Springs, WVA total loss of engine power due to carburetor icing.NTSB CEN23LA233Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Carrington, NDA total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.NTSB CEN23LA226Accident · Serious injuriesClass 3 · LimitedFinal reportTemco GC-1B · Bristow, OKThe loss of engine power due to carburetor ice due to the pilot’s delayed application of carburetor heat.NTSB ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB ERA23LA221Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC-CONV · Fort Mill, SCThe pilot’s failure to apply carburetor heat before initiating a descent in conditions conducive to the development of carburetor icing, which resulted in a partial loss of engine power due to carburetor ice.NTSB CEN23LA161Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Flint Township, MIThe pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.NTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB WPR23LA156Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Riverside, CAThe pilot’s failure to use carburetor heat during an extended ground delay before takeoff, which resulted in a total loss of engine power during initial climb due to carburetor ice.NTSB ERA23LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Atlanta, GAThe flight instructor’s failure to effectively utilize carburetor heat, which resulted in a total loss of engine power during initial climb due to carburetor ice that formed during the engine run-up and taxi.NTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.NTSB CEN23LA083Accident · No injuriesClass 3 · LimitedFinal reportCheek Carroll Hatz/Cheek · Brashear, TXA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude and the subsequent hard forced landing.NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.NTSB ERA23LA066Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot’s failure to appropriately use carburetor heat, which resulted in a total loss of engine power due to carburetor icing.NTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.NTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB CEN23LA002Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Danville, ILThe pilot decision to perform a precautionary landing to a field with obstacles which resulted in a ground loop. Contributing was the pilot’s inadequate fuel planning.NTSB CEN22LA425Accident · No injuriesClass 4 · LimitedFinal reportSlipstream Revelation · Delphi, INA loss of engine power due to carburetor icing.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 CEN22LA391Accident · No injuriesClass 3 · LimitedFinal reportBeech F33A · Baton Rouge, LAThe sudden and total loss of fuel flow to the engine for undetermined reasons.NTSB WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.NTSB ANC22LA064Accident · Serious injuriesClass 3 · LimitedFinal report5 Rivers SQ-2 · Soldotna, AKA total loss of engine power due to carburetor icing, which resulted from the pilot's failure to use carburetor heat while operating in conditions conducive to the formation of carburetor ice.NTSB ERA22LA309Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Lancaster, OHA partial loss of engine power due to the formation of carburetor ice.NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.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 CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.NTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.NTSB ERA22LA157Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Harveysburg, OHA complete loss of engine power as a result of carburetor ice due to the flight instructor’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.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 WPR22LA089Accident · No injuriesClass 3 · LimitedFinal reportBlake D Barrymore Just Acft Superstol · Ketchum, IDThe total loss of engine power due to carburetor ice.NTSB WPR22LA083Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Williams, AZThe pilot’s activation of the auxiliary fuel boost pump shortly after takeoff, which resulted in an excess amount of fuel to the engine and a total loss of engine power.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 CEN22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Port Aransas, TXThe loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat.NTSB CEN22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1A · St. Jo, TXThe total loss of engine power due to carburetor icing during cruise flight, which resulted in a forced landing and impact with terrain.NTSB ERA22LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Margarettsville, NCThe pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.NTSB CEN22LA027Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · La Porte, TXA total loss of engine power due to the failure of the carburetor float assembly.NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB CEN22LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Dallas, TXA temporary loss of engine power during the takeoff due to a damaged fuel pump, which resulted in a forced landing and a runway excursion. The source of the damage to the fuel pump could not be determined.NTSB WPR21LA363Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Orcas Island, WAThe total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.NTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.NTSB CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.NTSB CEN21LA390Accident · Minor injuriesClass 3 · LimitedFinal reportMantooth Thorp T-18 · San Antonio, TXThe loss of engine power after takeoff for undetermined reasons.NTSB WPR21LA329Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150D · Chino, CAThe pilot’s delayed use of carburetor heat, which resulted in a loss of engine power due to carburetor icing.NTSB CEN21LA386Accident · No injuriesClass 3 · LimitedFinal reportAcro Sport II · Fishers, INThe airplane’s total loss of engine power due to fuel exhaustion as a result of leaking fuel from a loose fuel inlet fitting to the fuel control unit.