NTSB investigations: Cessna 172L, CA
39 cases on aircraft the registry lists as Cessna 172L. 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
| 1971 | 1 |
|---|---|
| 1972 | 5 |
| 1973 | 5 |
| 1974 | 3 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2005 | 2 |
| 2015 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 3 |
| 2026 | 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 ('2072432'))
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 ('2072432'))
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 WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB WPR25LA004Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · El Monte, CAA total loss of engine power due to contaminated fuel.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.NTSB WPR22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172L · Ventura, CAA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve.NTSB WPR19LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Placerville, CAThe partial loss of engine power due to an improperly maintained carburetor.NTSB GAA16CA002Accident · No injuriesData collectionFinal reportCessna 172 · Avalon, CAThe pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.NTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX04LA089Accident · 1 fatalLimited investigationFinal reportCessna 172L · Vacaville, CAthe pilot's inadequate hand prop starting procedure.NTSB LAX03FA109Accident · 2 fatalField investigationFinal reportCessna 172L · Rosamond, CAthe pilot's failure to maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall and impact with flat level terrain. Also causal was the pilot's impaired judgment due to recent use of cocaine, and ethanol.NTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB LAX96LA134Accident · No injuriesLimited investigationFinal reportCessna 172L · Napa, CAthe failure of both pilots to see and avoid the other aircraft, and the failure of the pilot of the Cessna 172L, N7668G, to follow VFR procedures by not yielding the right of way to the Cessna 172M, N20858, which was already established in the traffic pattern.NTSB LAX93LA099Accident · No injuriesLimited investigationFinal reportCessna 172L · Ramona, CAA loss of engine power related to inadequate and improper maintenance practices concerning the carburetor.NTSB LAX91LA015Accident · No injuriesLimited investigationFinal reportCessna 172L · Placerville, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB LAX89LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Alturas, CAThe failure of the instructor pilot to maintain directional control of the airplane on the snow-covered runway, resulting in a nose-over when the airplane continued off the runway into deeper snow.NTSB LAX88LA326Accident · No injuriesLimited investigationFinal reportCessna 172L · Banning, CADuring a crosscountry flt, while enroute from lake havasu city, AZ, to Banning, CA, the engine experienced a loss of power. The airplane collided with the terrain after a forced landing. Inspection of the fuel system revealed there was no fuel on board.NTSB LAX85FA025Accident · Serious injuriesField investigationFinal reportCessna 172L · Westmoreland, CAAccording to the plt, he was descending to land at his intended when the acft encountered turbulence & the eng lost power. He was unable to restart the eng & subsequently landed in a freshly irregated field. During the landing, the acft touched down while…NTSB LAX82FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Meiners Oaks, CAWitnesses in a remote canyon reported an aircraft making low passes in that area. They last saw the plane going up the canyon. Later, the aircraft was located on a wall of the same canyon. Tests of the pilot's blood showed an alcohol level of .279 percent.…NTSB LAX82FUA05CaseClosedCessna 172 · Avalon, CANTSB LAX80DVG56Accident · No injuriesClosedCessna 172L · Grass Valley, CANTSB OAK77FA031Accident · 1 fatalClosedCessna 150L · Gilroy, CANTSB LAX76DUG57Accident · No injuriesClosedCessna 172 · Palo Verde, CANTSB LAX75DUG49Accident · No injuriesClosedCessna 172 · Phelan, CANTSB OAK75AP030Accident · 2 fatalClosedCessna 172L · 3 Rivers, CANTSB LAX75DUQ03Accident · Minor injuriesClosedCessna 172L · Rosamond, CANTSB OAK74AP033Accident · 2 fatalClosedCessna 172L · San Ramon, CANTSB LAX74AL011Accident · 1 fatalClosedCessna 172L · Sylmar, CANTSB LAX74AL023Accident · 4 fatalClosedCessna 172L · Descanso, CANTSB OAK74DXQ06Accident · No injuriesClosedCessna 172 · Mammoth Lks, CANTSB LAX74FUQ03Accident · No injuriesClosedCessna 172 · Santa Ynez, CANTSB LAX73AL031Accident · 4 fatalClosedCessna 172 · San Luis Ob, CANTSB OAK73DVG22Accident · No injuriesClosedCessna 172 · Vacaville, CANTSB LAX73AL004Accident · 3 fatalClosedCessna 172 · La Jolla, CANTSB OAK72FVM36Accident · Serious injuriesClosedCessna 172L · Bonny Doon, CANTSB OAK72DVM35Accident · No injuriesClosedCessna 172 · San Jose, CANTSB OAK72DVA65Accident · No injuriesClosedCessna 172 · Dunlap, CANTSB OAK71DVA79Accident · No injuriesClosedCessna 172 · Fresno, CA