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 ATL99LA096Accident · No injuriesLimited investigationFinal reportRutan VERI-EZE · Enterprise, ALThe pilot's failure to remove covers from the fuel tank vent which resulted in fuel starvation.NTSB ATL99LA095Accident · No injuriesLimited investigationFinal reportAircraft Parts & Dev. A-9B · Hartsell, ALThe pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.NTSB ATL99LA089Accident · Serious injuriesLimited investigationFinal reportBoyd Dan MONO-WHEEL; Euro · Smith, ALThe loss of engine power for undetermined reasons.NTSB ATL99LA083Accident · 1 fatalLimited investigationFinal reportMichael W. Campbell Lancair 320 · Tallessee, ALThe pilot's failure to maintain flying speed during the takeoff to initial climb that resulted in the a stall and the inflight collision with the trees.NTSB MIA99LA144Accident · No injuriesLimited investigationFinal reportCessna 172H · Sylvan Springs, ALThe total loss of engine power for undetermined reasons.NTSB MIA99LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Courtland, ALThe failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…NTSB MIA99LA122Accident · Serious injuriesLimited investigationFinal reportHarris VARI-EZE · Eufaula, ALThe loss of engine power for undetermined reasons.NTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.NTSB MIA99LA107Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Opp, ALa loss of engine power due to the failure of the engine to transmission drive shaft flex coupling, resulting in an in-flight collision with a vehicle.NTSB ATL99FA044Accident · 2 fatalField investigationFinal reportBeech 300 · Cullman, ALThe pilot's failure to adhere to the missed approach procedure resulting in a collision with terrain. Contributing factors were fog and the rotorcraft rated pilot's lack of fixed wing certification/experience.NTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.NTSB ATL99LA035Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Hanceville, ALThe loss of engine power for undetermined reasons. Factors were a dark night and terrain condition.NTSB MIA99LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150F · New Brockton, ALthe pilot's failure to perform fuel consumption calculations for the flight, resulting in a total power failure due to fuel exhaustion, and subsequent forced landing in soft terrain. Contributing factors in this accident were inadequate pre-flight planning…NTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.NTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.NTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.NTSB MIA98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Centre, ALThe failure of the pilot to attain the proper touchdown point and his delay in initiating a go-around during a high and fast approach. A factor was the ditch.NTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…NTSB ATL98LA107Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dothan, ALFuel Exhaustion due to the pilot's improper fuel consumption calculations. A factor was the power line.NTSB ATL98LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Pell City, ALThe pilot's improper use of the flight controls during a crosswind landing and the improper recovery from a bounce resulted in the collapse of the right main landing gear. A factor was the right crosswind.NTSB MIA98LA216Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Tuskegee, ALThe pilot's failure to attain adequate airspeed, and his failure to abort the takeoff.NTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.NTSB MIA98LA197Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M47A · Citronelle, ALThe pilot's failure to control the helicopter's altitude while overflying an area of rising terrain and trees.NTSB MIA98IA193Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Birmingham, ALThe improper electronic control unit software logic that permitted the electronic control unit to lock on a failed hydromechanical resolver, which failed due to damage to a wire that was incurred during the manufacturing process, resulting in an uncommanded…NTSB ATL98LA084Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Millry, ALThe fracture of the #2 cylinder connecting rod which resulted in partial loss of engine power and subsequent forced landing. A factor in the accident was the rough terrain.NTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB ATL98FA076Accident · Serious injuriesField investigationFinal reportBeech BE-45-T-34B · Montgomery, ALThe installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.NTSB MIA98LA160Accident · 2 fatalLimited investigationFinal reportM2 Sport 1000 · Semmes, ALThe pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.NTSB MIA98LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Luvurne, ALThe loss of engine power due to a leaking engine oil seal, resulting in a forced landing, and subsequent impact with the ground. A factor in this accident was improper maintenance and checks after rebuilding and reinstalling the airplane's engine.NTSB ATL98LA070Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Brewton, ALImproper maintenance procedures used to overhaul the engine, which led to the crankshaft failure. Contributing to the severity of the accident was the fence.NTSB MIA98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Dauphin Island, ALFailure of the pilot-in-command (CFI) to maintain directional control of the airplane following an intentional low altitude maneuver by the student. Also, altitude inadequate for recovery from the in-flight loss of control.NTSB MIA98FA089Accident · No injuriesField investigationFinal reportFokker F28 MK 0100 · Birmingham, ALWere the 1) the inoperative alternate anti-skid control valve due to the disconnected electrical connector on the parking brake shut-off valve, the area was inspected 2 days earlier 2) the total loss of the hydraulic system resulting in the inability of the…NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.NTSB ATL98LA031Accident · No injuriesLimited investigationFinal reportChristopher Coats Challenger II · Evergreen, ALThe undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge.NTSB ATL98LA018Accident · 1 fatalLimited investigationFinal reportJohn T. Simpson Challenger II · Rainbow City, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.NTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB MIA98LA031Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6-6 · Elberta, ALa passenger's inadvertent encounter with a rotating propeller.NTSB MIA97LA236Accident · No injuriesLimited investigationFinal reportCessna 182Q · Butler, ALThe failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.NTSB MIA97LA212Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK5A · Sylacauga, ALThe failure of the pilot to maintain main rotor rpm resulting in the helicopter descending and colliding with trees.NTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.NTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.NTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.NTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.NTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).NTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.