NTSB investigations: Cessna 172, MT
18 cases on aircraft the registry lists as Cessna 172. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 3 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2008 | 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\" = 'MT' 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 ('2072402'))
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" = 'MT' 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 ('2072402'))
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 SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB SEA02LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · W. Yellowstone, MTThe pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.NTSB SEA02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lindsay, MTThe pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.NTSB SEA91FA046Accident · 2 fatalField investigationFinal reportCessna C-172 · Colstrip, MTThe pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…NTSB DEN85LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Opheim, MTThe plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged.NTSB DEN81DTI13Accident · No injuriesClosedCessna 172 · Schafers Mdws, MTNTSB SEA77FTI02Accident · No injuriesClosedCessna 172 · Whitefish, MTNTSB SEA74DTI26Accident · No injuriesClosedCessna 172 · Swan Lake, MTNTSB SEA72FTI11Accident · No injuriesClosedCessna 172 · Kalispell, MTNTSB SEA68D0209Accident · No injuriesClosedCessna 172 · Wolf Point, MTNTSB SEA67A0068Accident · 2 fatalClosedCessna 172 · Helmville, MTNTSB SEA67F0271Accident · Serious injuriesClosedCessna 172 · Bridger, MTNTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNTSB SEA66D0290Accident · No injuriesClosedCessna 172 · Camas Prairi, MTNTSB SEA66D0265Accident · No injuriesClosedCessna 172 · Havre, MTNTSB SEA66D0041Accident · No injuriesClosedCessna 172 · Knobs, MTNTSB UNK65X0737Accident · No injuriesClosedCessna 172 · Ashland, MTNTSB UNK64X0501Accident · No injuriesClosedCessna 172 · Anaconda, MT