Skip to content

NTSB investigations: Cessna 172K, AK

24 cases on aircraft the registry lists as Cessna 172K. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

Where

Latest cases

Query with SQL

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 ('2072430')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072430'))
  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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.Sep 15, 2012 · N84549 · Substantial damage NTSB ANC04LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakutat, AKThe pilot's selection of an unsuitable landing area, which resulted in the collapse of the landing gear, and subsequent nose over during the landing roll. A factor associated with the accident was soft terrain.Jul 8, 2004 · N172JL · Substantial damage NTSB ANC01LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Wasilla, AKThe pilot's delay in aborting the takeoff roll.Jul 15, 2001 · N78254 · Substantial damage NTSB ANC99LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheldon Point, AKThe pilot's inadequate compensation for the gusty crosswind conditions during takeoff. Factors associated with the accident were a crosswind, and wind gusts.Jul 29, 1999 · N79169 · Substantial damage NTSB ANC96LA112Accident · No injuriesLimited investigationFinal reportCessna 172K · Nikiski, AKThe pilot's inadequate compensation for wind conditions. A factor was the windshear.Aug 3, 1996 · N78108 · Substantial damage NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.Jun 24, 1995 · N84468 · Substantial damage NTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.Aug 18, 1994 · N78428 · Substantial damage NTSB ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.Jun 18, 1993 · N7300G · Substantial damage NTSB ANC92LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taylor Road, AKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were the gusting crosswinds and the pilot's lack of total experience in this type operation.Sep 30, 1992 · N79046 · Substantial damage NTSB ANC90FA053Accident · No injuriesField investigationFinal reportCessna 172-K · Anchorage, AKPilot-in-command used poor judgement when he elected to take off on rough & uneven frozen lake which resulted in a failed nose ski.Apr 12, 1990 · N46410 · Substantial damage NTSB ANC89LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Eureka Lodge, AKImproper planning/decision by the pilot. A contributing factor was the hump (uneven surface) on the runway.Aug 19, 1989 · N78254 · Substantial damage NTSB ANC87LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Beluga, AKThe pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back.Feb 1, 1987 · N79416 · Substantial damage NTSB ANC82DAG38Accident · Minor injuriesFinal reportCessna 172K · 44mi Nw Mccarth, AKShortly after liftoff from a short gravel strip the aircraft settled back onto the rough terrain and crashed.Aug 2, 1982 · N84345 · Substantial damage NTSB ANC82DA054Accident · Minor injuriesFinal reportCessna 172K · Kasilof, AKThe pilot made a landing approach over trees at the approach end of the runway. The runway sloped slightly downhill in the direction of landing. The pilot landed long, then elected to go around, and during the go-around, the left wing struck a tree.Jul 2, 1982 · N84211 · Substantial damage NTSB ANC79DAG82Accident · Minor injuriesClosedCessna 172 · Purkeypile, AKJul 29, 1979 · N7339G · Substantial damage NTSB ANC79FAG36Accident · Serious injuriesClosedCessna 172K · Wasilla, AKMar 10, 1979 · N79435 · Substantial damage NTSB ANC77DAH12Accident · No injuriesClosedCessna 172K · Glenallen, AKSep 2, 1977 · N46434 · Destroyed NTSB ANC75AAG60Accident · Serious injuriesClosedCessna 172 · Kodiak, AKDec 29, 1974 · N46348 · Substantial damage NTSB ANC75DAG19Accident · Serious injuriesClosedCessna 172 · Kodiak, AKAug 18, 1974 · N79188 · Destroyed NTSB ANC74FAH13Accident · No injuriesClosedCessna 172 · Anchorage, AKMay 30, 1974 · N46352 · Substantial damage NTSB ANC73DAG14Accident · Minor injuriesClosedCessna 172K · Delta Junct, AKAug 7, 1972 · N46348 · Substantial damage NTSB ANC72DAG97Accident · No injuriesClosedCessna 172K · King Salmon, AKFeb 29, 1972 · N78542 · Substantial damage NTSB ANC71DAG88Accident · No injuriesClosedCessna 172K · Kasilof, AKMay 23, 1971 · N7220G · Substantial damage NTSB ANC71DAG32Accident · Minor injuriesClosedCessna 172K · Port Alswrth, AKSep 28, 1970 · N46633 · Substantial damage