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 MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.NTSB ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.NTSB MIA01LA197Accident · No injuriesLimited investigationFinal reportCessna 182B · Headland, ALThe pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…NTSB ATL01FA093Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Anniston, ALThe inadvertent activation of the flight control gust locks by the pilot rated passenger that resulted in the loss of control inflight. Contributing was the pilot in commands failure to follow the airplane's pre-flight inspection check list.NTSB MIA01LA153Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Double Springs, ALThe failure of the pilot to maintain clearance between the skid and trailer while attempting to lift from a trailer resulting in dynamic roll-over.NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB MIA01LA134Accident · No injuriesLimited investigationFinal reportDavid G. Holmes Bensen Gyrocopter · Troy, ALThe failure of the pilot to maintain airspeed during the approach resulting in a hard landing. A contributing factor in the accident was the loss of engine power during final approach due to undetermined reasons.NTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…NTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.NTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.NTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…NTSB MIA01LA080Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Seminole, ALthe pilot's improper inflight planning/decision and failure to refuel en route and ensure an adequate supply of fuel to safely complete the flight to his destination with adequate reserves, which resulted in fuel exhaustion, subsequent engine failure, and a…NTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.NTSB ATL01FA021Accident · Serious injuriesField investigationFinal reportLearjet LJ-60 · Troy, ALOn ground collision with deer during landing roll, and the inadvertent thrust reverser stowage caused by the damage to the landing gear squat switch by the collision, and subsequent application of forward thrust during rollout.NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsNTSB MIA01LA058Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Pittsview, ALThe failure of the pilot to conduct proper preflight planning, resulting in loss of engine power while in cruise flight due to fuel exhaustion, and the subsequent emergency descent and landing to an open field.NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.NTSB ATL01LA003Accident · 1 fatalLimited investigationFinal reportUniversity of Alabama MINI-500 · Tuscaloosa, ALThe loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.NTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.NTSB ATL00LA086Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Pine Hill, ALThe pilot's failure to adequately preflight the helicopter, which resulted in his failure to remove the tie down.NTSB MIA00LA259Accident · No injuriesLimited investigationFinal reportEugene L. Capozzi VAN RV-6A · Bayou La Batre, ALThe pilots failure to maintain airspeed during final approach result in the aircraft stalling and descending uncontrolled until ground impact.NTSB MIA00LA261Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Meridianville, ALthe pilot in command's improper recovery from a bounced landing which resulted in hard landing on the nose landing gear and collapse of the nose landing gear.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB MIA00LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Cullman, ALfailure of the pilot to maintain directional control of the aircraft during the landing rollout, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it collided with a dirt bank.NTSB MIA00LA244Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F260B · Meridianville, ALthe pilot's inadequate preflight planning/preparation which resulted in fuel contamination going undetected, which resulted in a forced landing and substantial damage to the aircraft during the emergency landing.NTSB MIA00LA232Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Alabaster, ALa loss of engine power for undetermined reasons resulting in a forced landing and subsequent impact with the ground. A factor in this accident was that the pilot did not obtain the proper touchdown point upon landing and landed long.NTSB MIA00LA196Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Selma, ALThe improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…NTSB MIA00LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Montgomery, ALthe student pilot's failure to maintain aircraft control upon encountering variable winds during the landing flare/touchdown and his failure to recover from the resulting bounced landing which resulted in substantial damage to the aircraft.NTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.NTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.NTSB MIA00LA114Accident · No injuriesLimited investigationFinal reportMckinnis Steen Skybolt · Tuscaloosa, ALa loss of engine power during climb due to fuel starvation which was caused by a fuel leak in the gascolator as a result of improper maintenance by the operator that resulted in the pilot making a forced landing during which the airplane sustained substantial…NTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.NTSB MIA00LA044Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5 · St. Elmo, ALThe failure of the pilot to maintain airspeed resulting in the in-flight loss of control while maneuvering for a forced landing in a field after the loss of engine power. Contributing factors were the loss of engine power due to water-contaminated fuel.NTSB MIA00FA043Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pelham, ALThe student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.NTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA00FA003Accident · 2 fatalField investigationFinal reportBell 206B · Centreville, ALThe pilot's inadequate preflight inspection of the helicopter's fuel system resulting in an in-flight loss of engine power due to fuel exhaustion as a result of overboard porting of fuel when the airframe fuel filter was left in the 'drain and locked'…NTSB MIA99LA259Accident · No injuriesLimited investigationFinal reportCessna 172N · Moontown, ALThe pilot's decision to land on a runway with a quartering tailwind, his failure to obtain the proper touchdown point on the runway, and his delay in aborting the takeoff phase of a touch and go landing, resulting in the aircraft overrunning the runway,…NTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.NTSB ATL99FA132Accident · 2 fatalField investigationFinal reportContinental Copters Tomcat MK5A · Heflin, ALThe pilot of N9010T's failure to maintain visual lookout while maneuvering, resulting in a midair collision with N30899. A factor was the sun glare.NTSB ATL99LA124Accident · No injuriesLimited investigationFinal reportCessna 190 · Enterprise, ALThe fatigue failure of the main landing gear spring.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB MIA99LA217Accident · No injuriesLimited investigationFinal reportBell 47G-B3 · Selma, ALThe pilot's failure to maintain the proper touchdown point during landing causing the landing skid to become entangled with the edge of the helipad platform and the resultant rollover and main rotor blade strike of the tow vehicle.NTSB ATL99LA107Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Camden, ALThe failure of the cyclic control rod due to an overstress separation resulting from a material defect (inadequate quality of material) by the manufacturer.NTSB MIA99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Jasper, ALthe pilot inadvertently became disoriented and misjudged his position on the runway/airport, which resulted in him turning the airplane too soon, and subsequently impacting with a tree. Factors in this accident were a loss of electrical power for undetermined…NTSB MIA99LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Auburn, ALThe pilot' failure to refuel the airplane prior to fuel exhaustion.NTSB ATL99LA098Accident · No injuriesLimited investigationFinal reportPiper PA-60-600 · Montgomery, ALThe pilot's inadvertent shutdown of the wrong engine that resulted in the total loss of engine power. A factor was the loss of engine power due to fuel starvation when the left fuel boost pump failed.