Cessna 172S
NTSB investigations · 589
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 ('2072439', '2072442')
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 ('2072439', '2072442')
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 GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA150Accident · No injuriesData collectionFinal reportCessna 172 · Kent, OHA deer collided with aircraft during landing at night.NTSB ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.NTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…NTSB GAA17CA573Accident · No injuriesData collectionFinal reportCessna 172 · Chino, CAAn in-flight collision with a bird while on downwind.NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.NTSB WPR17LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Seattle, WAThe total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.NTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.NTSB ERA17LA261Accident · 1 fatalLimited investigationFinal reportCessna 172 · Danbury, CTThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…NTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB GAA17CA327Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB GAA17CA312Accident · No injuriesData collectionFinal reportCessna 172 · El Cajon, CAThe student pilot's incorrect landing flare, which resulted in the airplane porpoising upon touchdown.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.NTSB GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.NTSB GAA17CA248Accident · No injuriesData collectionFinal reportCessna 172S · Jean, NVThe pilot’s runway selection, which resulted in landing with a tailwind and an unstabilized approach and subsequent runway overrun.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB CEN17FA111Accident · 2 fatalField investigationFinal reportCessna 172S · Berthoud, COThe failure of the pilots to apply prompt and/or correct flight control inputs to adequately recover from the intentional aerodynamic spin.NTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.NTSB GAA17CA122Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe student pilot’s failure to maintain proper pitch control, which resulted in a hard, bounced landing.NTSB GAA17CA104Accident · No injuriesData collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB GAA17CA065Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA060Accident · No injuriesData collectionFinal reportCessna 172 · Englewood, COAn in-flight collision with multiple birds.NTSB GAA17CA069Accident · No injuriesData collectionFinal reportCessna 172 · Danville, KYThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.NTSB ERA17LA026Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe pilot’s improper landing flare in gusting crosswind conditions, which resulted in a nose landing gear collapse.NTSB CEN16LA379Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Chesterfield, MOThe pilot's unstable approach and subsequent loss of airplane control during an attempted go-around.NTSB GAA16CA523Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB GAA16CA416Accident · No injuriesData collectionFinal reportCessna 172 · Palm Springs, CAThe student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.NTSB GAA16CA421Accident · No injuriesData collectionFinal reportCessna 172 · Oak Island, NCThe pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing and substantial damage to the firewall.NTSB GAA16CA415Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe student pilot's failure to maintain directional control during takeoff.NTSB GAA16CA400Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe pilot's failure to maintain a safe taxi distance from a large turbine-powered airplane, resulting in an encounter of the turbine-powered airplane's jet blast while taxiing.NTSB GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.NTSB CEN16LA228Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Deming, NMThe pilots’ failure to maintain adequate control of the airplane during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude. Contributing to the accident was the…NTSB GAA16CA295Accident · No injuriesData collectionFinal reportCessna 172 · Thomson, GAThe student pilot's incorrect landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing, nose wheel collapse, and runway excursion.NTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.NTSB GAA16CA268Accident · No injuriesData collectionFinal reportCessna 172 · Newport News, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in abnormal runway contact and a substantially damaged firewall.NTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.NTSB GAA16CA219Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain pitch control during the landing flare, which resulted in an abnormal runway contact, porpoise, nose gear collapse, runway excursion, and impact with terrain.
Back to Cessna 172S