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 ERA09LA263Accident · 1 fatalLimited investigationFinal reportKeeley/Tidd MK-1 · Demopolis, ALThe pilot's failure to maintain adequate airspeed following a complete loss of engine power resulting in a stall while maneuvering to land. The reason for the loss of engine power was undetermined.NTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.NTSB ERA09CA136Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Akron, ALThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.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 ERA09CA058Accident · No injuriesData collectionFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper flare during landing.NTSB ERA09LA026Accident · Serious injuriesLimited investigationFinal reportCessna 175A · Foley, ALThe pilot’s failure to maintain adequate airspeed during initial climb, resulting in a stall and collision with terrain. Contributing to the accident was the pilot’s lack of recent experience.NTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB ERA09CA018Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Repton, ALFuel exhaustion due to the pilot's inadequate preflight planning.NTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB NYC08CA309Accident · No injuriesData collectionFinal reportBell 206B · Eutaw, ALThe pilot's inadequate preflight inspection.NTSB MIA08CA183Accident · No injuriesData collectionFinal reportSmith Wylie Jay Kit Fox II · Deatville, ALThe pilot's inadequate fuel system maintenance.NTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.NTSB NYC08LA270Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Brownsboro, ALThe pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.NTSB NYC08CA321Accident · No injuriesData collectionFinal reportGrimes Barry R Chinook Plus TWO · Magnolia Springs, ALThe total loss of engine power during initial climb due to the failure of the fuel pump.NTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.NTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…NTSB MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.NTSB MIA08CA120Accident · Minor injuriesData collectionFinal reportBeech S35 · Creola, ALThe pilot's inadequate fuel calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA08CA137Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Muscle Shoals, ALThe pilot's failure to maintain clearance from utility wires during low altitude maneuvers.NTSB NYC08CA208Accident · Minor injuriesData collectionFinal reportCessna 177RG · Bessemer, ALFailure of the left magneto for undetermined reasons resulting in a partial loss of engine power during takeoff.NTSB NYC08CA195Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Mt. Olive, ALThe flight instructor's inadequate remedial action following an encounter with ground resonance.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB NYC08FA157Accident · 2 fatalField investigationFinal reportCartwright H Jr/Cottrell M RV-10 · Seale, ALThe pilot-in-command's in-flight loss of control due to spatial disorientation. Contributing to the accident were the weather conditions and the pilot-in-command's lack of flight experience in the accident airplane.NTSB NYC08CA154Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Alabaster, ALThe pilot's failure to utilize carburetor heat during a power off approach.NTSB LAX08LA105Accident · No injuriesLimited investigationFinal reportRaytheon B300 · Tuscaloosa, ALThe pilot's encounter with severe turbulence during descent into the airport environment, which resulted in an exceedence of the aircraft's design stress limit and structural damage.NTSB MIA08CA057Accident · No injuriesData collectionFinal reportCessna 172N · Centre, ALThe pilot's improper landing flare, resulting in a hard landing.NTSB NYC08CA089Accident · No injuriesData collectionFinal reportCessna 210G · Bessemer, ALThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.NTSB NYC08LA087Accident · 1 fatalLimited investigationFinal reportUnknown Free Bird Sportlite · McCullough, ALThe non-certificated pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the non-certificated pilot's improper decision to conduct a flight prior to the airplane being properly inspected and certified.NTSB NYC08CA085Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Arley, ALA malfunction of the rudder control system.NTSB MIA08CA039Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lapine, ALThe pilot's failure to attain the proper touchdown point.NTSB NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.NTSB MIA08CA030Accident · No injuriesData collectionFinal reportCessna 172N · Talladega, ALThe pilot's failure to maintain directional control of the airplane.NTSB NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.NTSB NYC08CA058Accident · No injuriesData collectionFinal reportFisher Aero Celebrity · White Plains, ALA propeller failure during cruise flight.NTSB MIA08FA026Accident · 2 fatalField investigationFinal reportCessna R182 · Woodland, ALThe flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…NTSB NYC08LA050Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Talladega, ALThe pilot's inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB MIA08CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Tuscaloosa, ALThe pilot's failure to maintain a visual look out while taxing resulting in an on-ground collision with a parked airplane.NTSB NYC08LA018Accident · No injuriesLimited investigationFinal reportBlair Skybolt · Guntersville, ALSeparation of the right tailwheel control link spring from the right control arm of the tailwheel, which resulted in a loss of control during landing.NTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB ATL07CA126Accident · No injuriesData collectionFinal reportRans RV-9A · Harvest, ALThe pilot's improper landing flare and touchdown.NTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.NTSB MIA07CA126Accident · Minor injuriesData collectionFinal reportPhantom Sport XI · Anderson, ALThe failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB MIA07LA111Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Cullman, ALThe pilot’s mismanagement of an in-flight emergency, which resulted in a gear-up landing and runway overrun. Contributing to the accident was a breach to the engine crankcase above and in line with the No. 1 cylinder.NTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.NTSB ANC07LA045Accident · No injuriesLimited investigationFinal reportCessna 177 · Centreville, ALThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and substantial damage during a forced landing on a road.NTSB MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.NTSB MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.