NTSB investigations: Cessna 172M, OR
29 cases on aircraft the registry lists as Cessna 172M. 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.
Cases per year
| 1975 | 2 |
|---|---|
| 1976 | 3 |
| 1977 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072418'))
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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR21LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fields, ORThe pilot’s failure to maintain directional control during landing on a highway, which resulted in an impact with terrain and subsequent nose over.NTSB ANC19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Newport, ORThe pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB GAA16CA011Accident · No injuriesData collectionFinal reportCessna 172M · McMinnville, ORThe flight instructor's failure to correct the student pilot's approach path during the final approach, which resulted in a collision with runway threshold lights. Contributing to the accident was the student pilot's failure to attain and maintain the…NTSB SEA07CA116Accident · No injuriesData collectionFinal reportCessna 172M · Astoria, ORThe student pilot's failure to adequately correct for changing wind conditions, leading to a loss of directional control during the takeoff ground roll. Factors include wet, soft terrain along the side of the runway.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.NTSB SEA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · McMinnville, ORThe student pilot's failure to adequately compensate for wind conditions while doing a touch-and-go landing.NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB SEA94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Mckenzie Bridge, ORA partial loss of engine power for undetermined reasons.NTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB SEA90LA031Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe pilots inadequate visual lookout while taxiing. Factors related to the accident are: the pilot's diverted attention and the pole.NTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…NTSB SEA88FA023Accident · Serious injuriesField investigationFinal reportCessna 172M · Hillsboro, ORThe daily radio traffic reporting flight was cleared for an IFR departure from Hillsboro airport in IMC. The owner/ operator of the aircraft stated the company had a 'no ifr' policy. On takeoff witnesses observed the aircraft to be lower and slower than…NTSB SEA86LA244Accident · No injuriesLimited investigationFinal reportCessna 172 M · Red'S Horse Ran, ORThe pilot was attempting to depart an airstrip with a strong tail wind. 10 to 20 feet AGL the aircraft descended back onto the ground to the right of the airstrip, bounced, rolled through a wire fence and onto soft muddy terrain. The nose wheel dug into the…NTSB SEA85LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Mulino, ORThe plt pushed the throttle forward to add power during final approach and the engine ceased operating. A forced landing was made onto a cabbage patch and the nose gear sheared off. The acft then nosed over. Investigation revealed the throttle cable housing…NTSB SEA78FYM08Accident · Serious injuriesClosedCessna 172M · Forest Grove, ORNTSB SEA77FYK14Accident · No injuriesClosedCessna 172M · Days Creek, ORNTSB SEA77FA040Accident · 2 fatalClosedCessna 172 · Azalea, ORNTSB SEA76FYC53Accident · No injuriesClosedCessna 172 · Aurora, ORNTSB SEA76DYC46Accident · No injuriesClosedCessna 172M · Yamhill, ORNTSB SEA76DYA16Accident · No injuriesClosedCessna 172 · Ontario, ORNTSB SEA76DYC06Accident · No injuriesClosedCessna 172 · Sandy, ORNTSB SEA76FYC03Accident · No injuriesClosedCessna 172 · Seaside, OR