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 ATL95LA151Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe chafing of the fuel flow gage pressure line with an electrical system wire which resulted in arcing.NTSB ATL95LA150Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe pilot's failure to check the runway condition prior to takeoff. The soft runway was a factor.NTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.NTSB ATL95LA147Accident · 1 fatalLimited investigationFinal reportQuadcity Challenger I · Anniston, ALThe pilot's failure to maintain airspeed, following an undetermined engine malfunction.NTSB ATL95LA136Accident · No injuriesLimited investigationFinal reportCessna 150F · Russellville, ALThe student pilot's failure to properly plan enough fuel for the solo cross country flight. A factor was the terrain.NTSB ATL95LA126Accident · No injuriesLimited investigationFinal reportCessna A188B · Decatur, ALThe pilot's selection of unsuitable terrain for a precautionary landing. Which resulted in the collapse of the main landing gear. The undetermined aircraft problem and rough/uneven terrain were related factors.NTSB ATL95LA122Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Andalusia, ALThe pilot's failure to maintain airspeed in a climbing turn, that resulted in an inadvertent stall.NTSB ATL95LA115Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Livingston, ALThe loss of engine power for undetermined reasons.NTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.NTSB ATL95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Huntsville, ALThe downdraft weather condition, and the pilot's failure to maintain adequate clearance from the terrain during his maneuver.NTSB ATL95LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Bessemer, ALThe pilot's failure to maintain directional control during a touch and go landing.NTSB ATL95LA102Accident · Serious injuriesLimited investigationFinal reportBurchfield Rose Parakeet · Tuscaloosa, ALThe pilot's inadequate preflight. Factors in the accident were the previous wing damage, and the obstruction of air flow over the aileron.NTSB ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.NTSB ATL95LA098Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Castleberry, ALFailure of the pilot to apply carburetor heat in a timely manner, resulting in the loss of engine power. A factor was the rough terrain at the forced landing site.NTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.NTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.NTSB ATL95FA090Accident · 2 fatalField investigationFinal reportAxell, Charles Glasair RG-2 · Elberta, ALThe pilot's failure to maintain flying speed which resulted in a stall. A factor was the loss of engine power due to a blocked fuel injector nozzle.NTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…NTSB ATL95LA080Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Brownsboro, ALThe student pilot's inadvertent use of spoilers during takeoff. Factors related to the accident were: the glider instructor's failure to identify the extended spoilers, and the proximity of trees in the emergency landing area.NTSB ATL95LA077Accident · Minor injuriesLimited investigationFinal reportBeech B-19 · Jackson, ALThe pilot's continued operation of the airplane with a known deficiency in available power.NTSB ATL95LA075Accident · No injuriesLimited investigationFinal reportCessna 182J · Calera, ALThe pilots improper decision to land downwind on the short runway.NTSB ATL95LA071Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Dauphin Island, ALThe pilot's improper use of the rudder control which resulted in a stall, and improper use of the elevator control, in that he maintained back pressure after the stall entry, keeping the airplane in a stalled conditions.NTSB ATL95FA065Accident · 1 fatalField investigationFinal reportPiper J-3L-65 · Tallassee, ALThe student pilot's failure to see and avoid the utility line while performing unwarranted low altitude maneuvers.NTSB ATL95LA060Accident · No injuriesLimited investigationFinal reportCessna 182P · Alabaster, ALThe pilot's failure to perform an adequate preflight inspection of the aircraft, which resulted in a takeoff with the control wheel lock installed.NTSB ATL95LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookwood, ALThe pilot's failure to lean the fuel mixture, stop at the first destination to refuel, and his incorrect fuel consumption calculations.NTSB ATL95LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269B · Addison, ALThe pilot's improper use of the throttle control during a descent which resulted in a hard landing.NTSB MIA95FA072Accident · Serious injuriesField investigationFinal reportCessna 152 · Mobile, ALThe pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.NTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.NTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.NTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.NTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…NTSB ATL95T#A01Accident · No injuriesClass 3Final reportCessna T210N · Montgomery, ALNTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.NTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.NTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.NTSB ATL94LA180Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Ozark, ALThe failure of the engines' main bearings because of a lack of lubrication. A factor was the heavily wooded terrain.NTSB ATL94LA177Accident · No injuriesLimited investigationFinal reportCessna 172D · Alabaster, ALThe pilot's failure to properly sump the fuel system during the preflight inspection that resulted in loss of power.NTSB ATL94LA172Accident · No injuriesLimited investigationFinal reportBell 47D1 Wasp · Hazel Green, ALUndetermined.NTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.NTSB ATL94FA166Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34R · Maylene, ALThe pilot exceeding the design stress limits of the aircraft, resulting in an overload failure of the wing spar, and separation of the left wing from the aircraft. A factor was the pilot's lack of total flying experience in this model of aircraft.NTSB ATL94LA149Accident · No injuriesLimited investigationFinal reportMiller, John Skybolt · Muscle Shoals, ALThe fatigue failure of the main landing gear strut that resulted in a loss of control.NTSB ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB ATL94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Samson, ALThe failure of the aileron torque tube bolt from fatigue, which resulted in an inflight loss of aircraft control and collision with terrain.NTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.NTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…NTSB ATL94LA112Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Summerdale, ALThe pilot's failure to maintain airspeed during takeoff.NTSB ATL94LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Hartford, ALThe student pilot's inadequate compensation for gusting wind conditions during the approach to land. Factors were the instructor pilot's inadequate supervision of his student, the gusting wind conditions, and the trees located in close proximity to the runway.NTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.NTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.NTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.