NTSB investigations: Cessna 172R, CA
18 cases on aircraft the registry lists as Cessna 172R. 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
| 1999 | 1 |
|---|---|
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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 WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…NTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR20CA219Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Concord, CAThe student pilot's failure to maintain airplane control when the airplane drifted off of runway centerline and subsequently collided with a taxiway sign during a go-around.NTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.NTSB WPR11CA472Accident · No injuriesData collectionFinal reportCessna 172R · Napa, CAThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB WPR09LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Oceanside, CAA total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.NTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX08LA121Accident · No injuriesLimited investigationFinal reportCessna 172R · S. Lake Tahoe, CAThe pilot's improper flare and subsequent hard landing. Contributing to the accident were the gusty winds and the high density altitude.NTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.NTSB LAX04LA027Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · San Diego, CAthe pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.NTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.NTSB LAX02LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Camarillo, CAThe pilot's failure to maintain directional control.NTSB LAX99LA185Accident · No injuriesLimited investigationFinal reportCessna 172R · Imperial, CAThe pilot's misjudged landing flare, which led to an inadvertent porpoise condition.