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 MIA84LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valdosta, GAThe instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not…NTSB ATL84MA148Accident · 6 fatalMajor investigationFinal reportPiper PA-34-220T · Mt Airy, GADrg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…NTSB ATL84FA147Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Athens, GABefore starting an apch, the plt was advised the wx was: 300 ft obscured, visibility 3/4 mi with light rain & fog. The minimums for a straight-in VOR apch to rwy 2 were 400 ft mda & 1 mi visibility; for a circling apch, the minimums were 433 ft & 1 mi. The…NTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.NTSB ATL84FA133Accident · 2 fatalField investigationFinal reportBeech A36TC · Atlanta, GADuring takeoff, the plt radioed that a door had popped open & he needed to return. According to a plt witness, the acft had climbed above treetop level when it started to lose alt. Another witness said the acft leveled off & started to sink, then the nose…NTSB ATL84LA128Accident · Minor injuriesLimited investigationFinal reportCessna 337E · Tifton, GAThe acft reportedly was not tied down. The plt was hand propping the aft engine while the forward engine was running. In an attempt to board the acft the pilot was run over by the right main gear. The acft continued to travel until it collided with trees.NTSB ATL84FA129Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Woodstock, GAShortly after breaking ground during the takeoff, the engine lost power & the acft came back down to the rwy. The engine regained power & the plt continued the takeoff. The engine again lost power. Subsequently, the acft impacted on an uneven, grassy, open…NTSB ATL84FKG07Accident · No injuriesFinal reportCessna 172P · Atlanta, GAThe plt was having trouble with his radios, electrical system, fuel/eng gages & ammeter, so he turned off his electrical equipment & prepared to make an emergency landing. Because he was afraid of fuel exhaustion, his spacing behind another acft in the…NTSB ATL84LA123Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Rome, GAThe acft lost power in the traffic pattern and forced landed off the arpt. The weather was conducive to carburetor icing. The plt said he applied carburetor heat after reducing power.NTSB ATL84LKG06Accident · No injuriesFinal reportHomebuilt Dragon FLY 294 · Franklin, GAThe Homebuilt acft with 3 persons aboard lost its propeller after the crankshaft failed during cruise. A forced landing was executed on a state highway. The plt said he lost directional control at about 30 mph and contacted a ditch and two fence posts. The…NTSB ATL84FA118Accident · No injuriesField investigationFinal reportPiper PA 31-350 · Atlanta, GAThe aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the…NTSB ATL84FKG05Accident · 1 fatalFinal reportPiper PA-34-220T · Madison, GAThe acft collided with a car while landing on an airstrip at night. The car had been parked on the strip & an occupant in the car was fatally injured. An illicit substance was found aboard the acft & it was confiscated by law enforcement officials. Rain & fog…NTSB ATL84LA112Accident · No injuriesLimited investigationFinal reportCessna P210N · Kennesaw, GAThe acft crashed during a forced landing after a power loss. The plt stated during a post accident interview that he didnot switch tanks during the power loss sequence. Investigation revealed that the right fuel tank was empty. About 1/2 oz of fuel was…NTSB ATL84IA117Incident · No injuriesIncident investigationFinal reportBeech 19A Sport III · Atlanta, GAThe student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright.NTSB ATL84LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Alma, GAThe plt was on downwind and reduced power,he stated,before application of carburetor heat. The engine lost RPM and when the plt tried to regain RPM. The engine stopped. The plt said he tried to restart but failed and then made a forced off arpt landing. The…NTSB ATL84FA105Accident · 1 fatalField investigationFinal reportGrumman G-164B · Dawson, GAA failed cylinder head assembly resulted in a total power loss very shortly after takeoff. Witnesses observed the aerial application acft at 30-50 ft AGL over the rwy before it pulled up steeply, rolled and entered a near vertical uncontrolled descent to…NTSB ATL84LKG04Accident · Serious injuriesFinal reportCessna 177B · Kennesaw, GAThe acft bounced during landing and when it started to veer off the rwy the plt attempted a go-around. The acft collidedwith trees and came to rest in a small ditch.NTSB ATL84IA104Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-31 · Forest Park, GACaptain heard a muffled explosion accompanied by a moderate left yaw and 'a deterioration of readings on #1 engine' shortly after takeoff. Acft returned for an uneventful landing. Examination revealed that the engine failure initiated in 'the T3 disk/blades…NTSB ATL84FKG02Accident · No injuriesFinal reportPiper PA-60 · Atlanta, GAWhile on final approach the plt noted an unsafe nose gear indication. Tower personnel were unable to determine gear position during a fly-by. During landing touchdown the nose gear collapsed. Investigation revealed the acft had a brokenbolt in the nose gear…NTSB MIA84FA072Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Hoboken, GAWhile on base leg for landing, the forward right wing strut failed causing the right wing to separate. The acft then entered an uncontrolled descent & crashed. The non-certificated plt owned the acft. He had not complied with airworthiness directive 77-03-08.…NTSB ATL84LA081Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Dalton, GAPlt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…NTSB ATL84FA082Accident · 4 fatalField investigationFinal reportCessna 177B · Lafayette, GAThe acft crashed in an open field during an uncontrolled descent after encountering forecast icing conditions. The plt had received weather briefings and filed a flt plan into icing conditions in an acft not equipped to handle icing. The plt stayed at an…NTSB ATL84FU003Accident · 1 fatalFinal reportPterodactyl Ascender II · Lawrenceville, GAThe plt took off in conditions of turbulence & gusty winds. Witnesses reported the ultralight vehicle pitched & rolled erratically after lift-off. The plt then made a right climbing turn to a downwind heading & proceeded over a tall tree line toward a field…NTSB ATL84FA078Accident · 2 fatalField investigationFinal reportBeech BE-36 · St. Catherines, GAThe plt received a wx briefing at 1037 EST before departing on an IFR x-country. At 1051, a severe thunderstorm warning (#537) was issued by the national wx svc. When the plt requested an IFR clearance at 1107, he was advised of the frontal activity. About 3…NTSB ATL84LA067Accident · No injuriesLimited investigationFinal reportCessna 182P-SYLANE · Damascus, GAThe plt, an auctioneer, had rented the acft to fly to a farm where he was to conduct an auction. Previously, he had inspected the intended landing area, a soy bean field, & thought it would be satisfactory for a landing. When he arrived & landed, the main…NTSB ATL84FA057Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Atlanta, GAAfter gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the…NTSB ATL84AA053Accident · 6 fatalFinal reportBeech A36 · Armuchee, GAThe acft collided with trees and higher terrain which was adjacent to the VOR approach path. The weather was described by witnesses as stormy with heavy rains and high winds. Some of the occupants of the accident acft were airsick according to the plts radio…NTSB ATL84LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Wadley, GAThe plt stated that he landed too fast on the grass strip, & when he attempted to turn off the rwy onto a taxiway, the acft groundlooped.NTSB ATL84FA033Accident · 1 fatalField investigationFinal reportCessna 172F · Brunswick, GAThe acft was observed entering a cloud layer about 500 ft AGL after takeoff. Another witness observed the acft's navigational lights in a circling motion as the acft plunged to the ground.NTSB ATL84FKG01Accident · Minor injuriesFinal reportBeech 65-A80 · Edison, GAAt aprx 2130 EDT, the acft collided with a tree while the plt was making a low pass over a wooded area. After hitting the tree, the plane crashed into a pond. Reportedly, the acft had returned from columbia (south america) & the aircrew were preparing to drop…NTSB ATL83FA386Accident · 1 fatalField investigationFinal reportCessna A150L · Ringgold, GAThe acft was observed buzzing a truck stop, partially owned by the plt, at low altitude. The acft then stalled & spun into the ground. Some of the witnesses observed the plt waving & one witness said it appeared that the plt was leaning out the window…NTSB ATL83LA387Accident · No injuriesLimited investigationFinal reportHughes 269A · Moultrie, GAThe acft landed hard during an autorotational forced landing after engine stoppage. This was an aerial application flt in VMC weather. Reportedly the engine quit at 100 ft AGL over trees while the plt was trying to land to reload. After the power loss a hard…NTSB ATL83LA381Accident · No injuriesLimited investigationFinal reportAerotek S-2A · Dublin, GAThe plt landed at eastman, GA, where he planned to refuel, while en route from milton, FL to sumter, SC. Fuel was not available, so he departed for swainsboro, GA. However, he decided that would be too FAR, and planned instead, to land at Dublin which was 30…NTSB ATL83FAG12Accident · No injuriesFinal reportBeech E18S · Jonesboro, GAThe acft ran off the departure end of the rwy and nosed over during takeoff after an engine lost power. The acft had notbeen flown in several weeks and there had been days of rain and humidity. The magnetoes on the right engine were rough but seemed to clear…NTSB ATL83LA372Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jonesboro, GAThe acft crashed during a forced landing after the engine quit. The pilot said he had been flying in the local area and came in to practice touch and go landings. During the 2nd takeoff the engine missed. He landed and did a magneto check then another takeoff…NTSB ATL83LA362Accident · No injuriesLimited investigationFinal reportBeech 58 · Chamblee, GAThe acft ran off the departure end of the rwy after an aborted takeoff due to a cabin door opening. The CFI said that more than half the rwy remained when the throttles were retarded and the right door popped open at 91 mph. One attempt was made to close the…NTSB ATL83FKG13Accident · No injuriesFinal reportCessna 188B · Luddwici, GAThe acft crashed into trees and burned during a takeoff attempt on a country road with 120 gallons of aerial spray on board. This was the 1st takeoff after lunch and the plt said the acft seemed'glued to the road'. Seeing that he was going to impact wires he…NTSB ATL83LA360Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pinehurst, GAThe plt stated that all three shock cords on the left main landing gear broke during the landing roll allowing the gear to collapse. The acft veered off the rwy & crossed a drainage ditch, at which time all three shock cords on the right main landing gear…NTSB ATL83LA351Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Griffin, GAThe plt stated his airspeed was low on final & lift was lost on the canard due to the rain. He stated he had full aft stick trying to get the nose up, but couldn't. the acft landed hard, bounced several times hard & the canard broke.NTSB ATL83LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Simons Isl., GADuring arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the…NTSB ATL83LA350Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Odum, GAThe plt stated he ran out of fuel about 1/2 mi from the rwy.NTSB ATL83LA347Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Blackshear, GAThe pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed…NTSB ATL83LA344Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Blairsville, GAThe plt reported that during the run-up before takeoff, he noted that the right brake was not firm, but he elected to continue the flt. While cruising, he checked the brake & reportedly, no pressure was available. The remainder of the flt was routine until…NTSB ATL83FKG11Accident · 1 fatalFinal reportCessna A188A · Jesup, GAThe plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered…NTSB ATL83FA339Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Lexington, GAThe plt was on a cable patrol/aerial observation mission. While patrolling, he missed a turn in the cable route & turn to relocate it. After relocating the route, he looked back to observe a portion that he had missed & saw a logging operation. The plt turned…NTSB ATL83LA333Accident · No injuriesLimited investigationFinal reportCessna C-182J · Savannah, GAThe acft crashed right after takeoff when the it went into an uncommanded uncontrolled turn to the right. The acft was slightly over max gross takeoff weight but the CG was within limits. This acft was equipped with an autopilot. Post accident investigation…NTSB ATL83LA335Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Baxley, GAThe acft collided with trees during an emergency landing after the cockpit filled with smoke. A mechanic who examined the acft after the accident reported that exhaust gases had burned through the muffler shroud & had burned the ignition wires.NTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…NTSB ATL83LA323Accident · No injuriesLimited investigationFinal reportBellanca 8-KCAB-150 · Kennesaw, GABoth aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that…NTSB ATL83LA322Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20B · Cordele, GAThe plt was competing in a regional soaring contest. While en route from the 1st turn point he encounter rain & elected to land in a pasture. During the landing roll, the tail skid struck a hole which cracked the fuselage, immediately forward of the empennage.