NTSB investigations
361 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.\"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."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 DCA24WA054Incident · No injuriesClass 5 · ForeignBoeing 787 · Birmingham, United KingdomNTSB ERA24LA032Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-65 · Columbia, TNA partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB CEN24LA033Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 500-B · Jackson, MIA loss of engine power to both engines as a result of the pilot’s improper fuel management. Contributing was the inoperative fuel quantity sending unit.NTSB ERA24LA014Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Ottawa, OHA total loss of engine power due to the formation of carburetor ice..NTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilNTSB CEN23LA419Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · El Dorado, ARA loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…NTSB ERA23LA342Accident · 2 fatalClass 3 · LimitedFinal reportBeech C23 · Greer, SCA partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…NTSB WPR23LA294Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Ravensdale, WAPartial loss of power for undetermined reasons. Contributing to the accident was the siphoning of fuel from the left-wing fuel filler port due to wear on the fuel filler cap.NTSB DCA23WA361Incident · No injuriesClass 5 · ForeignBoeing 767-300 · Chitose, JapanNTSB WPR23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · San Rafael, CAThe total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.NTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.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 DCA23WA102OccurrenceClass 5 · ForeignBoeing 737 · Dunavecse, HungaryNTSB 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 DCA23WA047IncidentClass 5 · ForeignBoeing 777 · Batam, SingaporeNTSB 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 DCA22WA154IncidentClass 5 · ForeignBoeing 737 · Wave Rock, AustraliaNTSB 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.