NTSB investigations: Cessna 172D, IL
10 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1976 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 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 ('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" = '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 ('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 CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.NTSB CHI93LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Galesburg, ILThe departing pilot's (N251NW) inadequate visual lookout while operating in VFR conditions at an uncontrolled airport. Factors related to the accident were: the departing pilot's diverted attention, and the arriving pilot's (N2632U) inadequate visual lookout.NTSB CHI93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Marshall, ILAn inadequate preflight inspection of the airplane by the pilot.NTSB CHI91LA230Accident · No injuriesLimited investigationFinal reportCessna 172 · Metropolis, ILMiscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.NTSB CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.NTSB CHI76FEE73Accident · No injuriesClosedCessna 172D · Savannah, ILNTSB CHI69D0358Accident · No injuriesClosedCessna 172 · Roselle, ILNTSB CHI67D0648Accident · No injuriesClosedCessna 172 · Plainville, ILNTSB CHI66D0566Accident · No injuriesClosedCessna 172 · Chicago, ILNTSB UNK64X0907Accident · No injuriesClosedCessna 172D · Greenwood, IL