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 ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.NTSB ERA20LA308Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA 1 · Newnan, GAThe flight instructor’s inadequate preflight fuel planning, which resulted in an interruption of the fuel supply to the engine and a subsequent a total loss of engine power due.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.NTSB WPR20LA259Accident · Serious injuriesClass 3 · LimitedFinal reportRutan Vari EZE · Kelso Valley, CAThe pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB ERA20LA278Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Allendale, SCA total loss of engine power as a result of fuel starvation due to contamination from a thermoplastic polymer used in the fuel system. Contributing to the accident was the pilot’s failure to report debris observed in the fuel system during previous preflight…NTSB ERA20LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA25 · Miami, FLA total loss of engine power due to carburetor ice that was not detected by the pilot.NTSB CEN20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Jonesboro, LALoss of engine power due to the use of improper fuel in the airplane by the non-certificated pilot.NTSB ERA20LA271Accident · 1 fatalClass 3 · LimitedFinal reportAmerican AA 5 · Dunnellon, FLA total loss of engine power due to fuel starvation as a result of improper installation and inspection of the airplane’s fuel system. Contributing to the accident was the pilot’s lack of certification and knowledge in aircraft maintenance.NTSB ERA20LA270Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA31 · Sumter, SCThe pilot’s fuel mismanagement during flight, which resulted in a total loss of engine power from both engines due to fuel starvation.NTSB CEN20LA276Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R R1340 · Keokuk, IAThe improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB GAA20WA116Accident · No injuriesForeign investigationCessna FA150 · Doub, FranceThe government of France has notified the NTSB of an accident involving a CESSNA FA150 airplane that occurred on June 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ERA20CA201Accident · No injuriesClass 4 · Data collectionFinal reportJabiru J250-SP · Gulf Of MexicoA total loss of engine power due to a fuel leak that could not be identified since the wreckage was not recovered.NTSB WPR20LA161Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Cascade Locks, ORThe pilot’s improper fuel tank selection which resulted in fuel starvation to the engine and a loss of engine power.NTSB CEN20LA170Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hallettsville, TXThe partial loss of engine power due to contaminated fuel and carburetor ice.NTSB ERA20LA163Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · East Hampton, NYThe partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB ERA20LA161Accident · No injuriesClass 3 · LimitedFinal reportKeuthan Buccaneer II · Coden, ALA total loss of engine power due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the engine.NTSB WPR20LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Corona, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to serious carburetor icing, which resulted in a total loss of engine power.NTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.NTSB ERA20LA126Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Beverly, MAA loss of engine power due to carburetor icing, and the student pilot’s failure to utilize carburetor heat in conditions conducive to carburetor icing.NTSB ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.NTSB ERA20LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Mount Pleasant, TNA partial loss of engine power during initial climb due to carburetor icing that formed while idling on the ground for an extended amount of time. Contributing was the flight instructor's failure to perform the recommended ground checks before takeoff.NTSB GAA20WA144Accident · No injuriesClass 4 · ForeignBeech 58 · Buenos Aires, ArgentinaNTSB WPR20FA065Accident · 1 fatalClass 3 · FieldFinal reportCessna T310 · Roy, UTThe pilot’s inadequate preflight fuel planning and fuel management, which resulted in a total loss of power to the left engine due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the…NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…NTSB CEN20LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Harrison, OHA total loss of engine power during approach to land due to carburetor icing during a simulated engine failure, which resulted in impact with trees.NTSB DCA20WA039Incident · No injuriesForeign investigationBoeing 767 · Shannon, IrelandThe government of Ireland has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on December 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB ERA20LA047Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Potts Camp, MSThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.NTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.NTSB ERA20LA023Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Grand Bay, ALA loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.NTSB WPR20WA023Incident · No injuriesForeign investigationSikorsky S92 · Port Harcourt NAS, NigeriaOn October 25, 2019, about 1419, time zone unknown, a Sikorsky S-92 helicopter, 5N-BOA, experienced an in-flight engine shutdown near Port Harcourt NAS, Nigeria. Their were no injuries. The helicopter was operated under the pertinent civil regulations of the…NTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.NTSB ERA20LA052Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Grove City, PAThe pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.NTSB CEN19LA309Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Walkerton, INThe partial loss of engine power due to fuel contamination.NTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.NTSB ERA19LA227Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Hastings, FLThe pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.NTSB ERA19LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Summit, SCA total loss of engine power during initial climb due to carburetor ice formation.NTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.NTSB ERA19LA217Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 77 · Leesburg, FLA partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.NTSB CEN19LA179Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Cottrellville Township, MIThe partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…NTSB WPR19LA165Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Medford, ORA total loss of engine power due to fuel starvation.NTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.