NTSB investigations: Cessna 172P, AK
18 cases on aircraft the registry lists as Cessna 172P. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2016 | 2 |
| 2021 | 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\" = '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 ('2072436'))
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 ('2072436'))
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 ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB ANC21FA065Accident · 2 fatalClass 3 · FieldFinal reportCessna 172P · Eagle River, AKAn inflight collision with terrain under unknown circumstances. Contributing to the delayed rescue response was the failure of the emergency locator transmitter (ELT) to activate as designed, and the mechanic’s failure to ensure the correct ELT was installed…NTSB GAA16CA487Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe airplane’s encounter with a developing sink hole during taxi on the ramp area.NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB ANC10CA063Accident · No injuriesData collectionFinal reportCessna 172P · New Stuyahok, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a collision with trees.NTSB ANC03LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Seldovia, AKThe failure of company maintenance personnel to properly maintain the airplane's brake system, which resulted in a loss of the right brake during landing roll due to a chafed brake line.NTSB ANC01LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Anchorage, AKThe pilot's selection of an unsuitable taxi area during taxi. A factor associated with the accident was a tree.NTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.NTSB ANC93LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Black Rapids, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factor was the rough, uneven terrain.NTSB ANC91FA132Accident · 3 fatalField investigationFinal reportCessna 172 · Eklutna Lake, AKThe pilot's failure to maintain terrain clearance. Contributing to the accident was the high terrain.NTSB ANC91LA025Accident · No injuriesLimited investigationFinal reportCessna 172-P · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the terrain (snowbank).NTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.NTSB ANC87LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Chena Hot Sprgs, AKThe pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop.NTSB ANC85IA172Incident · No injuriesIncident investigationFinal reportCessna C-172P · Scammon Bay, AKThe pilot elected to takeoff from the taxiway because it aligned into the wind. After takeoff and accelerating to climb airspeed, the airplane's controls felt mushy and the pilot elected to land on the road/taxiway. Prior to touchdown, a gust of wind forced…NTSB ANC85LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe acft sustained substantial damage when the pilot lost control of the acft and nosed over on its back. The weather was VMC but the pilot said he encountered a gust and crosswind during landing.NTSB ANC85LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Nightmute, AKThe plt stated that shortly after takeoff, he lost control of the acft. Subsequently, the acft crashed & was substantially damaged. The plt reported that the wind was from 290 deg at 25 gusting 35 KTS.NTSB ANC83LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinley Park, AKThe plt stated that he was unable to locate the windsock. While on final for rwy 16 'things' did not feel right, but he continued into a long, fast tailwind landing. As he neared the end of the rwy he deliberately groundlooped the acft to avoid going over a…NTSB ANC82DAG46Accident · No injuriesFinal reportCessna 172 · Quinhagak, AKThe pilot reported that he landed on a gravel bar about 900 ft long with a passenger to go fishing. Later, he took off to the west with a slight head wind. Near the end of the gravel bar was a tree with branches sticking out of the water. As the pilot took…