Cessna 172K
FAA incident reports · 683
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 ('2072430')
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 ('2072430')
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 19741231042679ACessna 172K · Avalon, CAGusting to 48K.Accident 19741229043299ACessna 172K · Kodiak, AKHit large wooden crates.Accident 19741215040339ACessna 172K · San Carlos, CAFuel tank vent clogged with paper.Accident 19741111037839ACessna 172K · SCAccident 19741109037919ACessna 172K · Danielson, CTAcft veered off rwy to l,cont on grass area. Struck trees with l wing. Wind gusting 21K..Accident 19741107037909ACessna 172K · Charlotte, NCPractice localizer approach,VFR cond. Safety plt commented too lo,took ctl,made pull up into stall.Accident 19741031039779ACessna 172K · Snowflake, AZAccident 19741027038189ACessna 172K · Haleyville, ALAcft obsvd making t/g ldgs. Impacted gnd 450-600FT short of rwy,ldg lgt on.Accident 19741009035249ACessna 172K · Beason, ILAD 72-7-2 requires opn on r or l fuel tank above 5000FT.plt using "both" psn. Vapor in fuel lines.Accident 19741003034329ACessna 172K · Graham, TXLnd on 3rd attmpt abt halfway dwn rwy. Wind sock on fld. Gusting to 20K.Accident 19740927039299ACessna 172K · Glendale Hts, ILPlt blood alcohol lvl 246 mg pct.Accident 19740918031479ACessna 172K · Indian Trail, NCTelephone and power lines,ip atmtd go under wires. Hit telephone line blo wires.Accident 19740917030589ACessna 172K · Montgomery Cty, MOWest wind tkof n aftr ldg plt noted sw wind.Accident 19740823027479ACessna 172K · Marshfield, MOAccident 19740818028349ACessna 172K · Kodiak, AKPilot made low pass over ship and mushed out of turn into waterAccident 19740801023859ACessna 172K · Downsville, NYDuring attempted go-around acft stalled and descended into trees. Came to rest on river bank.Accident 19740731027739ACessna 172K · Greenwood, INAcft made low apch-flaps up. Hit truck on road.Accident 19740726021879ACessna 172K · Clanton, ALPlt attn diverted to photographer.Accident 19740723023649ACessna 172K · Hinton, WVShort base leg. Lndd on golf course. Braking action nil,skidded.l wing struck tree.Accident 19740721025069ACessna 172K · Jaffrey, NHDeplaned psgr on unlighted ramp with engine idling. Psgr walked fwd into prop.Accident 19740712024979ACessna 172K · Jasper, ALIp dtmnd plt lndg long took ovr ctls. Acft mushed into trees at sw corner of arpt.Accident 19740709021329ACessna 172K · Strafford, MOAccident 19740630021739ACessna 172K · Burlington, WAAcft lndg rwy 03.gusting to 25K.Accident 19740629022359ACessna 172K · Jeannette, PAL fuel tank vent valve tubing passage found plugged solid with mud.Accident 19740626019719ACessna 172K · Wyatt, INWind gusting 15-18KTS.lndd in hayfield,cont into fence.Accident 19740608019579ACessna 172K · Palmer, MARolled down embankment.Accident 19740603020422ACessna 172K · Maple Lake, MNHolding on dept end of rwy aftr ldg. No turnoff avbl. Ok'd PA-28 tkof.Accident 19740530017639ACessna 172D · Anchorage, AKGusting to 25K.Accident 19740526020289ACessna 172D · Schaumberg, ILL main ldg gr struck an abandoned home freezer.Accident 19740512014419ACessna 172K · Charlestown, WVAcft struck rwy in a nose dwn attitude.Accident 19740508013529ACessna 172K · Pueblo, COPilot parked,did not shut down. Enplaning pax walked into prop.Accident 19740428011339ACessna 172D · Gold Beach, ORRising terrain. Gusts to 35K.exceeded allowable tkof wt.Accident 19740406007089ACessna 172K · Oxford, NCNse tire blew. Dmgd l wg tip,prop.Accident 19740403007469ACessna 172K · Oakland, MDRan off end of rwy.Accident 19740310008029ACessna 172K · MIAccident 19740228012969ACessna 172K · Warren, OHPrimer unlocked out abt 1/2 in. Ex pipe had black residue on inside. Otr ldg area avbl.Accident 19740221004589ACessna 172K · Corpus Chrsti, TXPlt prev briefed by FAA control tower of strong gusty 28-36K vbl winds bfor taxying.Accident 19740204003222ACessna 172K · Dixon, ILLndd into wind.Accident 19740130001999ACessna 172K · Romeo, MIAborted take off half way down runway. Pilot felt he would not clear wires. Ditch at end of runway.Accident 19740115000249ACessna 172K · Fort Lupton, COGusting to 15KAccident 19740113000979ACessna 172K · Holly, WACaught high wave during tkof. Bounced into air & stalled. Gusting to 20K.Accident 19731229041249ACessna 172K · Broomfield, COAccident 19731229041059ACessna 172K · Kenosha, WIGusts to 20KAccident 19731204037709ACessna 172K · Austin, TXLndd on narrow road border by trees. Nr 3 exh valve failed.Accident 19731104038549ACessna 172K · Cherokee, TXRecovery date 11/21/73.Accident 19731018038489ACessna 172K · Kissimmee, FLMDT rain shwrs,sparse ltg in area. Recovered from lake 10/27/73.Accident 19731013033639ACessna 172K · Plainfield, ILFull flap ldg,bounced,recontacted rwy nose wheel broke off strut.Accident 19731010032639ACessna 172K · Williamsburg, KYHi apch. Allowed a/s to build. Hit embankment of small drainage ditch.Accident 19730909031552ACessna 172K · Deerpark, NYL wing of Cessna N60616 struck rotating prop of N79269.Cessna N60616 l of taxiway ctr line.Accident 19730908030919ACessna 172D · Loma Linda, CAWife req wea brief for palm sprngs only. Flew into enroute wea,turned around,& hit obscured ridge.
Back to Cessna 172K