NTSB investigations: Cessna 172I, IL
16 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
| 1968 | 1 |
|---|---|
| 1969 | 4 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1981 | 2 |
| 1988 | 1 |
| 1998 | 1 |
| 2009 | 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 ('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" = '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 ('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 CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB CHI99LA028Accident · No injuriesLimited investigationFinal reportCessna 172I · Jacksonville, ILthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the student's lack of experience and the road which the airplane contacted.NTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.NTSB CHI81FEV33Accident · No injuriesClosedCessna 172I · Danville, ILNTSB CHI81DEE27Accident · No injuriesClosedCessna 172 · Rock Falls, ILNTSB CHI76FEE51Accident · No injuriesClosedCessna 172I · Ransom, ILNTSB CHI74FEE78Accident · No injuriesClosedCessna 172 · Rochelle, ILNTSB CHI73DEV27Accident · No injuriesClosedCessna 172I · Danville, ILNTSB CHI72DEE63Accident · No injuriesClosedCessna 172I · Kirkland, ILNTSB CHI71FCA06Accident · Minor injuriesClosedCessna 172I · Bethalto, ILNTSB CHI71FBQ36Accident · No injuriesClosedCessna 172 · Manito, ILNTSB CHI70F0364Accident · No injuriesClosedCessna 150G · Cahokia, ILNTSB CHI70A0006Accident · 3 fatalClosedCessna 172I · Barrington, ILNTSB CHI70F0210Accident · Serious injuriesClosedCessna 172I · Northbrook, ILNTSB CHI70D0003Accident · No injuriesClosedCessna 172 · Collinsville, ILNTSB CHI69F0078Accident · Minor injuriesClosedCessna 172I · Lombard, IL