NTSB investigations: Cessna 172S

77 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Abnormal runway contact. 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\" = '090' 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 GAA15CA026Accident · No injuriesData collectionFinal reportCessna 172S · Vernal, UTThe student pilot's failure to maintain attitude control during landing flare.Mar 28, 2015 · N2168D · Substantial damageNTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.Oct 23, 2014 · N564AT · Substantial damageNTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.Aug 16, 2014 · N10033 · Substantial damageNTSB CEN14CA187Accident · No injuriesData collectionFinal reportCessna 172 · Larimore, NDFailure of the pilot to attain and maintain sufficient control inputs to compensate for the crosswind. Contributing to the accident was the flight instructor's failure to adequately monitor the pilot and the flight.Apr 5, 2014 · N510ND · Substantial damageNTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.Dec 24, 2013 · N17223 · Substantial damageNTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.Aug 29, 2013 · N6065P · Substantial damageNTSB CEN13CA498Accident · No injuriesData collectionFinal reportCessna 172S · Indianapolis, INThe pilot's inadequate monitoring on the airplane's airspeed during the go-around, resulting in a stall.Aug 21, 2013 · N45EF · 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 WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.Apr 26, 2012 · N320ME · Substantial damageNTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.Apr 10, 2012 · N5253Q · Substantial damageNTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.Feb 2, 2012 · N5026C · Substantial damageNTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.Jul 1, 2011 · N789EP · Substantial damageNTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.Jun 13, 2011 · N539ND · Substantial damageNTSB ERA10CA350Accident · No injuriesData collectionFinal reportCessna 172S · Salisbury, MDThe student pilot's improper recovery from a bounced landing.Jun 25, 2010 · N2373K · Substantial damageNTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.Jun 4, 2010 · N789EP · Substantial damageNTSB CEN10CA289Accident · No injuriesData collectionFinal reportCessna 172S · Greenfield, INThe pilot's improper landing flare and recovery from a bounced landing.Jun 1, 2010 · N1448Z · Substantial damageNTSB ERA10CA282Accident · No injuriesData collectionFinal reportCessna 172S · Jekyll Island, GAThe pilot's loss of airplane control while landing with a crosswind.May 16, 2010 · N53039 · Substantial damageNTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.Oct 20, 2009 · N519ND · Substantial damageNTSB CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.Sep 13, 2009 · N523ND · Substantial damageNTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.Sep 7, 2009 · N568ND · Substantial damageNTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.Aug 4, 2009 · N401LP · Substantial damageNTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.Jul 2, 2009 · N538ND · Substantial damageNTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.Jul 2, 2009 · N525ND · Substantial damageNTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.Apr 13, 2009 · N144ME · Substantial damageNTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.Oct 6, 2008 · N6048Z · Substantial damageNTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.Apr 20, 2008 · N375LP · Substantial damageNTSB NYC08CA118Accident · No injuriesData collectionFinal reportCessna 172SP · Lincoln Park, NJThe certificated flight instructor's delayed decision to go-around.Mar 2, 2008 · N107MA · Substantial damage