NTSB investigations: Cessna 172I, GA
6 cases on aircraft the registry lists as Cessna 172I. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1983 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1998 | 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 ('2072426'))
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 ('2072426'))
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 MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Cummings, GAthe pilot landed the airplane with a tailwind condition, too long and too fast for the runway conditions.NTSB ATL92LA051Accident · No injuriesLimited investigationFinal reportCessna 172I · Bainbridge, GAThe pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.NTSB ATL83LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, GAThe aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they…NTSB MIA72FKG27Accident · Serious injuriesClosedCessna 172I · Marietta, GANTSB MIA71DKG42Accident · No injuriesClosedCessna 172 · Twin City, GA