NTSB investigations: Cessna 172H, GA
19 cases on aircraft the registry lists as Cessna 172H. 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
| 1967 | 1 |
|---|---|
| 1971 | 2 |
| 1972 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 2000 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2020 | 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 ('2072424'))
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 ('2072424'))
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 ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA20FA068Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newborn, GAThe pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane.NTSB ATL06LA099Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Ringgold, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation resulting in a forced landing, and collision with trees and the ground.NTSB ATL06CA033Accident · No injuriesData collectionFinal reportCessna 172H · Waycross, GAThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing.NTSB ATL05CA074Accident · No injuriesData collectionFinal reportCessna 172H · Oakwood, GALoss of engine power due to fuel system contamination.NTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB ATL94FA036Accident · Serious injuriesField investigationFinal reportCessna 172H · Perry, GAThe pilot's inadequate aircraft preflight inspection, in that he did not remove the flight control gust lock prior to the flight. A factor was the use of an unapproved, unmarked rivet as a flight control lock.NTSB ATL93LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's failure to attain the proper touchdown point, and his improper recovery from a bounced landing. A factor was the pilot's lack of total experience in the airplane.NTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.NTSB ATL85LA116Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, GAAcft slipped on final due to being high. Landed hard and bounced. On second touchdown rudder was still applied and acft veered off runway colliding with ditch bank.NTSB MIA79FKG70Accident · No injuriesClosedCessna 172M · Atlanta, GANTSB MIA78FKG29Accident · Serious injuriesClosedCessna 172 · Sparta, GANTSB MIA75DKG26Accident · No injuriesClosedCessna 172 · Jonesboro, GANTSB MIA72DKG87Accident · No injuriesClosedCessna 172 · Carrollton, GANTSB MIA72FKG74Accident · No injuriesClosedCessna 172H · Ephesus, GANTSB MIA72DKG61Accident · Minor injuriesClosedCessna 172H · Athens, GANTSB MIA72AM034Accident · 1 fatalClosedCessna 172H · Fitzgerald, GANTSB MIA68F0343Accident · Serious injuriesClosedCessna 172 · Lithonia, GA