NTSB investigations, 2013, CA
5 cases where the sequence of events included Fuel exhaustion.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 5 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 2 |
| 2026 | 4 |
Where
Latest 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\") = 2013
AND c.\"eventStateOrRegion\" = 'CA' 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 year(c."eventDate") = 2013 AND c."eventStateOrRegion" = 'CA' 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 WPR14LA056Accident · No injuriesLimited investigationFinal reportCessna T210 - F · Oceanside, CAThe pilot's failure to determine the actual onboard fuel quantity before beginning the flight, which resulted in a complete loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's habitual reliance solely on the cockpit fuel…NTSB WPR13LA383Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madera, CAThe pilots' inadequate fuel planning, which resulted in the airplane departing with insufficient fuel to complete the planned flight, and their failure to recognize that discrepancy en route, which resulted in a total loss of engine power due to fuel…NTSB WPR13CA163Accident · Minor injuriesData collectionFinal reportCessna 172G · Temecula, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR13LA125Accident · Minor injuriesLimited investigationFinal reportTemco D-16A · Heber, CAA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight and fuel planning.NTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.