NTSB investigations, GA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\" = 'GA' 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" = 'GA' 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 ATL87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Bainbridge, GAThe acft collided with trees while conducting an ag training flight. The training program was part of the locust control in central and southern africa. There was an instructor on the ground who acted as a radio controller for the flight. The pilot failed to…NTSB ATL87LA094Accident · Serious injuriesLimited investigationFinal reportBarlow Quickie 2 · Stockbridge, GAThe homebuilt Q-2 was on final approach when it impacted the trees about 300 feet short of the touchdown point. There were no witnesses and the pilot has no memory of the accident. He reported that he does not recall any problem with the aircraft except the…NTSB ATL87LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Darien, GADuring normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become…NTSB ATL87LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leslie, GAThe plt reported losing power shortly after takeoff; a forced ldg was subsequently made in a freshly-plowed field where the acft flipped over. Examination of the engine revealed a cracked #7 cyl head. FAA service difficulty reports (sdr's) indicated that…NTSB ATL87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Waycross, GADuring a normal approach to a sod strip, the pilot reported that the gusty wind condition ceased and the acft stalled to the ground short of the intended landing area. The pilot was not able to recover from the sinking condition. The impact caused substantial…NTSB ATL87LA078Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Augusta, GAThe acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…NTSB ATL87LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hampton, GAThe plt reported that a gusting x-wind existed during the approach to land. When he reduced pwr for touchdown, the acft pitched nose down, began a rapid sink and landed hard. The plt noted that he had the yoke full back but was unable to arrest the sink rate.…NTSB ATL87FA071Accident · 1 fatalField investigationFinal reportHughes 269A · Buford, GAThe helicopter was observed to slow down over the parking lot then continued out over the lake. A puff of smoke was observed around the rear of the engine area and the helicopter fishtailed as it almost came to a stop then dropped into the water nose first.…NTSB ATL87IA067Incident · No injuriesIncident investigationFinal reportBurkhart Grob G103 Twin Astir · Williamson, GAAs the glider plt was apchg the entry point for landing, he checked the spoilers for operation. The spoilers extended, but would not retract. There was a significant increase in the sink rate & the plt realized he would be unable to reach the arpt.…NTSB ATL87LA066Accident · Minor injuriesLimited investigationFinal reportCessna 337D · Savannah, GAThe pilot was flying a donated aircraft in support of a program to document the activities of wright whales off the coast of the carolina's and Georgia. The plt had been with the owner on a previous flt, when problems developed while switching to/and/or from…NTSB ATL87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, GAPlt deptd bowling green with a listed 5.0 hrs fuel on bd. After 3 hr 35 min he arrived over dest after exhausting fuel in the rt tank abt 30 min prior. He stated that the other tank was abt 1/2 full at the time. 15 min after rt tank exhaustion the plt req his…NTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…NTSB ATL87LA053Accident · No injuriesLimited investigationFinal reportCessna 182J · Kennasaw, GADuring initial climb for a local pleasure flight the pilot reported that the aircraft began to lose power. The pilot made a 180 degree turn to make an emergency downwind landing. He reported that the power increased and he decided to make a normal approach to…NTSB ATL87FA047Accident · Serious injuriesField investigationFinal reportCessna 310N · Savannah, GADuring ILS rwy 9 appraoch acft disappeared from radar at one mile short of rwy. Acft impacted in level attitude with landing gear extended on a northerly heading one half mile short and about one quarter mile left of rwy centerline. Plt and CFI both stated…NTSB ATL87FA039Accident · 1 fatalField investigationFinal reportCessna 170B · Madison, GAAlthough there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near…NTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…NTSB ATL87IA032Incident · No injuriesIncident investigationFinal reportMooney M20F · Columbus, GAPlt rpted he was descending in IMC for instrument approach when eng quit, restarted for 30 sec after switching fuel tanks, and quit again. Acft broke out of clouds about 700 feet, plt landed on interstate. Eng exam showed alternate air door seal blocking…NTSB ATL87LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waynesboro, GAThe plt called apch control & asked for vectors to the nearest field & said he was low on fuel. Vectors were provided but the eng lost power & the acft was damaged during a landing in a wooded area. An investigation revealed the acft had been flying for aprx…NTSB ATL87LA026Accident · No injuriesLimited investigationFinal reportMullinax KR-2 · Augusta, GAThe plt stated that the eng always ran rough at full pwr due to a rich mixture setting on the carburetor. Normally the eng roughness could be corrected by retarding the throttle or mixture control. The plt said that he adjusted the mixture on the carburetor…NTSB ATL87FA021Accident · 2 fatalField investigationFinal reportCessna 210L · Buford, GAAccording to the operator, cylinders had recently been replaced on the eng & plts had been instructed to operate the eng at 75% power with the mixture richer than normal during a break-in period. On this flt, the plt took off with a full load of fuel. As he…NTSB ATL87FA016Accident · 1 fatalField investigationFinal reportKoons-Donald Sonerai II · Macon, GADuring climbout, the pilot allowed the aircraft to stall while turning to a left crosswind. The acft impacted the ground in a nose low attitude after colliding with two trees. The pilot was unable to exit the aircraft and local residents were unable to assist…NTSB ATL87FA012Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Lawrenceville, GAAbout 20 min after takeoff, while cruising at 6500', the eng lost power. Rprtdly, the eng went to either idle or a wind-milling cond & the fuel pressure dropped to zero. The plt tried to restart the eng by using emerg procedures, but was unable. He initially…NTSB ATL87FKG01Accident · 1 fatalFinal reportJere L. Rosser Rand KR-2 · Kennesaw, GADuring initial climb the aircraft was observed at a high angle of attack at low altitude before descending in a stall/spin collision with the ground. Witnesses at the aprt reported that the engine sounded rough during the taxi and takeoff roll. The plt had…NTSB ATL87FA004Accident · Serious injuriesField investigationFinal reportBeech A-23-24 · Meldrim, GAThe pilot flight planned a total time enroute of 2HRS. 45 min. The aircraft fuel endurance was four hours. The pilot used about 1 hr. 15 min. Attempting to complete an instrument procedure. Sav was VFR throughout the entire flight and prior to the accident.…NTSB ATL86FA259Accident · 2 fatalField investigationFinal reportCessna 150M · Screven, GAThe plt and his best man for his wedding scheduled for later in the day dep LCL apt early in the am. The acft was observed maneuvering at a low alt over the plts parents home. Witnesses described the maneuvers to be like a crop duster making pull ups and…NTSB ATL86LA253Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19B · Griffin, GAThe glider departed on an aerial tow and was released at 1700' AGL. Intention of the flt was an out and back x-country. During the flt the plt could not find lift and radioed a friend, also in a glider, that he intended to land at a sod strip. The plt stated…NTSB ATL86LA244Accident · No injuriesLimited investigationFinal reportCessna A188B · Screven, GAThe plt was making a landing on an unpaved road near the aerial application site. He reported that the spray boom contacted peanut vines causing the acft to ground loop. The plt stated that he 'might have had a small bank to the right' at the time. The wind…NTSB ATL86LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Monroe, GAThe plt departed cox sky ranch for a flt to stone mt, GA. When he could not receive norcross VOR, he stated that he thought he was having nav radio problems and elected to land at Monroe, GA. Prior to landing he noted the right fuel gauge reading almost empty…NTSB ATL86FA242Accident · 1 fatalField investigationFinal reportLuscombe 8C · Lavonia, GAThe pilot had been diagnosed as having a brain tumor and was taking 300 mg of dilantin daily for the giloma. He suffered a grand mal seizure about two months before the accident. His mother stated that the pilot told her during a telephone conversation that…NTSB ATL86LA234Accident · No injuriesLimited investigationFinal reportBenham Midget Mustang M-1 · Rome, GAThe plt reported he took off too close behind a preceding acft and was caught in the wing tip vorticies. The vortices combined with a 110 deg left crosswind (wind 070/20 gusting higher) resulted in a loss of control and ground impact. The plt said he was in a…NTSB ATL86LA232Accident · No injuriesLimited investigationFinal reportCessna 150H · Rome, GAThe plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…NTSB ATL86LA230Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Shellman, GAJust after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An…NTSB ATL86FA223Accident · 2 fatalField investigationFinal reportBellanca 17-30 · West Green, GAThe plt took off at 1259 EDT, & at 1318, he reported level at 10,000'. There was no further comm with the acft. At about 1342, radar contact was lost. Subsequently, the acft wreckage was fnd scattered over a 425 yd area, along a sw azmith, aprx 1/2 mi from…NTSB ATL86FKG10Accident · Minor injuriesFinal reportGrumman American G-164A · Quitman, GAShortly after takeoff a loss of pwr was experienced. The plt attempted to land in a cotton field but the landing gear contacted a stump short of the field. The acft then contacted a ditch and nosed over. Post accident inspection revealed the supercharger…NTSB ATL86FA220Accident · Serious injuriesField investigationFinal reportBellanca 14-19-3A · Toccoa, GAThe plt checked on the acft the day prior to this flt and stated that he did not want it refueled. On the day of the flt he was observed draining fuel from the acft. He air filed an IFR flt plan and stated that he had 3 hrs and 45 mins of fuel and his en…NTSB ATL86FA217Accident · Minor injuriesField investigationFinal reportPiper PA-28-161 · Douglasville, GAThe plt loaded three adults plus herself into the warrior ii and attempted to take off from a grass strip which had a dip and a hill of about 6 feet near the departure end. The acft traveled about 150 ft past the end of the runway before impacting on the side…NTSB ATL86LA215Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cumming, GAThe plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down…NTSB ATL86LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Ringgold, GAThe pilot reported he attempted to make a 180 degree turn because he realized he was getting too close to an airport while on a cross country flight. A highway patrolman said the pilot told him he became disoriented during the turn, cut the power to land, and…NTSB ATL86LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Augusta, GADuring takeoff from an emergency landing zone, the aircraft collided with power lines and made a precautionary landing on the median between the highway. The helicopter was operating as an emergency medical services helicopter and the pilot was responding to…NTSB ATL86IA190Incident · Minor injuriesIncident investigationFinal reportSwearingen SA-26AT · Waycross, GAThe pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge…NTSB ATL86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbus, GAThe flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…NTSB ATL86FA182Accident · Minor injuriesField investigationFinal reportCessna P210N · Lawrenceville, GAThe acft was damaged during a forced lndg on a hiway after the engine quit. The flt was nearing its destination on a VFR x-country when the engine lost power. The acft fuel tank selector was on the rt tank for 2 hrs before and during the emergency. After the…NTSB ATL86FA176Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Columbus, GAJust as the aircraft flared for landing, a gust of wind struck the airport. The pilot and passengers reported that the aircraft ballooned up several feet, and the right wing dipped. The pilot got the wings level and attempted to perform a go-around. The…NTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.NTSB ATL86FA160Accident · Serious injuriesField investigationFinal reportBeech D45(T34B) · Rome, GAJust before takeoff, a rain shower was observed approaching the arpt. The plt elected to make a maximum performance takeoff. Rprtdly, after lift-off. She initiated a climb at 70 KTS & raised the flaps. The plt reported beginning a shallow turn at aprx 200 ft…NTSB ATL86LA159Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAThe plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for…NTSB ATL86LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GADuring a normal landing, the plt lost directional control of the acft which subsequently collided with a parked C-172. The plt reported that the right tire was inflated during the preflt inspection. Following the accident the tire was found deflated. The plt…NTSB ATL86FA148Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Stone Mountain, GAWhile on a bfr flt, the owner/plt was considered to be the plt-in-command. Drg departure, he took off on rwy 35 with a x-wind from the left. According to the instructor (CFI) & a witness, the takeoff was normal until shortly after lift-off, then the acft…NTSB ATL86LA145Accident · Minor injuriesLimited investigationFinal reportLangeford Midget Mustang MM-1 · Fayetteville, GAThe plt had flown the acft for about 20 minutes in the local area after which he returned to the airfield and made an apch. He initiated a go-around and reached about 400 ft AGL when the eng quit. He made a forced landing in a field and the acft nosed over.…NTSB ATL86LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Peachtree City, GAThe plt reported that the acft began to 'wheelbarrow' on the nose gear during the ldg roll. The acft veered off the rwy into a ditch. The plt said that he might not have had the pitch trim set correctly at touchdown. The acft flt manual before landing…