Skip to content

NTSB investigations, OH

19 cases where the sequence of events included Fuel exhaustion.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '192' 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

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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '192' 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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '192' 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 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.Apr 26, 2023 · N327WC · Substantial damage NTSB ERA23LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · Middlefield, OHThe pilot’s inadequate fuel planning and inflight fuel management which resulted in exhaustion of his fuel supply and a forced landing.Oct 13, 2022 · N62368 · Substantial damage NTSB ERA22LA330Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Kenton, OHThe pilot’s inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power.Jul 21, 2022 · N39MK · Substantial damage NTSB ERA22LA298Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Akron, OHThe pilots’ improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 4, 2022 · N12115 · Substantial damage NTSB CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.Aug 1, 2021 · N443JB · Substantial damage NTSB CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2020 · N15608 · Substantial damage NTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.Sep 23, 2020 · N81624 · Substantial damage NTSB CEN20CA274Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Springfield, OHThe pilot’s inadequate inflight planning that resulted in a loss of engine power due to fuel exhaustion.Jul 11, 2020 · N22111 · Substantial damage NTSB CEN20LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Wadsworth, OHThe pilot’s inadequate preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Feb 15, 2020 · N714ER · Substantial damage NTSB CEN17LA358Accident · No injuriesLimited investigationFinal reportCessna 177B · London, OHThe flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 17, 2017 · N35170 · Substantial damage NTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 5, 2017 · N3225T · Substantial damage NTSB CEN15LA303Accident · No injuriesLimited investigationFinal reportAviat A-1C-180 · Cincinnati, OHThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Jul 5, 2015 · N354BM · Substantial damage NTSB CEN13CA343Accident · No injuriesData collectionFinal reportCessna 150G · Franklin, OHThe pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.Jun 10, 2013 · N3718J · Substantial damage NTSB CEN13CA190Accident · Serious injuriesData collectionFinal reportMooney M20E · Middletown, OHThe total loss of engine power due to fuel exhaustion, which resulted from the noncurrent pilot’s improper in-flight fuel management and decision-making and his decision to conduct the flight after consuming alcohol.Mar 12, 2013 · N199Q · Substantial damage NTSB CEN11CA136Accident · Minor injuriesData collectionFinal reportAero Commander 500-B · Columbus, OHThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion.Dec 28, 2010 · N888CA · Substantial damage NTSB CEN09LA266Accident · 1 fatalLimited investigationFinal reportMcgrath Robert F Sonex · Louisville, OHThe pilot's failure to assure an adequate fuel level which resulted in fuel exhaustion. Contributing to the accident were the gusty winds and the pilot's loss of aircraft control during the forced landing.Apr 25, 2009 · N692RM · Substantial damage NTSB CHI08CA208Accident · Serious injuriesData collectionFinal reportErcoupe 415-G · West Jefferson, OHThe improper preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. Contributing factors were the pilot’s expired flight review and airman medical, the aircraft weight and balance exceeded by the pilot,…Jul 23, 2008 · N94413 · Substantial damage NTSB CHI08CA199Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Bryan, OHThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations. A contributing factor was the inaccurate fuel gauge.Jul 18, 2008 · N8814L · Substantial damage NTSB CHI08CA097Accident · No injuriesData collectionFinal reportHughes 269A · Franklin Furnac, OHThe fuel exhaustion during cruise flight and the unsuitable terrain encountered by the pilot-in-command. A contributing factor was the trees.Mar 21, 2008 · N9333V · Substantial damage