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.
Incident 19780805050189ICessna 172 · Kotzebue, AKNose sank in soft sand while taxiing, aircraft nosed up.Accident 19780729018319ACessna 172D · Leitchfield, KYAccident 19780728018809ACessna 172D · Chewelah, WAHit dirt mound to left of rwy.Incident 19780722038539ICessna 172 · Sheridan, ORMain chute streamered and detatched. Reserve chute inflated, riser strap tore loose, it streamered.Accident 19780719020389ACessna 172K · Key Largo, FLAcft 69LBS over max authorized weight.Accident 19780629019049ACessna 172K · Aulander, NCPlt seat slid aft on tracks drg tkof run. Plt unable to reach pedaeat track stop mislocated.Accident 19780623013549ACessna 172D · Circle, MTAccident 19780617016559ACessna 172D · Cheney, WAHit ditch.Accident 19780604021189ACessna 172D · Brawley, CAIncident 19780603041619ICessna 310Q · San Fernandoq, CABell crank assembly broken from excessive side load. Right main collapsed. No sign of previous crack.Accident 19780514013179ACessna 172D · Fredericktown, OHIncident 19780507032329ICessna 172 · Belleville, KSPilot allowed aircraft to drift off runway into soft mud. Aircraft nosed up.Accident 19780430010309ACessna 172D · Port Townsend, WAStudent overshot simulated forced ldg. Ip attmptd go arnd with pal pwr & full flaps.Incident 19780314015849ICessna 172 · Hayward, CAPilot landed long in an unfamiliar area of the airport. Taxied into a ditch leaving the runway.Accident 19780302002769ACessna 172D · Thedford, NEWind gusting to 40.Accident 19780219007949ACessna 172D · Colts Neck, NJUnpaved rwy with muddy areas.Incident 19780202005559ICessna 172K · New Madrid, MOPilot made an emergency landing due severe engine vibrations. 8 inches of a propeller blade had broken off.Accident 19771203041279ACessna 172K · Owego, NYWx briefed by LCL arpt operator and relatives.Accident 19771121036989ACessna 172K · Sacramento, CAWnd gusting 40Accident 19771113037929ACessna 172K · Providence, RIPIC hand propped unattended aircraft. Engine started. Aircraft taxiied into parked automobiles.Accident 19771111037899ACessna 172K · Wheeling, ILHit hangar obst lite.Accident 19771104041209ACessna 172K · Willits, CARecovery date 11/7/77.Accident 19771013031419ACessna 172K · Covington, TNFuel vent plugged by mud dauber nestAccident 19771003031949ACessna 172D · Princeton, ILDark night.3 r/w lights(portable) on each side.30' hi powerlines at departure end.Accident 19770921028099ACessna 172K · Alpine, TXAcft encountered downdrafts and turbl to extent that flight could not be maintainedAccident 19770916029979ACessna 172K · Skykomish, WAAtt dept fm unlit tree bordered mtn strip at night. Plt used strip prior in daylight conditions.Accident 19770910034739ACessna 172K · Warrenton, DCWinds gusting to 15KTS.Accident 19770902027209ACessna 172K · Kimberling Cy, MONarrow rwy (30 ft).Accident 19770902025239ACessna 172K · Glenallen, AK700FT soft uneven sod strip-heavy load.Accident 19770825037319ACessna 172K · MNAccident 19770819029759ACessna 172K · Orchard, ORIntentionally steered into a stump to stop acft rather than penetrate fence.Accident 19770802022889ACessna 172K · Bakersfield, CAMixture control push pull wire failed from bending. Swivel bolt improperly assembled at carburetorAccident 19770721020959ACessna 172K · Reno, NVNight descent to pattern alt,acft struck crest of ridge. Plt rptd downdraft.Accident 19770710017989ACessna 172K · Stambaugh, MIAccident 19770702018509ACessna 172K · Beaverton, MIPlt rprtd smoke coming frm cowling.Accident 19770628017809ACessna 172K · Oxford, MAAccident 19770627017799ACessna 172K · Lenwood, CAThird apch to short strip.Accident 19770602028829ACessna 172K · Panama City, FLLight turb presentAccident 19770528014029ACessna 172D · Lukachukai Az, AZAccident 19770522023129ACessna 172K · Flushing, NYPIC took off with full flaps,retracted flaps, aicraft stalled,struck house.Accident 19770424009709ACessna 172K · Mammoth Lakes, CAWind gusts to 25KTS.Accident 19770423009659ACessna 172K · Marlboro, MAAccident 19770321009159ACessna 172K · Cody, WYGusts to 50 KTS.Accident 19770308008859ACessna 172K · Andros Is BahamInvest under jurisdiction of govt of Bahamas.Accident 19770222002009ACessna 172K · Bartlesville, OKWind gusting 35K.Accident 19770216002599ACessna 172K · Jerseyville, ILStudent pilot intentionally attempted taxi through snowbank. Snowbank down center of rwy.Accident 19770120000729ACessna 172K · Pembroke Pines, FLStruck wires.Accident 19761222037489ACessna 172K · Fenton, MOOvershot and slid into ditch.Accident 19761210038059ACessna 172K · Riverside, CALndd in sandstorm. Wind gusting to 45KTS.Accident 19761118041329ACessna 172K · Binghamton, NY
Back to Cessna 172K