NTSB investigations: Cessna 172D, GA
11 cases on aircraft the registry lists as Cessna 172D. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1969 | 1 |
| 1971 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1996 | 2 |
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 ('2072410'))
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 ('2072410'))
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 MIA96LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Vilarica, GAThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.NTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ATL89LA083Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Cumming, GAThe pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.NTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…NTSB MIA71FKG97Accident · Minor injuriesClosedCessna 172D · Folkston, GANTSB MIA71DKG95Accident · No injuriesClosedCessna 172 · Dublin, GANTSB MIA69F0478Accident · No injuriesClosedCessna 172 · Cartersville, GANTSB MIA66D0514Accident · No injuriesClosedCessna 172 · Chamblee, GANTSB MIA66F0509Accident · Minor injuriesClosedCessna 172 · Athens, GANTSB MIA66F0020Accident · Serious injuriesClosedCessna 172D · Cumming, GANTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GA