NTSB investigations, AL
39 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 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\" = 'AL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0107'))
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" = 'AL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0107')) 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 ERA26LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Enterprise, ALThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.NTSB ERA26LA193Accident · No injuriesClass 4 · LimitedFinal reportBell UH1 · Enterprise, ALThe in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.NTSB ERA25LA315Accident · Serious injuriesClass 4 · LimitedFinal reportPatriot CX1900A · Centreville, ALThe pilot’s failure to detect and remove water contamination from the airplane’s fuel system before the flight, which resulted in a total loss of engine power during initial climb.NTSB ERA24FA102Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24 · Eufaula, ALA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate fuel planning/management.NTSB ERA23LA325Accident · No injuriesClass 3 · LimitedFinal reportLong Charles Jackson Avid Flyer · Wetumpka, ALA loss of engine power due to fuel exhaustion because of a leaking fuel drain valve.NTSB ERA23LA232Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Selma, ALThe pilot’s improper preflight inspection, during which the left wing fuel sump drain was moved to and left in the open and locked position, allowing for fuel to drain during the flight and resulting in a total loss of engine power due to fuel starvation.…NTSB ERA23LA122Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 500 · Sylacauga, ALThe pilot’s failure to assure there was an adequate amount of fuel onboard to complete the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.NTSB ERA23LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Tanner, ALThe pilot’s inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA028Accident · No injuriesClass 4 · LimitedFinal reportMcglaughlin Richard Sportsman GS2 · Pell City, ALThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB ERA21LA107Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Pell City, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer’s engine restart procedures after a total loss of engine power and his incomplete preflight…NTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.NTSB ERA20LA197Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C-1 · Ozark, ALA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.NTSB ERA20FA063Accident · 2 fatalClass 3 · FieldFinal reportVans Vans RV-6 · Cullman, ALThe pilot’s inadequate planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the runway after…NTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.NTSB ERA18LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Gulf Shores, ALThe pilot's improper preflight and in-flight fuel planning, which resulted in fuel exhaustion to the left engine and a total loss of engine power during an attempted go-around maneuver.NTSB ERA18LA073Accident · No injuriesLimited investigationFinal reportAero Commander 680 F · Lapine, ALThe pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA17LA302Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Harvest, ALThe pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA537Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Foley, ALThe ground crew’s incorrect hook up of the banner, which resulted in a nose-over.NTSB ERA17LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bridgeport, ALThe pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.NTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…NTSB ERA15LA345Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Atmore, ALA total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.NTSB ERA15CA018Accident · No injuriesData collectionFinal reportBell 206B · Prattville, ALThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14TA326Accident · Serious injuriesFinal reportCessna 336 · Mobile, ALThe pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.NTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA14LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Alabaster, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.NTSB ERA12LA589Accident · No injuriesLimited investigationFinal reportCessna 421B · Selma, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power on the right engine and a partial loss of engine power on the left engine due to fuel starvation.NTSB ERA12LA253Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Margaret, ALThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power during cruise flight due to fuel starvation.NTSB ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…NTSB ERA10CA093Accident · No injuriesData collectionFinal reportRockwell International 114 · Birmingham, ALA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA09LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jasper, ALA total loss of engine power due to fuel starvation as a result of the flight instructor's improper fuel management.NTSB ERA09FA289Accident · 2 fatalField investigationFinal reportBeech A36 · Beauregard, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA09CA052Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Tuscaloosa, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. Contributing to the accident was improper preflight planning.NTSB ERA09CA018Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Repton, ALFuel exhaustion due to the pilot's inadequate preflight planning.NTSB MIA08CA183Accident · No injuriesData collectionFinal reportSmith Wylie Jay Kit Fox II · Deatville, ALThe pilot's inadequate fuel system maintenance.