NTSB investigations, NJ
8 cases where the sequence of events included Fuel starvation.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2018 | 1 |
| 2023 | 1 |
| 2024 | 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\" = 'NJ' 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" = 'NJ' 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 ERA24LA369Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Somerville, NJA total loss of engine power due to an undetermined fuel delivery issue.NTSB ERA23LA333Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Norris, NJThe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA19TA042Accident · Serious injuriesClass 3Final reportMooney M20C · Wildwood, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation during the initial climb. Contributing to the accident was the pilot’s decision to initiate a 180° turn following the loss of power.NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.NTSB ERA11CA225Accident · Serious injuriesData collectionFinal reportPiper PA38 · Manville, NJThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel starvation.NTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.NTSB NYC08LA222Accident · 2 fatalLimited investigationFinal reportDennis P. McGurk F1 Rocket · Woodbine, NJA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the proper tank prior to performing aerobatics.NTSB NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…