NTSB investigations: Cessna 172A, GA
14 cases on aircraft the registry lists as Cessna 172A. 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 | 2 |
| 1967 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 2021 | 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 ('2072404'))
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 ('2072404'))
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 ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlNTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.NTSB ATL90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Villa Rica, GAFuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.NTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…NTSB ATL80DKG25Accident · No injuriesClosedCessna 172A · Athens, GANTSB MIA76AM088Accident · 1 fatalClosedCessna 172A · Milledgeville, GANTSB MIA74AM059Accident · 3 fatalClosedCessna 172A · Jackson, GANTSB MIA73FKG05Accident · No injuriesClosedCessna 172A · Rome, GANTSB MIA70FKG21Accident · No injuriesClosedCessna 172 · Atlanta, GANTSB MIA70DKG23Accident · No injuriesClosedCessna 172 · St Marys, GANTSB MIA67D0557Accident · No injuriesClosedCessna 172 · Savannah, GANTSB MIA66F0381Accident · Serious injuriesClosedCessna 172 · Baxley, GANTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GANTSB UNK64X3524Accident · 1 fatalClosedCessna 172 · Macon, GA