Cessna 172L
FAA incident reports · 511
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 ('2072432')
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 ('2072432')
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 19761220041659ACessna 172LAccident 19761011032329ACessna 172D · Stronsville, OHAccident 19761009031842ACessna 172L · Huron, SDReceived aprt advisory & lndd into wind rwy 17.Accident 19760926037129ACessna 172L · Beluga Mt, AKPilot was buzzing cabin. Blood alcohol lvl 145 mg .Accident 19760730024279ACessna 172L · Raymond, WALndd on ocean beach.Accident 19760619019009ACessna 172L · Eminence, MOFull flap apch a/s abt 65MPH,atmtg establish a r crab enctrd svr dndft.Accident 19760617016619ACessna 172L · Palo Verde, CAGusts to 25K. Lnd on desert road.Accident 19760531017279ACessna 172L · Deerfld Beach, FLPlt flew acft on sod strip for some time. Roughness of strip contributed to failure.p/n S2138-1.Accident 19760526016479ACessna 172L · Columbus, GAPlt lndd due dizziness for undetermined reason.Accident 19760522016199ACessna 172L · Plymouth, FLLight didnt come on when switch activated,cb ok. Unlighted airport.Accident 19760222002519ACessna 172L · NCAccident 19760207002169ACessna 172L · Mason, MIFwd seat rollers came off tracks and seat moved aft. Fwd seat track pins not found.Accident 19760131003639ACessna 172L · Bay City, MISnowing in area quite a while bfr acdt. Snow blown almost horizontally by winds EST in excess 30K.Accident 19760117000209ACessna 172L · Chicago, ILAccident 19760116007599ACessna 172L · White Plains, NYDecended below mda,no glide slope receiver. Wrong altimeter setting found 29.92 in. Setting 29.79 inAccident 19760116001209ACessna 172L · Titusville, PADrifted snow on rwy,lack of contrast. Hit snowdrift.Accident 19760114000489ACessna 172L · Worcester, MAWind gusting 40K.wing walkers avbl on rqst.Accident 19760111000369ACessna 172L · Forkland, ALAccident 19751108042409ACessna 172L · Key West, FLAcft on photo mission of boats participating in powerboat race flt abt 50FT abv water.Accident 19751014034249ACessna 172L · Rockfort, ILT/d aprx 1/2 way down 2540FT rwy.Accident 19751003030139ACessna 172L · Angier, NCThree foot deep hole on runway. Plt steered acft to r side of rwy to turn around to taxi back.Accident 19750809028969ACessna 172L · Grafton, OHAll 4 plugs nr 2 and 4 cyl oil soaked bottom plugs nr 1 and 3 cyl large lead deposits.Accident 19750809022049ACessna 172L · Nw Prt Richey, FLPlt attempted tkeoff with full flaps.Accident 19750704018449ACessna 172L · Fields, ORMistakingly landed in soft borax lake bed.Accident 19750621019769ACessna 172L · Circle City, AK3Rd ldg attempt.Accident 19750612015009ACessna 172L · Burnet, TXMech pitot cover stuck on tkof. Airspeed read zero.Accident 19750611015449ACessna 172L · Phelan, CAUn outclimb rising terrain. Nr max gross wt. Dens alt 5400FT.Accident 19750611015429ACessna 172L · Putney, VTHit,destroyed sheibe SF25A,N6388.glider not vsbl due 15DEG jog at rwy midpoint.Accident 19750603014459ACessna 172L · Mt Sterling, ILThe stepped dowel pin p/n STD-1065 broke allowing crankshaft to turn free of gr and gr train.Accident 19750602013769ACessna 172L · Goodland, KSPlt clrd to lnd rwy 21 while flaring to lnd fss advsd flt lndg rwy 23,closed rwy.11.6HR in 24HR pdAccident 19750524012099ACessna 172L · Sanibel Island, FLAftr roundout acft floated. Ran off end of rwy hit a ditch.Accident 19750510015709ACessna 172L · Marathon, FLBlood alcohol lvl 0.19 pct. Acft struck water sltly nose dwn,l wing low attitude.Accident 19750505012789ACessna 172L · Linden, MIDescended thru clouds to obtain gnd reference. Observed tree too late to avoid collision.Accident 19750420010459ACessna 172L · Wadsworth, OHAcft crossed end of rwy,crossed a road hit a two ft deep ditch.Accident 19750412015119ACessna 172L · Banaue,LuzonInvest under jurisdiction of govt of phillipinesAccident 19750401007349ACessna 172L · Calhoun, GAT/d abt 20-30FT bfr rwy.Accident 19750228004869ACessna 172L · Pine River, MNHigh snowbanks bordering rnwyAccident 19750208002449ACessna 172L · Ajo, AZAccident 19750130002369ACessna 172L · Eden Prairie, MNAccident 19750103010349ACessna 172L · CorregidorRan into bushes. Invest under jurisdiction of govt of phillipines.Accident 19741230043959ACessna 172L · Missing Aircraf, CAAcft dmg & inj index presumedAccident 19741222043739ACessna 172L · Hollywood, FLDrifted toward parked acft.Accident 19741207041239ACessna 172L · Tuxedo, NYPlt lost,requested assistance. Radar contact not established. Flew into mtn aprx 1200FT MSL.Accident 19741128041179ACessna 172L · Stone Mountain, GAAccident 19741126041609ACessna 172L · Greenville, TXAcft r wg hit temp maint lt stand on taxiway.Accident 19741105037469ACessna 172L · Cleveland, TN7 Rwy lgts out acft rolled ovr 15FT embankment. Alternator belt loose.Accident 19741013035919ACessna 172L · Crivitz, WIShort fld ldg. Blown tire,cracked fairing,bent prop,wrinkled firewall.Accident 19740914028969ACessna 182P · Las Vegas, NVVbl winds,gusting to 23K.Accident 19740908030469ACessna 172L · Mastic, NYAcft made hard landing left wing struck ground acft flipped over.Accident 19740812025969ACessna 172L · Westfield, MASeries of bounces bfr go-around.
Back to Cessna 172L