NTSB investigations: Cessna 172H, AK
14 cases on aircraft the registry lists as Cessna 172H. 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 | 3 |
|---|---|
| 1970 | 1 |
| 1972 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2025 | 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\" = 'AK' 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 ('2072424'))
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" = 'AK' 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 ('2072424'))
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 ANC25LA056Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Manokotak, AKThe pilot’s decision to land on an unsuitable landing surface with a tailwind, which resulted in a nose over. Contributing was the pilot’s failure to recognize the wind direction, resulting in a tailwind landing.NTSB ANC22LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Chugiak, AKThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.NTSB ANC19LA006Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain airplane control during the landing flare, which resulted in the wing striking the runway. Contributing to the accident was a partial loss of engine power, which resulted from fuel contamination.NTSB ANC10CA015Accident · No injuriesData collectionFinal reportCessna 172H · Nightmute, AKThe pilot's failure to maintain control of the airplane in a strong gusting wind, and his decision to taxi for takeoff in such conditions.NTSB ANC04LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to abort the takeoff, which resulted in an in-flight collision with a stump, and subsequent loss of control. Factors associated with the accident were snow-covered terrain and a…NTSB ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…NTSB ANC89LA159Accident · No injuriesLimited investigationFinal reportCessna 172H · Sparrevohn, AKThe bucket which was blown into the flight path by a crosswind.NTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…NTSB ANC73DAG47Accident · No injuriesClosedCessna 172 · Kenai, AKNTSB ANC73DAG10Accident · No injuriesClosedCessna 172H · Palmer, AKNTSB ANC70DAG09Accident · No injuriesClosedCessna 172 · Anchorage, AKNTSB ANC69D0054Accident · No injuriesClosedCessna 172H · Shungnak, AKNTSB ANC69F0019Accident · No injuriesClosedCessna 172H · Ft Wainwrght, AKNTSB ANC69F0015Accident · No injuriesClosedCessna 172G · Skwenta, AK