NTSB investigations: Cessna 172G, IA
14 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
| 1966 | 3 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1983 | 1 |
| 1995 | 1 |
| 2006 | 1 |
| 2023 | 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\" = 'IA' 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" = 'IA' 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 CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CHI07CA025Accident · No injuriesData collectionFinal reportCessna 172G · Ankeny, IAThe pilot's improper decision to land on an unlighted runway at night, and her resulting failure to attain a proper touchdown point leading to the landing over run. Contributing factors were the night (low light) condition and the ditch encountered during the…NTSB CHI96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Nora Springs, IAthe pilot's inadequate preflight planning/preparation, which resulted in loss of airspeed and a stall/mush as he was maneuvering to avoid obstructions off the end of the runway. Factors relating to the accident were: the unfavorable wind condition, high…NTSB MKC83LA229Accident · No injuriesLimited investigationFinal reportCessna 172G · La Porte City, IAScattered rain showers in the area had just made the turf rwy wet. The pilot reported that as he turned off the rwy the acft skidded and went sideways into a ditch.NTSB MKC75DCD36Accident · No injuriesClosedCessna 172 · Wellman, IANTSB MKC74DCD03Accident · Minor injuriesClosedCessna 172 · Bedford, IANTSB MKC71AK044Accident · 1 fatalClosedCessna 172G · Marshalltown, IANTSB MKC70D0224Accident · No injuriesClosedCessna 172 · Missouri Val, IANTSB MKC69F0052Accident · Serious injuriesClosedCessna 172G · Des Moines, IANTSB MKC67D0570Accident · No injuriesClosedCessna 172 · Grimes, IANTSB MKC67D0478Accident · No injuriesClosedCessna 172 · Eldora, IANTSB MKC67A0036Accident · 2 fatalClosedCessna 172G · Elkhorn, IANTSB MKC67D0158Accident · No injuriesClosed172 · Dayton, IANTSB MKC66F0548Accident · Serious injuriesClosedCessna 172 · St Donatus, IA