Skip to content

NTSB investigations: Cessna 172G, WA

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

19662026

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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.Jan 14, 2021 · N5930R · Substantial damage NTSB WPR19LA202Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Port Townsend, WAThe loss of engine power for reasons that could not be determined based on available information.Jul 21, 2019 · N3863L · Substantial damage NTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.May 14, 2018 · N4144L · Destroyed NTSB WPR10LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Mar 27, 2010 · N5880R · No damage NTSB SEA03LA049Accident · No injuriesLimited investigationFinal reportCessna 172G · Packwood, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.Mar 24, 2003 · N4150L · Substantial damage NTSB SEA99LA006Accident · No injuriesLimited investigationFinal reportCessna 172G · Vancouver, WARefueling was not preformed which subsequently led to fuel exhaustion. Factors include the student pilot's inadequate preflight planing/preparation.Oct 23, 1998 · N3765L · Substantial damage NTSB SEA96LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Kettle Falls, WAthe pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.Jul 25, 1996 · N4478L · Destroyed NTSB SEA94LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Paradise, WAProper altitude was not maintained and improper inflight planning/decision. Factors to the accident were mountainous/hilly terrain conditions and lack of total experience.Sep 5, 1994 · N4628L · Destroyed NTSB SEA91LA011Accident · No injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot poorly compensated for the wind condition.Oct 27, 1990 · N4174L · Substantial damage NTSB SEA89LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynden, WAThe pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…May 4, 1989 · N6064R · Substantial damage NTSB SEA82DYP06Accident · No injuriesClosedCessna 172G · Mattawa, WADec 2, 1981 · N5757R · Substantial damage NTSB SEA75FYE23Accident · No injuriesClosedCessna 172 · Seattle, WAOct 31, 1974 · N3763L · Substantial damage NTSB SEA75DYE22Accident · No injuriesClosedCessna 172 · Lummi Island, WAOct 26, 1974 · N3942L · Substantial damage NTSB SEA74DYE40Accident · No injuriesClosedCessna 172 · Olympia, WAMar 9, 1974 · N4681L · Substantial damage NTSB SEA74DYE38Accident · No injuriesClosedCessna 172 · Bellingham, WAFeb 24, 1974 · N4112L · Substantial damage NTSB SEA74DVE35Accident · Minor injuriesClosedCessna 172 · Bellingham, WAJan 2, 1974 · N1300T · Substantial damage NTSB SEA73FYE26Accident · Serious injuriesClosedCessna 172G · Bellevue, WAFeb 17, 1973 · N4126L · No damage NTSB SEA71AS029Accident · 1 fatalClosedCessna 172 · Reardan, WADec 19, 1970 · N4431L · Destroyed NTSB SEA70F0105Accident · No injuriesClosedCessna 172 · Auburn, WAOct 25, 1969 · N6064R · Substantial damage NTSB SEA69D0178Accident · No injuriesClosedCessna 172 · Shelton, WAJan 18, 1969 · N1165F · Substantial damage NTSB SEA68D0083Accident · No injuriesClosedCessna 172 · Vashon Is., WAJul 29, 1967 · N4618L · Substantial damage NTSB SEA67D0304Accident · Minor injuriesClosedCessna 172 · Zillah, WAMay 4, 1967 · N6019R · Substantial damage NTSB SEA67D0149Accident · No injuriesClosedCessna 172 · Puyallup, WASep 19, 1966 · N5757R · Substantial damage NTSB SEA67D0155Accident · No injuriesClosedCessna 172 · Snohomish, WASep 13, 1966 · N5789R · Substantial damage