NTSB investigations: Cessna 172N

81 cases on aircraft the registry lists as Cessna 172N, where the sequence of events included Loss of control on ground. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" 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.

NTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.May 18, 2016 · N4668G · Substantial damageNTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.Apr 3, 2016 · N2124E · Substantial damageNTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.Dec 3, 2015 · N5185D · Substantial damageNTSB GAA15CA235Accident · No injuriesData collectionFinal reportCessna 172N · Kalispell, MTThe pilot's loss of directional control, which resulted in a runway excursion, and collision with runway and taxiway lights and terrain.Aug 19, 2015 · N733NH · Substantial damageNTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.Jun 26, 2015 · N3159E · Substantial damageNTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.Sep 30, 2014 · N738TJ · Substantial damageNTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.Mar 21, 2014 · N739RX · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.Jul 31, 2013 · N738RQ · Substantial damageNTSB WPR13LA299Accident · No injuriesLimited investigationFinal reportCessna 172 - N · Trout Lake, WAThe pilot's failure to maintain clearance from trees during takeoff from a soft field and to abort the landing when the airplane reached the runway’s midpoint at a low airspeed.Jun 28, 2013 · N75542 · Substantial damageNTSB ERA13CA202Accident · Minor injuriesData collectionFinal reportCessna 172N · Summersville, WVThe pilot's failure to maintain directional control of the airplane while landing, which resulted in a runway excursion.Apr 13, 2013 · N6136F · Substantial damageNTSB ERA13CA185Accident · No injuriesData collectionFinal reportCessna 172N · Bally, PAThe pilot's failure to maintain directional control during the takeoff roll.Mar 30, 2013 · N4601D · Substantial damageNTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.Nov 18, 2012 · N4811G · Substantial damageNTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.May 25, 2012 · N73743 · Substantial damageNTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.Dec 3, 2011 · N737ET · Substantial damageNTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.Apr 3, 2011 · N3484E · Substantial damageNTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.Mar 31, 2011 · N73836 · Substantial damageNTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.Feb 12, 2011 · N733TM · Substantial damageNTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.Jan 15, 2011 · N1946F · Substantial damageNTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.Nov 14, 2010 · N249ER · Substantial damageNTSB WPR11CA008Accident · No injuriesData collectionFinal reportCessna 172N · Salem, ORThe pilot's failure to maintain directional control during the landing roll.Oct 2, 2010 · N545DS · Substantial damageNTSB ERA10CA268Accident · No injuriesData collectionFinal reportCessna 172N · Blue Hill, METhe flight instructor’s inability to maintain directional control while landing with gusting winds.May 16, 2010 · N733XD · Substantial damageNTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.Apr 24, 2010 · N5371D · Substantial damageNTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.Apr 3, 2010 · N222UN · Substantial damageNTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Oct 7, 2009 · N2219E · Substantial damageNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB CEN09CA373Accident · Serious injuriesData collectionFinal reportCessna 172N · Marysville, OHThe pilot's inability to maintain directional control of the airplane during the landing roll for undetermined reasons.Jun 22, 2009 · N734EN · Substantial damageNTSB CEN09CA292Accident · No injuriesData collectionFinal reportCessna 172N · Springdale, ARThe student pilot's failure to maintain control of the airplane during the landing roll and subsequent go-around.May 12, 2009 · N73842 · Substantial damageNTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.Feb 26, 2009 · N737KR · Substantial damageNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.Jan 22, 2008 · N738UE · Substantial damage