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 ATL85LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAThe acft was damaged during a forced landing into a plowed field after the eng quit. Investigation revealed the plt had been instructed to refuel at his first stop of an extended x-country flt. The acft ran out of fuel aprx 1 mi from the second scheduled stop.NTSB ATL85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cumming, GADespite a fss forecast of thunderstorm activity for the next 24 hours the plt departed in order to evaluate wx situation for himself. Conditions were as forecasted and the plt elected to return to the arpt from which he had departed. Due to the movement of…NTSB ATL85LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Griffin, GAThe acft ran off the side of the rwy during landing. The plt planned to do touch and go landings. On the 1st landing theacft veered to the right and rolled off the rwy. The plt added power but the acft went into a ditch. The student plts logbook was not…NTSB ATL85LA016Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Commerce, GAAfter climbing to 8,000 ft the plt noticed fuel siphoning out of the left fuel tank cap. For the next hour & 20 min the flt operated on the left tank in an effort to use fuel from the left tank before it was siphoned out. Aprx 6 miles north of athens, GA, the…NTSB ATL85FA013Accident · 1 fatalField investigationFinal reportCessna 150L · Douglas, GAThe passenger reported that the former aerial application plt was demonstrating an aerial application maneuver when he entered a steep descent over a lake. The plt delayed the recovery and the passenger, who held a student plt certificate, attempted to level…NTSB MIA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Coolidge, GAThe acft collided with a bush during landing. The plt flew under a wire that he saw just in time to avoid hitting and over the 5 foot embankment on the opposite side of an intervening roadway. After the collision, the acft flipped over and slid through a…NTSB ATL85FA008Accident · Serious injuriesField investigationFinal reportCessna 150L · Cumming, GAThe arpt manager observed the acft start a go-around about 2 ft above the rwy with full wing flaps extended. Flaps remained full down as the acft attempted to climb before colliding with trees aprx 1/4 mi from the arpt. According to the plt, the go-around was…NTSB ATL85IA005Incident · No injuriesIncident investigationFinal reportBell 206B · Chamblee, GAThe plt attemped a descent and noticed the collective had locked up. Even with considerable pressure, he was unable to move the collective in either direction. He checked the system & made several remedial action attempts to no avail. An uneventful emerg…NTSB ATL85LA001Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Milledgeville, GAThe plt departed for the intended destination, but was unable to find the arpt due to fog. After landing at another nearby arpt, he found no av-gas available. He then elected to return to his original destination, but experienced a total power loss due to…NTSB MIA84LA260Accident · No injuriesLimited investigationFinal reportCessna C-152 · Little S.Simons, GAThe acft struck a washed-out area during a beach landing at night and was destroyed when it flipped over into the ocean. Investigation revealed that the plt was bringing a mechanic/plt to this part of the beach in an effort to repair another acft that had…NTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…NTSB ATL84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, GAThe plt departed deland, FL, for Columbus, GA, with an intended fuel stop at americus, GA. While en route from deland to americus the ceiling became lower than forecast and the plt made the decision to fly at 8500 ft MSL staying above the cloud layer. With…NTSB ATL84LA289Accident · No injuriesLimited investigationFinal reportWilliam T. Hodges Goldwing · Americus, GADuring the initial takeoff climb at an alt of 150 ft AGL, a ttl loss of power occurred. A forced landing was made in a soybean filed at which time the acft was substantially damaged. The plt stated the loss of power resulted from the installation of a…NTSB MIA84LA252Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T15 · Climax, GAThe plt said he was familiar with the area and was aware of the power line but misjudged his clearance and inadvertantlycollided with the top wire. The wire broke and wrapped around the landing gear of the acft and dragged it down. The acftwas destroyed when…NTSB ATL84FKG12Accident · No injuriesFinal reportCessna 411 · Hazlehurst, GAUpon takeoff at alt of 300 ft AGL, plt stated, rt engine failed. Plt feathered rt engine. Acft began to turn to rt so plt reduced pwr on left engine and made a forced landing straight ahead in a field. Acft contacted a small pine tree, slid sideways and gear…NTSB ATL84LA278Accident · Minor injuriesLimited investigationFinal reportHead Balloons AX7-77 · Austell, GAWhile flying at a low alt looking for a suitable landing area the plt noticed power lines at a higher alt. Plt initiallyapplied heat to the envelope to try and climb above the wires, but did not immediately realize the height of the wires. Plt then advised…NTSB ATL84LA273Accident · No injuriesLimited investigationFinal reportRockwell S2R · Shellman, GAPlt was en route to airstrip after spray run when he smelled smoke. Shortly thereafter the engine surged and lost power. Plt executed a forced landing in a corn field as flames from engine area became visible. Acft damaged by post-landing fire. Investigation…NTSB MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…NTSB MIA84LA230Accident · Minor injuriesLimited investigationFinal reportMooney 20E · St. Simon, GAOn landing roll, acft swerved to left & departed rwy surface into grass. Plt applied full pwr and attempted go-around, headed aprx 20 degrees left of runway alignment. Acft became airborne, angling toward ramp and hangar complex. Witnessesobserved acft assume…NTSB MIA84LA226Accident · No injuriesLimited investigationFinal reportAyres Thrush S2R-T15 · Quitman, GAAt the end of swath run the acft struck a piece of farm equipment during the pull-up. After the collision the plt noticed liquid trailing behind the acft as he returned to his departure airport. Upon ldg when the left wing settledclose to the rwy, the plt…NTSB ATL84FA252Accident · Minor injuriesField investigationFinal reportBoeing A75N1 · Cumming, GAThe acft experienced a partial pwr loss during takeoff. The pilot released the banner the acft was towing, made a left turn into a valley and collided with a ditch during a forced landing. Investigation revealed maintenance deficiencies in both the carburetor…NTSB ATL84FA248Accident · 4 fatalField investigationFinal reportCessna 421C · Kennesaw, GAAccording to witnesses, the acft entered clouds at low alt during the initial climb after takeoff. They reported that the acft then turned sharply back toward the arpt & descended below the clouds. It rolled out in the direction of the crash site with the…NTSB ATL84FA247Accident · Serious injuriesField investigationFinal reportCessna 172H · Ellijay, GAThe student pilot and passenger were on unauthorized flight in the local area at 0145 when the accident occured. According to the student pilot he had returned from a local flt, picked up a pax, departed again and had flown for 30 to 45 mins before returning…NTSB MIA84LA221Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Bainbridge, GAThe acft was destroyed by fire after it crashed into a wooded area just beyond the runway after taking off on a crop control flt. The plt stated that after takeoff he saw smoke and flames coming from under the cowling. The acft would not maintain alt and…NTSB MIA84LA220Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Pelham, GAThe acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings.NTSB ATL84LA245Accident · No injuriesLimited investigationFinal reportCessna R182 · Rome, GAThe acft made a hard landing after a power loss during takeoff. The ground was soft from rain and the nose gear failed at the fork as it dug into the dirt. The plts said that before takeoff they had checked for water in the fuel from both wing sumps and…NTSB ATL84LA240Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Franklin, GAFlying cross-country on a special ferry permit (the aircraft's annual inspection had expired) the pilot reports a gradual decline in power occurred until altitude could no longer be maintained. A forced landing was accomplished on apublic road, but the pilot…NTSB MIA84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Nahunta, GAAfter the student made a full stop landing on a 3000 ft rwy, he started to turn around & back taxi to the apch end to takeoff; however, the instructor (CFI) told him to make a short field takeoff from where he had stopped. A takeoff was initiated with about…NTSB ATL84LA236Accident · No injuriesLimited investigationFinal reportCessna T210L · Toccoa, GAPlt made a forced landing in a grove of trees 1 1/2 miles north of the arpt after reporting an engine failure due to fuel exhaustion. Plt stated adequate fuel was on board to complete the flt however, an en route course deviation was made to avoid various…NTSB MIA84LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Bainbridge, GAShortly after takeoff at about 150 ft AGL the propeller hub failed allowing one propeller blade to separate from the acft. The pilot flew the forced landing straight ahead into trees. Metallurgical examination of the hub revealed evidence of a fatigue…NTSB ATL84LA235Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Augusta, GADuring a turbulence encounter a pax standing in the rear of the cabin fell and suffered a fractured leg. The seat belt sign was illuminated for the entire flt. At the direction of the capt, in-flt service by the flt attendants was terminated. The injured pax…NTSB MIA84FA204Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · St.Simons Is., GAThe acft crashed during a forced landing after a power loss on final apch. The plt reported to fss on a 3 mile final and then reported the power loss and said he would make a 'dead stick' landing. Shortly thereafter, fss received an ELT signal. The acft was…NTSB DCA84IA030Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Marietta, GAEastern airlines flt 92, a Boeing 727, N8840E, and an air force-KC-135, reg #60-0330, call sign fowl 24, were involved in a near collision while both acft were maintaining FL350. The captain of flt 92 reported that during the occurrence, the KC-135 passed…NTSB ATL84LU007Accident · Serious injuriesFinal reportTeraton TA · Snellville, GAAfter making a touch & go landing, the plt was unable to climb over trees at the departure end of the rwy. Subsequently, the ultralight vehicle lodged in a tree about 40 to 50 ft AGL. The plt said that he was not injured during the impact with the tree.…NTSB ATL84LA219Accident · No injuriesLimited investigationFinal reportHaxton Quickie Q2 · Kennesaw, GAThe home built acft had just been constructed & the plt was making hi speed taxi checks. On the 3rd check, he applied full power, intending to accelerate to a target speed of 60 mph. He reduced the power before reaching that speed; however, the acft…NTSB ATL84FKG11Accident · No injuriesFinal reportCessna 421C · Kennesaw, GAThe plt reported that during the takeoff roll, at about 80 KTS, the right baggage door came open. He aborted the takeoff & the acft ran off the end of the rwy.NTSB ATL84FA216Accident · 1 fatalField investigationFinal reportCessna 150J · Terry Town, GAWitnesses observed the aircraft manuvering in the vicinity of the accident site at about 100 ft AGL. A second low pass was executed, terminating with a sharp pull up to a near vertical attitude. The acft climbed to about 300 ft AGL, the nose tucked under and…NTSB ATL84LKG10Accident · Minor injuriesFinal reportAero Commander S2R · Americus, GAAccording to the plt, he had maneuvered to finish spraying a field & was descending on a trim run when the eng coughed/hesitated. He stated that he became distracted by the problem & before he realized it, the acft was converging on trees. He turned the acft…NTSB ATL84LKG09Accident · No injuriesFinal reportRockwell S2R · Smithville, GAThe acft contacted a dirt mound after bouncing during a forced landing after white smoke came from the engine en route to a spraying operation. The power decreased and the engine quit prior to touchdown in a field. After striking a dirt mound the acft was…NTSB ATL84MA208Accident · 5 fatalMajor investigationFinal reportPiper PA-32-300 · Canton, GAThe acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…NTSB ATL84FA203Accident · 2 fatalField investigationFinal reportCamair 480 · Cumming, GAAccording to witnesses, the acft crossed a highway after taking off, entered a left turn, descended & pulled back up, then went out of control & crashed. One witness indicated that the acft entered a spin prior to crashing. An exam of the wreckage showed…NTSB ATL84LA197Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Stockbridge, GAThe ultralight vehicle lost power at about 250 ft AGL, shortly after takeoff. The plt chose a field for an emergency landing. However, while avoiding the tops of trees, the ultralight lost airspeed. Subsequently, there was insufficient airspeed to flare…NTSB ATL84LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, GAThe student pilot stated that the acft touched down at about midfield at aprx 90 mph. He was unable to stop the acft & it struck a chain link fence near the end of the rwy. The student had only 2 hrs of total flt time in this make & model of acft.NTSB ATL84FA190Accident · Serious injuriesField investigationFinal reportMaule M-6-235 · Marietta, GAThe float equipped acft departed on a southwesterly heading from the lake. Surface winds were reported from the north at 8 KTS gusting to 15. With full flaps extended the acft got airborne and continued a downwind climb over a tree line to about 250 ft AGL.…NTSB ATL84FU004Accident · 1 fatalFinal reportUltraflight Lazair II · Blichton, GAThe ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No…NTSB ATL84LA181Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jessup, GAThe acft landed off the rwy during a forced landing following a power loss. Wx conditions were conducive to carburetor icing.NTSB ATL84LA179Accident · No injuriesLimited investigationFinal reportCondor III · Kennesaw, GAThe two place ultralight actt crashed 30FT short of the rwy due to fuel exhaustion. The acft had been flying into a headwind of 13 knots at an indicated airspeed of 40 knots. The acft impacted in some underbrush.NTSB ATL84FA168Accident · 2 fatalField investigationFinal reportCessna 172RG · Dallas, GAApproximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…NTSB ATL84LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Jesup, GAThe plt reported he was spraying water and at the end of a swath run when he turned off the spray and pulled up, the engine lost power. The acft collided with trees during the forced landing. No mechanical discrepencies or malfuntions were found after the…NTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.