Skip to content

NTSB investigations: Cessna 172K, WA

26 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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR14CA125Accident · No injuriesData collectionFinal reportCessna 172K · Eastsound, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing in gusty wind conditions.Feb 4, 2014 · N78330 · Substantial damage NTSB SEA02LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Clarkston, WAThe pilot's failure to maintain control of the aircraft during taxi along the gravel landing site after having landed off the designated runway. A contributing factor was the embankment which the aircraft's left wing impacted during taxi.Jun 13, 2002 · N84840 · Substantial damage NTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.Jul 18, 1994 · N7417G · Substantial damage NTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.Jun 3, 1990 · N79931 · Destroyed NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.Sep 26, 1989 · N84152 · Substantial damage NTSB SEA88LA144Accident · No injuriesLimited investigationFinal reportCessna 172K · Moses Lake, WAWhile on his first x-country flt in this type aircraft, the pilot decided to land short of the destination due to low fuel. The engine quit from fuel exhaustion during descent. The aircraft nosed over on touchdown in a soft irrigated field one mile from the…Aug 5, 1988 · N84445 · Substantial damage NTSB SEA88LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Monroe, WAThe pilot reported that he encountered a downdraft on final. He added power for a go-around; however, a wingtip struck the ground. The aircraft cartwheeled and came to rest to the left of the runway.Jul 26, 1988 · N46692 · Substantial damage NTSB SEA85LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Spanaway, WAThe plt was attempting to better align the acft for final apch when a tree was struck with the right wing. The plt stated she was distracted while making preparations to land. The landing was continued without incident.Feb 17, 1985 · N84578 · Substantial damage NTSB SEA80DYE28Accident · Minor injuriesClosedCessna 172 · Concrete, WAApr 12, 1980 · N79242 · Destroyed NTSB SEA79FYP40Accident · No injuriesClosedCessna 172K · Deer Park, WAAug 13, 1979 · N46652 · Substantial damage NTSB SEA78DYP42Accident · No injuriesClosedCessna 172 · Chewelah, WAJul 28, 1978 · N84679 · Substantial damage NTSB SEA78DYP36Accident · No injuriesClosedCessna 172 · Cheney, WAJun 17, 1978 · N79026 · Substantial damage NTSB SEA78FYE21Accident · Minor injuriesClosedCessna 172 · Port Townsend, WAApr 30, 1978 · N7222G · Substantial damage NTSB SEA77FA052Accident · 3 fatalClosedCessna 172K · Skykomish, WASep 16, 1977 · N78597 · Destroyed NTSB SEA77DYM58Accident · Minor injuriesClosedCessna 172K · Orchard, WAAug 19, 1977 · N79931 · Substantial damage NTSB SEA77FYP14Accident · No injuriesClosedCessna 172K · Mead, WADec 11, 1976 · N7089G · Substantial damage NTSB SEA77FYE01Accident · No injuriesClosedCessna 172 · Lummi Island, WANov 5, 1976 · N84647 · Substantial damage NTSB SEA74DYE50Accident · No injuriesClosedCessna 172 · Burlington, WAJun 30, 1974 · N79931 · Substantial damage NTSB SEA74DYE34Accident · No injuriesClosedCessna 172 · Holly, WAJan 13, 1974 · N7234G · Substantial damage NTSB SEA72AS056Accident · No injuriesClosedCessna 172K · Anacortes, WAJun 24, 1972 · N78634 · Substantial damage NTSB SEA72FYG20Accident · No injuriesClosedCessna 172K · Spokane, WANov 14, 1971 · N84034 · Substantial damage NTSB SEA71DWD15Accident · No injuriesClosedCessna 172 · Kenmore, WASep 27, 1970 · N7234G · Substantial damage NTSB SEA71FWG21Accident · No injuriesClosedCessna 172K · Moses Lake, WASep 22, 1970 · N84153 · Substantial damage NTSB SEA71AS008Accident · 3 fatalClosedCessna 172K · Anacortes, WAAug 6, 1970 · N79594 · Destroyed NTSB SEA71AS006Accident · 4 fatalClosedCessna 172K · Westport, WAJul 31, 1970 · N84845 · Destroyed NTSB SEA70FWD19Accident · No injuriesClosedCessna 172 · Puyallup, WAJun 8, 1970 · N46382 · Substantial damage