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 ATL85FA071Accident · Serious injuriesField investigationFinal reportCessna 172N · Dothan, ALThe plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums.NTSB ATL85LA065Accident · No injuriesLimited investigationFinal reportMooney M20E · Monroeville, ALPlt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to…NTSB ATL85FA067Accident · 2 fatalField investigationFinal reportRobinson R-22 Alpha · Huntsville, ALA popping sound then a loud noise and a puff of smoke preceded the helicopter's fall to the ground, stated a 12 year old boy who said he saw the accident. Examination of the helicopter failed to disclose any trace of fire. However one main rotor blade…NTSB ATL85LKG02Accident · No injuriesFinal reportCessna 172N · Tuscaloosa, ALThe acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear.NTSB ATL85FKG01Accident · Serious injuriesFinal reportPiper PA-28-140 · Huntsville, ALAccording to the pax very shortly after takeoff the acft 'stall light' illuminated as the acft flew over trees aft the end of the rwy. One pax reported that the acft climbed slightly before it dropped to the ground left wing and nose first. Exam of the eng…NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB DCA85AA006Accident · Serious injuriesFinal reportConvair 440 · Jasper, ALShortly after climbing & leveling at 6000 ft, the r eng bmep gage indicated a rapid power loss & the r eng RPM 'increased out of control' to about 3100 RPM. The aircrew retarded the r throttle & reduced the r eng to 2100 prm by using the prop…NTSB ATL85FA056Accident · 2 fatalField investigationFinal reportBeech C23 · Athens, ALThe acft was observed doing training stall type maneuvers in the area shortly before the accident. It was then observed in a steep right descending turn, crossing a paved road at low alt and striking the ground with the right wing tip. The bottom of the acft…NTSB ATL85FA041Accident · Serious injuriesField investigationFinal reportCessna 172K · Lineville, ALPlt obtained 2 wx briefings stating VFR flight not recommended along intended route. Plt requested local wx only during 3rd wx briefing. Reporting stations upwind and downwind of mountains were forecasting ceilings to be below mountain tops. Route of flt was…NTSB ATL85LA030Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ariton, ALAcft lost pwr and plt attempted to restart engine by switching fuel tanks. Power was not regained and forced landing was made in a field. Plt stated aux tanks were full and rt main contained 1/2 gallon of fuel. Fuel tank selected at time of power loss is…NTSB ATL85LA023Accident · Minor injuriesLimited investigationFinal reportFour Seasons Aviations American Aerolight · Springville, ALAt aprx 150 ft the plt heard a noise and observed a fire involving the rear portion of the acft. The plastic fuel tank ruptured and burning fuel was sucked aft through the pusher prop. The ballistic parachute was deployed and opened as the acft hit a 60 ft…NTSB ATL85LA022Accident · No injuriesLimited investigationFinal reportBeech 95 · Birmingham, ALPlt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire.NTSB ATL85LA014Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-8-71 · Hamilton, ALN825E, operated as delta air lines flt 977 heavy, encountered turbulence during descent. One flt attendant suffered serious injuries, two flt attendants & two passengers had minor injuries. Even though the seat belt sign was illuminated the flt attendants…NTSB ATL85LA010Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hueytown, ALThe acft crashed into a river while on final approach to land. The plt reported that he allowed engine RPM to drop and at the same time applied collective pitch. The acft struck the water in a steep descent. There was no report of any failures or malfunctions.NTSB ATL85LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Ozark, ALThe student plt was on her fourth supervised solo flt. During the ground roll of her fourth landing the acft started to go left of the rwy centerline. The plt said she over corrected twice and ended up heading off the rwy toward a ditch. Inan attempt to…NTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…NTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…NTSB ATL84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Hope, ALThe plt excessively flared the acft on landing at which time the acft ballooned. Recovery from the balloon was made but upon touchdown, the acft was not aligned with the rwy. The acft traveled off the left side of the rwy and contacted several small trees.NTSB ATL84LA242Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe pilot stated that while approaching a field in preparation for agricultural sraying, the engine failed. The aircraftwas pulled up into a climbing left turn and turned back toward the field for a forced landing. The aircrafts glide was extended to clear…NTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…NTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.NTSB ATL84LA214Accident · Serious injuriesLimited investigationFinal reportMooney M-20F · Red Bay, ALThe acft landed gear up short of the rwy in an attempt to return to the rwy after a power loss at low alt. During takeoff the arpt manager said the engine sound change was consistent with power loss from fuel starvation. FAA did a post accident engine test…NTSB ATL84FKG08Accident · No injuriesFinal reportCessna 177RG · Pell City, ALDuring the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…NTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…NTSB ATL84FA193Accident · 2 fatalField investigationFinal reportCessna 150F · Laceys Spring, ALA non-certificated plt made a steep turn after takeoff. The acft then entered a dive & impacted the ground in a steep nose low attitude. No record of pilot proficiency was found. Acquaintances reported that the plt had no training other than the minimum…NTSB ATL84LA189Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Huntsville, ALAfter lift-off & gear retraction, the acft settled back onto the rwy, hit a barrier cable, slid backward aprx 300 ft & crossed a road before coming to rest. The plt reported that the carburetor heat door had come loose. However, an FAA inspector examined the…NTSB ATL84FA184Accident · 1 fatalField investigationFinal reportBeech A36 · Fayette, ALThe acft collided with the ground in a near vertical nose down attitude after being observed by witnesses to pitch down during cruise flt. This acft & plt flew earlier in the day with an instructor who had to recover control of the acft after the plt allowed…NTSB ATL84FA183Accident · Serious injuriesField investigationFinal reportCessna 152 · Piedmont, ALThe plt reported that prior to flying, he had 2 mixed drinks which contained alcoholic beverage. The flt originated at talledega, AL. The plt then flew to anniston, AL, where he landed. From there he flew to jacksonville & centre, where he made touch-&-go…NTSB ATL84LA182Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ALAccording to the instructor (CFI), he & the student were practicing base-to-final turns as they were returning to the arpt. He reported that the acft was flown at about 60 KTS with 20 deg of flaps at appx 800 ft AGL. He stated that the student steepened the…NTSB ATL84LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Lacey Springs, ALWhen the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched…NTSB ATL84LA177Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tallassee, ALThe plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon…NTSB ATL84LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, ALThe plt made a flt of about 30 min to practice landings, then landed to pick up 2 passengers. About 10 min after taking off on the 2nd flt, he began having symptoms of a medical problem. He said he felt hot & the air felt stagnant & stale. The vents & a…NTSB ATL84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Boaz, ALThe acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt.NTSB ATL84LA149Accident · No injuriesLimited investigationFinal reportMooney 21 · Centre, ALWhile in cruise flt the engine failed. The pilot executed a forced landing, and the acft sustained substantial damage during the landing sequence. Examination of the acft revealed no fuel in the tanks, lines, or pump. The acft had flown about 5 hours since…NTSB ATL84MA114Accident · 6 fatalMajor investigationFinal reportCessna 421B · Cullman, ALPlt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west…NTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…NTSB ATL84FA106Accident · 2 fatalField investigationFinal reportBeech A36 · Hamilton, ALThe acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…NTSB ATL84FA100Accident · 1 fatalField investigationFinal reportBell 47GL · Cullman, ALThe plt had just completed an eng overhaul & was test flying the helicopter. While maneuvering at aprx 100 ft AGL, the eng lost power & the plt initiated an autorotation. During the landing, the helicopter impacted hard on rising terrain, rolled onto its side…NTSB ATL84LKG03Accident · No injuriesFinal reportCessna 152 · Albertville, ALThe acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft.NTSB ATL84FA083Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Attalla, ALDuring a VOR approach to land in IMC wx, the acft collided with a tree. The non-instrument rated plt had filed an IFR flt plan on this and other occasions even though he was not qualified. During this approach, the descent was continued past the mda of 960…NTSB ATL84LA077Accident · No injuriesLimited investigationFinal reportCessna 150L · Ozark, ALThe plt reported that the acft had about 17 gal of fuel on board before he took off. About 2 hrs & 40 mins later, while in slow flt at aprx 700 ft AGL, the eng lost power. The plt landed in a small field that was surrounded by trees. During the landing roll…NTSB ATL84LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Mountain, ALWhile en route, the plt arrived at a check point 18 min behind schedule. Aprx 25 min later, he tuned in an incorrect VOR frequency that he had written down on his flt plan. The station that he tuned in was east of the desired station & the geographic features…NTSB ATL84LA047Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Bessemer, ALThe acft collided with a station wagon while taxiing for takeoff during a purchaser demonstration flt. The prospective buyers were a husband and wife and the wife was occupying the left front seat with the CFI in the right seat. The CFI stated, that while…NTSB ATL84LA034Accident · No injuriesLimited investigationFinal reportCessna 150A · Dauphin Island, ALThe acfts nose gear collapsed during landing. The student plt was on a solo training mission to practice landings. The plt said he made a normal landing and as the nose gear was lowered he added slight right rudder to hold a roll parallel to the rwy…NTSB ATL84FKJ02Accident · 1 fatalFinal reportCessna A188B · Hazel Green, ALThe acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…NTSB ATL84IA029Incident · No injuriesIncident investigationFinal reportCessna 150M · Mobile, ALThe acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot.NTSB ATL84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Montgomery, ALAccording to the plt he had an unsafe gear indication while in the traffic pattern. He alerted the tower to the problem and made a low pass over the runway. He was informed by tower personnel that the gear looked down and normal. During the landing the plt…NTSB ATL84LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Cullman, ALThe student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying…NTSB ATL84LA011Accident · No injuriesLimited investigationFinal reportBeech 58 · Montgomery, ALDuring an apch to land, the plt lowered the gear handle, but observed that the nose gear light did not come on & the right main gear light was flickering. Consequently, he recycled the gear operation. After that, he reportedly saw all 3 indicating down &…NTSB ATL84LA004Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Elberta, ALThe plt took off with a passenger, who was also a plt, but was not performing as such on this flt. After returning to the arpt, the plt landed on the north-south rwy. He stated that during the landing roll, he encountered a x-wind that caused the acft to…