NTSB investigations: Cessna 172K, GA
13 cases on aircraft the registry lists as Cessna 172K. 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
| 1971 | 3 |
|---|---|
| 1972 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2018 | 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 ('2072430'))
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 ('2072430'))
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 GAA19CA020Accident · No injuriesData collectionFinal reportCessna 172 · Lawrenceville, GAThe student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.NTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…NTSB ATL86LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Stone Mountain, GAShortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…NTSB ATL83FA238Accident · 1 fatalField investigationFinal reportCessna 172K · Millhaven, GAThe plt & his son took off at night to participate in the search for a downed acft. Subsequently, they found the burning wreckage of the downed plane. They saw people moving around the accident scene & made a pass over it by diving with the landing light on.…NTSB MIA79FKG10Accident · No injuriesClosedCessna 172 · Chamblee, GANTSB MIA72KHD12Accident · No injuriesClosedCessna 172K · Jonesboro, GANTSB MIA72AM011Accident · 1 fatalClosedCessna 172K · Atlanta, GANTSB MIA71DKG72Accident · No injuriesClosedCessna 172 · Lithonia, GANTSB MIA71FKG57Accident · Serious injuriesClosedCessna 172 · Statesboro, GA