OpenAirDocs.org

Fuel related

Open the Markdown

NTSB defining event · CICTT: Fuel

CICTT occurrence categories (PDF)CICTT phases of flight (PDF)

All 269 cases361 anywhere in the sequence
Defining event in
269 cases
In the sequence of
361 cases
Fatal cases
27
NTSB code
190

NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.

When and where

In green, cases where it was the defining event; in gray, cases where it came elsewhere in the sequence. The map shows the cases where it was the defining event. Events are coded with the final report, so the latest years are incomplete.

Cases per year

2008Defining eventElsewhere in the sequence2026

Where

Open the map
Query with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT e.case_mkey) AS cases,
    count(DISTINCT e.case_mkey) FILTER (WHERE e.\"isDefiningEvent\") AS defining
  FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = e.case_mkey
  WHERE e.\"tier2Number\" = '190' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")
  GROUP BY 1
  ORDER BY 1"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

In these cases

Phase of flight
  • Initial climb40
  • Enroute-cruise39
  • Enroute39
  • Approach25
  • Approach-VFR pattern final20
  • Maneuvering19
  • Takeoff18
  • Enroute-descent15
  • Maneuvering-low-alt flying12
  • Approach-VFR pattern downwind8
In the probable cause
Aircraft models

Aircraft matched to the registry by N-number and date.

Query with SQL
duckdb -csv -c "WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"tier2Number\" = '190' AND \"isDefiningEvent\")
  SELECT * FROM (
  SELECT 'Phase of flight' AS kind, e.\"tier1Number\" AS code, max(e.\"eventTier1Name\") AS name, count(DISTINCT e.case_mkey) AS cases
  FROM defining e
  GROUP BY ALL
  UNION ALL
  SELECT 'Finding in the probable cause', left(f.\"findingCode\", 8), max(f.\"tier4Name\"), count(DISTINCT f.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f.\"inProbableCause\"
  WHERE f.\"findingCode\" GLOB '[0-9][0-9]*'
  GROUP BY ALL
  UNION ALL
  SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
  LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
  WHERE a.aircraft_model_code IS NOT NULL
  GROUP BY ALL
  )
  QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
  ORDER BY kind, cases DESC"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

Newest cases · 269

NTSB DCA26WA372Incident · No injuriesClass 5 · ForeignAirbus Canada BD500 · Garbutt, AustraliaSep 22, 2026 · VH-X4ANTSB ERA26FA243Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Bowie, MDOn June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code…Jun 21, 2026 · N249WF · Substantial damageNTSB DCA26WA241Occurrence · No injuriesClass 5 · ForeignBoeing 787-9 · Singapore, SingaporeJun 21, 2026 · N27997NTSB DCA26WA221OccurrenceClass 5 · ForeignAirbus A321 · Stuarts Creek, AustraliaMay 24, 2026 · VH-OFW · No damageNTSB CEN26LA190Accident · 1 fatalClass 3 · LimitedPreliminary reportDowner 14-19-3 · Forney, TXOn May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived…May 16, 2026 · N7NL · Substantial damageNTSB CEN26LA189Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Morris, ILThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.May 15, 2026 · N201QM · Substantial damageNTSB ERA26LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Flemington, GAThe pilot’s inadvertent manipulation of the mixture control, which resulted in a total loss of engine power during initial climb and a subsequent forced lading.Jan 9, 2026 · N96493 · Substantial damageNTSB ERA26LA079Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 140 · Ceres, VAThe pilot’s failure to recognize and mitigate carburetor icing, which resulted in a partial loss of engine power and forced landing.Dec 27, 2025 · N89884 · Substantial damageNTSB ANC25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Yakataga, AKThe total loss of engine power due to carburetor icing and the pilot’s failure to effectively use carburetor heat in meteorological conditions conducive to the formation of carburetor icing.Sep 22, 2025 · N4282F · Substantial damageNTSB DCA25WA325IncidentClass 5 · ForeignAirbus A320 · Chennai, IndiaSep 1, 2025 · VT-ATF · No damage
See all 269 cases
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\" = '190')
  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.