NTSB investigations: Cessna 172S

117 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Collision with terr/obj (non-CFIT). 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 ('2072439', '2072442')
      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\" = '470' 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 GAA16CA295Accident · No injuriesData collectionFinal reportCessna 172 · Thomson, GAThe student pilot's incorrect landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing, nose wheel collapse, and runway excursion.Jun 8, 2016 · N124CK · Substantial damageNTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.Jun 5, 2016 · N124ME · Substantial damageNTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.May 14, 2016 · N917CP · Substantial damageNTSB GAA16CA219Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain pitch control during the landing flare, which resulted in an abnormal runway contact, porpoise, nose gear collapse, runway excursion, and impact with terrain.May 2, 2016 · N509ND · Substantial damageNTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.Jan 2, 2016 · N947SP · Substantial damageNTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.Dec 29, 2015 · N914CP · DestroyedNTSB ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.Oct 10, 2015 · N5295Y · Substantial damageNTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…Sep 21, 2015 · N347SP · Substantial damageNTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.Jul 19, 2015 · N962SP · Substantial damageNTSB ERA15LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Norfolk, VAThe engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.Jan 6, 2015 · N2102P · Substantial damageNTSB WPR15LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Big Bear, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Oct 16, 2014 · N612SP · Substantial damageNTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.Oct 5, 2014 · N2179L · Substantial damageNTSB ERA14CA317Accident · Minor injuriesData collectionFinal reportCessna 172S · Orlando, FLThe flight instructor's failure to maintain control while taxiing in a strong gusty wind.Jun 29, 2014 · N775SP · Substantial damageNTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…Jun 10, 2014 · N5524L · DestroyedNTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.Feb 17, 2014 · N426SP · Substantial damageNTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.Feb 15, 2014 · N2143X · Substantial damageNTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.Nov 24, 2013 · N113SF · Substantial damageNTSB ERA14CA106Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.Nov 16, 2013 · N873EF · Substantial damageNTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.Aug 3, 2013 · N645PD · Substantial damageNTSB CEN13LA348Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.Jun 13, 2013 · N552ND · Substantial damageNTSB WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.May 31, 2013 · N327PA · 2 aircraft · Substantial damageNTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.Feb 7, 2013 · N328SP · DestroyedNTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.Dec 2, 2012 · N3554Y · Substantial damageNTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.Aug 3, 2012 · N6276Z · Substantial damageNTSB ERA12LA445Accident · No injuriesLimited investigationFinal reportCessna 172S · Allentown, PAThe student pilot's failure to maintain directional control during a touch-and-go takeoff, which resulted in a runway excursion and a subsequent impact with a gopher hole, and the flight instructor's inadequate supervision of the student pilot and his delayed…Jul 9, 2012 · N680MA · Substantial damageNTSB WPR12CA251Accident · No injuriesData collectionFinal reportCessna 172S · Bend, ORThe pilot’s inadequate crosswind correction, which resulted in a loss of airplane control and runway excursion into a berm.Jun 9, 2012 · N698SP · Substantial damageNTSB WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.May 27, 2012 · N21718 · Substantial damageNTSB ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.May 27, 2012 · N787LF · Substantial damageNTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.Apr 12, 2012 · N17304 · Substantial damageNTSB ERA12LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLA total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.Apr 9, 2012 · N375LP · Substantial damageNTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.Mar 29, 2012 · N480SP · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.Feb 18, 2012 · N506SP · Substantial damageNTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.Nov 12, 2011 · N24350 · Substantial damageNTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.Sep 26, 2011 · N169ME · Substantial damageNTSB WPR11CA440Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll.Sep 8, 2011 · N5275S · Substantial damageNTSB ERA11CA343Accident · No injuriesData collectionFinal reportCessna 172S · Covington, GAThe pilot's failure to maintain directional control during takeoff.Jun 14, 2011 · N6026P · DestroyedNTSB WPR11LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Payson, AZThe pilot's decision to conduct a touch-and-go arrival during his first flight to a high elevation airport, which resulted in an improper mixture adjustment and a partial loss of engine power for the takeoff and attempted climbout.Apr 16, 2011 · N1835U · Substantial damageNTSB ERA11CA244Accident · No injuriesData collectionFinal reportCessna 172S · Saint Petersburg, FLThe failure of the student pilot to maintain directional control during a touch-and-go landing.Apr 13, 2011 · N2468Z · Substantial damageNTSB ERA11FA146Accident · 2 fatalField investigationFinal reportCessna 172S · New Smyrna Beach, FLThe flight instructor's failure to recognize or implement adequate remedial action to counter the effects of spatial disorientation. Contributing to the accident was the spatial disorientation experienced by one or both pilots.Feb 16, 2011 · N6345L · Substantial damageNTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.Jan 29, 2011 · N6013J · Substantial damageNTSB ERA11FA118Accident · 2 fatalField investigationFinal reportCessna 172S · North Myrtle Beach, SCThe pilot's loss of airplane control during a missed approach due to spatial disorientation.Jan 18, 2011 · N2100V · Substantial damageNTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.Dec 23, 2010 · N385ME · Substantial damageNTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.Nov 1, 2010 · N3542V · Substantial damageNTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.Jul 13, 2010 · N295SP · Substantial damageNTSB CEN10LA381Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Goddard, KSThe pilot did not maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s poor preflight planning.Jul 9, 2010 · N919YA · Substantial damageNTSB ERA10CA326Accident · No injuriesData collectionFinal reportCessna 172 · New Smyrna Beach, FLThe student pilot’s improper landing flare, and the flight instructor's delayed remedial action.Jun 9, 2010 · N62568 · Substantial damageNTSB WPR10CA230Accident · No injuriesData collectionFinal reportCessna 172S · Palo Alto, CAThe student pilot's failure to maintain directional control and the certified flight instructor’s delayed response to the student pilot's loss of control during the takeoff roll.May 3, 2010 · N796SP · Substantial damageNTSB ERA10LA105Accident · 1 fatalLimited investigationFinal reportCessna 172S · Greenbush, METhe pilot's improper decision to attempt a transoceanic flight in turbulent, icing conditions, with an overweight airplane that was not approved for moderate turbulence and not equipped with deicing systems. Contributing to the accident was the pilot's…Jan 4, 2010 · N5118J · Substantial damage