NTSB investigations, OR
5 cases where the sequence of events included Fuel starvation.
Cases per year
| 2012 | 1 |
|---|---|
| 2015 | 1 |
| 2019 | 2 |
| 2023 | 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.\"eventStateOrRegion\" = 'OR' 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\" = '191' 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 c."eventStateOrRegion" = 'OR' 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" = '191' 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 WPR23LA267Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Coquille Bay, ORThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with terrain.NTSB WPR19LA265Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Gresham, ORA total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.NTSB WPR19TA162Accident · Minor injuriesClass 3Final reportBeech 35 · Medford, ORThe pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR15LA155Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Crescent Lake, ORThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…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.