NTSB investigations: Cessna 172S, 2008

10 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Hard landing. 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 per year

20082026
NTSB investigations: Cessna 172S, 2008 per year, 2008–2026: 102 cases
200810
20094
201012
20114
20125
20137
20144
20154
201612
20177
20184
20196
20205
20214
20221
20235
20241
20255
20262

Latest cases

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 year(c.\"eventDate\") = 2008
    AND 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\" = '092' 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 ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.Nov 1, 2008 · N2055R · 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 NYC08CA282Accident · No injuriesData collectionFinal reportCessna 172 · Charlottesville, VAThe pilot's improper flare while landing. Contributing to the accident was the gusty wind condition.Aug 10, 2008 · N5210A · Substantial damageNTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.Aug 9, 2008 · N1600U · Substantial damageNTSB NYC08CA214Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper flare.Jun 13, 2008 · N65939 · Substantial damageNTSB MIA08CA111Accident · No injuriesData collectionFinal reportCessna 172S · Kissimmee, FLThe pilot's improper landing flare.May 24, 2008 · N716SP · Substantial damageNTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.May 7, 2008 · N513JG · Substantial damageNTSB LAX08CA124Accident · No injuriesData collectionFinal reportCessna 172S · San Luis Obispo, CAThe pilot's inadequate landing flare, resulting in a hard landing. Contributing to the accident was the gusty wind condition.Apr 7, 2008 · N65630 · Substantial damageNTSB MIA08CA056Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilot's inadequate recovery from a bounced landing.Feb 15, 2008 · N618VT · Substantial damageNTSB MIA08CA068Accident · No injuriesData collectionFinal reportCessna 172S · Westiminster, MDThe student pilot's improper flare.Jan 26, 2008 · N65329 · Substantial damage