NTSB investigations, GA
22 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1983 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2006 | 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\" = 320)
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" = 320) 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 ATL07CA019Accident · Serious injuriesData collectionFinal reportHolmgreen RV-6A · Midway, GAAn on ground encounter with rough/uneven terrain during the landing roll out resulting in the collapse of the nosewheel and subsequent nose over.NTSB ATL03LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · Newnan, GAThe pilot's failure to maintain directional control during the landing roll that resulted in the collapse of the right main landing gear.NTSB ATL03LA063Accident · No injuriesLimited investigationFinal reportCessna A152 · Peachtree City, GAThe pilot's failure to maintain directional control during landing roll that resulted in a nose over after the airplane departed the runway surface. A factor is muddy terrain.NTSB ATL03LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Watkinsville, GAThe pilot's inadvertent collision with an ant hill during takeoff that resulted in a ground loop and the subsequent collision collision with the ground. A factor was unsuitable terrain.NTSB ATL02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Thomaston, GAFailure of the pilot-in-command to maintain directional control on landing, resulting in an inadvertent ground loop.NTSB MIA02LA013Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Athens, GAthe pilot misjudged the ailment of the airplane on the active runway, inadvertently taking off from a parallel taxiway, and subsequently departing the hard surface into a 40 foot drop off. A factor in this accident was a dark night, and the pilot's total…NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB MIA99LA200Accident · No injuriesLimited investigationFinal reportBell OH-13H/M74A · Sparta, GAthe pilot's inadequate preflight which resulting in his failure to remove all the tie downs, and the subsequent impact with the ground.NTSB ATL98LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Athens, GAThe student pilot's failure to maintain directional control during land roll out that resulted in the on ground collision.NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB ATL92LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Cartersville, GAThe pilot's failure to operate the flight controls properly during the takeoff attempt and the pilot's planning decision during rollout.NTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.NTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.NTSB ATL86LA244Accident · No injuriesLimited investigationFinal reportCessna A188B · Screven, GAThe plt was making a landing on an unpaved road near the aerial application site. He reported that the spray boom contacted peanut vines causing the acft to ground loop. The plt stated that he 'might have had a small bank to the right' at the time. The wind…NTSB ATL86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbus, GAThe flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…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 MIA84LA260Accident · No injuriesLimited investigationFinal reportCessna C-152 · Little S.Simons, GAThe acft struck a washed-out area during a beach landing at night and was destroyed when it flipped over into the ocean. Investigation revealed that the plt was bringing a mechanic/plt to this part of the beach in an effort to repair another acft that had…NTSB ATL83FA267Accident · Minor injuriesField investigationFinal reportCessna 172M · Sylvester, GAThe pilot had accomplished two takeoffs and two full stop landings. The pilot stated that on the third takeoff RPM was lost about the time for liftoff. He elected to abort the takeoff about halfway down the runway. When he pulled the power/throttle back to…NTSB ATL83LA319Accident · No injuriesLimited investigationFinal reportBeech 55 · Cornelia, GAThe acft collided with a grass-covered curbing at the edge of a taxiway as the pilot attempted to clear the rwy. At thisarpt the rwy is also used as a taxiway. While using the rwy to taxi for takeoff a radio call was heard reporting a landing acft so the…NTSB ATL83LA206Accident · No injuriesLimited investigationFinal reportSchweizer 1-26B · Senoia, GAAprx 2 hrs after takeoff, the glider plt ran out of lifting action & selected a hay field for a landing place. From the air, the field appeared to be a suitable landing area. However, after touchdown, the right wing encountered a clump of higher hay (aprx 3…