NTSB investigations: Cessna 172S
102 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, 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\" = '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.
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" = '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" 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.
NTSB GAA16CA134Accident · No injuriesData collectionFinal reportCessna 172 · Newport News, VAThe student pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and impact with terrain.NTSB GAA16CA104Accident · No injuriesData collectionFinal reportCessna 172 · Dothan, ALThe pilot-rated student's hard landing, which resulted in fuselage damage.NTSB GAA15CA237Accident · No injuriesData collectionFinal reportCessna 172 · Springfield, OHThe pilot's improper pitch control during landing, which resulted in a hard landing.NTSB GAA15CA140Accident · No injuriesData collectionFinal reportCessna 172 - S · Traverse City, MIThe student pilot's failure to maintain pitch control during the landing, resulting in a hard landing.NTSB GAA15CA046Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain airplane control, resulting in a hard landing.NTSB ERA15CA150Accident · No injuriesData collectionFinal reportCessna 172S · Richmond, VAThe student pilot's inadequate landing flare which resulted in a hard landing and substantial damage to the airplane.NTSB ERA14CA452Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's self-induced pressure to land due to the deteriorating weather conditions.NTSB ERA14CA273Accident · No injuriesData collectionFinal reportCessna 172S · Harrisburg, PAThe pilot's failure to compensate for wind conditions during landing, which resulted in a hard landing.NTSB CEN14CA191Accident · No injuriesData collectionFinal reportCessna 172S · Albuquerque, NMThe student pilot's improper flare that resulted in a bounced landing.NTSB ERA14CA109Accident · No injuriesData collectionFinal reportCessna 172S · Immokalee, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.NTSB 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.NTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.NTSB ERA13CA335Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna Beach, FLThe student pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB WPR13CA332Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbra, CAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB 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.NTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.NTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA12CA569Accident · No injuriesData collectionFinal reportCessna 172S · Farmingdale, NYThe student pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12CA426Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate landing flare, which resulted in a hard landing.NTSB ERA12CA439Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.NTSB ERA11CA516Accident · No injuriesData collectionFinal reportCessna 172S · Westminster, MDThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control. Contributing to the accident was the pilot's improper approach airspeed for a short-field landing.NTSB CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.NTSB 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.NTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB CEN10LA563Accident · No injuriesLimited investigationFinal reportCessna 172S · Longmont, COThe pilot's inadequate landing flare and improper recovery from a bounced landing.NTSB ERA10CA468Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDUndetermined.NTSB WPR10CA475Accident · No injuriesData collectionFinal reportCessna 172S · Santa Maria, CAThe pilot's inadequate flare which resulted in a bounce and hard landing.NTSB ERA10CA398Accident · No injuriesData collectionFinal reportCessna 172 · White Plains, NYThe student pilot's improper landing flare and the flight instructor's delayed remedial action resulting in a bounced landing.NTSB ERA10CA363Accident · No injuriesData collectionFinal reportCessna 172S · Chesapeake, VAA hard landing by person(s)unknown.NTSB ERA10CA326Accident · No injuriesData collectionFinal reportCessna 172 · New Smyrna Beach, FLThe student pilot’s improper landing flare, and the flight instructor's delayed remedial action.NTSB 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.NTSB CEN10CA289Accident · No injuriesData collectionFinal reportCessna 172S · Greenfield, INThe pilot's improper landing flare and recovery from a bounced landing.NTSB WPR10CA238Accident · No injuriesData collectionFinal reportCessna 172S · Corvallis, ORThe pilot's improper use of the flight and engine controls, resulting in a bounced landing.NTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.NTSB CEN10CA163Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot's failure to maintain an appropriate glide path during approach. Contributing to the accident was the student pilot's decision to continue the approach instead of going around.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.NTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB NYC08CA282Accident · No injuriesData collectionFinal reportCessna 172 · Charlottesville, VAThe pilot's improper flare while landing. Contributing to the accident was the gusty wind condition.NTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.NTSB NYC08CA214Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper flare.NTSB MIA08CA111Accident · No injuriesData collectionFinal reportCessna 172S · Kissimmee, FLThe pilot's improper landing flare.NTSB 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.NTSB 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.