NTSB investigations: Cessna 172M, GA
35 cases on aircraft the registry lists as Cessna 172M. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1973 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 1 |
| 1980 | 2 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2006 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2022 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA23LA043Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Roberta, GAThe pilot’s failure to maintain a stabilized approach speed on landing, which resulted in a runway excursion and collision with logs.NTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.NTSB GAA16CA483Accident · No injuriesData collectionFinal reportCessna 172 · Covington, GAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA273Accident · No injuriesData collectionFinal reportCessna 172M · Suchez, GAThe failure of the pilot to initiate a go-around and his excessive airspeed on the final landing approach.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.NTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.NTSB ATL06CA065Accident · No injuriesData collectionFinal reportCessna 172 M · Griffin, GAThe pilot's failure to achieve the proper touchdown point, which resulted in an overrun of the runway, collision with an embankment, and subsequent nose over.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.NTSB ATL03LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot misjudged the landing distance, landed with excessive airspeed, did not attempt a go-around resulting in the airplane going off the overrun, and colliding with trees.NTSB ATL02LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Dahlonega, GAThe pilot's improper recovery from a bounced landing and failure to maintain directional control resulting in the airplane going off the left side of the runway and colliding with a ditch.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 ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB ATL97LA076Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, GAthe pilot misjudged his distance/airspeed during the approach to land, and touched down long on the runway.NTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.NTSB ATL90FA105Accident · 1 fatalField investigationFinal reportCessna 172M · Jonesboro, GAPilot-in-command's inadequate preflight and inflight planning, and his delayed climb after execution of a go-around. Contributing factors were his misreading of airfield wind information, his improper utilization of the flaps during climbout, his failure to…NTSB ATL89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Griffin, GAAfter a preflight and runup the pilot made a takeoff and remained in closed traffic for landing practice. On downwind, opposite the desired point of touchdown, he retarded power, applied carb heat and slowed the airplane. Turning base, the acft lost power.…NTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…NTSB ATL87LA238Accident · No injuriesLimited investigationFinal reportCessna 172M · Marietta, GAThe student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,…NTSB ATL86LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Monroe, GAThe plt departed cox sky ranch for a flt to stone mt, GA. When he could not receive norcross VOR, he stated that he thought he was having nav radio problems and elected to land at Monroe, GA. Prior to landing he noted the right fuel gauge reading almost empty…NTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.NTSB 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 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 ATL85LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Griffin, GAThe acft ran off the side of the rwy during landing. The plt planned to do touch and go landings. On the 1st landing theacft veered to the right and rolled off the rwy. The plt added power but the acft went into a ditch. The student plts logbook was not…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 ATL83FLA01Accident · 2 fatalFinal reportCessna 172M · 9nm Nw Quitman, GAWitnesses observed the acft a little above the tree tops prior to colliding with a high voltage tension wire. The two passengers (ages 10 & 11) were seated in the right front seat, both using the same seat belt. The surviving passenger stated they had…NTSB ATL82DA248Accident · Minor injuriesFinal reportCessna 172M · Perry, GAThe student pilot departed Perry, GA on a solo cross-country flight to augusta and jessup, GA. He was expected to return to Perry at about 1600 EDT. The flight progressed uneventfully to jessup where it was delayed by a thunderstorm. After departing jessup,…NTSB ATL82FLA03Accident · 2 fatalFinal reportCessna 172M · Thomasville, GAThe aircraft was being operated on a business flight for the purpose of surveying farm crops in the area. At about 1700 EDT, it crashed into a 20 acre farm lake while on a westerly heading. The weather was reported as clear, visibility 6 to 7 miles with haze,…NTSB ATL80FA090Accident · 1 fatalClosedCessna 172 · Milledgeville, GANTSB MIA80DLA39Accident · No injuriesClosedCessna 172 · Folkston, GANTSB MIA78FA051Accident · 2 fatalClosedCessna 172M · Griffing, GANTSB MIA76DKG81Accident · No injuriesClosedCessna 172 · Chauncey, GANTSB MIA76AM086Accident · 2 fatalClosedCessna 172M · Lavonia, GANTSB MIA74DKG07Accident · No injuriesClosedCessna 172 · St.Simons Isle, GA