NTSB investigations: Cessna 172, CA
113 cases on aircraft the registry lists as Cessna 172. 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
| 1964 | 7 |
|---|---|
| 1965 | 8 |
| 1966 | 7 |
| 1967 | 7 |
| 1968 | 8 |
| 1969 | 6 |
| 1970 | 4 |
| 1971 | 5 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 7 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 2 |
| 1996 | 2 |
| 1999 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 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.\"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 ('2072402'))
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 ('2072402'))
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 ANC24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Huasna, CAThe pilot’s failure to maintain adequate airspeed during a low altitude maneuver, resulting in a loss of control.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…NTSB WPR12CA153Accident · Minor injuriesData collectionFinal reportCessna 172 · Johnson Valley, CAThe pilot did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane.NTSB WPR11CA152Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, CAThe student pilot's improper flare which resulted in a hard landing. Contributing to the accident was the certified flight instructor's delayed remedial action.NTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.NTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.NTSB WPR09LA056Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lompoc, CAThe pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.NTSB LAX08CA164Accident · Minor injuriesData collectionFinal reportCessna 172 · Santa Rosa, CAThe pilot's improper in-flight decision making and inadequate fuel consumption calculations that resulted in fuel exhaustion.NTSB SEA07LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Chiriaco Summit, CAEngine fire during start-up for undetermined reasons.NTSB LAX06LA064Accident · 4 fatalLimited investigationFinal reportCessna 172 · Gilroy, CAThe non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…NTSB LAX99LA217Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Needles, CAThe pilot's inadequate compensation for the gusty crosswind condition and subsequent failure to maintain alignment with the road used for takeoff, which resulted in a collision with a construction sign during the initial climb.NTSB LAX97LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Bear City, CAthe pilot's inadequate compensation for the wind condition, and his failure to maintain alignment with the runway. The gusty crosswind was a related factor.NTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.NTSB LAX94LA250Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Suisun City, CAundetermined.NTSB LAX94LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAthe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited experience in conventional gear aircraft.NTSB LAX92LA407Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAThe student pilot's failure to maintain directional control. Contributing to this accident was the student's pilot total lack of experience and the crosswind.NTSB LAX91LA318Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chico, CAThe pilot's improper starting procedure.NTSB LAX91FA247Accident · 1 fatalField investigationFinal reportCessna C-172 · Lakeside, CAThe failure of the pilot to request radar assistance to avoid low ceilings in high terrain and the pilot's inadequate visual outlook which ultimately resulted in an inflight collision with high terrain. Contributing to the accident were the weather conditions…NTSB LAX91FA103Accident · Serious injuriesField investigationFinal reportCessna 172 · Bullhead City, CAThe pilot's poor in-flight planning and decision and physical impairment from fatigue; he also failed to maintain flying speed. The lineman's failure to secure the access door and the pilot's impairment due to consumption of alcohol were factors in the…NTSB LAX90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · California City, CAThe pilot's improper landing flare. A factor related to accident was the gusty wind condition.NTSB LAX90LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Byron, CAThe pilot's failure to maintain sufficient terrain clearance altitude during a low altitude turn. Contributing to the accident was the pilot's poor judgement in conducting touch-and-go landings with a 700-foot ceiling.NTSB LAX89FA182Accident · 3 fatalField investigationFinal reportCessna 172 · Industry, CAThe failure of the pilot to maintain an adequate altitude to ensure obstruction clearance. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's continued flight into adverse weather conditions.NTSB LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 172 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.NTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…NTSB LAX86LA334Accident · No injuriesLimited investigationFinal reportCessna 172 · Oroville, CAThe pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They…NTSB LAX86LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, CAThe pilot reported that he experienced a loss of power shortly after leveling off at about 1,000 MSL. The power loss was smooth and rapid. During the subsequent forced landing roll-out, the acft nosed over onto its back. Post accident investigation disclosed…NTSB LAX85FVA02Accident · Serious injuriesFinal reportCessna 172 · Santa Nella, CAWitnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.NTSB LAX84IA448Incident · No injuriesIncident investigationFinal reportCessna 172 · Redding, CAPlt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.NTSB LAX84LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague, CAAn improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &…NTSB LAX83LA391Accident · No injuriesLimited investigationFinal reportCessna 172 · Herndon, CAThe pilot reported that the approach and landing were normal. During rollout, the acft's landing light failed and the pilot was unable to see well enough to maintain his course on the rwy. The acft veered off the left side onto soft terrain and the nose gear…NTSB LAX82DA197Accident · No injuriesFinal reportCessna 172 · Fresno, CAThe acft landed hard, bounced, veered left & collided with a parked acft. The CFI recognized that the approach speed wastoo slow & waited too long before taking over. A deliberate turn was made to avoid residences.NTSB LAX82FVD05Accident · No injuriesClosedCessna 172 · Ukiah, CANTSB LAX81AA119Accident · 1 fatalClosedPiper PA-28R · San Jose, CANTSB LAX81FVD32Accident · Serious injuriesClosedCessna 172 · Santa Rosa, CANTSB LAX81DVM25Accident · No injuriesClosedBolen 172 · San Jose, CANTSB LAX81FVD22Accident · No injuriesClosedCessna 172 · Novato, CANTSB LAX81FA081Accident · 1 fatalClosedCessna 172 · Claremont, CANTSB LAX81FUA03Accident · No injuriesClosedCessna 172 · Fullerton, CANTSB LAX80DVA61Accident · No injuriesClosedCessna 172 · Visalia, CANTSB LAX80FVA57Accident · Minor injuriesClosedCessna 172M · Columbia, CANTSB LAX80FV602Accident · No injuriesClosedCessna 172 · Fair Oaks, CANTSB LAX79FA076Accident · 1 fatalClosedCessna 172 · Lancaster, CANTSB LAX79FUQ25Accident · No injuriesClosedCessna 172 · Simi Valley, CANTSB LAX80FA051Accident · 3 fatalClosedCessna 172 · Eureka, CANTSB LAX78DUG33Accident · No injuriesClosedCessna 172 · Fontana, CANTSB LAX77FUG59Accident · No injuriesClosedCessna 172 · Joshua Tree, CANTSB LAX77DUG32Accident · Minor injuriesClosedCessna 172 · Blythe, CANTSB OAK77DVG18Accident · Serious injuriesClosedCessna 172 · Dunsmuir, CANTSB LAX77FUG07Accident · No injuriesClosedCessna 172 · Perris, CA