NTSB investigations, MD
5 cases where the sequence of events included Fuel starvation.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2020 | 1 |
| 2024 | 2 |
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\" = 'MD' 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" = 'MD' 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 ERA24LA380Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Baltimore, MDThe undetected worn internal parts of the on-condition carburetor, which restricted movement of the float, resulting in fuel starvation. Contributing to the severity of the accident was the pilot’s delayed reduction of the throttle when performing a forced…NTSB ERA24FA305Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 402 · Easton, MDOn July 16, 2024, about 0932 eastern daylight time, a Cessna 402B, N7875E, was substantially damaged when it was involved in an accident near Easton, Maryland. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA20LA160Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Pylesville, MDThe loss of engine power due to fuel starvation as a result of unporting of the fuel tank supply pickup while the helicopter was maneuvered to move a conductor wire. Contributing to the accident was the helicopter’s inappropriate configuration for the type of…NTSB ERA12FA002Accident · 1 fatalField investigationFinal reportTemco GC-1B · Ewell, MDThe pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.NTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.