NTSB investigations: Cessna 172K, OR

14 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

NTSB investigations: Cessna 172K, OR per year, 1970–2026: 14 cases
1970	1
1972	2
1973	1
1974	1
1981	1
1984	1
1991	1
1993	1
1995	1
2000	1
2001	1
2008	1
2017	1

Where

Open the map

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 GAA17CA373Accident · No injuriesData collectionFinal reportCessna 172 · Roseburg, ORAn in-flight collision with a bird during the approach.Jun 25, 2017 · N79938 · Substantial damage NTSB LAX08FA256Accident · 5 fatalField investigationFinal reportCessna 172K · Gearhart, ORThe pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.Aug 4, 2008 · N828CC · Destroyed NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.Jan 7, 2001 · N78284 · Substantial damage NTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.Sep 28, 2000 · N84034 · Substantial damage NTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.Dec 17, 1995 · N143JP · Substantial damage NTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.Oct 22, 1993 · N79405 · Destroyed NTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.Aug 28, 1991 · N6LG · Substantial damage NTSB SEA84LA128Accident · No injuriesLimited investigationFinal reportCessna 172K · Pendleton, ORThe plt said he initiated his takeoff on rwy 25 with the wind from 220 deg at 35 gusting 42 KTS. Just after lifting off, at about 10 ft AGL, the stall warning horn sounded & the plt noticed that the airspeed had dropped to about 45 mph. The acft then drifted…Jun 7, 1984 · N84153 · Substantial damage NTSB SEA82DYM01Accident · No injuriesClosedCessna 172 · Long Creek, ORNov 8, 1981 · N7244G · Destroyed NTSB SEA74AS039Accident · 4 fatalClosedCessna 172K · Gold Beach, ORApr 28, 1974 · N79141 · Destroyed NTSB SEA73DYC39Accident · Minor injuriesClosedCessna 150G · Brightwood, ORJun 23, 1973 · N84685 · Destroyed NTSB SEA72FYI22Accident · No injuriesClosedCessna 172 · Klamath Flls, ORMay 11, 1972 · N84271 · Substantial damage NTSB SEA72DYI12Accident · Minor injuriesClosedCessna 172 · Deschutes, ORJan 10, 1972 · N78672 · Substantial damage NTSB SEA71AS011Accident · 1 fatalClosedCessna 172 · Agness, ORAug 26, 1970 · N79511 · Destroyed