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 ATL86FA137Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Valdosta, GAThe left engine lost power shortly after takeoff and the pilot did not feather the propeller. A traffic pattern was flown with the aircraft in a continuous descent. Insufficient altitude remained to maneuver the aircraft to the runway, so the pilot elected to…NTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…NTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…NTSB ATL86LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Toccoa, GAThe pilot made three unsuccessful attempts to land the aircraft on the runway. During the third attempt the aircraft bounced on the runway and the pilot applied power to go-around. During the attempted go-around the aircraft collided with trees on the left…NTSB ATL86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · Braselton, GAThe pilot reported that the engine RPM decreased while conducting a banner tow flight and that the engine subsequently quit. The airplane was landed in a field of an auto race track where a telephone pole was struck during the landing roll. Temperature was 92…NTSB ATL86LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Moultrie, GAA deputy sheriff rented an acft to assist the sheriff's dept with a ground search for an escaped prisoner. Witnesses observed the acft flying low and slow over the area when it made a partial turn and pitch down into the trees. There were no indications of…NTSB ATL86FKG08Accident · Minor injuriesFinal reportJoachim Hoehne Pazmany PL-4A · Canton, GAThe acft struck a powerline wire during an attempted go-around after a bounced landing. The plt aborted the landing and turned left at low alt until impact with a wire occurred at a distance of about 300 ft left of the rwy and 1200 ft from the approach end.…NTSB ATL86FA102Accident · 2 fatalField investigationFinal reportNorth American NA219 (T28B) · Luthersville, GAAfter takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an…NTSB ATL86LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Stone Mountain, GAShortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…NTSB ATL86IA098Incident · No injuriesIncident investigationFinal reportCessna 404 · Mc Rae, GADuring cruise flight pilot heard loud bang from right engine and right propeller feathered. Aircraft was diverted and landed with no further damage and no injuries to the pilot. Subsequent teardown of engine revealed fractured connecting rod. Examination of…NTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.NTSB ATL86FA084Accident · Minor injuriesField investigationFinal reportBell B-214-B-1 · Bullard, GAA helicopter involved in a logging operation was in process of lifting a log when crew reported a 'loud explosion' and a loss of power was experienced. An autorotative landing was accomplished and a small engine fire was extinguished. The 1st stage turbine…NTSB ATL86FKG07Accident · Serious injuriesFinal reportPiper PA-28-180 · Statesboro, GAThe acft collided with the ground after encountering a downdraft over a wooded area at about 500 ft AGL. The plt reported that he flew out to overlook some land from the air. To avoid air traffic in the landing pattern he dropped down to about 550 ft and made…NTSB ATL86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Alma, GAThe pilot reported that the engine quit during his descent from the 2000 foot cruise altitude. The aircraft examination failed to disclose any system malfunction or failure. The pilot stated that his preflight indicated that there was about 1/2 and 1/3 tanks…NTSB MIA86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Folkston, GAThe plt stated that while on a flight from tampa, to jacksonville FL, he made an unauthorized deviation & landed at davis field Folkston ga, where the left main landing gear collapsed. Post crash examination of the acft revealed that the gear collapsed due to…NTSB ATL86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atlanta, GAThe pilot was unable to start the engine and elected to rotate the propeller by hand to free the congealed oil in the engine. When the propeller was rotated the engine started and the aircraft taxied into another parked aircraft. Post-accident examination of…NTSB ATL86FA057Accident · Serious injuriesField investigationFinal reportCessna 210M · Tucker, GADuring a night VFR flt the acft experienced a total loss of power and made a forced landing in a small parking lot in a business area. When rescue personnel asked the plt what had happened he stated that the acft ran out of fuel. Inspection of the wreckage…NTSB ATL86FA062Accident · 5 fatalField investigationFinal reportCessna 337G · Blairsville, GAAcft was flown VFR from ravenna, Ohio en route to atlanta, GA. It departed ravenna about 0930 01/17 & failed to arrive at its destination. Family reported acft missing. Air force rescue center notified at 2020 01/19. Cap commenced air search 01/20, hampered…NTSB MIA86FA053Accident · 1 fatalField investigationFinal reportCessna 172M · St. Marys, GADrg a ngt x-country flt, the non-instrument rated plt contacted apch control & rprtd he was 'sort of lost in the fog.' He obtained wx info & elected to divert to waycross, GA. Shortly thereafter, the acft collided with trees on uneven terrain & crashed.…NTSB ATL86IA051Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 B4-203 · Atlanta, GADuring takeoff initial climb the aircraft experienced an uncontained failure of the no 1 engine. The pilot returned to the airport and landed without further incident. Post incident examination disclosed four broken turbine mid frame strut studs. The fracture…NTSB ATL86LA047Accident · No injuriesLimited investigationFinal reportCessna 177RG · Atlanta, GAThe aircraft landed hard resulting in substantial damage to the aircraft. This was following a final approach which was flown high and fast. The aircraft was observed to stall approximatel 10 ft above the runway and land on the nose gear.NTSB ATL86LA044Accident · No injuriesLimited investigationFinal reportHughes 269B · Stone Mountain, GADuring ground refueling of the aircraft the fuel tank was over- filled and the fuel spilled over onto the ramp. The fuel was ignited and the aircraft was destroyed by fire.NTSB ATL86LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Stone Mountain, GAAfter an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down…NTSB ATL86FA034Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Dacula, GAThe acft collided with trees 3.5 miles from the arpt during an instrument approach in dense fog. The approach required an adf receiver and the acft did not have one. The mda on the approach was 1600 ft. the acft impacted the trees at 1200 ft MSL. The acft was…NTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…NTSB ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…NTSB ATL86FA014Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Ocilla, GAThe pilot of the second company aircraft to arrive in the vicinity of the airport held while the first attempted an ndr approach. After the first aircraft made a missed approach the pilot of the second aircraft attempted the approach. The aircraft flew into…NTSB ATL86MA011Accident · 2 fatalMajor investigationFinal reportBeech 58P · Forsyth, GAThe flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to…NTSB ATL86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, GADuring an attempted touch and go landing the student plt lost directional control of the acft. The acft ballooned during touchdown, veered off the rwy and nosed over.NTSB ATL86FA009Accident · 2 fatalField investigationFinal reportCessna 172N · Clayton, GAThe pilot and his passenger showed up for the second day in a row and checked the weather for the return trip to Florida. They found the weather VFR at the airport. An employee of the FBO took the pilot outside and pointed out that the mountains to the south…NTSB ATL86FKG03Accident · No injuriesFinal reportCessna 182P · Hawkinsville, GAThe acft caught fire during a forced lndg after losing eng power during cruise. The plt approached a hi-way for landing and smoke filled the cockpit. During rollout fire came thru the firewall and the plt evacuated the moving acft. The unoccupied acft…NTSB ATL86LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Atlanta, GADuring a practice autorotation the acft experienced a hard ldg when the plt failed to arrest the sink rate prior to contacting the ground.NTSB ATL86LA004Accident · No injuriesLimited investigationFinal reportCessna 305A(0-1A) · Marietta, GAAircraft was on touch and go landing. Pilot allowed aircraft to become airborne prematurely. Flaps were not raised during go around and pilot stated he lost it. Aircraft veered to left after initial lift off for go around touched down repeatedly,with second…NTSB ATL86FKG04Accident · Serious injuriesFinal reportMooney M20J · Americus, GAThe acft contacted a tree and came to rest inverted during a forced landing following a loss of pwr. The loss of pwr occurred aprx 5 miles west of the destination arpt. Post accident inspection of the airframe and powerplant failed to disclose any mechanical…NTSB ATL86FKG01Accident · Serious injuriesFinal reportPiper PA-32-300 · Perry, GAThe acft landed short of the rwy during a forced landing following loss of pwr during a x-country flt of 2 hrs. 3 witnesses saw the acft bring refueled but the only one who mentioned the amount of fuel added was the refueler who said he'topped off' all 4…NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…NTSB ATL85LA281Accident · No injuriesLimited investigationFinal reportCessna A188B · Baxley, GAPlt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured.NTSB ATL85FKG10Accident · No injuriesFinal reportPiper PA 60-700P · Hampton, GAThe plt feathered the #2 eng during flt when the oil pressure dropped to zero. #1 alternator failed to produce power and when the landing gear was lowered the battery was depleted to the point that the cockpit instrument lights went out. The acft was landed…NTSB ATL85LA274Accident · No injuriesLimited investigationFinal reportCessna 150G · Dalton, GADuring arrival, the student plt elected to land on a taxiway since the rwy was closed for constuction. He stated that he made a normal pattern, but was a little high on final apch. He reported that he flared about 20 ft above the taxiway, then the acft landed…NTSB ATL85LA255Accident · No injuriesLimited investigationFinal reportCessna 172E · Villa Rica, GAThe plt took off from the stockmar arpt on a local flt. After flying in the local area, he returned at dusk to land, but inadvertently made an approach to another arpt that was located about 1/2 mi from the stockmar arpt. He did not realized that he was…NTSB MIA85LKG04Accident · No injuriesFinal reportCessna A188B · Bainbridge, GAThe acft stalled during aerial application operations and collided with the ground. The plt said the wind was gusting to 30 KTS and during a steep downwind turn the loaded acft stalled at 100 ft AGL. The plt recommended less steep turns and not operating in…NTSB ATL85FA252Accident · 4 fatalField investigationFinal reportMooney M20C · Columbus, GAAcft departed airport after enroute stop for fueling.VFR conditions with broken clouds at 2800 feet and turbulence in clouds. Acft was cleared to 4500 and PIC asked to report reaching. During climb PIC was asked his altitude. His response was unintelligible…NTSB MIA85LKG05Accident · No injuriesFinal reportCessna L-188 · Camilla, GAThe plt stated that during a swath run at an alt of aprx 5 ft AGL, a sudden loss of pwr occurred. The acft was damaged when it settled and contacted the terrain. Post accident inspection and a test run of the eng failed to reveal any mechanical…NTSB ATL85LA248Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Irwinville, GAThe acft reportedly suffered a loss of power during aerial application. A forced landing was attempted in a field and collided with a tree. The cause of the loss of power was undeterminedNTSB ATL85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Peachtree City, GAPilot was renewing proficiency in light acft. On first touch and go landing, according to his statement during phone interview, he flared, acft ballooned, landed hard and porpoised. During ensuing roll out nose of acft settled and prop contacted runway. Acft…NTSB ATL85LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Leesburg, GAThe aircraft suffered a loss of power due to water in fuel and made an emergency landing in a field. During landing roll the aircraft collided with trees at the end of the field.NTSB ATL85FA234Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F · Chamblee, GAReportedly, the plt & passengers had gone to a local establishment, where the entire party had consumed an unspecified amount of alcoholic beverages. One passenger reported that after arriving at the arpt, the plt made a walk-around inspection of the…NTSB ATL85FA230Accident · No injuriesField investigationFinal reportCessna 210N · Chamblee, GAPlt had obtained check out in acft prior to departure on x-cflt. About 3.35 hrs into flt called atl ctr exp concern about fuel. At that time acft was about 4 mi w of rome ga VOR and about 15 mi from rome apt. Plt nor center were sure if fuel was avail at rome…NTSB ATL85LA229Accident · No injuriesLimited investigationFinal reportCessna 150K · Orchard Hill, GAThe acft suffered a loss of pwr due to fuel exhaustion and the plt made an emergency landing in a fld. During landing roll the acft collided with trees at the end of the fld. Post accident exam of the acft revealed one gallon of fuel in the right fuel tank…