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 ATL83LA119Accident · No injuriesLimited investigationFinal reportCessna 210 · Folkston, GAShortly after departure, the pilot observed fuel coming from the fuel tank vent and elected to make a precautionary landing. He touched down in the first 1/3 of runway 17 at a speed of about 80 mph. The pilot stated that the brakes failed during the roll-out…NTSB ATL83LA109Accident · No injuriesLimited investigationFinal reportPiper J-3C · Stockbridge, GAThe acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the…NTSB ATL83LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, GAThe aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they…NTSB ATL83LA106Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marietta, GAThe plt reported that he took off to practice engine out procedures & touch-and-go landings. Two successful touch- and-go landings were executed, the 1st with 20 deg of flaps & the 2nd with 10 deg of flaps. A 3rd engine-out landing was initiated, but with no…NTSB ATL83LA102Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, GAThe acft landed with the wheels up during an attempted go-around. The plt who was receiving instruction decided as the acft floated during a landing that he would go-around. Full power was added as someone retracted the landing gear and the flaps. The acft…NTSB ATL83LA087Accident · No injuriesLimited investigationFinal reportLockheed 18-56 · Madison, GAThe plt reported that after he taxied to the rwy, the #1 oil temp was not up to the minimum temp. He set the parking & advanced the #1 throttle to 1500 RPM until the engine warmed up. When both oil temps were within limits, he advanced both throttles to 30…NTSB ATL83FA083Accident · Serious injuriesField investigationFinal reportBeech C23 · Peachtree City, GAThe eng lost power shortly after the plt was making a takeoff. Subsequently, the acft was badly damaged during a landing in an area of relatively small trees & brush. An exam of the acft revealed there was water in the left fuel tank & carburetor. The fuel…NTSB ATL83FKG07Accident · Serious injuriesFinal reportPiper PA-28R-200 · Lumber City, GADuring flight, the oil pressure began dropping rapidly just after the engine RPM abruptly increased. Minutes later, the RPM decreased and the engine failed. While the pilot was making a forced landing in darkness, the aircraft struck an object just before…NTSB ATL83LA075Accident · No injuriesLimited investigationFinal reportCessna 210 · Valdosta, GAPlt stated he departed adel with 12 gals of fuel. Purpose of flt was to refuel at Valdosta (25 mi). Eng quit due to fuel exhaustion 1/2 mi short of Valdosta arpt.NTSB ATL83LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Benning, GAStudent was doing a touch and go landing. While changing flap, carb heat and applying full throttle aircraft veered left. Recovery was attempted throttle off but aircraft left runway and collapsed nose gear, before flipping over.NTSB ATL83FKG06Accident · No injuriesFinal reportQuickie 2 · Stockbridge, GAReportedly, when the aircraft was landed, it touched down long and with excessive airspeed. The aircraft veered off the right side of the runway, when brakes were applied, and overturned. The wind was report as light and variable.NTSB ATL83IA070Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Moultrie, GAThe pilot was making a refueling stop in Moultrie, GA when the aircraft touched down on runway 14 at spence field with the landing gear in the up position. The pilot does not recall what events led to the wheels up landing. On exiting the aircraft, he noted…NTSB ATL83AA059Accident · 4 fatalFinal reportCessna 421B · Savannah, GAPlt reported he was on a missed approach & was returning to charleston "heading 360 degrees..." The acft crashed about 1/4 mi south & 100 ft short of the departure end of rwy 27. The wreckage scatter pattern was oriented on a heading of 155 deg. Missed…NTSB ATL83IA054Incident · No injuriesIncident investigationFinal reportGulfstream American G-159 · Chamblee, GAOrion airlines flt 110 experienced an engine fire immediately after tkof from dekalb-peachtree airport. At 400 ft AGL, the rt engine fire warning lt illuminated. Flames were observed over the wing and coming from the inbd side of the right eng cowl. The rt…NTSB ATL83FKG04Accident · No injuriesFinal reportMooney M22 · Hampton, GAAfter takeoff the acft climbed to about 60-70 ft & the eng quit. The acft crash landed off the end of rwy 24. The overboard flexible atmospheric drain vent, connected to the fuel pressurization valve, was found to be plugged by a very small piece of foreign…NTSB ATL83FKG03Accident · Minor injuriesFinal reportCessna 150M · Stone Mountain, GAThe pilot reported that while flying in marginal weather, he came to Stone Mountain and turned to avoid it. The aircraft crashed on the side of the Mountain about 300 ft from the base. About 9 mi east southeast of the crash site, the weather was reported as…NTSB ATL83FKG05Accident · No injuriesFinal reportPiper PA-28-161 · Pine Moutain, GADue to local wx conditions, the acft was receiving radar vectors to columbus, GA. Enroute to columbus, the plt elected to land at the callay gardens-harris county arpt. During final approach, he encountered a downdraft & struck several trees. He then added…NTSB ATL83FA039Accident · Serious injuriesField investigationFinal reportAero Commander 680W · Atlanta, GAThe plt reported that on the previous flt, the center fuel tank gauge was malfunctioning and indicated 800 lbs even when it was full with 1400 lbs. After lndg at charlotte,NC, it was still indicating 800 lbs. Bfr tkof, the center tank was refilled. While en…NTSB ATL83LA035Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAPilot stalled aircraft 10 feet above runway and made a hard landing.NTSB ATL83FKG01Accident · 1 fatalFinal reportBeech A23 · Junnel Hill, GADuring takeoff, the engine lost power at about 700 ft AGL. A forced landing was made in a pasture that was hilly with a gully running through it. During the landing, the aircraft first contacted the top of a small Hill in the pasture, then became airborne a…NTSB ATL83FKG02Accident · No injuriesFinal reportCessna 152 · Doraville, GAThe pilot was on an IFR flight plan and made a missed approach at the destination. While on a second approach, the aircraft ran out of fuel. During a forced landing, the nose gear collapsed and the left wing and right aileron were damaged.NTSB ATL83FLA01Accident · 2 fatalFinal reportCessna 172M · 9nm Nw Quitman, GAWitnesses observed the acft a little above the tree tops prior to colliding with a high voltage tension wire. The two passengers (ages 10 & 11) were seated in the right front seat, both using the same seat belt. The surviving passenger stated they had…NTSB ATL83LA019Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Adel, GAFollowing maintenance performed on the aircraft the pilot conducted a check flight. After takeoff the pilot discovered fuel splashing on the windshield and proceeded to abort the takeoff. Upon landing the pilot lost control of the aircraft. The aircraft…NTSB ATL83FA012Accident · 1 fatalField investigationFinal reportCessna 182P · Conyers, GAAircraft was observed making low passes. During on of these low passes aircraft collided with wires, trees and a tennis court. Pilots blood ethanol level was 214 mg percent. The pilot had not been given permission by the owner to fly the aircraft.NTSB ATL83LA007Accident · No injuriesLimited investigationFinal reportBeech S35 · Macon, GAAfter landing and coming to a stop on the runway, the pilot made a 180 degree turn to proceed to a taxiway and began cleaning up the cockpit. During the turn, the gear collapsed. The pilot stated that he inadvertently raised the gear handle instead of the…NTSB ATL83LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Albany, GAThe pilot of N737LJ departed on a cross-country business trip with less than full fuel tanks. After flying about 2 hours the aircraft engine quit and the pilot made an emergency landing in an open field. The aircraft collided with trees at the edge of the…NTSB ATL82DA286Accident · No injuriesFinal reportPiper PA-32RT-300T · Athens, GAThe pilot initiated an intersection takeoff with 1400 ft of runway remaining. After starting the takeoff, he elected to abort; however, the aircraft continued off the end of the runway and collided with obstacles. The performance charts showed that a 3000 lb…NTSB ATL82DA277Accident · No injuriesFinal reportCessna 120 · Hawkinsville, GAThe aircraft nosed over while landing in a peanut field. The pilot reported that the terrain was softer than he realized, and when he applied brake pressure, the plane nosed over. He believed the accident would not have occurred it brakes had not been applied.NTSB ATL82DA274Accident · No injuriesFinal reportPiper PA-25 · Baxley, GAPrior to landing, the pilot noticed that the left brake would not pump up. The pilot landed and during the landing rollout the left brake failed completely. The aircraft groundlooped and one landing gear collapsed.NTSB ATL82DA269Accident · No injuriesFinal reportPiper PA 25-235 · Ray City, GAThe pilot reported that while he was spraying crops, the engine began to skip and backfire. He decided to terminate the swath run and climb from the field. At that time, the engine quit and the pilot climbed as high as possible before gliding to a nearby…NTSB ATL82DA268Accident · No injuriesFinal reportCessna 188 · Nashville, GAThe engine failed while the acft was enroute to spray a soybean crop. Deposits of dirt & sediment were found in the fuel control assembly body screen.NTSB ATL82FA278Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Alma, GADuring his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…NTSB ATL82DA265Accident · No injuriesFinal reportCessna 188B · Gibson, GAThe pilot began a swath run by approaching the field over tall trees. Just beyond the trees was a 7 ft rise in the terrain. The pilot stated that he did not flare soon enough. Reportedly, the plane struck the crop, the gear sheared off and the plane slid to a…NTSB ATL82FA263Accident · 3 fatalField investigationFinal reportCessna 170A · Brunswick, GAThe non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the…NTSB ATL82FA261Accident · 1 fatalField investigationFinal reportCessna 170B · Lawrenceville, GADuring the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later…NTSB ATL82DA250Accident · No injuriesFinal reportCessna 310C · Brunswick, GAThe pilot experienced an electrical failure inflight after takeoff. He hand-cranked the landing gear to the down and locked position prior to landing. After rolling approximately 200 feet, he left main gear collapsed. Examination of the landing gear revealed…NTSB ATL82DA248Accident · Minor injuriesFinal reportCessna 172M · Perry, GAThe student pilot departed Perry, GA on a solo cross-country flight to augusta and jessup, GA. He was expected to return to Perry at about 1600 EDT. The flight progressed uneventfully to jessup where it was delayed by a thunderstorm. After departing jessup,…NTSB ATL82IA245Incident · No injuriesIncident investigationFinal reportBeech C23 · Duluth, GADuring preflight, the pilot found the right aileron front push-pull rod end broken. This defect would have precluded aileron control. Metallurgical examination of the fracture revealed that the part had failed due to reverse bending fatigue as a result of…NTSB ATL82DA246Accident · No injuriesFinal reportCessna 182P · Batesville, GAThe pilot reported that during the landing, he flared normally at what he perceived to be the runway threshold. He was surprised when he touched down hard on an upslope, about 15 feet short of the marked threshold and several feet below the runway level. The…NTSB ATL82FKG16Accident · No injuriesFinal reportCessna 150M · Madison, GAAfter touchdown the tailwheel equipped C-150 veered off the rwy into a gully breaking off the tailwheel. The acft then struck an embankment.NTSB ATL82DA238Accident · No injuriesFinal reportCessna 152 · Stone Mountain, GAThe pilot reported that a split-s maneuver was performed at a low altitude and the aircraft struck the branches of a pine tree. The aircraft continued to fly and the pilot returned to the airport. There was damage to the right wing and the fuselage.NTSB ATL82FA233Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Folkston, GAThe acft crashed into the okefenokee swamp in se Georgia. Thunderstorms, varying in magnitude from levels 3 to 5, were moving from west of jacksonville FL to an area north of the okefenoke swamp. The storms were moving nw at 20K.NTSB ATL82IA218Incident · No injuriesIncident investigationFinal reportCessna 152 · Hampton, GADuring taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…NTSB ATL82DA221Accident · No injuriesFinal reportGrumman G-164 · Donalsonville, GAWhile en route back to the airport, the engine lost power and the pilot landed in a rain soaked, soybean field. During the landing roll, the wheels bogged down in soft earth and the plane nosed over. According to the pilot, there was 10 to 12 gallons of fuel…NTSB ATL82DA209Accident · No injuriesFinal reportCessna T188C · Moultrie, GAA catastrophic engine failure occurred at an altitude of about 500 ft AGL while the pilot was returning to the airport. The pilot elected to land on a highway. He reported that during the landing, he ran the plane off the road to avoid an oncoming car. An…NTSB ATL82DA204Accident · No injuriesFinal reportGulfstream G-164B · Edison, GAWhile landing on a private sod strip to reload, the aircraft began pulling to the right. The pilot stated that all efforts to counteract with left brake, rudder, and power had no effect. Subsequently, the right wing struck a fence and the plane flipped over…NTSB ATL82DA220Accident · No injuriesFinal reportCessna 210D · St. Simons Isla, GAThe pilot was unable to extend the landing gear by using either the normal or emergency pump. Subsequently, a wheels up landing was made. An examination of the hydraulic powerpack, pn 1280510-1, revealed that the secondary pressure relief poppet valve…NTSB ATL82IA198Incident · No injuriesIncident investigationFinal reportCessna 177RG · Near Sparta, GAThe aircraft experienced power failure while in cruise flight en route from wilmington, NC to atlanta ga. Following the power loss, the pilot landed gear up in an open field Near Sparta, GA. Investigation revealed that the aircraft had last been refueled on…NTSB ATL82FA196Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Roswell, GAAbout 12 minutes after takeoff the plt reported "...alternator or generator trouble" & requested to return to the arpt. He later reported that he was having radio problems. The plt was vectored to intercept the ILS rwy 20L apch course. The accident occurred…NTSB ATL82DA197Accident · No injuriesFinal reportBellanca 7ECA · Savannah, GAThe owner/pilot stated that he was checking out the other pilot in the tailwheel equipped aircraft. The owner was a private pilot and the other pilot was reportedly a flight instructor (ip). During the landing roll, the ip overcorrected with the rudder and…