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 ATL97LA053Accident · Minor injuriesLimited investigationFinal reportCatchot Hauler · Centerville, ALthe engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.NTSB MIA97LA103Accident · Serious injuriesLimited investigationFinal reportHughes TH-55 · Cullman, ALa loss of engine power for undetermined reasons and the pilot-in-command's failure to maintain control of the helicopter. Factors in this accident were: an improper autorotation as a result of improper collective use and resulting failure to maintain main…NTSB MIA97LA102Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Bessemer, ALthe student pilot's misjudged landing flare and the CFI's inadequate supervision by not taking timely remedial action.NTSB MIA97FA095Accident · 3 fatalField investigationFinal reportCessna T210L · Meridianville, ALthe pilot's improper decision to takeoff downwind which resulted in his failure to maintain control of the airplane. The winds were a factor.NTSB MIA97LA096Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Huntsville, ALTotal loss of engine power due to fuel exhaustion for undetermined reasons.NTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.NTSB ATL97LA031Accident · No injuriesLimited investigationFinal reportCessna 310Q · Selma, ALThe failure of maintenance personnel to correctly repair and install the pilot's seat.NTSB MIA97FA040Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Birmingham, ALfailure of the pilot to follow emergency procedures and feather the malfunctioning engine, which led to a forced landing and subsequent collision with a chimney (residence) and the terrain. His lack of recent experience in make/model of aircraft was a related…NTSB MIA97LA039Accident · No injuriesLimited investigationFinal reportWiedemann KIT FOX · Montgomery, ALimproper installation of a throttle cable clamp by an unknown person, resulting in a loose throttle cable housing and an inability to control the throttle position; and failure of the pilot to maintain adequate airspeed during an approach for an emergency…NTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.NTSB MIA97LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Gulf Shores, ALInadequate maintenance/inspection of the aircraft engine, which allowed continued use of a deteriorated ignition harness and subsequent loss of engine power.NTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…NTSB ATL97LA011Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Abbeyville, ALThe loss of engine power for undetermined reasons.NTSB ATL97LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Morris, ALThe pilot selected the wrong runway relative to the wind, and misjudged the proper touchdowm point on the runway. The tailwind was a factor.NTSB MIA97LA003Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Mobile, ALthe pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.NTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…NTSB MIA96LA232Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Slocomb, ALThe pilot's failure to maintain airspeed.NTSB MIA96LA226Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · St Clair, ALfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to ground.NTSB MIA96TA221Accident · No injuriesFinal reportBell OH-58A · Wetumpka, ALThe student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB ATL96LA120Accident · No injuriesLimited investigationFinal reportGreat Lakes GL2T-1A-2 · Montgomery, ALThe locked rudder in a fully deflected position which resulted in the pilot's inability to maintain directional control.NTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.NTSB MIA96LA195Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Wedowee, ALThe failure of the pilot to obtain a preflight weather briefing and his failure to maintain directional control during the landing roll following a precautionary landing due to adverse weather encountered during the flight.NTSB ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.NTSB MIA96LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Brewton, ALa loss of engine power for undetermined reasons.NTSB MIA96LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, ALfuel contamination, which resulted in loss of engine power, a forced landing, and impact with trees. A factor relating to the accident was: inadequate maintenance and/or inspection after the previous loss of engine power and forced landing.NTSB MIA96FA185Accident · 1 fatalField investigationFinal reportChampion Aeronca 7GCB · Fairhope, ALfailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…NTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.NTSB ATL96FA095Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Clanton, ALcorrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.NTSB MIA96LA161Accident · No injuriesLimited investigationFinal reportCessna 170A · Southside, ALfailure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…NTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB ATL96LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALfailure of the pilot to maintain directional control of the airplane during a go-around. A factor relating to the accident was: improper flare by the pilot during the landing.NTSB ATL96LA068Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Grove Hill, ALfatigue failure of the vertical fin forward spar in an area that was not accessible to inspection. A factor relating to the accident was: guidance for inspection of the area (where the fatigue occurred) was insufficiently defined by the manufacturer.NTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.NTSB ATL96LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Birmingham, ALthe pilot's failure to maintain directional control during landing,NTSB MIA96LA076Accident · No injuriesLimited investigationFinal reportCessna 310L · Auburn, ALan overstress failure of the left main gear side brace lock end fitting for undetermined reasons.NTSB MIA96LA062Accident · No injuriesLimited investigationFinal reportCessna 310C · Irvington, ALThe pilot's failure to maintain adequate airspeed during the landing flare, which resulted in a hard landing.NTSB ATL96FA021Accident · 2 fatalField investigationFinal reportMooney M20J · Bay Minette, ALfailure of the alternate air door, which resulted in blockage of air through the induction system. A factor relating to the accident was: failure to comply with Safety Bulletin SB-M20-253.NTSB ATL96LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alexander City, ALThe leaking fuel injector, which created a rich mixture, and caused the aircraft engine to lose power.NTSB ATL96LA008Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Tuscaloosa, ALFatigue failure of the number one piston assembly, which resulted in a loss of engine power.NTSB MIA96TA014Accident · No injuriesFinal reportCessna 182R · Redstone Arsena, ALthe pilot's poor inflight planning decision for not flying the scheduled time and electing to perform 3 additional takeoffs not planned during fuel consumption calculations. Contributing to the accident was the use of an inaccurate dipstick.NTSB MIA96LA010Accident · No injuriesLimited investigationFinal reportRockwell 112A · Meridianville, ALLoss of engine power due to inadequate maintenance during the 100-hour annual. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.NTSB ATL95LA176Accident · No injuriesLimited investigationFinal reportCessna 182R · Tuscaloosa, ALEngine oil starvation for undetermined reasons, which resulted in a connecting rod cap failure.NTSB ATL95LA175Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hoover, ALThe pilot's failure to maintain directional control when he positioned the helicopter in a hover so as to induce a loss of tail rotor effectiveness.NTSB ATL95FA162Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Double Springs, ALfailure of the pilot to follow emergency procedures for loss of engine power, and his failure to maintain control of the airplane. Factors relating to the accident were: the pilot's inadequate preflight planning/preparation and improper fuel consumption…NTSB ATL95LA161Accident · Serious injuriesLimited investigationFinal reportRonsrans R 12 · Clanton, ALThe pilot's failure to maintain proper flying speed, and the improper mixture of the fuel.NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.