NTSB investigations, GA
59 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 3 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 NYC08CA067Accident · No injuriesData collectionFinal reportMooney M20F · Carrollton, GAThe pilot's descent below the glidepath during the approach, which resulted in a collision with terrain. Contributing factors included the pilot's diverted attention, pilot fatigue, and the night lighting conditions.NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.NTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.NTSB ATL03LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hampton, GAThe certified flight instructor's failure to maintain clearance from the runway during a low pass. A factor was gusty wind conditions.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.NTSB ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.NTSB MIA01LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain a visual lookout while maneuvering during a agricultural run, and inadvertent descent with a known sun glare resulting in an in-flight collision with terrain.NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB MIA00LA123Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Leesburg, GAThe failure of the pilot to maintain clearance during a spray pass resulting in the in-flight collision with the raised rows of the field.NTSB ATL00FA017Accident · 1 fatalField investigationFinal reportCessna 551 · Cordele, GAThe pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.NTSB ATL99LA073Accident · No injuriesLimited investigationFinal reportCessna 140A · Dallas, GAThe pilot's selection of unsuitable terrain/landing area for a short field landing, and his delay in executing a go-around.NTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB MIA98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain airspeed resulting in a stall.NTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.NTSB ATL98LA073Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger II · Savannah, GAIn flight collision with terrain for undetermined reasons. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA122Accident · Serious injuriesLimited investigationFinal reportBrock 162F · Canton, GAthe pilot's improper use of throttle and collective pitch during initial takeoff climb, which resulted in a decay of rotor rpm and settling of the helicopter into a lake.NTSB MIA98LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe failure of the student to recover (pull-up) from the intentional maneuver resulting in the in-flight collision with terrain. Contributing to the accident was the ostentatious display by the student.NTSB MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.NTSB MIA97LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Pinehurst, GAThe failure of the pilot to maintain clearance with the cotton crop while maneuvering to begin a spray pass over a 5 foot-tall cotton crop, resulting in the in-flight collision with the crop and terrain.NTSB MIA97FA232Accident · 1 fatalField investigationFinal reportBeech 200 · Dalton, GAthe pilot's improper IFR procedure, by failing to maintain the minimum descent altitude (MDA) during the ILS localizer approach, until the runway environment was in sight, which resulted in a collision with terrain short of the runway. Factors relating to the…NTSB MIA97LA198Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Bainbridge, GAthe pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…NTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.NTSB MIA95FA207Accident · 1 fatalField investigationFinal reportCessna 210C · Dawsonville, GAThe pilot's disregard of the weather forecast and flight into known adverse weather (instrument flight conditions), resulting in an in-flight collision while maneuvering in mountainous terrain. Contributing to the accident was the pilot's lack of recent…NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.NTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.NTSB ATL94FA010Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Richmond Hill, GAThe pilot's failure to maintain an adequate altitude above the water. And his physical impairment due to drugs.NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.NTSB ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.NTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.NTSB ATL91LA102Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lake Seminole, GAThe failure of the pilot to maintain clearance from the surface.NTSB ATL91FA042Accident · 1 fatalField investigationFinal reportCessna 310 · Brunswick, GAThe incapacitation of the pilot.NTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB ATL90FA093Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Ellijay, GAThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions.NTSB ATL89FA193Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13/M74 · Norman Park, GAImproper planning/decision by the pilot, which resulted in his physical impairment from exposure to lannate, and his failure to maintain altitude/clearance above the ground. A factor related to the accident was: failure of the pilot to use a respirator while…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…NTSB 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…NTSB 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…NTSB ATL87DKG06Accident · 1 fatalFinal reportPitts S-1 · Brooks, GAThe acft was observed in aerobatic maneuvers near the departure airfield. The last of the series was a lomcevak maneuver, which was started at an estimated alt of 2500 to 2700 ft. a witness rprtd the acft went into an inverted flat spin, which was corrected…NTSB ATL87FA122Accident · 1 fatalField investigationFinal reportBeech D-55 · Leesburg, GADuring a return flight at night, the aircraft crashed in an open field. The aircraft impacted the ground in a nose low attitude. The impact displaced the wing assembly rearward perpendicularly through the rear spar assembly. Both engine and propeller…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 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 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 ATL85FA013Accident · 1 fatalField investigationFinal reportCessna 150L · Douglas, GAThe passenger reported that the former aerial application plt was demonstrating an aerial application maneuver when he entered a steep descent over a lake. The plt delayed the recovery and the passenger, who held a student plt certificate, attempted to level…NTSB DCA84IA030Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Marietta, GAEastern airlines flt 92, a Boeing 727, N8840E, and an air force-KC-135, reg #60-0330, call sign fowl 24, were involved in a near collision while both acft were maintaining FL350. The captain of flt 92 reported that during the occurrence, the KC-135 passed…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 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 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 ATL83LA304Accident · No injuriesLimited investigationFinal reportCessna 150J · Monroe, GAAfter turning final approach the pilot realized he was high so he lowered full flaps. Shortly thereafter he saw that the indicated airspeed was low and made an aircraft attitude adjustment. After he corrected for the low air speed he failed to rotate to a…