Cessna 172H
FAA incident reports · 469
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 ('2072424')
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 ('2072424')
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 19770127002849ACessna 172D · Denton, TXAccident 19761229038849ACessna 172H · Detroit, MICollided with fuel truck. Truck driver failed to see & avoid aircraft.Accident 19761211040039ACessna 172H · Houston, TXAccident 19761114041289ACessna 172H · PAAccident 19761113037672ACessna 172H · Lynchburg, VAAccident 19761004031719ACessna 172H · Parowan, UT35FT p-line NE end rwy 22.evasive maneuver to avoid coyote and p-line. Landed long. Flaps full down.Accident 19761002039079ACessna 172H · Grangeville, IDPsgr deplaned to direct plt to parking. Whl stuck in hole. Psgr walked into prop drg shutdown. Dusk.Accident 19760912032889ACessna 172H · Glen Rose, TXNoncertificated pilot operating aircraft from lt seat. Student pilot in rt seat.Accident 19760816038669ACessna 172H · Mandan, NDPlt asked for local wx only. Flt ovr unlit terrain,sky overcast. Rcvrd 8/17/76.Accident 19760807024349ACessna 172H · Albuquerque, NMWitness observed acft on takeoff with near full flaps down. Density alt abt 7800FT.Accident 19760805026609ACessna 172D · Hooker, OKAccident 19760729031059ACessna 172H · Windermere, FLCarburetor accelerating fuel pump shaft bindingAccident 19760610018899ACessna 172H · Mahopac, NYHigh lvl off,bounced lndg.Accident 19760527013169ACessna 172H · Flushing, MIAccident 19760516014109ACessna 172H · Hollister, CANr 1 cyl conrod bolts failed.Accident 19760503018089ACessna 172H · CAAccident 19760502010219ACessna 172H · Jerseyville, ILWind gusting 30 KTS. Local radio and st louis wx briefing.Accident 19760415019619ACessna 172D · Winslow, AZPilot filed but did not open VFR flt pln. Called abq artc for assistance enroute.Accident 19760207001129ACessna 172H · Ft Bragg, CABecame lost. Hit guy wire while ldg on hiway. Abt 18 gals fuel found in tanks.Accident 19751108034769ACessna 172H · Lubbock, TXPlt didnt retract flaps & didnt use UNICOM.Accident 19750902030609ACessna 172H · New Cumberland, WVSteep embankment at runway end.Accident 19750824027249ACessna 172H · Deary, IDBird nest in carb intake,material injested into carb.Accident 19750819025599ACessna 172H · Nichols, SCAcft stalled on tkeoff from 1200 ft field following precautionary lndg. Fld wet and soft.Accident 19750725020899ACessna 172H · Oakdale, CALnd in pasture.Accident 19750703018399ACessna 172H · ALAccident 19750622017859ACessna 172H · Quinton, VA2Nd apch lndd long and fast.Accident 19750528017309ACessna 172H · Flint, MIAccident 19750505010222ACessna 172H · Montpelier, VTParked on taxi strip,structural dmg to r wing,aileron and wing tip.N5210M substantial dmg.Accident 19750502008589ACessna 172H · Roanoke Rapids, NCPlt reaching across throttle to ck flap switch. Pilot-inadvertently actuated throttle.Accident 19750330006989ACessna 172H · Scottsbluff, NEAccident 19750325007109ACessna 172H · Sacramento, CAGusting to 38K.Accident 19750226002099ACessna 172H · Columbus, NEDeplaning pax walked into rotating prop.Accident 19750220003129ACessna 172H · Seguin, TXMud dauber nest blocked vent line.Accident 19750217013289ACessna 172H · Olive Branch, MSAccident 19750131005899ACessna 172H · Bakersfield, CAPlt blood alc lvl .09PCT.Accident 19740920039269ACessna 172H · Bluebell, PARcvd assist fm phl twr. Passed ovr arpt. Plt rptd gnd in sight,descended to find arpt.Accident 19740829029669ACessna 172H · Jonesboro, GANosewheel enctrd rut,acft flipped.Accident 19740823029409ACessna 172H · Catasauqua, PAPlt ctctd abe twr and rptd bad flt cond and rqstd assist. While being radar vectored,ctlr lost ctc.Accident 19740718029109ACessna 172H · Snoqualme Ps, WAPlt on vctn trp frm Ohio attmptd flt thru obscured mtn pass. Recovery date 7/20/74.Accident 19740616029049ACessna 172H · Battle Grnd, WAClrd ditch next to rwy & hit brush. Gusting to 20K.Accident 19740504010679ACessna 172H · Horton, KSInitiated go-arnd after t/d.tail hit fence post.Accident 19740502010629ACessna 172H · Honobia, OKSettled into trees.Accident 19740327005659ACessna 172H · Ellenville, NYBounced on landing drifted off runway into soft dirt nosed over onto back.Accident 19740317011799ACessna 172H · Las Vegas, NVNo rest previous night. Recent gastrectomy. Evidence that plt fell asleep at ctls. Rcvrd 4/6/74.Accident 19740228003699ACessna 172H · Aurora, ILWind gusting 29K.drg turn onto rwy wind gust struck acft fm l.Accident 19740219003989ACessna 172H · Newburgh, NYLast apch advsd 45MIN fuel remain,rptd om inbnd fuel ex. Missed apch made abv mda. Last alt ck 1967.Accident 19740115001019ACessna 172H · Carlisle, PAAccident 19731202039619ACessna 172H · Beatrice, NEPlt attmptd letdwn thru fog. Flt lasted 15 min. Hit pwr pole.Accident 19731118034629ACessna 172H · Forsyth, MTPlt expedited apch due sleet. Wnd gusting 12K.Accident 19731008032619ACessna 172D · Carlisle, ARDrg turn out of fog,un avoid tree in path. Continued flt,ctls locked atmtng lndg apch.
Back to Cessna 172H