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 19790916025289ACessna 172M · Atlanta, GAEngine quit while towing banner; fuel exhaustion. Made landing in park. Hit tree & curb. Found water in tanks.Accident 19790725022769ACessna 172 · Montebello, VAAcft was operating at low altitude during candy drop when crash occurred. Occupants could not recall circumstancesAccident 19790607031769ACessna 172H · Boulder Junctio, WIAcft failed to climb on takeoff. Pilot dragged a wing tip in lake. Many maintenance discrepancies found.Accident 19790520009189ACessna 172 · Santa Cruz, CAPilot made forced landing on beach. Engine failure could not be verified. Aircraft washed out to sea.Incident 19790515027069ICessna 172 · Ft Atkinson, WIStudent pilot landed long, overshot departure end of runway. Damaged nose gear, cowling prop, wing tip.Accident 19790506009089ACessna 172 · Key West, FLAircraft veered off runway during landing roll. Ran into ditch and overturned.Incident 19790429100839ICessna 172 · Watertown, SDAircraft porpoised on landing, damaging nose landing gear.Accident 19790417006859ACessna 172 · Spruce Pine, NCPilot allowed aircraft to drift to side of runway. Dragged wing on runway while correcting back to runway.Accident 19790322005049ACessna 172H · Crosbyton, TXPilot landed in crosswind. Allowed aircraft to veer off runway into soft ground, flipped over.Accident 19790217003119ACessna 172 · Linden, MIStudent pilot made night downwind landing on unlit runway. Ran off departure end, flipped over in snowbank.Accident 19790203033139ACessna 172 · Independence, CAAttempt takeoff at gross weight with full flaps. Made premature liftoff. Aircraft stalled and hit the ground.Accident 19790116000899ACessna 172H · Mount Judea, ARAircraft hit top of a hill which was covered with fog. Water was found in fuel. Acft was not found for 5 daysAccident 19790110000659ACessna 172H · Malone, NYAircraft made a left turn after takeoff and flew into the administration building.Accident 19781210036249ACessna 172D · FLAccident 19781121040691ACessna 172D · Mt Airy, NCAccident 19781118041979ACessna 172H · Kent, TX196MG percent of ethyl alcohol in the pilot's bloodstream. Pax staplt had little exp-none rectyAccident 19781105034809ACessna 172D · Andrews, TXAccident 19780929029952ACessna 172H · Santa Rosa, CABoth acft cleared to taxi on intersecting taxiways.Incident 19780912017019ICessna 172 · Niagara Falls, NYAircraft blown off ramp while taxiing behind large aircraft.Incident 19780812037839ICessna 172H · HillsboroForced landing due to fuel exhaustion.Accident 19780805037639ACessna 172D · Rosemount, MNOff airport operation.Accident 19780728027999ACessna 172H · Tony, WIIncident 19780628035199ICessna 172H · Defiance, MOLanding in field necessary when the engine lost power. Air filter gasket had come loose and lodged in carburetor.Incident 19780623036239ICessna 172H · South Weymouth, MAPilot landed after noting loss of oil pressure due to a broken line.Accident 19780623016239ACessna 172H · Detroit, MIPractice x-wind landings.Accident 19780610015309ACessna 172H · Hopeville, WVAccident 19780610012299ACessna 172H · Brandon, FLAccident 19780326005849ACessna 172D · Sparta, GAPlt ran out of fuel while making approach to emergency landing siue low fuel state.Incident 19780225001859ICessna 172 · Wilkes-Barre, PAInstrument pilot ran into weather on VFR flight at night. Was given an asr approach after elec emergencyAccident 19780217003649ACessna 172H · Fond Du Lac, WIIncident 19780131001899ICessna 172 · Mattoon, ILPropeller struck pilot after hand-propping aircraft with mags on.Accident 19780126000729ACessna 172H · Marshfield, MOWnd gusting 35K. R/w snow depth 12 to 18 inches.Accident 19771209038139ACessna 172H · Valkaria, FLAccident 19771201041269ACessna 172H · Cades Cove, TNAccident 19771027033759ACessna 172H · Romulus, MIStruck by APU truck.Accident 19771003033009ACessna 172H · FLAccident 19770918035799ACessna 172H · Marlton, PAAccident 19770905031809ACessna 172H · Lancaster, NHDuring xc flt over mountainous terrain encounterd sever down draft unable check descent.Accident 19770827027119ACessna 172H · Wickenburg, AZDust devil.Accident 19770710026469ACessna 172H · Watertown, NYAircraft went over embankment along taxiway after failure of l brake for undetermined reason.Accident 19770625016339ACessna 172H · College Park, MDNr 2 exhaust valve stuck open.Accident 19770605015599ACessna 172H · Valparaiso, INNosewheel struck rwy light.Accident 19770508010489ACessna 172H · Fall River, KSAirport closed.Accident 19770507009039ACessna 172H · New Cumberland, WVWind gusts to 15KTS.Accident 19770428009899ACessna 172H · Hot Springs, SDRunway lights malfunctioned. Pilot thought fence was center line of runway. Landed left of runwayAccident 19770423009649ACessna 172H · Sultan, WATkof fm 2000FT turf rwy with flaps full down. Cap rpts unreliable flap indicator.Accident 19770417009519ACessna 172H · Louisville, KYAccident 19770320005709ACessna 172H · Beckwourth, CAAccident 19770204001529ACessna 172H · Grand Island, NEWind gusting to 38KTS.Accident 19770129002419ACessna 172H · Cedar Key, FL
Back to Cessna 172H