NTSB investigations, 2012
15 cases where NTSB found Fuel system, general.
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 | 9 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 2012
AND 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 year(c."eventDate") = 2012 AND 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.
NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB CEN12FA654Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Roanoke, TXThe loss of engine power during takeoff due to fuel contamination. Contributing to the accident was maintenance personnel's failure to adequately correct the water contamination effects. Contributing to the severity of the occupants' injuries was the lack of…NTSB ERA12LA555Accident · Serious injuriesLimited investigationFinal reportPitcairn PA-4 · Rawlings, MDA total loss of engine power due to fuel starvation, which resulted from a fuel outlet in the fuel tank that was blocked by peeled debris from a previously approved fuel tank sealer.NTSB WPR12LA392Accident · No injuriesLimited investigationFinal reportCessna 210 · Kemmerer, WYThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.NTSB CEN12LA582Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Jim Falls, WIThe blockage of the right fuel tank vent, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12LA512Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bragg City, MOThe pilot's failure to properly tighten the b-nut from the engine-driven fuel pump to the fuel-metering unit during maintenance, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12LA328Accident · Serious injuriesLimited investigationFinal reportHughes Helicopters 369E · The Dalles, ORThe loss of engine power due to fuel starvation, which resulted from the fuel tank supply pickup becoming unported while the helicopter was pulling power lines.NTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.NTSB CEN12LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Bangor, MIThe pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.NTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…NTSB WPR12LA182Accident · No injuriesLimited investigationFinal reportMays Kitfox Lite 2 · Cedarville, CAA loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.NTSB WPR12LA178Accident · Serious injuriesLimited investigationFinal reportBeechcraft A36TC · Pendleton, ORThe pilot's failure to maintain an adequate glidepath for landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's failure to secure the left-side fuel cap before departure. Contributing to the…NTSB CEN12FA249Accident · Minor injuriesField investigationFinal reportHeiser Robert C JR Pulsar XP · San Angelo, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent line.NTSB ERA12FA262Accident · 1 fatalField investigationFinal reportBeech 58 · Calhoun, KYThe failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…NTSB CEN12LA128Accident · No injuriesLimited investigationFinal reportSanderson Pitts Special SPS-1 · Revere, MNThe total loss of engine power during cruise flight due to fuel contamination and the inadequate design of the fuel system.