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 ATL82DA192Accident · No injuriesFinal reportPiper PA-28-180R · Carrollton, GADuring cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation…NTSB ATL82DA186Accident · No injuriesFinal reportCessna A188 · Statesboro, GAThe pilot stated that he landed the aircraft on the numbers but was close to the left side of the runway. He delayed applying right rudder and the aircraft ground looped. The right landing gear collapsed and the right wing was substantially damaged.NTSB ATL82DA167Accident · Minor injuriesFinal reportPiper PA-28-161 · Atlanta, GAThe student pilot was practicing touch-and-go landings in winds that were variable 330 to 340 degrees at 10 knots. During the second touch-and-go, the aircraft touched down normally. However, as it was accelerating for takeoff, the plane suddenly swerved to…NTSB ATL82DA168Accident · Serious injuriesFinal reportSchweizer SGS-2-32-A · Williamson, GAOn downwind, the pilot saw another glider on the runway. He maintained altitude until the glider cleared the runway. When clear the pilot started his descent extending the spoilers fully. The pilot stated that when he reached his desired altitude and leveled…NTSB ATL82FA163Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Atlanta, GAShortly after takeoff, a loud noise was heard and sparks were observed coming from the right side of the right engine. The aircrew attempted to feather the right engine, but it would not feather. They were unable to maintain altitude and descended into trees.…NTSB ATL82DA162Accident · Serious injuriesFinal reportPiper PA-28-181 · Savannah, GAThe pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service…NTSB ATL82FLA03Accident · 2 fatalFinal reportCessna 172M · Thomasville, GAThe aircraft was being operated on a business flight for the purpose of surveying farm crops in the area. At about 1700 EDT, it crashed into a 20 acre farm lake while on a westerly heading. The weather was reported as clear, visibility 6 to 7 miles with haze,…NTSB ATL82FKG14Accident · Minor injuriesFinal reportFokker DR-1 · Hampton, GAThe pilot was also the owner of the fixed tri-wing, amateur-built aircraft. After returning from a local flight, he entered the traffic pattern. He flew a large pattern to maintain spacing behind a Cessna 150. After making a low approach, he positioned…NTSB ATL82IA154Incident · No injuriesIncident investigationFinal reportBeech 18 · Macon, GAAccording to the pilot, the flight was being conducted under ferry flight provisions. The flight was issued a takeoff clearance for runway 05,with reported surface winds of 320 degrees at 10 knots. The copilot started the takeoff roll and was unable to…NTSB ATL82FKG15Accident · 1 fatalFinal reportAeronca 7AC · Cedartown, GAThe acft stalled & crashed into trees from an altitude of approximately 60 feet AGL. The elevator trim tab control was found in the full nose up position.NTSB ATL82DA143Accident · No injuriesFinal reportCessna 172P · Jonesboro, GAThe pilot stated that after applying brakes on landing roll the aircraft began to hydroplane on water that was on the runway. He elected to raise the flaps and apply full power in a attempt to go-around but was unable to clear trees off the end of the runway.NTSB ATL82DA136Accident · Minor injuriesFinal reportCessna 150 · Buford, GAThe pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled…NTSB DCA82AA020Accident · 4 fatalFinal reportGates Learjet 23 · Near Savannah, GAThe flt was cleared to descend from FL410 to FL390. The flightcrew acknowledged the clearance & ATC observed the radar target descend. The acft suddenly pitched up when within 600 ft of FL390 & climbed. The pitchup was followed by two pitch oscillations which…NTSB ATL82FKG13Accident · 2 fatalFinal reportGreat Lakes 2T-1A-2 · Thomson, GAPrior to the accident, witnesses observed the aircraft while aerobatics were being performed. One witness estimated that the maneuvers were being flown between 100 and 300 yards AGL. Reportedly, the aircraft had been performing rolls, loops and spins for…NTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…NTSB ATL82FKG12Accident · Serious injuriesFinal reportCessna 421C · Atlanta, GADuring arrival, the pilot was cleared for an ILS approach to runway 20L. The pilot stated that the approach was normal in moderate to heavy rain and he broke out at about 800 ft AGL. He crossed the end of the runway with full flaps, was high, and touched down…NTSB ATL82FKG11Accident · 2 fatalFinal reportCessna 210 · Lexington, GAIn the early morning hours on 4/23/82, the aircraft departed covington, GA and proceeded on an undetermined route. At about 2300 PST that night, residents near the accident site heard the sounds of a crash. The wreckage was found the next morning about 1000…NTSB ATL82FA110Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Lafayette, GADrg the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & poor visibility. The plt responded he had to go to ft. payne VFR because they have no instrument approach. A jeppesen us (lo)29 low alt enroute chart was found at…NTSB ATL82DA101Accident · No injuriesFinal reportPiper PA-25-235D · Baxley, GADuring takeoff, the engine lost power at about 75 ft AGL. The pilot jettisoned his load of pesticide and landed straight ahead on the remaining runway. The plane continued off the end of the runway, ran into a drainage ditch, and was substantially damaged.…NTSB ATL82FA092Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Baconton, GAAs the pilot was descending from 7000 to 5000 ft, he heard a loud bang, followed by a temporary vibration and a violent swerve to the right. He looked out the right window and thought the right engine had fallen off since all he could see was the tops of the…NTSB ATL82FKG10Accident · 2 fatalFinal reportBeech A36 · Darien, GAThe pilot filed a VFR flight plan, but did not activate it after takeoff. While en route, he encountered deteriorating weather and obtained an IFR clearance. As he continued, he entered an area of thunderstorms, turbulence, and heavy rain. As the pilot was…NTSB ATL82IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31P · Savannah, GADuring flight, electrical fumes, smoke and sparks began emitting from the circuit breaker panel immediately left of the pilot's seat. The pilot was forced to move to the right seat. He tried to suppress the sparks with a chemical fire extinguisher and tried…NTSB ATL82DA090Accident · No injuriesFinal reportPiper PA-28-140 · Hazlehurst, GAThe pilot made a successful precautionary landing after becoming disoriented due to problems with his communication and navigation radios. After finding out his location he attempted to depart from a soft field covered with tall grass that was approximately…NTSB ATL82DA088Accident · No injuriesFinal reportPiper PA-24-250 · Macon, GAThe non-instrument rated pilot reported departing ft lauderdale, FL with 4 hrs of fuel on board on a 40 minute flight to okeechobee, FL. The next day, he departed okeechobee without refueling on a flight to Macon, GA. He reported that he had to climb to…NTSB ATL82FLA01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hoboken, GAThe pilot reported that during takeoff, he accelerated to 68 mph, then realized he would be unable to clear trees. He stated that he closed the throttle and mixture, aimed the aircraft at an opening in the trees, and maintained a level attitude until impact.…NTSB ATL82FA083Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Carrollton, GAThe student completed a touch & go & was climbing out when the instructor took control. He told the student that he was going to show him what to do if the eng quit shortly after takeoff. At 150-180 ft above the rwy near the upwind numbers the instructor cut…NTSB ATL82DA082Accident · Minor injuriesFinal reportCessna 177 · Jefferson, GADuring arrival, the wind shifted favoring runway 27. The pilot reported that he started his final approach at 80 mph and then slowed to 60 mph as he approached the threshold. Just as the aircraft crossed over a treeline, the aircraft suddenly dropped and hit…NTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…NTSB ATL82FKG09Accident · 1 fatalFinal reportCessna 210D · Near Commerce, GAThe owner had flown a PA-23 from charlotte to jackson county,FL with another plt following him in N3909Y. The owner stated the other plt was very meticulous & always drained fuel prior to flt. After the 1 hr flt to jackson county, they both looked over the…NTSB ATL82DA062Accident · 1 fatalFinal reportPiper PA-25-235 · Griffin, GAThe pilot was hired to perform for the filming of an agricultural spraying operation. During one of the low passes the aircraft struck two of the ground crew. The cameraman received fatal injuries. Pieces of the wooden propeller, used to drive the spray pump,…NTSB ATL82IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Atlanta, GAPilot was making an ILS approach to runway 20L with winds easterly at 12 with gusts to 20 KTS. A wind check at the outer marker disclosed winds 100 deg at 8 KTS, and tower authorized pilot to land on 20L or circle to runway 09 at his discretion. After a…NTSB ATL82FA052Accident · No injuriesField investigationFinal reportCessna 401 · Jessup, GAAfter reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…NTSB ATL82DA050Accident · No injuriesFinal reportCessna 140 · Statesboro, GADuring the second landing of a supervised solo flight, a gust of wind picked up the right wing and the left wing struck the ground. The student pilot applied power while initiating corrective action. However, the plane ground looped and flipped over on its…NTSB ATL82DA045Accident · No injuriesFinal reportCessna 182L · Conyers, GAThe destination airport is a private strip that is oriented on a 150/330 degree heading. The northwest end is enclosed by tall trees. Accordingly, most landings are made toward the northwest regardless of wind direction. The pilot landed on runway 33 which…NTSB ATL82DA044Accident · No injuriesFinal reportCessna 172N · Cumberland Isla, GAThe 2500 ft runway had trees on 3 sides. The normal pattern for landing was from east to west and departures were normally from west to east. A long, shallow, tailwind approach was made from the east at about 65 knots. The pilot used 40 degrees of flaps and…NTSB ATL82IA042Incident · No injuriesIncident investigationFinal reportBeech B200 · Atlanta, GAWhile at cruise with recommended power settings, the left engine oil pressure and torque indications began fluctuating and dropping. As the power lever was retarded a popping sound was heard and the engine was shut down. A precautionary landing was made in…NTSB ATL82DA040Accident · No injuriesFinal reportCessna 177 · Athens, GADuring an enroute refueling stop on 1/21 the pilot noticed fuel leaking around the left tank cap. After arriving at sanford the acft was refueled with appx 50 gals & a local flight of about 12 min was flown. The acft has a usable fuel capacity of 59 gals. The…NTSB ATL82FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Blairsville, GAThe aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…NTSB ATL82DA027Accident · No injuriesFinal reportBell 206L-1 · Chamblee, GAWhile returning to refuel from an air ambulance flight the helicopter yawed left and N2 dropped to about 92% approximately one mile from the airport. At 30-50 feet with airspeed at about 20 knots the aircraft yawed violently to the left with corresponding…NTSB ATL82FKG08Accident · Minor injuriesClosedPiper PA-32 · Jefferson, GANTSB ATL82FA023Accident · 2 fatalClosedCessna 310K · Gainsville, GANTSB ATL82FA022Accident · 1 fatalClosedCessna 206 · Pine Mountain, GANTSB ATL82FA017Accident · 1 fatalClosedPiper PA-28 · Savannah, GANTSB ATL82FKG07Accident · No injuriesClosedGrumm Amer AA-5B · Blue Ridge, GANTSB ATL82FKG06Accident · Minor injuriesClosedEnstrom 280C · Savannah, GANTSB ATL81FKG05Accident · No injuriesClosedHughes 269C · Atlanta, GANTSB ATL82FKG04Accident · No injuriesClosedPiper PA-28 · Swainsboro, GANTSB ATL82FKG03Accident · Minor injuriesClosedCessna 150F · Columbus, GANTSB ATL82FLA02Accident · No injuriesClosedMooney M20C · Folkston, GANTSB ATL82FKG02Accident · No injuriesClosedPiper PA-28 · Stone Mountain, GA