NTSB investigations, NC
11 cases where the sequence of events included Fuel related.
Cases per year
| 2009 | 1 |
|---|---|
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2020 | 2 |
| 2021 | 3 |
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\" = 'NC' 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\" = '190' 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" = 'NC' 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" = '190' 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 ERA22LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Margarettsville, NCThe pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.NTSB ERA21FA237Accident · 1 fatalClass 3 · FieldFinal reportBeech A23 · Pinnacle, NCThe flight instructor’s mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.NTSB WPR18LA194Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Salisbury, NCA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available information.NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB ERA18LA026Accident · No injuriesLimited investigationFinal reportPiper PA28 · Bladenboro, NCA loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.NTSB ERA17LA215Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Ocean Isle Beach, NCThe pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.NTSB ERA17FA001Accident · 1 fatalField investigationFinal reportCulver PQ 14A · Hickory, NCThe loss of engine power due to carburetor icing. Contributing to the accident was the pilot's use of automobile gasoline, which increased the likelihood of carburetor icing.NTSB ERA10CA072Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Coyote · Indian Trail, NCA loss of engine power due to carburetor icing.