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 MIA85LA224Accident · No injuriesLimited investigationFinal reportBell TH-13T · Quitman, GAPilot stated that after completing a left turn at the end of a cotton field, the aircraft yawed sharply to the left and the yaw could not be controlled with cyclic control. Another left turn at the oppsite end of the field the aircraft again yawed to the…NTSB MIA85LA222Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe aircraft was substantially damaged and the pilot uninjured when the aircraft flipped upside down in a field during a forced landing in an open field following engine failure. A post accident examination of the engine revealed the number seven cylinder…NTSB ATL85LA222Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Williamson, GAThe plt of the powered glider reported that during an apch to land, the acft encountered a downdraft & landed hard. The landing gear was damaged as well as the prop, eng cowling & oil cooler.NTSB ATL85FA221Accident · 1 fatalField investigationFinal reportCessna 421C · Kennesaw, GAThe acft lost power on # 2 eng shortly after take-off. The acft crashed and burned in a wooded area several miles sw of the arpt. The # 2 eng was severly damaged in the fire. No pre-impact malfunction could be documented. Examination of the prop did not…NTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.NTSB ATL85LA214Accident · Minor injuriesLimited investigationFinal reportWag-Aero Cubbie (J-3) · Stockbridge, GADuring a departure, the eng had a partial loss of power. The plt reported that after climbing to about 75 ft, neither the acft's speed nor alt would increase. He lowered the nose to increase the eng RPM & speed, but the eng did not respond. Subsequently, the…NTSB ATL85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAAccording to the pilot, he forgot to extend the landing gear. He stated most of his flight time had been in fixed gear aircraft. On this flight he had been told by his instructor to work on smoothing his radio technique on the second landing of the flight he…NTSB MIA85LA207Accident · No injuriesLimited investigationFinal reportQuinn EL Tomcat MK-5A · Blakley, GAWhile en route to reposition the helicopter to another farm, the eng lost power. The plt reported that during an autorotation, the main rotor lost some RPM as he stretched his glide to avoid a fence. As the helicopter touched down on uneven terrain, the main…NTSB ATL85LA202Incident · No injuriesLimited investigationFinal reportBeech 95-B55 · Alma, GAThe acft was lndd with the gear retracted during, practice touch & go landings. The plt was a FAA flight test engineer. The plt stated that the gear collapsed on touchdown; however, examination of the landing gear system failed to reveal a system malfunction.NTSB ATL85LA199Accident · No injuriesLimited investigationFinal reportBeech 55 · Savannah, GABefore taking off, the plt checked the trim & the auto-plt. During the takeoff run, he noted that the 'aircraft felt heavy on rotation/takeoff aborted.' The acft continued off the end of the rwy, hit a mound of dirt & was damaged. A post-accident exam…NTSB ATL85FA191Accident · 1 fatalField investigationFinal reportPiper J5A · Cleveland, GAThe plt took off from a private strip with his 5 yr old daughter on board. He then made several low passes by a guest house so that his daughter could wave to her grandparents. The acft was last seen headed generally in a northerly direction when it banked…NTSB ATL85FA182Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Cartersville, GAThe circumstances & purpose of the flt was not determined. According to witnesses, the owner/student plt & another psn, who was a certified mechanic & an instructor plt, took off & entered what appeared to be a closed traffic pattern for rwy 18. The traffic…NTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…NTSB ATL85FA179Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Kennesaw, GAPrior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and…NTSB MIA85LA181Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Marys, GAThe plt stated that he established a normal apch over the trees to the 2000 ft dry sod rwy. After clearing the trees, a high sink rate developed which was not arrested until the acft impacted the rwy on all three wheels, slid 66 ft, then nosed over. The plt…NTSB ATL85LKG06Accident · Serious injuriesFinal reportPiper PA-28-140 · Brooklet, GAThe plt stated that 2 approaches were made to rwy 09 and he could not locate a wind indicator. He was also unable to contact anyone over the UNICOM to obtain wind information. The plt attempted a landing on rwy 09 during which the acft bounced and a go-around…NTSB ATL85LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monticello, GAAbout 20 min after takeoff, while cruising at 5000 ft, the plt observed oil on the windshield & noted a decrease in oil pressure. He turned back toward the departure arpt & reduced the power in an attempt to prolong eng life. A short time later, the eng began…NTSB ATL85LA172Accident · No injuriesLimited investigationFinal reportGalloway B-8M · Milledgeville, GAThe plt stated that the gyroplane was blow off the side of the rwy by a gust of wind during the takeoff portion of a touch and go landing. The acft traveled into a grass area and nosed over. The student plt did not have a solo endorsement and had only two…NTSB ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…NTSB ATL85FA168Accident · No injuriesField investigationFinal reportEmbraer EMB-110-P1 · Atlanta, GAThe acft was on final apch when the circuit breaker caution light illuminated. The PIC failed to verify which cb tripped and assumed it was the gear control cb. PIC then activated emerg hydraulic sys and manually lowered the gear. After landing the hydraulic…NTSB ATL85LA167Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAShortly after takeoff with a low fuel state, the plt pulled the acft into a steep climb. A pwr loss was experienced and the acft reportedly stalled and spun into a pond on the pvt grass airstrip. Ten pounds of fuel were drained from the acft after the…NTSB ATL85FA165Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Milledgeville, GAAcft left home airport at 0400. Flt plan left with FBO indicated 6 hours to destination, no en route stops, and 4+30 hours fuel on board. Fuel consumption calculated, 4+36 hours endurance available. Acft flew 4+47 hours. The pilot told approach control acft…NTSB MIA85LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Jekyll Island, GAThe student plt was on her 1st supervised solo. During a touch-&-go landing, the acft veered off the left side of the rwy & subsequently hit a culvert. The student said that after she landed, she applied too much left rudder.NTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…NTSB ATL85LA161Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GAThe plt ldg the acft with the ldg gear retracted. He stated that he evidently forgot to extend the gear.NTSB ATL85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Ashburn, GAThe plt was on a flt to clean the spray boom by flying down the center of the airstrip & dispensing a cleaning substance thru the spray boom. He made one pass down the strip, then entered a pull-up to the right. He stated that he then turned back to the left…NTSB ATL85LA154Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Williamson, GAThe student plt stated his final apch to the rwy was made off-center to account for a x-wind. The glider touched down to the left of the paved strip & began converging on a fence. The plt retracted the speed brakes & lifted off as the glider approached the…NTSB MIA85LA164Accident · No injuriesLimited investigationFinal reportMooney M20C · Bainbridge, GAWhile en route, the plt noted a severe eng vibration. He shut down the eng & made an emergency landing. During the roll-out, the acft hit a ditch & was damaged. An investigation revealed that one prop blade had failed from fatigue & the end of the blade had…NTSB ATL85FKG05Accident · No injuriesFinal reportPiper PA-31 · Atlanta, GAOn may 2, 1985, at 0714 EDT, a Piper PA-31, N902BH, regisered to paul m. furnee, was struck by a ground vehicle while taxiing for take off at hartsfield international airport, Atlanta, Georgia on an airtaxi cargo flight. Instrument meteorological conditions…NTSB ATL85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Alma, GAThe student pilot and passenger changed the engine oil just prior to attempting the takeoff. The oil was drained on the ground on the airport where the aircraft was parked. Examination of the oil, disclosed that metal shavings were present in the drained oil.…NTSB ATL85LKG04Accident · No injuriesFinal reportAero Commander S2R · Leslie, GAThe acft lost power en route to spray crops & crash landed in a wooded area. The acft had flown only 2 miles when the power loss occurred. During the post accident investigation an exam of the powerplant & systems revealed that the supercharger had a loose…NTSB ATL85LA125Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Blairsville, GAThe private pilot and his student plt passenger were departing the a/p when the plt made a sharp turn downwind at about 100 ft of alt. The a/c mashed into the ground bounced and landed in small trees. The nearest reported winds were recorded at 19 KTS. The…NTSB ATL85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Blairsville, GADuring flt, the plt encountered unfavorable winds & rain, then became concerned about his fuel supply. He diverted to Blairsville & was landing when a gust of wind blew the acft side ways. The plt re-aligned the acft with the rwy, but it suddenly dropped &…NTSB ATL85LA124Accident · No injuriesLimited investigationFinal reportKirst Allen J DR-1 · Thomaston, GAThe plt made an emergency ldg in a fld after total loss of power due to fuel exhaustion. The plt was on a flt from lakeland, FL. To griffin, GA. With a planned refueling stop at americus, GA. According to the plt he was unable to land at americus due to…NTSB ATL85LA123Accident · No injuriesLimited investigationFinal reportCessna 182P · Atlanta, GAThe plt lost directional control during ldg when the acft encountered wind gusts and was blown off the rwy.NTSB ATL85LA116Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, GAAcft slipped on final due to being high. Landed hard and bounced. On second touchdown rudder was still applied and acft veered off runway colliding with ditch bank.NTSB MIA85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Brunswick, GAThe plt stated that his takeoff roll was normal, but just before he rotated, the nose gear collapsed. No determination could be made as to the nature of the malfunction during a post crash exam & retraction test of the landing gear.NTSB ATL85LA104Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Suches, GAAfter takeoff in mountainous terrain pilot used shallow climb on course. Pilot stated he failed to climb to a suitable altitude. When first ridge was cleared a downdraft was encountered. Pilot made 180 degree turn but was unable to climb above terrain.NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…NTSB ATL85LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lawrenceville, GAStudent pilot bought acft previous day, asked instructor to fly acft with him to home airport. CFI delayed en route to practice touch and go. On go around engine would not produce full power and acft would not climb. During subsequent interview pic/cfi told…NTSB ATL85IA096Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 3101 Jetstream · Macon, GAAcft was being slowed to holding speed in icing conditions. Crew heard sound of ice striking left side of fuselage followed by spool down of left engine. Then same occurred on the right side. Dual airstart successful. Crew elected to make precautionary ldg.…NTSB ATL85FA097Accident · 1 fatalField investigationFinal reportBeech H18 · Cartersville, GAThe flt had not yet been scheduled when the plt retired for the evening at 2230 to 2300 EST. At 0230, he was awoken & notified to make a ngt cargo flt. The owner obtained a wx briefing & filed a flt plan, then briefed the plt later. The plt arrived at the…NTSB ATL85FA090Accident · Serious injuriesField investigationFinal reportCessna 152 · Acworth, GAThe acft contacted power lines and descended uncontrolled to the terrain during the recovery phase of a simulated forced landing. The simulated forced landing was initiated by the CFI at an alt of aprx 800 ft AGL over the median strip of hwy 75. The student…NTSB ATL85MA083Accident · No injuriesMajor investigationFinal reportLockheed 188C · Dobbins Afb, GADuring gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…NTSB ATL85LA069Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairburn, GAThe aircraft reportedly suffered a loss of power while on the x-wing leg for a touch-&-go landing. The plt attempted to land the aircraft on the reciprical rwy from which he departed. The aircraft touched down long and ran off of the end of the runway into…NTSB ATL85LA052Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Griffin, GAThe acft crashed during an emergency landing while on a personal x-counry flight. Inspection of the acft at the accident site revealed empty fuel sumps and fuel tanks.NTSB ATL85IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Atlanta, GADuring cruise flt electrical fire erupted in the circuit board and electrical components of the temp control unit for the rear galley oven. Associated circuit breaker opened, electrical power to galley was turned off and within minutes the unit was cool to…NTSB ATL85LA046Accident · No injuriesLimited investigationFinal reportBell 206B · Chamblee, GAThe plt reported that he was conducting 'self refresher autorotation' practice with a student plt in the front left seat to observe. He stated that several autorotations were completed without incident. However, on the final attempt the acft settled through…NTSB ATL85FA043Accident · Serious injuriesField investigationFinal reportBeech M35 · Gainesville, GAThe acft crashed during an emergency landing while operating in VFR conditions on a dark night over isolated terrain. The plt stated he thought the eng exploded & lost visual contact due to oil spraying on the windshield. The rt front passenger held a…NTSB ATL85LA031Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Hogansville, GAA deplaning passenger walked into the rotating tail rotor. The passenger had been walked away from the acft by the plts brother but she returned on her own and was struck by the tail rotor.