Cessna 172G
FAA incident reports · 420
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 ('2072420')
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 ('2072420')
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 19731103036909ACessna 172G · Hookena, HIFlt was for hire. Recovered 11/4/73. Dscnd into low clds twice,hit trees 2nd attmpt.Accident 19731022033799ACessna 172D · Bass Lake, CAWind gusting 60-70K.Accident 19730909030649ACessna 172G · Prattsburg, GAR brake worn. Acft veered off l side of rwy struck some peach trees.Accident 19730828031469ACessna 172G · Anchorage, AKCarb heat friction lock inop. Slid to full hot pos. Float equipped. Wg hit tree.Accident 19730818026799ACessna 172G · Monroe, SD800 Ft rough grass strip. R stab & elevator struck barbed wire fence. Plt lnd ok.Accident 19730817027812ACessna 172D · Swan Quarter, NCCarbon monoxide level of C-172 plt 14 pct,source undetermined.Accident 19730718022059ACessna 172D · Bedford, IABounced ldg,acft floated 2/3 of the distance dwn the rwy.Accident 19730712020069ACessna 172G · Chester, MTAccident 19730608014169ACessna 172G · Edgewater Park, NYAbout 4 gal ea tank bfor tkof. Unusable fuel 3 gal.Accident 19730527013239ACessna 172G · Overton, NVHit post while parking acft. 1st solo x-c.Accident 19730525017609ACessna 172G · Elton, PAEnctrd deteriorating wx cond un cont flt VFR.rqsd fss assist. Un provide due otr emgcy. Wpafb brief.Accident 19730518016369ACessna 172G · Belle Glade, FLPlt did not consider length of sod surface,g/w of the acft and lack of wind. Atmtd turn l due ditchAccident 19730518011859ACessna 172G · Braithwaite, LAPlt on 2nd solo flt,1st from fld involved. Hit pwr lines aprx 30FT hi abt 350FT short of rwy.Accident 19730517013079ACessna 172G · Wilmot, WIWind nw lndd rwy 18 ovr-ran end of rwy hit tree. Gusting to 20K.Accident 19730508014009ACessna 172G · Madras, ORWind shifted to a tailwind.Accident 19730428008579ACessna 172G · Santa Ana, CATaxied behind B-737 moving across rwy.Accident 19730315004669ACessna 172G · Romulus, MIPlt rcvd gusty wind fcst. Drg taxi to ramp area wing lifted,acft turned ovr. Wind gusting 39K.Accident 19730217003269ACessna 172G · Moriarty, NMBecame airborne unexpectedly while taxiing fast to avoid getting stuck on rwy. Lndg gear mud packedAccident 19730217003169ACessna 172G · Bellevue, WAPax switching seats,eng not shut down. Dark nite.Accident 19730210014499ACessna 172D · Ft.Lauderdale, FLWx brief by ATIS wind rptd 18K gusting 25K.wind gusting 40K at time of acdt.
Back to Cessna 172G