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 ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…NTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.NTSB ATL94FA071Accident · 1 fatalField investigationFinal reportBeech 58TC · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the base turn. Factors were the pilot's inadequate preflight, high winds with gusts at the airport, and the pilot's diverted attention due to the open baggage door.NTSB ATL94LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Muscle Shoals, ALWas the loose throttle cable, and the pilot's failure to abort the takeoff when the engine did not produce full power. A factor was the inadequate maintenance inspection of the engine.NTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…NTSB ATL94FA046Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Centreville, ALThe pilot's failure to assure that the fuel selector was in the proper position for takeoff.NTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.NTSB ATL94LA035Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mobile, ALAn inadequate major repair by company maintenance personnel who failed to install the cotter pin which secured the retaining nut of the right main rotor hub teeter pin.NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB ATL94LA019Accident · Serious injuriesLimited investigationFinal reportBell-Carson 47G-SUPER C-4 · Eufaula, ALThe pilot's failure to maintain aircraft control. A factor was the pilot's limited helicopter flight experience.NTSB ATL94LA014Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 Soloy · Atmore, ALThe pilot's inadequate pre-flight inspection. Factors were the lack of a filter on the refueling pump which would preclude water passage, and the high trees.NTSB ATL94LA009Accident · No injuriesLimited investigationFinal reportBell 47G2 · Billingsley, ALThe pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.NTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.NTSB ATL93LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Deatsville, ALWas a crack in no.3 cylinder head which resulted in the loss of engine power.NTSB ATL93LA149Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Tuscaloosa, ALFouled spark plugs on the number 2 and 3 cylinders, and a lack of compression on the number 1 and 4 cylinders, which resulted in a loss of engine power. A factor was the high vegetation at the forced landing site.NTSB ATL93FA136Accident · Serious injuriesField investigationFinal reportCessna 172M · Harvest, ALThe pilot's poorly planned approach and the failure of the pilot to execute a go-around.NTSB ATL93LA134Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ashford, ALThe failure of the engine supercharger assembly, which resulted in a loss of engine power. A factor was the trees at the forced landing site.NTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.NTSB ATL93LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Summerdale, ALThe pilot's failure to attain the proper touchdown point.NTSB ATL93FA127Accident · 1 fatalField investigationFinal reportHughes 369HS · Talladega, ALThe pilot's poor in-flight decision to land downwind in a confined area that was surrounded by high obstructions, and his failure to properly compensate for the tailwind condition. A factor related to the accident was: the pilot's lack of total experience in…NTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.NTSB ATL93LA116Accident · No injuriesLimited investigationFinal reportGrumman G164A · Brundidge, ALThe broken carburetor accelerator pump piston rivet which lodged under the needle valve, allowed the float chamber to flood with fuel, and the engine to quit. The lack of suitable terrain for a forced landing was a factor.NTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.NTSB ATL93IA111Incident · No injuriesIncident investigationFinal reportSikorsky S-76A · Cullman, ALThe failure of company maintenance personnel to properly inspect the tail rotor control cable at the last 750 hour inspection, and the subsequent total failure of the cable due to wear.NTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.NTSB ATL93LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Attalla, ALThe failure of the left engine turbocharger due to rotor shaft seizure, which resulted in a loss of engine power.NTSB ATL93LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's failure to maintain clearance from trees during agricultural application maneuvering. Factors were the trees in the vicinity of the planned flight path.NTSB ATL93LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Tuskegee, ALThe pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB ATL93LA097Accident · No injuriesLimited investigationFinal reportLet L-13 · Elberta, ALThe pilot's inadequate preflight planningNTSB ATL93T#A01Accident · No injuriesFinal reportBellanca 8GCBC · Billingsley, ALNTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.NTSB ATL93LA084Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamilton, ALThe pilot's failure to properly calculate fuel consumption at an increased power setting, which resulted in fuel exhaustion and loss of engine power. Trees at the forced landing area were a factor in the accident.NTSB ATL93LA081Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Payne, ALThe pilot's failure to compensate for winds during the initial takeoff that resulted in the airplane colliding with the runway, exceeding the design limits of the aircraft and upon landing at the destination airport, the collapse of the main landing gear.NTSB ATL93LA069Accident · No injuriesLimited investigationFinal reportJohn Thomason Laco 145 · Tuskegee, ALThe overload failure of the tail wheel leaf springs, which resulted in a loss of directional control during the landing roll.NTSB ATL93FA058Accident · 2 fatalField investigationFinal reportCessna 402B · Geneva, ALThe pilot's failure to maintain minimum controllable airspeed during the initial climb, which resulted in a loss of aircraft control and collision with trees and terrain.NTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.NTSB MIA93FA041Accident · 1 fatalField investigationFinal reportLuscombe 8A · Lillian, ALThe pilot-in-command's failure to maintain airspeed as the aircraft was turned from base leg to final approach, resulting in an inadvertent stall and uncontrolled descent to the ground.NTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.NTSB MIA93LA037Accident · Serious injuriesLimited investigationFinal reportBunn, Richard B. Swearingen SX300 · Montgomery, ALThe pilot in command's decision to operate the aircraft with known fuel leaks and his failure to monitor fuel quantity en route which resulted in loss of engine power due to fuel exhaustion.NTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.NTSB ATL93FA039Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Phenix City, ALThe pilot's failure to maintain control of the aircraft in instrument meteorological conditions. A factor was the pilots lack of total experience in instrument flight conditions.NTSB ATL93FA031Accident · 6 fatalField investigationFinal reportBeech 95-B55B · Calera, ALThe pilot's continued flight with the fuel tank selector handles improperly positioned, which resulted in fuel starvation and engine stoppage. Factors were the cloudy weather conditions, the night lighting conditions, and the steep, hilly terrain conditions…NTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…NTSB ATL93FA025Accident · 3 fatalField investigationFinal reportCessna 172 · Brownsboro, ALThe pilot failed to evaluate the wind conditions and took off with a tailwind which resulted in the collision with a tree on the departure end of the runway. Factors were dark night and tailwind.NTSB ATL93LA023Accident · 1 fatalLimited investigationFinal reportBede BD-5B · Guntersville, ALThe pilot's inadvertent stall of the airplane, during the base to final turn, at too low an altitude to effect recovery. Factors were the improper lift off, which resulted in the airplane re contacting the runway after lift off, and served to distract the…NTSB ATL93LA009Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Centre, ALThe pilot's failure to maintain main rotor RPM, which resulted in an in flight loss of control and collision with terrain.NTSB ATL93FA004Accident · 1 fatalField investigationFinal reportAero Commander 680 · Headland, ALThe pilot's failure to maintain control of the airplane while conducting a high speed taxi maneuver which resulted in inadvertent flight. Factors were the pilot's over confidence in his ability, his lack of familiarity with the airplane and the wind gust.NTSB ATL93LA003Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Clanton, ALThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control during landing. Factors were the turbulence and gusty wind conditions present at the time of the accident.