NTSB investigations, AL
144 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 9 |
| 2010 | 4 |
| 2011 | 10 |
| 2012 | 12 |
| 2013 | 6 |
| 2014 | 11 |
| 2015 | 14 |
| 2016 | 6 |
| 2017 | 8 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 8 |
| 2023 | 7 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 5 |
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\", '0106'))
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", '0106')) 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 ERA26LA285Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tuscumbia, ALThe pilot’s failure to keep the tail rotor clear of an obstacle while attempting to land.NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB ERA26LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Lanett, ALThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a runway excursion and collision with taxiway sign.NTSB ERA26LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Bessemer, ALThe pilot’s loss of directional control during the landing roll.NTSB ERA26LA094Accident · Minor injuriesClass 4 · LimitedFinal reportSled Thomas Helicycle · Mobile, ALThe pilot’s failure to maintain yaw control during a crosswind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, hard landing, and subsequent rollover.NTSB ERA26LA026Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS350 · Wetumpka, ALThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.NTSB ERA25LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Calera, ALA loss of control during landing.NTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.NTSB ERA24FA055Accident · 2 fatalClass 3 · FieldFinal reportBeech E95 · Elkmont, ALThe flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.NTSB ERA24LA047Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20F · Meridianville, ALThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.NTSB ERA24LA027Accident · No injuriesClass 4 · LimitedFinal reportMustang II · Asheville, ALThe pilot’s failure to maintain control of the airplane during initial climb after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…NTSB ERA23FA175Accident · 2 fatalClass 3 · FieldFinal reportAirbus Helicopters EC 130 T2 · Chelsea, ALThe pilot’s delayed corrective inputs while maneuvering, which resulted in a loss of control. Contributing to the accident was the pilot’s use of multiple sedating medications.NTSB ERA23LA159Accident · Minor injuriesClass 3 · LimitedFinal reportTextron 172S · Tuskegee, ALThe flight instructor’s improper flare, which resulted in a hard landing and subsequent runway excursion.NTSB ERA23LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Montgomery, ALThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA23LA003Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny XLT · Oneonta, ALThe uncertificated pilot’s failure to maintain control of the powered parachute during takeoff.NTSB ERA22LA423Accident · Serious injuriesClass 4 · LimitedFinal reportKumhyr David B Vans RV-8A · Elberta, ALThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a loss of control and subsequent nose over during landing.NTSB ERA22FA343Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter AS350 · Andalusia, ALThe pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.NTSB ERA22LA284Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Scottsboro, ALThe pilot’s failure to maintain directional during an aborted landing, which resulted in a runway excursion and collision with two parked trailers.NTSB ERA22LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Tuskegee, ALThe pilot’s inadequate compensation for the gusty crosswind wind conditions which resulted in a hard landing and subsequent nose gear collapse.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 ERA21LA345Accident · No injuriesClass 4 · LimitedFinal reportMaule MXT-7-180 · Troy, ALThe pilot's failure to maintain directional control while landing which resulted in a collision with terrain.NTSB ERA21LA254Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Ozark, ALThe pilot's failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB ERA21LA162Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 1730 · Bessemer, ALThe pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.NTSB ERA21LA068Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35A · Attalla, ALA loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.NTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB ERA20CA293Accident · Minor injuriesClass 4 · Data collectionFinal reportWag Aero Cubby · Pell City, ALThe flight instructor’s inadequate remedial action following the student pilot’s loss of directional control during landing, which resulted in a runway excursion and subsequent nose over.NTSB ERA20LA272Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Alabaster, ALA loss of control and lack of climb performance shortly after takeoff for reasons that could not be determined based on available evidence, resulting in a collision with terrain.NTSB ERA20CA263Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Prattville, ALThe student pilot's failure improper landing flare, which resulted in a hard landing.NTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.NTSB ERA20LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32RT · Meridianville, ALThe pilot's slip maneuver with a less than full fuel tank selected, which resulted in unporting of the fuel supply, and a total loss of engine power due to fuel starvation.NTSB ERA20CA116Accident · Serious injuriesData collectionFinal reportLet L 23 Super Blanik · Huntsville, ALThe pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.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 GAA19CA539Accident · No injuriesData collectionFinal reportPiper J3C · Winfield, ALThe pilot's failure to maintain proper wind correction input during taxi in a gusting tailwind, which resulted in a nose over.NTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.NTSB ERA19LA260Accident · Serious injuriesClass 3 · LimitedFinal reportDG Flugzeugbau DG-500MB · Robertsdale, ALImpact with trees during the landing approach for reasons that could not be determined based on the available information.NTSB ERA19TA185Accident · Minor injuriesClass 3Final reportCessna 182 · Robertsdale, ALThe pilot's failure to obtain the proper touchdown point while landing on a wet turf runway, which resulted in a runway overrun.NTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.NTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.NTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.NTSB GAA18CA332Accident · No injuriesData collectionFinal reportWaco YKS 7 · Fairhope, ALThe pilot’s failure to maintain directional control while landing.NTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB GAA18CA178Accident · No injuriesData collectionFinal reportFlightworks Capella XS FW2C80TD · Hartselle, ALThe pilot's failure to maintain directional control during the landing roll.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…