NTSB investigations: Cessna 172G, CA
59 cases on aircraft the registry lists as Cessna 172G. 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
| 1966 | 6 |
|---|---|
| 1967 | 11 |
| 1968 | 4 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 6 |
| 1972 | 2 |
| 1973 | 2 |
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 3 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2013 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 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 ('2072420'))
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 ('2072420'))
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 WPR25LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxnard, CAThe student pilot’s failure to maintain directional control during landing roll.NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB WPR22LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Van Nuys, CAThe student pilot’s failure to maintain sufficient distance behind a jet airplane which, resulted in his loss of airplane control due to the jet airplane’s jet blast and the flight instructor’s delayed remedial action.NTSB WPR21LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Washington, CAA total loss of engine power during an enroute climb due to a stuck exhaust valve and multiple failed piston compression rings.NTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.NTSB WPR13CA163Accident · Minor injuriesData collectionFinal reportCessna 172G · Temecula, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB LAX01LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Lancaster, CAThe pilot's delay reversing course while flying toward rising terrain in a box canyon. Factors in the accident included a downdraft on the lee side of a ridge forming the box canyon, high density altitude, and the pilot's improper use of flaps.NTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.NTSB LAX97LA054Accident · No injuriesLimited investigationFinal reportCessna 172G · Chino, CAthe pilot's attempt to taxi with a crosswind component well in excess of the aircraft's maximum factory demonstrated capability. The wind conditions were factors.NTSB LAX96LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Ocotillo Wells, CAthe failure of the pilot to maintain a proper glide path on final approach.NTSB LAX95LA101Accident · 1 fatalLimited investigationFinal reportCessna 172G · Pope Valley, CAthe pilot's poor judgment to buzz the lake and his inadequate visual lookout.NTSB LAX94LA359Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Corona, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion and the rough terrain were factors in this accident.NTSB LAX93LA345Accident · No injuriesLimited investigationFinal reportCessna 172G · Avalon, CAthe oil starvation related failure of the number 1 and 2 connecting rods due to improper torque of the crankcase through bolts at the number 2 cylinder, which allowed fretting of the bearing surfaces and the resulting closure of the oil ports. The under…NTSB LAX90LA270Accident · No injuriesLimited investigationFinal reportCessna 172G · Trinity Center, CAThe pilot's excessive airspeed and his failure to touchdown at the proper location on the runway.NTSB LAX88FA161Accident · 4 fatalField investigationFinal reportCessna 172G · Los Banos, CAFailure of the pilot to maintain control of his aircraft to avert a collision with the ground.NTSB LAX85LA149Accident · No injuriesLimited investigationFinal reportCessna 172G · Mojave, CAPrior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position.NTSB LAX84LA111Accident · No injuriesLimited investigationFinal reportCessna 172G · Macdoel, CAThe acft collided with trees during landing rollout. The plt said he thought the wind was 'southerly at about 20 kts'. He stated that while flaring for landing on rwy 15 a stront gust estimated at 40 KTS was encountered & the acft drifted off the 40 ft wide…NTSB LAX83FA295Accident · Serious injuriesField investigationFinal reportCessna 172G · Huntington Bch, CAThe plt-in-command (PIC) & student plt were on an aerial photography flt when the PIC noticed a loss of eng oil pressure. They saw meadowlark arpt & began an emergency apch. The PIC stated that she relinquished her PIC duties to the student because she…NTSB LAX83LA110Accident · No injuriesLimited investigationFinal reportCessna 172G · Antioch, CAAccording to the left seat pilot the engine sputtered at 2200 RPM and quit. There were wires obstructing the field selected for landing. The acft went under most of them but clipped one service electric line. The acft landed & rolled about 75 feet before…NTSB LAX80FA032Accident · 2 fatalClosedCessna 172 · Coalinga, CANTSB LAX79FUG22Accident · No injuriesClosedCessna 172G · Apple Valley, CANTSB LAX79FA016Accident · 1 fatalClosedCessna 172G · Cuyamaca, CANTSB OAK75FVD43Accident · Minor injuriesClosedCessna 172G · Sonoma, CANTSB OAK74AP017Accident · 1 fatalClosedCessna 172G · Bass Lake, CANTSB LAX73FUA41Accident · No injuriesClosedCessna 172 · Santa Ana, CANTSB LAX72AL065Accident · 2 fatalClosedCessna 172 · La Mesa, CANTSB LAX72DVA68Accident · Minor injuriesClosedCessna 172 · Olancha, CANTSB LAX72FUG21Accident · Minor injuriesClosedCessna 172 · D.Hot Sprgs, CANTSB OAK72DVG14Accident · No injuriesClosedCessna 172 · Auburn, CANTSB OAK71AP040Accident · 2 fatalClosedCessna 172 · Sacramento, CANTSB OAK71FVA64Accident · Serious injuriesClosedCessna 172G · Fresno, CANTSB LAX71FUD11Accident · No injuriesClosedCessna 172 · Santa Monca, CANTSB OAK71DVA60Accident · No injuriesClosedCessna 172 · Dinuba, CANTSB LAX71DVM25Accident · No injuriesClosedCessna 172 · Atascadero, CANTSB OAK70FVA17Accident · No injuriesClosedCessna 172G · Tulare, CANTSB LAX70I0002Incident · No injuriesClosedCessna 172 · San Fernando, CANTSB LAX69A0069Accident · 3 fatalClosedCessna 172G · Bg Bear Cty, CANTSB OAK69D0300Accident · No injuriesClosedCessna 172 · Death Vally, CANTSB OAK69D0022Accident · No injuriesClosedCessna 172 · Morro Bay, CANTSB LAX68A0108Accident · 4 fatalClosedCessna 172 · Forrest Homes, CANTSB LAX69F0291Accident · Serious injuriesClosedCessna 172G · Inyokern, CANTSB LAX68F0417Accident · Minor injuriesClosedCessna 172 · Huntingtn Bch, CANTSB OAK68D0268Accident · Minor injuriesClosedCessna 172G · Susanville, CANTSB OAK68F0130Accident · No injuriesClosedCessna 172 · Fresno, CANTSB OAK68F0090Accident · Minor injuriesClosedCessna 172 · Columbia, CANTSB OAK68D0222Accident · No injuriesClosedCessna 172 · Auburn, CANTSB LAX68D0093Accident · No injuriesClosedCessna 172 · Lancaster, CANTSB LAX67D0410Accident · No injuriesClosedCessna 172 · Inyokern, CANTSB OAK67D0290Accident · No injuriesClosedCessna 172 · San Carlos, CANTSB DEN67D0227Accident · No injuriesClosedCessna 172G · Montrose, CA