Cessna 172M
NTSB investigations · 1,699
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.NTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.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.NTSB ERA09LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Sarasota, FLA loss of engine power for undetermined reasons.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB WPR09CA206Accident · No injuriesData collectionFinal reportCessna 172M · Corona, CAThe pilot's improper landing flare.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB ERA09CA061Accident · No injuriesData collectionFinal reportCessna 172 · Ft. Lauderdale, FLThe student pilot's improper flare during landing. Contributing to the accident was the student pilot's lack of experience.NTSB ANC09CA010Accident · No injuriesData collectionFinal reportCessna 172M · Girdwood, AKThe pilot's decision to attempt to take off on a snow-covered runway. Contributing to the accident was the snow-covered runway.NTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.NTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.NTSB LAX08LA240Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Bountiful, UTA partial loss of engine power for undetermined reasons.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.NTSB LAX08CA234Accident · No injuriesData collectionFinal reportCessna 172M · Leavenworth, WAThe pilot's inadequate preflight planning and failure to attain a sufficient airspeed to continue the takeoff. A contributing factor was the high density altitude and short runway.NTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.NTSB LAX08CA216Accident · No injuriesData collectionFinal reportCessna 172M · Skykomish, WAThe pilot's inadequate in-flight planning/decision and failure to execute a go-around when the airplane floated during the flare. Contributing to the accident was the short and wet turf runway surface, which reduced braking action.NTSB NYC08LA228Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toms River, NJThe failure of the pilot's seat to engage or remain engaged due to the improper inspection of the worn seat tracks.NTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB LAX08FA190Accident · 3 fatalField investigationFinal reportCessna 172M · Pahala, HIThe pilot's continued visual flight into instrument meteorological conditions and his failure to remain clear of rising terrain while deviating from his planned route of flight. Contributing to the accident were clouds and mountainous terrain.NTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.NTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.NTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.NTSB DFW08CA154Accident · No injuriesData collectionFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain clearance from an object while taxiing. Contributing to the accident were the pilot's diverted attention and a vehicle.NTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.NTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.NTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.NTSB SEA08CA126Accident · No injuriesData collectionFinal reportCessna 172M · Dixie, IDThe pilot's failure to maintain adequate clearance from the vegetation during takeoff.NTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.NTSB DFW08FA078Accident · 1 fatalField investigationFinal reportCessna 172M · Gun Barrel City, TXThe pilot's failure to avoid the transmission line. A contributing factor was the pilot's decision to perform a low-level maneuver.NTSB DEN08LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Pine Bluffs, WYThe pilot's failure to maintain control of the airplane. Contributing factors in this accident were the unfavorable wind and the snow bank.NTSB DFW08CA051Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot's failure to maintain aircraft control. A contributing factor was prevailing crosswind.NTSB CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.NTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.NTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB SEA07LA251Accident · No injuriesLimited investigationFinal reportCessna 172M · Thompson, UTThe pilot's failure to maintain terrain clearance while maneuvering in a box canyon.NTSB CHI07CA294Accident · No injuriesData collectionFinal reportCessna 172M · Pontiac, MIThe pilot's misjudgment of the landing flare and her improper recovery from the bounced landing.NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB LAX07CA169Accident · No injuriesData collectionFinal reportCessna 172M · St. George, UTthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.NTSB NYC07CA111Accident · Minor injuriesData collectionFinal reportCessna 172S · Montgomery, NYThe pilot's improper flare while landing, which resulted in a loss of directional control and collision with terrain.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 LAX07CA125Accident · Minor injuriesData collectionFinal reportCessna 172M · Stockton, CAThe loss of engine power due to fuel exhaustion resulting from the pilot's inaccurate fuel consumption calculations and failure to refuel while en route.NTSB DFW07CA046Accident · No injuriesData collectionFinal reportCessna 172M · Houston, TXThe pilot's failure to compensate for the existing wind conditions during the landing roll resulting in a loss of control. A contributing factor was the crosswind.
Back to Cessna 172M