Cessna 172I
FAA incident reports · 212
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 ('2072426')
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 ('2072426')
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 19740314006409ACessna 172I · Cortland, NYWind gusting 25K.acft left the rwy in a side skid.Accident 19740302007639ACessna 172I · Swansea, MASim instrument conditions. Entered unusual attitude at lo alt. Un rcvr before hitting wires.Accident 19740218004779ACessna 172I · Plymouth, MAApplied brakes following touchdown nosed over.Accident 19740127001659ACessna 172I · Selinsgrove, PAPilot lost directional control drg landing aircraft departed runway,struck snowbank,overturned.Accident 19731221041769ACessna 172I · Callahan, CAMtn peaks obscured. Mod-svr turbc rptd. Flew into mtn at 6200FT.rcvrd 7/7/74.plt time to 8/25/72.Accident 19731129039569ACessna 172I · Carlisle, ARPlt lndd half way dwn rwyAccident 19731012033029ACessna 172D · Alexandria Bay, NYPilot mistook unimproved field for airport. Engine failed during attempt to abort approach.Accident 19730721020899ACessna 172I · Mena, ARPlt became lost twice enroute to Mena. Touch dwn abt 2200 ft on 3800 ft rwy. No brake malfunction.Accident 19730627021999ACessna 172I · Childress, TXRt tire blew,un to mntn drctnl control. Damage to rt gr box attachment and door post.Accident 19730511010499ACessna 172I · Chillicothe, OHAcft ran off end of rwy and down slope.Accident 19730430011629ACessna 172D · Danville, ILLndd s atmtd n tkof aprx 200 short of s end of rwy. Gnd run 1600FT not airborne,aborted.6 in grass.Accident 19730320006619ACessna 172I · Farmingdale, NJDrg taxi to park area l wing of acft hit unlighted parked truck adjacent to taxiway. Ldg lgt on.
Back to Cessna 172I