NTSB investigations, AL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.NTSB ATL05LA081Accident · 1 fatalLimited investigationFinal reportPaul E. Conner Rotor-EZ · St Elmo, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.NTSB ATL05CA080Accident · No injuriesData collectionFinal reportPiper J4E · Akron, ALThe pilot's premature liftoff and his failure to attain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's delay in aborting the takeoff.NTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.NTSB ATL05FA044Accident · 2 fatalField investigationFinal reportCessna T206H · Huntsville, ALThe pilot's decision to attempt flight into known adverse weather, which resulted in an in-flight encounter with a thunderstorm.NTSB ATL05CA036Accident · No injuriesData collectionFinal reportChampion 7-GCAA · Talladega, ALThe binding right wheel brake that resulted in a loss of control during landing roll. A factor was the drainage ditch.NTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.NTSB ATL05CA027Accident · Serious injuriesData collectionFinal reportBeech A36TC · Huntsville, ALThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing to an open field.NTSB ATL05CA016Accident · No injuriesData collectionFinal reportCessna 172 · Mobile, ALThe pilot's inadequate preflight planning and his inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent collision with the ground.NTSB ATL05LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Guntersville, ALTotal loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.NTSB ATL05CA006Accident · No injuriesData collectionFinal reportCessna 177 · Auburn, ALThe pilot's improper landing flare resulting in a hard landing. A factor was the pilot's diverted attention.NTSB ATL05CA003Accident · Minor injuriesData collectionFinal reportBell 206 B · Eutaw, ALThe pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL05LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Ashland, ALA total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.NTSB ATL04LA195Accident · 2 fatalLimited investigationFinal reportCessna 172L · Gadsden, ALThe flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.NTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.NTSB ATL04CA165Accident · No injuriesData collectionFinal reportMooney M20F · Brewton, ALA loss of engine power (non-mechanical) for undetermined reasons. A factor was the collision with a fence during emergency landing.NTSB ATL04LA164Accident · 1 fatalLimited investigationFinal reportCessna 172S · Waterloo, ALThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.NTSB ATL04CA160Accident · No injuriesData collectionFinal reportPiper PA 25 · Foley, ALThe pilot's failure to maintain airspeed during climbout which resulted in a stall while maneuvering to pick up a banner.NTSB ATL04CA149Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Tallassee, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. A factor was pilot fatigue and the unauthorized use of the airplane .NTSB ATL04CA146Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Hillsboro, ALThe pilot's inadequate visual lookout and failure to maintain adequate obstacle clearance, which resulted in collision with transmission wires.NTSB ATL04TA137Accident · No injuriesFinal reportBell 206B · Graysville, ALThe pilot's inadequate compensation for a tailwind and his failure to maintain directional control resulting in a loss of tail rotor effectiveness. A factor was the pilot's improper in-flight decision to hover with a tailwind.NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.NTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.NTSB ATL04LA105Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Elberta, ALThe loss of engine power due to a foreign substance blockage of the fuel line which resulted in fuel starvation, and the pilot's failure to maintain terrain clearance during an aborted landing.NTSB ATL04LA087Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development Alarus CH2T · Bay Minette, ALThe pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.NTSB ATL04CA083Accident · Minor injuriesData collectionFinal reportDantzer Lawrence L Rans S-12 · Lowndesboro, ALThe pilot's failure to maintain airspeed while manuevering which resulted in an inadvertent stall/spin. A factor was trees.NTSB ATL04LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Montgomery, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing roll that resulted in the collapse of the nose gear. The crosswind was a contributing factor.NTSB ATL04FA077Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Arlington, ALThe pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.NTSB ATL04IA073Incident · No injuriesIncident investigationFinal reportCessna 208B · Auburn, ALThe fatigue fracture of the wire rope portion on the rudder control cable assembly due to improper installation and inadequate procedures by the aircraft manufacturer.NTSB ATL04LA066Accident · Minor injuriesLimited investigationFinal reportCurrent Kitfox 313 · Selma, ALThe pilot's inadequate installation, and his failure to secure the main fuel line, which resulted in fuel starvation.NTSB ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.NTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.NTSB ATL04LA034Accident · No injuriesLimited investigationFinal reportHughes 269A · Birmingham, ALThe certified flight instructor's inadequate aircraft control and his improper landing flare resulting in a hard landing and roll over.NTSB ATL04LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Troy, ALThe certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.NTSB ATL04LA029Accident · No injuriesLimited investigationFinal reportYakovlev YAK55M · Troy, ALA loss of engine power due to a fractured connecting rod for undetermined reasons.NTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.NTSB ATL04LA011Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Huntsville, ALThe pilot's failure to maintain obstacle clearance while hovering out of ground effect, which resulted in a collision with a tree and subsequent uncontrolled collision with the ground.NTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.NTSB ATL03LA146Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7-AC · Pell City, ALThe pilots failure to maintain airspeed that resulted in the loss of control and the subsequent collision with the ground.NTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.NTSB ATL03LA109Accident · No injuriesLimited investigationFinal reportKeuthan Buccaneer II · Pell City, ALThe failure of the throttle cable due to fatigue resulting in a loss of engine power. Factor were uphill rough and uneven terrain.NTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.NTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…NTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.