Cessna 172G
FAA incident reports · 420
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2072420')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2072420')
ORDER BY event_date DESC, report_number 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.
Incident 19810709054059ICessna 172G · Utica, NYFloat plane blown over inverted in water during taxi.Accident 19810705038039ACessna 172G · Newburg, MOAircraft crashed during IMC after pilot attempted to contact fss for weather information.Incident 19810621052419ICessna 172G · Highwood, ILZa electrical failure, landed at nearest airport. Found generator commutator worn and dirty.Accident 19810619034199ACessna 172G · Martin, KYAircraft crashed during cross-country when numerous thunderstorms on route of flight. Fuel tank found empty.Accident 19810606032779ACessna 172G · Shallowater, TXUnable to lift off due to uphill, heat, and elevation. Aborted, ran off end of runway and overturned.Incident 19810525030399ICessna 172G · Salt Lake City, UTAircraft was raised by jet blast then dropped on wingtip.Incident 19810410024699ICessna 172G · Groton, CTHolding for takeoff behind another aircraft. Blown over by prop blast and gusty wind.Accident 19810315010259ACessna 172G · Clarksville, INAircraft crashed at night when pilot was attempting night landing on unlighted runway.Accident 19810303007149ACessna 172G · Lewiston, IDVibration right main gear on takeoff. Aborted late. Ran off end of runway. Some flat spots on tire tread.Accident 19801130072549ACessna 172 · Springfield, OHStudent pilot lost control while landing in gusty crosswind. Airplane ground-looped.Incident 19801018075219ICessna 172F · Winona, MNOut of fuel after 4.7 hours of flight, landed on highway. Added auto fuel hit a road sign during turn for takeoff.Accident 19801018063949ACessna 172 · Hamburg, NYWind blew aircraft over during turn to part in aircraft parking area.Incident 19800820066319ICessna 172 · Packwood, WAPilot making night landing at unlighted airport. Struck wires at departure end on go around, next try successful.Incident 19800801067229ICessna 172G · Bloomington, ILEmergency landing made after engine roughness. Found stuck piston.Accident 19800602017989ACessna 172G · Cape May, NJPilot attempting go-around, pulled up sharply and stalled aircraft.Incident 19800529051709ICessna 172G · Guam, GuamPilot lost directional control after crosswind landing and ran off runway.Accident 19800505011479ACessna 172G · Allentown, PACrosswind gust lifted wing on level off. Dragged wing. Cartwheeled on runway.Incident 19800313038309ICessna 172G · Albany, NYGust of wind tipped aircraft up on left wing tip, left main gear and nose wheel, allowing prop to strike runway.Incident 19800125015849ICessna 172G · Cambridge, MNPilot pulled prop through by hand,engine fired and broke pilot's leg. Magneto switch had been left on left magnetoAccident 19800103000049ACessna 172G · Coalinga, CAPlane crashed in field. No cause was found.Incident 19791217046509ICessna 172 · Great Falls, MTDuring taxi in strong gusty winds, nose wheel encountered slush on runway, pilot lost control, damaged wing, prop.Incident 19791017051229ICessna 172G · Boston, MASmall plane blown up on prop and wing tip jet blast from large jet turning to return to the ramp.Accident 19790918040989ACessna 172G · Brownstown, ILOff course, in ground fog. Tried to land in a field. Overshot. Stalled airplane on attempted go-around.Incident 19790912035299ICessna 172 · Howlton, MEChutist accidently deployed reserve chute, cut away the main, was injured in hard landing.Accident 19790902023259ACessna 172 · Shinhopple, NYPilot made a precautionary landing in a corn field due to deteriorating weather.Incident 19790811030529ICessna 172G · Wheeling, ILWhile taxiing in grass area, nose wheel dropped into ditch.Accident 19790519010499ACessna 172C · Herron, WVPilot allowed student to land airplane. Aircraft veered off runway. A conflict developed over use of rudder.Incident 19790501025449ICessna 172N · Wheeling, ILPilot lost directional control after touchdown.Accident 19790405006459ACessna 172 · Valier, MTThe aircraft struck snow and sod on the runway while landing and nosed over.Accident 19790314004699ACessna 172G · Grand Rapids, MIAircraft blown over while conducting run up at runway intersection. Peak gust 40 knots.Accident 19790308004299ACessna 172G · Apple Valley, CAAircraft ran out of fuel in traffic pattern after cross country flight. Landed in adjacent field. Nosed over.Accident 19790103000219ACessna 172 · Anchorage, ALStudent pilot mistook the area between the rwy and taxiway for the landing area.Accident 19781205044839ACessna 172D · Cuyamaca, CASct to bkn clouds and mod to severe turb below 20000FT,esp ovr mtorecast in area.Accident 19781015034019ACessna 172D · Linville, NCEng not developing full power.Accident 19781008033129ACessna 172D · Bridgeport, TXWind gusting 25K.Accident 19780812027399ACessna 172G · Taylor, MOOn climb out ran into fog,attempted descent.Accident 19780727025609ACessna 172G · Augusta Spring, VAAtt takeoff fm 1200 ft grass area at 2000 ft MSLAccident 19780705016589ACessna 172G · Lowell, MICarb heat applied during tkof.Accident 19780604020559ACessna 172D · AKIncident 19780601041339ICessna 172G · Mount Olive, NCWorn fuel selector valve failed and engine quit.Accident 19780510009879ACessna 172G · Springfield, MOIncident 19780408009069ICessna 172G · Charlottesville, VAPilot allowed aircraft to drift off side of runway after aborting takeoff. Aircraft was slightly over gross weightAccident 19780406005979ACessna 172G · Imperial, TXAccident 19780307006819ACessna 172G · Plain City, OHAccident 19780216003469ACessna 172G · Taylor, AZWnd gusting 20K.Incident 19780212006389ICessna 172 · Mentone, INPilot departing from a center plowed snowy runway, lost directional control. Nosed up in the deeper snow.Accident 19771224042979ACessna 172G · Blairsville, GABase of overcast below mtn range tops. Hit mtn abt 3000FT MSL.Accident 19771103034529ACessna 172G · Jacksboro, TXCollided with hwy sign while making precautionary lndg on highway with 4 degree downslopeAccident 19771014032039ACessna 172G · TXAccident 19771003030929ACessna 172G · Portsmouth, OH
Back to Cessna 172G