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 ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.NTSB ATL84LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Mccullough, ALThe acft crashed in a cotton field after maneuvering at low alt to check the crop. The pilot said he was at an alt of 4 or 5 ft and forward flt was below transitional lift speed. The rotor RPM began to reduce and also there was a drop in engine RPM. The pilot…NTSB ATL83LA385Accident · No injuriesLimited investigationFinal reportBeech 58 · Birmingham, ALThe acft swerved off the rwy after the left tire deflated during heavy braking & the left landing gear collapsed during the swerve. The pilot stated the acft was rolling too fast after landing to make the first turn off. The pilot then applied heavy braking…NTSB ATL83LA384Accident · No injuriesLimited investigationFinal reportCessna 172K · Brundidge, ALWhile cruising at 2,000 ft the plt smelled fuel fumes & elected to make a precautionary landing. When within gliding distance of the arpt, he secured the eng with the mixture control & made an uneventful deadstick landing. After exiting the acft he noticed…NTSB ATL83LA382Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9 · Andalusia, ALAfter spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt…NTSB ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…NTSB ATL83FA376Accident · Serious injuriesField investigationFinal reportAeronca O-58B · Geiger, ALThe acft impacted the ground in a nose low attitude. A witness saw the acft circle at 300-400 ft AGL and then do a snap roll. The acft then entered a spin and spun about 2 turns before impact. The witness said the engine sounded normal throughout the…NTSB ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…NTSB ATL83LA368Accident · No injuriesLimited investigationFinal reportCessna 310J · Birmingham, ALThe acft landing gear collapsed during landing. An FAA inspector said the gear made grinding noises when extended. During a fly-by the left gear door appeared to be jammed. Reportedly the landing gear transmission assembly failed.NTSB ATL83LA361Accident · No injuriesLimited investigationFinal reportCessna 188 · Slocomb, ALThe plt stated that he pulled up from a swath run and the eng began loosing power. He climbed to 300 ft & started back to the airstrip, then a total power loss occurred. During an emergency landing, he was unable to stop before the acft collided with trees at…NTSB ATL83LA349Accident · Serious injuriesLimited investigationFinal reportJohnston Long E-Z · Pell City, ALThe acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff…NTSB ATL83LA352Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Tyler, ALThe plt reported that while he was spray a field, he was flying under 2 transmission lines. He reported that as he began spraying the field, there was a thunderstorm aprx 2 to 3 mi away & the air became 'rough.' As the acft was crossing under the 2nd wire on…NTSB ATL83LA343Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600-A · Florala, ALThe pilot stated that during takeoff roll he experienced a power surge but the engine did not quit. He aborted the takeoff by reducing power on both engines and applying brakes. This resulted in the aircraft swerving off the right side of the runway, rolling…NTSB ATL83LA341Accident · No injuriesLimited investigationFinal reportCessna A188B · Samson, ALThe acft collided with a dirt bank during a forced landing after an inflt power loss. The pilot was enroute to a field at about 500 ft AGL when the power loss occurred. The pilot did not jettison his load of chemicals. He landed on wet grass and was unable to…NTSB ATL83FA340Accident · Minor injuriesField investigationFinal reportCessna T210L · Pleasant Grove, ALThe plt reported that the eng lost power as he was approaching his destination with the left main fuel gage indicating 1/2 full. During the emergency landing the left wing tip hit a utility pole prior to touchdown. The acft then collided with a chain link…NTSB ATL83LA316Accident · No injuriesLimited investigationFinal reportCessna 195A · Elberta, ALThe acft ran off the departure end of the rwy into a ditch during landing. The landing was on a private airstrip with a wet grass rwy that sloped downhill in the direction of landing for the last 1/3 of the rwy. The acft landed about a quarter of the way down…NTSB ATL83LA310Accident · No injuriesLimited investigationFinal reportCessna T188C · Semmes, ALThe acft collided with a power line during an aerial application maneuver. There were 2 set of wires crossing the area, a low set and a high set. The pilot suddenly came upon the low set and climbed over them but collided with the high set. The vertical…NTSB ATL83LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Birmingham, ALThe instructor (CFI) reported the eng began missing when power was applied after practicing stalls. A decision was made to return to the arpt. Carburetor heat was applied & the throttle was retarded to descend. The mixture was in full rich. After a couple of…NTSB ATL83FA277Accident · No injuriesField investigationFinal reportAero Commander 680 · Jacksonville, ALBefore takeoff, the acft had aprx 40 gal of fuel in the main tanks & 10 gal was added to each of the auxiliary tanks. The plt took off in hazy conditions for a short flt of apprx 10 min. While on downwind for a landing, he switched from the auxiliary to the…NTSB ATL83LA274Accident · No injuriesLimited investigationFinal reportCessna 150M · Muscle Shoals, ALThe acft made a hard landing and nosed over during an attempted go-around. The acft according to the pilot was operatingat nearly max gross weight and the density alt was 2300 ft. he tried a go-around with full flaps extended. A turn was made to avoid…NTSB ATL83FKJ05Accident · 2 fatalFinal reportAeronca 7BCM L-16A · Gadsden, ALThe acft collided with the ground in a 70 degree dive while taking part in an air show as a spotter plane. The acft had dropped one smoke grendade and was orbiting to drop another when it turned left and pitched down. According to an inspection guide for this…NTSB ATL83FA261Accident · No injuriesField investigationFinal reportHiller UH-12B · Huntsville, ALThe helicopter was damaged in a forced autorotative landing after the engine quit at 1200 ft MSL in cruise flt. The acftlanded in a mowed wheat field and the right skid dug into the soft ground. The plt and passengers declared no injureis. The plt said the…NTSB ATL83LA256Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · Weaver, ALAfter making 5 swath runs which expended about 1/2 of his load, the plt stated his fuel gage read 5 gals. He diverted to mcminn arpt to refuel. On final the eng quit & the acft touched down in the muddy overrun. The wheels sank in the mudshearing off the main…NTSB ATL83LA276Accident · No injuriesLimited investigationFinal reportPiper L-21B · Vernon, ALThe acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.NTSB ATL83LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe acft collided with a cow during takeoff for an aerial application flt. The collision broke off the right main landing gear and killed the cow. The pilot stated that the cow got through the fence and wandered onto the strip. The airstrip has a small rise…NTSB ATL83LA250Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Tuscaloosa, ALThe acft collided with a power line spanning a river during a low pass over the water. The pilot said the purpose of thelow pass was to look for his father in a boat. He said he thought he saw the boat and in pulling up the acft hit the power line. Control…NTSB ATL83AA235Accident · 8 fatalFinal reportCessna 421A · Atmore, ALAbout 20 mins after takeoff the plt reported the right eng had lost power & the acft would not maintain alt. Vectors were provided for an emergency landing, but the acft crashed in a wooded area about 3 mi from the arpt. There was evidence that the gear &…NTSB ATL83IA234Incident · No injuriesIncident investigationFinal reportCessna 177RG · Ozark, ALWhile in cruise flight the engine failed to respond to throttle movement due to the throttle linkage being loose. Forced landing was made to a pasture.NTSB ATL83LA227Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9 · Florala, ALThe plt reported that during takeoff, the eng began to lose power at the edge of the arpt. He noted that fuel pressure was lost & reported that he was unable to regain the pressure with the electric fuel pump. He switched the fuel selector to the fullest…NTSB ATL83LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Tallassee, ALAs the student jumper was getting out of the aircraft and onto the step in preparation for a parachute jump the pack tray prematurely opened and the canopy blossomed under the tail pulling the jumper into the horizontal stabilizer causing a cut on his left…NTSB ATL83LA209Accident · Serious injuriesLimited investigationFinal reportBarnes AX-6B · Decatur, ALThe balloon was launched from a field with power lines along the east side after another balloon was launched. The first balloon was aprx 50 ft from the power line when it was launched. When it tookoff, it traveled to the north northwest & remained well clear…NTSB ATL83FKJ04Accident · Serious injuriesFinal reportCessna 310 · Decatur, ALThe pilot stated that just after retracting the landing gear, the left engine appeared to quit. Unable to maintain flying speed, he elected to land in an open field but was unable to clear a row of trees. The acft impacted the ground after striking the trees.…NTSB ATL83IA208Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Muscle Shoals, ALThe right main landing gear strut failed on landing roll. The cause for the failure was not determined, the owner would not make the strut available for testing.NTSB ATL83FA198Accident · 4 fatalField investigationFinal reportBeech V35B · Chesson, ALWhile the acft was on a x-country flt at 4000 ft MSL, radio & radar contact were lost soon after a turn was initiated. Wreckage of the aircraft was found scattered over a distance of 2193 ft. an exam of the wreckage revealed that the stabilizers/ruddervators,…NTSB ATL83LA181Accident · No injuriesLimited investigationFinal reportPitts S1-SP · Wetumpka, ALThe acft experienced an inflt structural failure of its upper wing during aerobatics in an air show. The acft was landedsafely and the pilot was not injured. The upper wing leading edge ribs reportedly collapsed as the pilot began to pull up at the beginning…NTSB ATL83LA170Accident · No injuriesLimited investigationFinal reportCessna A-188B · New Hope, ALThe acft struck powerlines and crashed during an emergency landing after a loss of power while spraying on an aerial application mission. The plt stated that while spraying he noticed oil beginning to cover the windshield. He had begun aclimb and dumped the…NTSB ATL83LA168Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · New Hope, ALThe acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…NTSB ATL83LA166Accident · No injuriesLimited investigationFinal reportBeech C-23 · Birmingham, ALThe acft nose gear collapsed during landing on a student solo flt. The student and CFI flew a dual flt first and some airwork and 3 landings were accomplished. The 1st landing after the CFI got out of the acft was nose first with a bounceand a go-around. This…NTSB ATL83FA161Accident · 1 fatalField investigationFinal reportCessna 177RG · Mobile, ALThe plt had not flown actively for aprx 1 yr. However, shortly before the accident, he had told friends that he had missed flying & was going to resume this activity. He received a checkout in the Cessna 177RG on 12/12/82 in anticipation of flying again. This…NTSB ATL83FU001Accident · No injuriesFinal reportWizard J-3 · Wetumpka, ALThe plt reported having about 0.4 hour of experience in this new ultralight vehicle. The nosewheel of the vehicle was not steerable & there were no brakes on the main gear. Therefore, the plt relied on the rudder for ground steering. At slow speed, air from…NTSB ATL83LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Verbena, ALThe acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency…NTSB ATL83LA148Accident · No injuriesLimited investigationFinal reportCessna 175 · Tuscaloosa, ALThe aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn…NTSB ATL83LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Jasper, ALAs the acft was taxiing on rwy 9 for a takeoff on rwy 27 the left main gear dropped off the rwy into soft terrain. The plt attempted to taxi back onto the rwy by turning the nose gear to get a better edge. Nevertheless, both the nose &left gear left the rwy &…NTSB ATL83FKJ03Accident · 1 fatalFinal reportEaa Biplane P-2 · Southside, ALThe pilot was performing aerobatics over the airport at 400-500 feet AGL. On the last pass, he had completed one roll and was inverted in what appeared to be a second roll when the aircraft dove at the ground in a near vertical position. The aircraft engine…NTSB ATL83FA129Accident · 2 fatalField investigationFinal reportBeech K35 · Birmingham, ALThe acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…NTSB ATL83FA121Accident · Minor injuriesField investigationFinal reportMooney M20F · Anniston, ALJust prior to departure, the fuel tanks were filled. The plt stated that he drained both tanks after refueling by using the strainer pull handle in the cockpit with the selector positioned to each tank. However, he did not drain the individual tank sumps.…NTSB ATL83LA114Accident · No injuriesLimited investigationFinal reportCessna 172K · Scottsboro, ALThe acft was damaged in a hard landing. The plt did not believe the acft was substantially damaged and has disagreed with filing an accident report. Examination of the acft by a mechinic showed a partially collapsed nose gear buckled firewall and deformed…NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…NTSB ATL83FA091Accident · 4 fatalField investigationFinal reportMooney M-20A · Prattville, ALThe left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…NTSB ATL83FKJ02Accident · Serious injuriesFinal reportLuscombe 8E · Elba, ALThe plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…