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 ATL93LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Aliceville, ALMaintenance personnel's failure to properly secure the fuel line from the fuel pump to the fuel injector during the engine installation, which resulted in a complete engine failure.NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…NTSB ATL92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22T · Headland, ALThe pilot's improper evaluation of wind conditions and selection of the wrong runway, which resulted in a loss of control during the landing roll. A factor to the accident was a gusting tail wind.NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB ATL92LA160Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Slocomb, ALA hard landing due to a power loss from fuel exhaustion. A factor in the accident was the lack of sustable terrain for the landing.NTSB ATL92LA159Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Guntersville, ALThe pilot's inadequate evaluation of the in flight weather conditions, and his subsequent loss of aircraft control, which resulted in the design stress limits of the aircraft being exceeded. Factors were clouds, the associated turbulence, and the hail in the…NTSB ATL92LA158Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ft. Payne, ALThe pilot's improper procedure, in that he failed to raise the flaps following the short field landing, as prescribed in the pilot's information manual, which resulted in a loss of directional control. Factors were the tall grass adjacent to the runway, the…NTSB MIA92LA159Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Toney, ALThe left main landing gear attachment bolt failed for undetermined reasons resulting in the collapse of both main landing gear during the take off roll.NTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.NTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.NTSB ATL92LA143Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Eufaula, ALThe failure of the fuel injector servo as a result of the sticking bushing between the diaphragms.NTSB ATL92FA138Accident · 2 fatalField investigationFinal reportKory G. Cornum SH-3R · Auburn, ALThe failure of the pilot-in-command to maintain adequate airspeed after initiating a maneuver from low altitude. A factor was the lack of sufficient altitude.NTSB ATL92LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, ALThe failure of the pilot to maintain directional control of the aircraft as a result of his lack of total experience.NTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.NTSB ATL92LA132Accident · 1 fatalLimited investigationFinal reportBell 206B · Bessemer, ALThe pilots failure to maintain clearance from wires.NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.NTSB ATL92LA131Accident · No injuriesLimited investigationFinal reportBell 47D1 · Centre, ALThe pilot's inadequate visual lookout, resulting in a collision with a wire.NTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.NTSB ATL92MA118Accident · 3 fatalClass 1 · MajorFinal reportBeech C99 · Anniston, ALThe failure of senior management of gp express to provide adequate training and operational support for the startup of the southern operation, which resulted in the assignment of an inadequately prepared captain with a relatively inexperienced first officer…NTSB ATL92FA107Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Wetumpka, ALThe pilot's inadequate visual lookout, and his failure to maintain proper clearance from the transmission wires.NTSB ATL92FA106Accident · No injuriesField investigationFinal reportCessna 152 · Seale, ALA loss of engine power for undetermined reasons. A factor was the right seat pilot's selection of unsuitable terrain for the forced landing.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.NTSB ATL92LA079Accident · No injuriesLimited investigationFinal reportGuy Whisenant Skybolt · Gadsden, ALThe pilot's inadequate preflight planning and preparation, resulting in fuel exhaustion due to an inadequate fuel supply for the planned flight.NTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.NTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.NTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.NTSB ATL92LA036Accident · Serious injuriesLimited investigationFinal reportMosley HS GN-1 · Cullman, ALThe pilot's failure to maintain a safe flying speed.NTSB ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB ATL92LA018Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1D · Brewton, ALA blockage of the fuel vent system which prevented the pilot from topping off the fuel system. A factor in this accident was the inadequate design by the manufacturer of the fuel vent system.NTSB ATL92FA013Accident · Serious injuriesField investigationFinal reportBeech 58 · Pelham, ALThe pilot's failure to correct the position of the fuel selector before takeoff, and her inattentiveness to fuel consumption during the flight, which resulted in fuel starvation. Factors were the non-performance of engine out emergency procedures and the…NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.NTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.NTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.NTSB ATL92LA003Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gadsden, ALFuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.NTSB ATL91LA145Accident · No injuriesLimited investigationFinal reportCessna 188B · Monroeville, ALThe pilot's misjudgment of the clearance between the airplane and the electrical transmission wire. A factor was the hazy visibility.NTSB ATL91LA143Accident · No injuriesLimited investigationFinal reportHinton Kitfox · Killen, ALWeather conditions conducive to carburetor icing. A factor was the lack of a carburetor heat system on the engine.NTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.NTSB ATL91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hazel Green, ALThe inadvertent control interference caused when a parachute line became entangled in the right elevator trim tab, after the student jumper exited the airplane.NTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…NTSB ATL91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Muscle Shoals, ALThe loss of engine power for undetermined reasons.NTSB ATL91LA118Accident · No injuriesLimited investigationFinal reportMaule MXT-180 · Mobile, ALThe pilot's failure to properly compensate for wind conditions. A factor to this accident was the gusting winds.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.