NTSB investigations, GA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

NTSB ATL89FA013Accident · 1 fatalField investigationFinal reportCessna 182E · Brooklet, GAWitnesses reported the plt began a low altitude, high speed pass over the rwy as he had done on several previous occasions. However, as he initiated the pass, the descent to the rwy was not arrested & the airplane 'pancaked' near the threshold. The airplane…Oct 14, 1988 · N2834Y · DestroyedNTSB ATL89LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Savannah, GAWhile landing with a left x-wind, the acft veered to the left & went off the rwy. Subsequently, the nose gear collapsed in soft terrain. The plt thought tower personnel had told him the wind was from 030 deg at 9 KTS. A check of the transcript revealed that…Oct 7, 1988 · N7769N · Substantial damageNTSB ATL89FA005Accident · Serious injuriesField investigationFinal reportCessna 120 · Monroe, GAThe pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…Oct 5, 1988 · N77458 · DestroyedNTSB ATL88LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gray, GAInstructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &…Sep 15, 1988 · N32105 · Substantial damageNTSB ATL88DKG18Accident · No injuriesFinal reportGrumman G-164B · Smithville, GASoon after takeoff from a private sod airstrip for aerial application maneuvering, the engine lost power. The plt was forced to land in soft muddy terrain where the acft nosed over. Post acc invest revealed that the float assy in the carburetor jammed which…Sep 9, 1988 · N8132K · DestroyedNTSB ATL88IA241Incident · Minor injuriesIncident investigationFinal reportBoeing 737-387 · Savannah, GAWhile cruising at FL 310, usair flight 333 encountered severe turbulence. The pilot reported observing the thunderstorm activity on the airborne radar. The flight was within 20 miles of the cell before action was taken to avoid the encounter. The recommended…Aug 30, 1988 · N353AU · No damageNTSB ATL88DKG15Accident · Minor injuriesFinal reportRockwell S2R · Pelham, GAThe crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire…Aug 30, 1988 · N4887X · DestroyedNTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…Aug 26, 1988 · N4006P · Substantial damageNTSB ATL88FA231Accident · 1 fatalField investigationFinal reportCessna 172 · Adel, GAThe pilot had been briefed on the weather conditions along the intended route of flight. VFR flight was not recommended. The pilot elected to land at his alternate, and had reported visual contact. Local witnesses reported low ceilings and reduced visibility.…Aug 17, 1988 · N65790 · DestroyedNTSB ATL88DKG17Accident · No injuriesFinal reportIntermountain Mfg. Callair A-9 · Redbud, GAAug 13, 1988 · N7233V · Substantial damageNTSB ATL88DKG12Accident · No injuriesFinal reportCessna 188B · Bainbridge, GAAug 10, 1988 · N731UH · DestroyedNTSB ATL88LA229Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Cumming, GAThe pilot had made a precautionary landing due to enroute weather. After conditions had improved he obtained a weather briefing for his intended destination. He was told that there were tstms in the area but that conditions were VFR. After departure from the…Aug 7, 1988 · N4575K · Substantial damageNTSB ATL88IA227Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAAug 5, 1988 · N775NC · Minor damageNTSB ATL88IA226Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAThe eastern DC-9 collided with the delta DC-9 during taxi. Ground personnel had cleared the eastern flight forward after the pilot had completed a powerback which left the airplane perpendicular to the delta flight. Due to the long fuselage and the relative…Aug 5, 1988 · N421EA · 2 aircraft · Minor damageNTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GAJul 30, 1988 · N4880Y · Substantial damageNTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…Jul 25, 1988 · N4506F · Substantial damageNTSB ATL88LA217Accident · No injuriesLimited investigationFinal reportMooney M20E · Lawrenceville, GAThe plt reported that the engine failed shortly after takeoff. The pilot made a 180 degree turn and landed downwind on the runway. He elected to land gear up to avoid a drop-off past the runway end. The acft slid off the runway end, but came to a stop before…Jul 21, 1988 · N6810V · Substantial damageNTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GAJul 15, 1988 · N91217 · Substantial damageNTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…Jul 10, 1988 · N3525Q · DestroyedNTSB ATL88FA210Accident · Serious injuriesField investigationFinal reportCessna 210L · St. Marys, GAJul 7, 1988 · N732JV · Substantial damageNTSB ATL88LA208Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Thomson, GAThe plt reported that the engine lost pwr about 20 miles from the arpt where he had intended to refuel. The airplane subsequently collided with utility wires as he was attempting to land on a hwy. the plt attributed the pwr loss to fuel exhaustion. Postcrash…Jul 1, 1988 · N29238 · Substantial damageNTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…Jun 22, 1988 · N4282U · DestroyedNTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.Jun 20, 1988 · N8371T · DestroyedNTSB ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GAJun 16, 1988 · N6489 · Substantial damageNTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…Jun 14, 1988 · N7776F · DestroyedNTSB ATL88LA188Accident · No injuriesLimited investigationFinal reportMooney M-20 · Hartwell, GAThe nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…Jun 4, 1988 · N5705Q · Substantial damageNTSB ATL88LA181Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1A · Blue Ridge, GAThe plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg…May 22, 1988 · N80582 · Substantial damageNTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…May 21, 1988 · N8374U · Substantial damageNTSB ATL88FA173Accident · No injuriesField investigationFinal reportSwearingen SA-226-TC · Atlanta, GADuring a visual approach to runway 27L, the airplane was landed gear up. Both the capt and f/o stated that the landing gear had been lowered over the outer marker and that they had observed three green lights and that the warning horn had not sounded prior to…May 16, 1988 · N1013G · Substantial damageNTSB ATL88LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAThe student plt returned to the departure arpt and attempted a landing with a cross wind gusting to an estimated 20 KTS. After landing, a gust of wind was encountered. The aircraft became airborne. The student pilot held the aircraft's controls rigid. The…May 5, 1988 · N8205 · DestroyedNTSB ATL88FA162Accident · No injuriesField investigationFinal reportBeech 55 · Atlanta, GAMay 2, 1988 · N2025W · Substantial damageNTSB ATL88LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Watkinsville, GAStrong headwinds were encountered during the x-c flt. The plt landed at an arpt to refuel but found the arpt FBO to be closed. He continued on toward his destination. About 10 miles from his destination, he made a precautionary ldg in a field due to a…Apr 24, 1988 · N5921T · Substantial damageNTSB ATL88FA142Accident · Serious injuriesField investigationFinal reportBalloon Works AX-8B · Alpharetta, GAApr 14, 1988 · N74070 · Substantial damageNTSB ATL88LA215Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Lawrenceville, GAThe instructor reported that he initiated a sim engine failure during climb at about 100 ft AGL, as part of the recurrency flight. The pilot initiated an autorotation, at about 50 ft AGL, the rate of descent increased and the throttle was rolled in to arrest…Apr 13, 1988 · N42JW · Substantial damageNTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…Apr 13, 1988 · N1213D · 2 aircraft · Substantial damageNTSB ATL88IA139Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Atlanta, GAThe left MLG outer cylinder main trunnion fractured and separated while the airplane was sitting at the gate, shortly before the planned departure. Subsequent metallurgical exam of the part revealed that it was improperly overhauled, which significantly…Apr 12, 1988 · N889Z · Minor damageNTSB ATL88DKG06Accident · No injuriesFinal reportChristen Industries Eagle II · Chamblee, GAApr 10, 1988 · N722HS · DestroyedNTSB ATL88LA134Accident · No injuriesLimited investigationFinal reportCessna 150C · Funston, GAThe plt reported that the engine lost pwr at 200-250 ft AGL after departing rwy 30 at the private 1,750' sod airstrip. He stretched his glide to avoid wires off of the end of the rwy. After clearing the lines. The airplane nose 'fell through', and the…Apr 7, 1988 · N7956Z · Substantial damageNTSB ATL88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.Apr 7, 1988 · N49409 · Substantial damageNTSB ATL88LA129Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Stockbridge, GAThe airplane landed with the left wheel locked, and subsequently nosed over during the ldg roll. Post-crash exam revealed that the left wheel could not be rotated in the fwd direction by hand, and that it could be rotated aft by hand only with considerable…Apr 2, 1988 · N9871C · Substantial damageNTSB ATL88FA131Accident · 1 fatalField investigationFinal reportMooney M20G · Jasper, GABefore depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…Apr 1, 1988 · N3638N · DestroyedNTSB ATL88LA122Accident · No injuriesLimited investigationFinal reportCessna 310Q · Donalsonville, GAThe pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued…Mar 20, 1988 · N7765Q · DestroyedNTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…Mar 19, 1988 · N60586 · Substantial damageNTSB ATL88IA107Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Atlanta, GAMar 10, 1988 · N310DA · Minor damageNTSB ATL88LA098Accident · No injuriesLimited investigationFinal reportBeech 77 · Concord, GAPIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…Feb 21, 1988 · N623CH · Substantial damageNTSB ATL88LA091Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…Feb 17, 1988 · N9265T · Substantial damageNTSB ATL88LA101Accident · No injuriesLimited investigationFinal reportRockwell 112A · Juliette, GAThe airplane struck a transmission cable over a river at about 100 ft AGL. The plt rptd that he inadvertently stalled the airplane while turning to reverse direction during an aerial photo flt, and that he felt a 'bump' during recovery. After returning to the…Jan 20, 1988 · N1432J · Substantial damageNTSB ATL88FA082Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Augusta, GAJan 19, 1988 · N101JR · DestroyedNTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GAJan 14, 1988 · N12NF · Substantial damageNTSB ATL88FA072Accident · 2 fatalField investigationFinal reportNorth American T-28C · Woodstock, GAA plt/witness rptd that the airplane first flew over the arpt to the North at about 500 ft AGL, and subsequently performed a wingover at the North end of the arpt. The airplane then made a high-speed pass over the rwy to the south, at about 50 ft AGL. Upon…Jan 2, 1988 · N9719G · Destroyed