NTSB investigations: Cessna 172P
32 cases on aircraft the registry lists as Cessna 172P, where the defining event was 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
| 2008 | 5 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 5 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092'))
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 ('2072436')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '092'))
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 ERA24LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Moultonborough, NHThe student pilot’s improper remedial response to a bounced landing, which resulted in a hard landing.NTSB WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB WPR22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Portland, ORThe pilot under instruction’s improper landing flare, and the flight instructor’s delayed remedial action.NTSB ERA22LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Kennesaw, GAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB WPR21LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Tucson, AZThe student pilot’s improper pitch control and landing flare, which resulted in a hard bounce and subsequent porpoised landing.NTSB CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.NTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.NTSB ERA17LA319Accident · No injuriesLimited investigationFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA16CA064Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe student pilot's improper flare during landing, which resulted in a bounced landing, and a runway excursion.NTSB GAA16CA047Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing.NTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.NTSB GAA15CA058Accident · No injuriesData collectionFinal reportCessna 172P · TamuningThe student pilot's failure to maintain pitch control, resulting in a hard landing.NTSB ERA15CA153Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe student pilot's failure to maintain aircraft control during landing, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.NTSB ERA13CA146Accident · No injuriesData collectionFinal reportCessna 172P · Valparaiso, FLThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.NTSB ERA12CA579Accident · No injuriesData collectionFinal reportCessna 172P · Richmond, KYThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.NTSB WPR12CA204Accident · No injuriesData collectionFinal reportCessna 172P · Spokane, WAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA10CA208Accident · No injuriesData collectionFinal reportCessna 172P · Ft. Pierce, FLThe student pilot's improper flare and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB ERA10CA213Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot’s improper flare and recovery from a bounced landing.NTSB ERA10CA143Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare during landing.NTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR09CA209Accident · No injuriesData collectionFinal reportCessna 172P · Livermore, CAThe student pilot’s improper recovery from a bounced landing.NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB LAX08CA163Accident · No injuriesData collectionFinal reportCessna 172P · Bremerton, WAThe student pilot's inadequate recovery from a bounced landing.NTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.NTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.NTSB NYC08CA103Accident · No injuriesData collectionFinal reportCessna 172P · Gainesville, FLThe pilot's improper flare.