NTSB investigations, AL
18 cases where NTSB found Inspection.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2018 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2025 | 1 |
Where
Latest 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\", '020615'))
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", '020615')) 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 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 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 ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.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 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 ERA22LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Selma, ALThe failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.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 ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…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 ERA15LA240Accident · No injuriesClass 3 · LimitedFinal reportWeatherly 201B · Pell City, ALThe inadequate inspection of the airplane's landing gear, which resulted in a collapse of the right main landing gear due to cracking and corrosion.NTSB ERA14LA179Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Clayton, ALMaintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.NTSB ERA14LA099Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Pell City, ALThe pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…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 ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…NTSB ERA13LA407Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Guntersville, ALThe improper installation of the engine magneto by unknown maintenance personnel, which resulted in the magneto separating from the engine and a subsequent total loss of engine power. Contributing to the accident was the pilot's delay in proceeding directly…NTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…NTSB ERA11LA167Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Auburn, ALA loss of engine power due to an internal failure of the muffler that was not detected by maintenance personnel.NTSB NYC08CA309Accident · No injuriesData collectionFinal reportBell 206B · Eutaw, ALThe pilot's inadequate preflight inspection.