Skip to content

NTSB investigations: Cessna 172, OR

21 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

19652026

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" = '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 ('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\" = '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 ('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" = '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 ('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 WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…Aug 28, 2019 · N4108F · Destroyed NTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.Jun 23, 2012 · N5781A · Substantial damage NTSB SEA06LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Gleneden Beach, ORThe pilot's failure to maintain clearance from objects while maneuvering over the airport environment. Dark night conditions, trees, and ground fog were factors.Oct 21, 2005 · N6000A · Substantial damage NTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.Jul 31, 1998 · N835T · Substantial damage NTSB SEA91FA059Accident · 1 fatalField investigationFinal reportCessna 172 · Oregon City, ORThe pilot's failure to attain proper airspeed before takeoff. Factors relating to the accident were the binding brake, the uphill grass airstrip, the tail wind weather conditions, and the improper annual inspection that was just completed on the aircraft.Feb 28, 1991 · N7119T · Destroyed NTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…May 29, 1987 · N4173F · Substantial damage NTSB SEA86LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172 · North Bend, ORThe plt reported having difficulty finding the tie down ramp area at the unfamiliar arpt in dusk light conditions. The passenger exited the acft with a flashlight to locate a tie down spot and walked into the spinning prop. The plt stated the passenger was…Oct 29, 1985 · N8316B · No damage NTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…Jan 24, 1982 · N8172B · Destroyed NTSB SEA78DYM18Accident · Minor injuriesClosedCessna 172 · Brooks, ORMar 5, 1978 · N5704A · Substantial damage NTSB SEA77DYM45Accident · No injuriesClosedCessna 172 · Madras, ORJul 12, 1977 · N6414E · Substantial damage NTSB SEA77FA029Accident · 2 fatalClosedCessna 172N · Newberg, ORMay 1, 1977 · N733VP · Destroyed NTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNov 9, 1976 · N5789A · Destroyed NTSB SEA76FYC62Accident · Serious injuriesClosedCessna 172M · Albany, ORJul 5, 1976 · N1381U · Substantial damage NTSB SEA76A5043Accident · 1 fatalClosedCessna 172 · Sweet Home, ORApr 10, 1976 · N7075T · Destroyed NTSB SEA72DYI21Accident · Minor injuriesClosedCessna 172K · North Bend, ORApr 25, 1972 · N84196 · Destroyed NTSB SEA70DVQ08Accident · No injuriesClosedCessna 172 · Creswell, ORMay 23, 1970 · N7358A · Substantial damage NTSB SEA69D0162Accident · No injuriesClosedCessna 172 · Tillamook, OROct 8, 1968 · N7100T · Substantial damage NTSB SEA69D0132Accident · Minor injuriesClosedCessna 172 · Lakeview, ORSep 29, 1968 · N6352E · Substantial damage NTSB SEA68A0027Accident · 1 fatalClosedCessna 172 · Portland, ORSep 16, 1967 · N5907A · Destroyed NTSB SEA67D0289Accident · No injuriesClosedCessna 172 · Shady Grove, ORMar 20, 1967 · N8185B · Substantial damage NTSB SEA65F0051Accident · Serious injuriesClosedCessna 172 · Newberg, ORApr 20, 1965 · N7140T · Destroyed