Skip to content

NTSB investigations: Cessna 172M, ID

24 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

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" = 'ID' 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

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\" = 'ID' 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" = 'ID' 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

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 WPR26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Nampa, IDThe pilot’s failure to verify that the seat locking pins were fully engaged before takeoff, which allowed the seat to slide aft during the takeoff roll and resulted in a loss of directional control.Feb 5, 2026 · N4464R · Substantial damage NTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.Jun 14, 2017 · N9912Q · Substantial damage NTSB WPR10CA323Accident · No injuriesData collectionFinal reportCessna 172M · Twin Falls, IDThe student pilot's improper landing flare.Jul 1, 2010 · N64427 · Substantial damage NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.Dec 24, 2009 · N1883V · Substantial damage NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.Jun 22, 2009 · N12463 · Substantial damage NTSB LAX08CA237Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe pilot's decision to take off in known adverse wind conditions that lead to an encounter with a windshear, the resulting inability of the pilot to maintain airspeed, and a stall/mush into the terrain.Jul 21, 2008 · N9912Q · Substantial damage NTSB SEA08CA126Accident · No injuriesData collectionFinal reportCessna 172M · Dixie, IDThe pilot's failure to maintain adequate clearance from the vegetation during takeoff.May 3, 2008 · N20406 · Substantial damage NTSB SEA04LA030Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Elk City, IDThe pilot's failure to maintain clearance from trees during a go-around. Factors include dark night conditions and trees.Dec 26, 2003 · N1363U · Substantial damage NTSB SEA03LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Idaho Falls, IDThe student pilot's failure to maintain proper runway alignment (centerline tracking) during a go around maneuver resulting in the aircraft impacting a runway light. Contributing factors were the gusty/crosswind conditions and the light fixture.Mar 17, 2003 · N64427 · Substantial damage NTSB SEA00LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Wallace, IDThe pilot's failure to maintain airspeed and his failure to maintain clearance from the trees. Related factors were trees and mountainous terrain.Jun 22, 2000 · N9895V · Substantial damage NTSB SEA00LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Mackay, IDThe pilot's failure to land at the proper touchdown point. Factors include a wind gust, a grass runway, and a drop-off into rough terrain at the end of the runway.Oct 28, 1999 · N12376 · Substantial damage NTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…Jul 20, 1997 · N1418U · Substantial damage NTSB SEA96LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Nez Perce, IDthe pilot's improper in-flight decision to turn up a canyon, which the aircraft was unable to out-climb. Factors relating to the accident were: high ambient temperature, high density altitude, blind/box canyon, and trees in the area where the aircraft's climb…Jul 26, 1996 · N61842 · Substantial damage NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.Sep 7, 1994 · N61838 · Substantial damage NTSB SEA94LA133Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Lookout Pass, IDPoor in-flight planning. Factors include cloudy weather.May 29, 1994 · N30608 · Destroyed NTSB SEA93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yellow Pine, IDThe pilot's improperly planned approach and delayed remedial action. A factor related to the accident was: the proximity of mountainous terrain.Aug 2, 1993 · N9554H · Substantial damage NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.Sep 9, 1990 · N9895V · Substantial damage NTSB SEA87LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corral, IDThe plt was scouting for elk in rugged rising terrain. The eng began losing power, so he applied carburetor heat. However, the RPM dropped further & the acft crashed on wooded terrain. No mechanical difficulties were found. County authorities stated that…Nov 12, 1986 · N12870 · Substantial damage NTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…Apr 28, 1986 · N3580Q · Substantial damage NTSB SEA85LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Couer D'Alene, IDThe eng lost power after carb heat was applied & the throttle was retarded on base leg. Subsequently, the acft nosed over during a forced landing on freshly plowed ground short of the rwy. No preimpact part failure or malfunction was found during the…May 17, 1985 · N13403 · Substantial damage NTSB SEA79DYP01Accident · Minor injuriesClosedCessna 172 · Elk City, IDOct 29, 1978 · N1557V · Substantial damage NTSB SEA78DYP45Accident · No injuriesClosedCessna 172 · St.Maries, IDJul 24, 1978 · N13403 · Substantial damage NTSB SEA78DYP40Accident · No injuriesClosedCessna 188 · Tilma, IDJul 17, 1978 · N80770 · Substantial damage NTSB SEA77DYA11Accident · Minor injuriesClosedCessna 172 · Boise, IDFeb 20, 1977 · N80691 · Substantial damage