NTSB investigations
5 cases where NTSB found Fuel sys wiring.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2021 | 1 |
| 2022 | 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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01022897')) 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", '01022897')) 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 ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB CEN21LA274Accident · Minor injuriesClass 3 · LimitedFinal reportBeech U-8F · Goodland, KSMaintenance personnel’s inadequate inspection of the airplane, which failed to detect and correct chafed electrical wiring and a degraded fuel bladder with holes, which resulted in ignition of fuel vapor and a right wing explosion.NTSB CEN11LA553Accident · No injuriesLimited investigationFinal reportHyde William R Helicycle · Metone, INThe loss of engine power due to fuel starvation as a result of an electrical system failure.NTSB CEN10CA138Accident · Serious injuriesData collectionFinal reportEnstrom 280FX · Goshen, INThe inadequate preflight inspection by both pilots, resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the disconnected fuel tank sending unit.NTSB DEN08LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Pine Bluff, ARA total loss of engine power due to fuel starvation as a result of an electrical short in the wiring to the manual fuel switch that closed the fuel valves.