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.
Accident 19770912027349ACessna 172G · Albuquerque, NMNo comp #2 cyl,little comp #3 cyl. Dens alt aprx 6900FT.mix not leaned.Accident 19770813024039ACessna 172G · Wasilla, AKAvoiding boat. Wingtip,float caught water,cartwheeled.Accident 19770623017229ACessna 172G · Earle, ARBlocked by dirt & grassAccident 19770611013259ACessna 172G · Zellwood, FLLanded in plowed field next to grass strip.Accident 19770429013549ACessna 172G · Ticonderoga, NYWind gusting 15 KTS.Accident 19770407008509ACessna 172G · Sandstone, MNWind gusting to 15 KTS.Accident 19770218002649ACessna 172G · Lordsburg, NMAccident 19770115000989ACessna 172G · Rutledge, MNEngine breather line was found to be blocked with ice. Plt pulled mixture off at altitude.Accident 19761216041449ACessna 172G · Richmond, VABoth doors sepd,hit horz stabs. Recovered.Accident 19760926030639ACessna 172G · Landrum, SCPilot unable to extend landing flaps. Alternator failed and battery was discharged.Accident 19760923032989ACessna 172G · Marcy, NYNr 6 cyl failed at base flange.Accident 19760820026229ACessna 172G · London, OHLndd on a gravel rd parallel to a corn fld l wing tip hit corn plt lost ctl of acft.Accident 19760703021649ACessna 172G · St Pauls, NCR clbg turn aftr low pass.Accident 19760618038601ACessna 172I · OKAccident 19760611016539ACessna 172G · Gary, INRwy switched to 02 due wind shift. Plt did not follow ctlrs insts lndd rwy 20.wind 12K.Accident 19760610015639ACessna 172G · Blairstown, NJPlt manipulating carb heat to correct engine problem when acft hit wire across highway.Accident 19760606014919ACessna 172G · Crystal, MNAccident 19760531013239ACessna 172G · Harlowtown, MTPorpoised.Accident 19760407008849ACessna 172G · Las Vegas, NVTaxied between DC-9 & B-727.Accident 19760312014439ACessna 172G · Marksville, LAPlt in 2 acft formation being led by his flt instructor. Ran into enroute nite wea.Accident 19760312009139ACessna 172G · Perry, FLBecame airborne aftr t/d.lndd adj to rwy rolled into ditch. Wind gusting 20K.Accident 19760208002769ACessna 172G · Preston, IDRecovery date 2/10/76.Accident 19751220039019ACessna 172G · Eagle Pass, TXGusting to 20K.Accident 19750910029479ACessna 172G · Victoria, TXBattery low. Pulled prop thru,mag switch was on. Hit Cessna 150,N6508S,demolished.Accident 19750908030629ACessna 172G · Waterville Vly, NHTracking VOR outbound to locate arpt. Plt pulled up to avoid cloud and collided with mountain.Accident 19750707020009ACessna 172G · Bloomington, ILAbt 3 1/2 qts drained fm l tank,8 oz drained fm lowest point in sys.Accident 19750417008809ACessna 172G · Sonoma, CAExternal gust lock restricted elev travel to abt 2 in.Accident 19750407009629ACessna 172G · Post, TXGusting to 35K.plt stated he waited for wg walkers but none avail.Accident 19750407008739ACessna 172G · Byron Center, MIAccident 19750306004479ACessna 172G · Candelaria, TXLnd on short rough strip. Swerved off rwy into brush due bluff at end. Made 4 passes bfor ldg.Accident 19750226002109ACessna 172G · Wellman, IAWind gusting 25K.Accident 19750122001219ACessna 172G · Aberdeen, IDPax had feet on brakes.Accident 19750105000559ACessna 172G · Baxley, GALow on apch. Student plt at ctls,slammed throttle in,eng hesitated.Accident 19741218042949ACessna 172G · Livingston, TN3 Hr 40 min flown on 36 gal usable fuel. Flt in turb air with carb heat part on.Accident 19741031035469ACessna 172D · Seattle, WAFloat equipped. Demonstrating slow flt.Accident 19741026039369ACessna 172G · Lummi Island, WAObstructions both ends of rwy.Accident 19740927031149ACessna 172G · MOAccident 19740911031859ACessna 172G · Amarillo, TXPlt swtchd fuel tnk aftr dscndng to 1200 ft AGLAccident 19740811029579ACessna 172G · Wauchula, FLPwr loss abt 20FT AGL.Accident 19740724021859ACessna 172G · Leawood, KSOvershot rwy,hit terrace. Plt did not consider go-around until it was to late to do so.Accident 19740708017989ACessna 172G · Wagon Mound, NMLost,landed on road. Refueld auto gas. Took off with insfnt dist,hit wires. Dens alt 9900 ft.Accident 19740611016329ACessna 172G · Petersburg, VAAtmtg clr ridge. Enctrd dndft,un maintain alt.Accident 19740309004969ACessna 172G · Olympia, WAGusting wind.Accident 19740224004069ACessna 172G · Bellingham, WALong final due otr acft. Winds vbl,gusts reported. Plt partially recovered from stall.Accident 19740221002519ACessna 172G · Farmville, NCOvershot lndg. Swerved off rwy to avoid trees. Struck ditch.Accident 19740125002799ACessna 172G · Marlboro, MALanded long turned off runway into snowbank to avoid fence at end of runway nosed over.Accident 19740118000099ACessna 172G · Hamilton, NCEngine failure due water in fuel. Struck tree during forced landing approach.Accident 19740102000669ACessna 172G · Bellingham, WAAcft stoppd on rwy. Wnd rpts 030 deg 18 KTS,gusts 38 KTS. Plt statd wnd rpt was gusts 28 KTSAccident 19731125038109ACessna 172G · MDAccident 19731122039199ACessna 172G · Elkhorn, WITakeoff run extended due to soft turf runway. Aircraft mushed into trees during attempted climb out
Back to Cessna 172G