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 19730903029429ACessna 172K · Cobleskill, NYT/d midway on 1800FT rwy. Drg go-around acft cont ovr end of rwy onto corn fld 60FT blo rwy elev.Accident 19730902028199ACessna 172K · Farmingdale, NJAbt 10-15FT AGL acft started drifting l,controls seemed sluggish l wing dropped. Sandy area.Accident 19730829025349ACessna 172K · Yucca Valy, CAEncountered dustdevil on level off touchdown.Accident 19730817023309ACessna 172K · Lake Lure, NCGrnd speed less than predicted. Ran out of fuel. Crashed on hiway.Accident 19730813028369ACessna 172K · Huntingdon Vly, PAPlt had history of heart trouble.Accident 19730807022849ACessna 172K · Silver Peak, NVLooking for landing strip.Accident 19730806023289ACessna 172K · Delano, CANose whl dropped into hole.Accident 19730804026509ACessna 172K · Leesburg, VAStruck rwy bounced acft pitched up dscndd in aprx lvl flt hi sink rate.Accident 19730728023239ACessna 172K · Mann, WVFlew into obscured mtn. Plt called fss then took car & drove down mtn valley to look at wea.Accident 19730727035892ACessna 172D · Yukon, OKFAR 91.67 applies. Flt ck indicated holes in ATC radar system. Vsby restricted by hi wing.Accident 19730721022289ACessna 172D · Charles City, VAPlt mistook pasture for arpt. Lnd,realized error & began go arnd. Then closed throttle due trees.Accident 19730628018179ACessna 172D · Crossville, TNEntrd cloud,initiated l turn to fly out aftr count of 3.hit trees on mtn.Accident 19730627021989ACessna 172K · St.Ignace, MIAerosol can & box rolled under plts feet. Plt tried to kick them out of way. Skidded,caught wg tip.Accident 19730613015849ACessna 172K · Malta, MTRwy covered with high grass. Ditch obscured.Accident 19730608026199ACessna 172K · Ranier, MNR wg lifted dragged l wg in lake bottom. Float equipped. Gusting to 35K.Accident 19730605012969ACessna 172D · Henryetta, OKPilot attempted prolonged glide with engine idling. Diverted attn to eng re-start,hit wires.Accident 19730528013709ACessna 172K · Calexico, CASeat locking spring(p/n 1414116-1) no tension onlocking pin(p/n 1200504-1).seat slipped durg ldg.Accident 19730522013879ACessna 172K · Marlboro, NJAcft left rwy hit on l gr buckled wing destroyed nose gr. Brakes and sys ckd ok.Accident 19730505009219ACessna 172K · Luray, VAAtmtd become airborne. Un clr 8FT pile of dirt and tree stump. Wind gusting 30K.Accident 19730429015362ACessna 172D · Santa Ana, CAN30141 on sightseeing flt. Plt stated 13K tailwind contributed to nose over onto N78084.Accident 19730424008539ACessna 172K · Scottsdale, AZPorpoised.Accident 19730419008249ACessna 172K · Alva, OKPlt rcvd wea bdcst via radio 6 hrs prior to accident. Wnds increased to 35 kts/gusting 50K aftr depAccident 19730418009039ACessna 172D · Follett, TXPIC attempted enroute precautionary landing. Misc-pilot blinded by lightning flashAccident 19730406011909ACessna 172K · Oceanside, CA8 In separated from tip. Arpt within range. Plt was too hi,didnt use flaps. Lnd in weed fld near arptAccident 19730403007749ACessna 172K · Fullerton, CAPlt stated eng lost pwr momentarily.Accident 19730327009279ACessna 172K · Onsted, MILndd on soft gnd 1000FT to l of rwy. Airad stated loars fld closed due to thaw.Accident 19730315006029ACessna 172D · San Diego, CAAcft went und wires,lndd nose wheel first,bounced,nose ovr. Nose strut and wheel broke.Accident 19730313006339ACessna 172K · BajaInvestigation under the jurisdiction of the mexican government.Accident 19730227003669ACessna 172D · Relief, NCAccident 19730222003989ACessna 172D · Startzville, TXAccident 19730214005299ACessna 172D · Perry, FLLoss of ctl for undet reason. Tstm in area. Piece of bullet found in plts heart.Accident 19730121002799ACessna 172K · Boulder, COTaxiing around water puddle on twy,hit snowplow.Accident 19730118001429ACessna 172K · Wichita, KSDark nite,lost ctl shortly after tkof. Plt had heart lesion.
Back to Cessna 172K