NTSB investigations: Cessna 172N, WY
12 cases on aircraft the registry lists as Cessna 172N. 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2004 | 2 |
| 2013 | 1 |
| 2018 | 1 |
| 2024 | 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\" = 'WY' 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 ('2072434'))
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" = 'WY' 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 ('2072434'))
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 WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.NTSB WPR18LA241Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Afton, WYThe pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.NTSB DEN04CA099Accident · No injuriesData collectionFinal reportCessna 172N · Laramie, WYfuel exhaustion due to the pilot's improper inflight decision not to stop and refuel. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…NTSB DEN82DA152Accident · No injuriesFinal reportCessna 172N · Lander, WYThe pilot reported that the aircraft suddenly veered to the right after he had slowed to about 30 to 35 KTS. An examination revealed that the nose gear fork had failed in two places. The breaks were just below the strut attachment point and directly accross…NTSB DEN80DTC06Accident · No injuriesClosedCessna 172N · Kemmerer, WY