Skip to content

NTSB investigations: Cessna 172, WA

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

19642026

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 WPR25LA307Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Anacortes, WAOn September 22, 2025, about 1157 Pacific daylight time, a Cessna 172, N6831A, was substantially damaged when it was involved in an accident near Anacortes, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Sep 22, 2025 · N6831A · Substantial damage NTSB WPR25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Concrete, WAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.Jul 20, 2025 · N6964A · Substantial damage NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.Mar 31, 2011 · N7302A · Substantial damage NTSB LAX07CA254Accident · Minor injuriesData collectionFinal reportCessna 172 · Leavenworth, WAthe pilot's failure to maintain an adequate clearance from the trees.Aug 19, 2007 · N5967A · Substantial damage NTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.May 30, 2003 · N7301A · Substantial damage NTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.May 19, 2001 · N4053F · Substantial damage NTSB SEA95LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Mazama, WAThe pilot's failure to maintain adequate airspeed for the wind conditions during climbout. The gusty wind condition was a factor.Jul 23, 1995 · N8627B · Substantial damage NTSB SEA94FA154Accident · 1 fatalField investigationFinal reportCessna 172 · Port Angeles, WALack of oil and connecting rod failure. A factor to the accident was rough/uneven terrain.Jun 21, 1994 · N8025B · Destroyed NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.Jul 11, 1992 · N8348B · Substantial damage NTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…May 9, 1988 · N7090A · Substantial damage NTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…May 24, 1987 · N5711A · 2 aircraft · Destroyed NTSB SEA84LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Stewart Island, WAThe plt landed to the west on a wet grass strip with 1/4 inch of standing water. He said he had no traction & the acft slid off the end between 2 trees, damaging both wings. He also said the wind was 090 deg at 5 KTS gusting 15 KTS.May 25, 1984 · N4180F · Substantial damage NTSB SEA76FYE39Accident · Serious injuriesClosedCessna 172 · Martha Lake, WAMay 9, 1976 · N8597B · Substantial damage NTSB SEA75DYG19Accident · No injuriesClosedCessna 172 · Colville, WAFeb 2, 1975 · N7230A · Substantial damage NTSB SEA75FYG11Accident · No injuriesClosedCessna 172 · Richland, WANov 2, 1974 · N7143T · Substantial damage NTSB SEA73DYG26Accident · No injuriesClosedCessna 172 · Othello, WAApr 5, 1973 · N7021T · Substantial damage NTSB SEA73DYE30Accident · Serious injuriesClosedCessna 172 · Chehalis, WAApr 3, 1973 · N6718A · Substantial damage NTSB SEA72DYE20Accident · No injuriesClosedCessna 172 · Eastbound, WANov 8, 1971 · N8604B · Substantial damage NTSB SEA71FYG52Accident · No injuriesClosedCessna 172 · Electric Cty, WAMay 10, 1971 · N5741A · Substantial damage NTSB SEA71DYE30Accident · Minor injuriesClosedCessna 172 · Darrington, WAApr 25, 1971 · N4262F · Substantial damage NTSB SEA71DWD11Accident · Serious injuriesClosedCessna 172 · Federal Way, WAAug 23, 1970 · N6449B · Substantial damage NTSB SEA70DWD17Accident · No injuriesClosedCessna 172 · Oakville, WAMay 31, 1970 · N9180B · Substantial damage NTSB SEA70D0067Accident · No injuriesClosedCessna 172 · Electric Cty, WAAug 14, 1969 · N5741A · Substantial damage NTSB SEA69D0246Accident · No injuriesClosedCessna 172 · Waterville, WAApr 25, 1969 · N8602B · Substantial damage NTSB SEA69D0250Accident · No injuriesClosedCessna 172 · Maple Valley, WAApr 24, 1969 · N8295B · Substantial damage NTSB SEA69D0063Accident · No injuriesClosedCessna 172 · Yakima, WAJul 27, 1968 · N4134F · Substantial damage NTSB SEA69F0030Accident · No injuriesClosedCessna 172 · Renton, WAMay 24, 1968 · N6374E · Substantial damage NTSB SEA68A0060Accident · 4 fatalClosedCessna 172 · Puyallup, WAMar 24, 1968 · N6069A · 2 aircraft · Destroyed NTSB SEA68F0224Accident · Minor injuriesClosedCessna 172 · Castle Rock, WANov 12, 1967 · N7045T · Substantial damage NTSB SEA68F0160Accident · Serious injuriesClosedCessna 172 · Skykomish, WASep 5, 1967 · N8244U · Destroyed NTSB SEA68D0147Accident · No injuriesClosedCessna 172 · Snohomish, WAAug 27, 1967 · N5674A · Substantial damage NTSB SEA68F0151Accident · No injuriesClosedCessna 172 · Tumwater, WAAug 19, 1967 · N7027T · Destroyed NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB SEA66A0060Accident · 3 fatalClosedCessna 172 · Metaline Fls, WAMay 24, 1966 · N7230A · Substantial damage NTSB SEA67F0041Accident · Serious injuriesClosedCessna 172 · Ocean Shores, WAMay 8, 1966 · N5949A · Destroyed NTSB SEA66A0025Accident · 1 fatalClosedCessna 172 · Puyallup, WAOct 10, 1965 · N5724A · Destroyed NTSB UNK65X1265Accident · No injuriesClosedCessna 172 · Oses Lake, WAJan 10, 1965 · N4264F · Substantial damage NTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WAAug 19, 1964 · N7045T · Substantial damage NTSB UNK64X1702Accident · No injuriesClosedCessna 172 · Pe Ell, WAMay 10, 1964 · N8724B · Substantial damage NTSB UNK64X0483Accident · No injuriesClosedCessna 172 · Davenport, WAFeb 7, 1964 · N4264F · Substantial damage