NTSB investigations: Cessna 172N, GA
40 cases on aircraft the registry lists as Cessna 172N. 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
| 1980 | 2 |
|---|---|
| 1981 | 2 |
| 1982 | 3 |
| 1985 | 3 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2023 | 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 ('2072434'))
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 ('2072434'))
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 ERA23LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s loss of directional control while landing, which resulted in a runway excursion and collision with an airport sign.NTSB ERA21LA090Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Locust Grove, GAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB ERA10CA402Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe pilot's failure to maintain clearance from a pole while taxiing.NTSB NYC08CA110Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's inadequate compensation for wind conditions during landing. Contributing to the accident were the gusting winds.NTSB NYC08CA037Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe student pilot's failure to maintain a proper flare at touchdown.NTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB ATL04CA089Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe pilot's failure to establish a positive climb and his failure to maintain clearance during a go-around, which resulted in an in-flight collision with trees. A factor was the gusting winds.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 ATL03LA024Accident · No injuriesLimited investigationFinal reportCessna 172N · Cartersville, GAThe student pilot's failure to maintain directional control, during the landing roll resulted in the on ground collision with a ravine.NTSB MIA02LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, GAthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the left side of the runway, impacting with a gully and nosing over.NTSB MIA01LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, GAThe flight instructor's improper monitoring of the dual student during a simulated engine out approach and her delayed decision to initiate a go-around resulting in the airplane colliding with trees at the departure end of the runway during the go-around.NTSB ATL01LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Colquitt, GAThe student pilot's failure to use the fuel selector valve properly which resulted in fuel starvation and the subsequent loss of engine power, and the pilot's improper flare during landing.NTSB MIA00LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, GAThe pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.NTSB ATL98FA060Accident · 5 fatalField investigationFinal reportCessna 525 · Marietta, GAThe failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…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 MIA97LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAThe student pilot's failure to maintain directional control during a crosswind landing. The winds were a factor.NTSB ATL95LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Peachtree City, GAThe pilot's failure to maintain an adequate lookout while maneuvering on the ramp which resulted in his misjudging the clearance between his airplane and parked aircraft.NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.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 ATL90FA081Accident · 2 fatalField investigationFinal reportCessna 172N · Montezuma, GAThe failure of the pilot to maintain sufficient airspeed during the takeoff.NTSB ATL90LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ocilla, GAThe aircraft's encounter with low level windshear resulting in an uncontrollable descent.NTSB ATL90LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAInadequate visual lookout by the pilot (failure to see & avoid the obstruction). Contributing factors were the transmission (power) line and lack of visual cues (pilot's visual perception).NTSB ATL89LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrenceville, GAAfter 3 full stop landings, the pilot reported that the airplane would not accelerate to liftoff airspeed on 4th takeoff after rolling about 2000 feet. The pilot elected to abort the takeoff. The airplane rolled off the departure end of runway 07 and nosed…NTSB ATL88LA021Accident · No injuriesLimited investigationFinal reportCessna 172P · Swainsboro, GAThe acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…NTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…NTSB ATL87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Vidalia, GAThe plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed…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 ATL85LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monticello, GAAbout 20 min after takeoff, while cruising at 5000 ft, the plt observed oil on the windshield & noted a decrease in oil pressure. He turned back toward the departure arpt & reduced the power in an attempt to prolong eng life. A short time later, the eng began…NTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…NTSB ATL83LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Albany, GAThe pilot of N737LJ departed on a cross-country business trip with less than full fuel tanks. After flying about 2 hours the aircraft engine quit and the pilot made an emergency landing in an open field. The aircraft collided with trees at the edge of the…NTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…NTSB ATL82DA044Accident · No injuriesFinal reportCessna 172N · Cumberland Isla, GAThe 2500 ft runway had trees on 3 sides. The normal pattern for landing was from east to west and departures were normally from west to east. A long, shallow, tailwind approach was made from the east at about 65 knots. The pilot used 40 degrees of flaps and…NTSB ATL81FKG30Accident · No injuriesClosedCessna 172N · Lexington, GANTSB ATL81FA086Accident · Serious injuriesClosedLuscombe 8A · Tifton, GANTSB ATL80FKG24Accident · Serious injuriesClosedCessna 172N · Atlanta, GANTSB ATL80DLA12Accident · No injuriesClosedCessna 172 · Jekyll Island, GA