NTSB investigations: Cessna 172G, IL
22 cases on aircraft the registry lists as Cessna 172G. 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
| 1965 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 6 |
| 1968 | 2 |
| 1969 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'IL' 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 ('2072420'))
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" = 'IL' 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 ('2072420'))
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 CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB CHI97LA298Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Chicago, ILthe pilot's selection of the wrong taxi route (service road) and not maintaining clearance between his airplane's wing and a bus.NTSB CHI90LA037Accident · No injuriesLimited investigationFinal reportCessna 172G · Savoy, ILImproper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.NTSB CHI82DA118Accident · No injuriesFinal reportCessna 172 · Marion, ILThe pilot reported that the wind was from 200 degrees at 22 gusting 30 knots. While taxiing eastbound from the runway, a gust of wind lifted the right wing and tail, and the aircraft nosed over.NTSB CHI79FA078Accident · 2 fatalClosedCessna 172G · Brownstown, ILNTSB CHI76FEV01Accident · No injuriesClosedCessna 172G · Bloomington, ILNTSB CHI72AC071Accident · 3 fatalClosedCessna 172G · Orion, ILNTSB CHI71FBQ21Accident · No injuriesClosedCessna 172 · Manito, ILNTSB CHI69D0649Accident · No injuriesClosedCessna 172 · East St.Louis, ILNTSB CHI69D0523Accident · No injuriesClosedCessna 172 · Lisle, ILNTSB CHI68D0733Accident · No injuriesClosedCessna 172 · Ottawa, ILNTSB CHI68F0681Accident · No injuriesClosedCessna 172 · Peoria, ILNTSB CHI68F0185Accident · Minor injuriesClosedCessna 172G · Greenwood, ILNTSB CHI68F0219Accident · Minor injuriesClosedCessna 172 · Lexington, ILNTSB CHI68D0060Accident · No injuriesClosedCessna 172 · Northbrook, ILNTSB CHI68F0127Accident · Minor injuriesClosedCessna 172G · Polo, ILNTSB CHI67F0609Accident · No injuriesClosedCessna 172 · Ottawa, ILNTSB CHI67D0584Accident · No injuriesClosedCessna 172G · Cahokia, ILNTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILNTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILNTSB CHI67F0056Accident · No injuriesClosedCessna 172G · Columbia, ILNTSB CHI66F0511Accident · No injuriesClosedCessna 172G · Streator, IL