NTSB finding · Aircraft › Aircraft systems › Fuel system
- Cases
- 181
- In the probable cause
- 165 (91%)
- Fatal cases
- 22
- NTSB code
- 01022800
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 NTSB made it part of the probable cause; in gray, a factor or other finding. Findings are coded with the final report, often a year or more after the event, so the latest years are incomplete.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 12 |
| 2010 | 7 |
| 2011 | 15 |
| 2012 | 15 |
| 2013 | 12 |
| 2014 | 9 |
| 2015 | 12 |
| 2016 | 8 |
| 2017 | 10 |
| 2018 | 10 |
| 2019 | 2 |
| 2020 | 11 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 14 |
| 2024 | 8 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapQuery with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT f.case_mkey) AS cases,
count(DISTINCT f.case_mkey) FILTER (WHERE f.\"inProbableCause\") AS in_probable_cause
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = f.case_mkey
WHERE starts_with(f.\"findingCode\", '01022800') AND c.\"eventDate\" >= DATE '2000-01-01'
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.
SELECT year(c."eventDate") AS year, count(DISTINCT f.case_mkey) AS cases, count(DISTINCT f.case_mkey) FILTER (WHERE f."inProbableCause") AS in_probable_cause FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = f.case_mkey WHERE starts_with(f."findingCode", '01022800') AND c."eventDate" >= DATE '2000-01-01' GROUP BY 1 ORDER BY 1
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.
In the same cases
Query with SQL
duckdb -csv -c "WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with(\"findingCode\", '01022800'))
SELECT * FROM (
SELECT 'Defining event' AS kind, e.\"tier2Number\" AS code, max(e.\"eventTier2Name\") AS name, count(DISTINCT f.case_mkey) AS cases
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e.\"isDefiningEvent\"
WHERE e.\"tier2Number\" <> ''
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.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
UNION ALL
SELECT 'Other finding', left(g.\"findingCode\", 8), max(g.\"tier4Name\"), count(DISTINCT g.case_mkey)
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g.\"findingCode\", '01022800') AND g.\"findingCode\" GLOB '[0-9][0-9]*'
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.
WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with("findingCode", '01022800'))
SELECT * FROM (
SELECT 'Defining event' AS kind, e."tier2Number" AS code, max(e."eventTier2Name") AS name, count(DISTINCT f.case_mkey) AS cases
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e."isDefiningEvent"
WHERE e."tier2Number" <> ''
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.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
UNION ALL
SELECT 'Other finding', left(g."findingCode", 8), max(g."tier4Name"), count(DISTINCT g.case_mkey)
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g."findingCode", '01022800') AND g."findingCode" GLOB '[0-9][0-9]*'
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESCRun 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.
Newest cases · 181
NTSB CEN26LA221Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S-2R · Gause, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the separated wing fuel tank screen and sealant debris in the fuel tank.NTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB CEN25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Farlinville, KSA loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.NTSB WPR25LA046Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Gillette, WYA loss of engine power due to fuel starvation resulting from a loose B-nut at the engine-driven fuel-pump inlet.NTSB CEN25LA009Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Garden Ridge, TXA loss of engine power that resulted from improper fuel system maintenance and the subsequent fuel starvation due to the leaking fuel pump outlet fuel line.NTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB WPR24LA281Accident · No injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Grants, NMA total loss of engine power due to fuel starvation for reasons that could not be determined.NTSB CEN24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Perryton, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB WPR24LA148Accident · No injuriesClass 3 · LimitedFinal reportKjelsrud Gary Kitfox · Powell, WYThe pilot’s adjustment of the carburetor to an incorrect setting, which resulted in partial loss of engine power during takeoff.NTSB ERA24LA152Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Opelika, ALA partial loss of engine power due to a combination of fuel/oil contamination in the fuel injector assembly.
See all 181 casesQuery 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01022800')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01022800')) 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.