NTSB investigations, TN
11 cases where the sequence of events included Fuel related.
Cases per year
| 2018 | 1 |
|---|---|
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 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\" = 'TN' 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" = 'TN' 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 ERA24LA254Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Tullahoma, TNA total loss of engine power during takeoff as a result of fuel starvation.NTSB ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…NTSB ERA24LA032Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-65 · Columbia, TNA partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.NTSB ERA21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23-250 · Springfield, TNThe flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…NTSB ERA21LA070Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Nashville, TNThe pilot’s failure to use carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA20LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Mount Pleasant, TNA partial loss of engine power during initial climb due to carburetor icing that formed while idling on the ground for an extended amount of time. Contributing was the flight instructor's failure to perform the recommended ground checks before takeoff.NTSB ERA18TA255Accident · Serious injuriesFinal reportCalvin Nate H Velocity STD RG E · Kingsport, TNThe pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.