Skip to content

NTSB investigations: Cessna 172H, CA

64 cases on aircraft the registry lists as Cessna 172H. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('2072424')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072424'))
  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 ('2072424'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR23LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Santa Rosa, CAThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel exhaustion.Aug 19, 2023 · N3282L · Substantial damage NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…Jan 9, 2022 · N8056L · Substantial damage NTSB WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.Jan 6, 2020 · N1658F · Substantial damage NTSB LAX02LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Weed, CAThe pilot's failure to follow adequate hand propping engine starting procedures.Sep 22, 2002 · N2469L · Substantial damage NTSB LAX01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172H · San Diego, CAThe pilot's inadequate preflight planning and weather evaluation that resulted in the inadvertant entry into instrument meteorological conditions while conducting visual flight. A factor was fog and the night visual conditions.Dec 12, 2000 · N4959R · Substantial damage NTSB LAX98LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mariposa, CAFuel exhaustion due to the pilot's inadequate preflight planning, and improper in-flight decision not to make a precautionary landing for additional fuel.Jun 5, 1998 · N2573L · Substantial damage NTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.Feb 14, 1997 · N3757F · Substantial damage NTSB LAX96LA026Accident · No injuriesLimited investigationFinal reportCessna 172H · Borrego Springs, CAthe pilot's inadequate preflight inspection which failed to detect a bird's nest in the air induction system. Factors in the accident were carburetor icing conditions and the pilot's improper use of carburetor heat.Oct 28, 1995 · N2552L · Substantial damage NTSB LAX94LA039Accident · No injuriesLimited investigationFinal reportBoeing PT-13D · Half Moon Bay, CAImproper planning/decision by the pilot of the second stearman, and his selection of the wrong runway on which to land. A factor related to the accident was: failure of the stearman pilots to obtain pertinent NOTAM information.Nov 6, 1993 · N14FR · 2 aircraft · Substantial damage NTSB LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.Jun 13, 1992 · N8014L · Substantial damage NTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.Jan 8, 1992 · N1608F · Substantial damage NTSB LAX91LA345Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Elsinore, CAThe pilot's poor judgement for unwarranted low flying and poor visual lookout.Aug 4, 1991 · N2457L · Substantial damage NTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.Aug 6, 1989 · N2667L · Destroyed NTSB LAX86LA232Accident · No injuriesLimited investigationFinal reportCessna 172 · Huntington Bch, CAThe acft contacted a parked car and a hangar following a loss of control during an attempted go-around. The plt reported the acft was high and fast on final apch. He selected full flaps and a nose up attitude to lose airspeed and alt. He flared the acft at 20…May 24, 1986 · N172HW · Substantial damage NTSB LAX85LA009Accident · No injuriesLimited investigationFinal reportCessna 172H · Long Beach, CAThe plt said that after he returned to the arpt for a night landing, he applied back pressure during the flare, then heard the stall warning horn. Subsequently, the acft was damaged when it landed hard & bounced. However, the plt was able to taxi to the…Oct 9, 1984 · N8048L · Substantial damage NTSB LAX80DVG09Accident · No injuriesClosedCessna 172 · Sacramento, CADec 10, 1979 · N8173L · Substantial damage NTSB LAX79FUQ30Accident · No injuriesClosedCessna 172 · Santa Barbara, CAMay 20, 1979 · N3711R · Substantial damage NTSB OAK79DVW08Accident · Serious injuriesClosedCessna 172 · Independence, CAFeb 3, 1979 · N1604F · Destroyed NTSB OAK78DVD58Accident · No injuriesClosedCessna 172 · Santa Rosa, CASep 29, 1978 · N3758F · 2 aircraft · Substantial damage NTSB OAK77DX012Accident · No injuriesClosedCessna 172H · Beckwourth, CAMar 20, 1977 · N8099L · Substantial damage NTSB OAK76AP053Accident · 3 fatalClosedCessna 172H · Hollister, CAMay 16, 1976 · N3744R · Destroyed NTSB OAK76DVD22Accident · Minor injuriesClosedCessna 172 · Ft Bragg, CAFeb 7, 1976 · N2868L · Substantial damage NTSB OAK7LDVA04Accident · No injuriesClosedCessna 172H · Oakdale, CAJul 25, 1975 · N2753L · Substantial damage NTSB /AK75FVA67Accident · No injuriesClosedCessna 172H · Merced, CAJun 7, 1975 · N8103L · Substantial damage NTSB OAK75DVG51Accident · No injuriesClosedCessna 172 · Sacramento, CAMar 25, 1975 · N8100L · Substantial damage NTSB LAX75AL037Accident · 2 fatalClosedCessna 172H · Bakersfield, CAJan 31, 1975 · N8043L · Destroyed NTSB OAK73DVG39Accident · No injuriesClosedCessna 172H · Nut Tree, CADec 31, 1972 · N1641F · Destroyed NTSB OAK73DVM04Accident · No injuriesClosedCessna 172 · Palo Alto, CAJul 30, 1972 · N8099L · Substantial damage NTSB LAX72DVA74Accident · Minor injuriesClosedCessna 172H · Ketlman Cty, CAMay 23, 1972 · N1770F · Substantial damage NTSB OAK72AP038Accident · 1 fatalClosedCessna 172H · Orinda, CAApr 23, 1972 · N3732F · Destroyed NTSB LAX72AL051Accident · 2 fatalClosedCessna 172H · Silverado, CAMar 26, 1972 · N2619L · Destroyed NTSB OAK72DVG43Accident · No injuriesClosedCessna 172 · Napa, CAMar 16, 1972 · N3901R · Substantial damage NTSB OAK72DVD35Accident · No injuriesClosedCessna 172H · Lodi, CAMar 5, 1972 · N2596L · Substantial damage NTSB OAK72AP012Accident · Minor injuriesClosedCessna 150 · Franklin, CAOct 25, 1971 · N4687X · 2 aircraft · Substantial damage NTSB LAX72DUN13Accident · No injuriesClosedCessna 172 · Chula Vista, CAOct 23, 1971 · N8049L · Substantial damage NTSB OAK71FVG74Accident · No injuriesClosedCessna 172H · Foresthill, CAMay 13, 1971 · N2528L · Substantial damage NTSB LAX71FUG65Accident · Serious injuriesClosedCessna 172 · El Monte, CAMar 27, 1971 · N2710L · Destroyed NTSB LAX71FUG23Accident · Minor injuriesClosedCessna 172 · Corona, CAJan 5, 1971 · N8823Z · Substantial damage NTSB OAK71DVD09Accident · Minor injuriesClosedCessna 172 · Concord, CAAug 28, 1970 · N2439L · Substantial damage NTSB OAK71DXQ05Accident · No injuriesClosedCessna 172 · Lake Tahoe, CAJul 22, 1970 · N2461L · Substantial damage NTSB OAK71DVM03Accident · No injuriesClosedCessna 172 · San Jose, CAJul 13, 1970 · N1604F · Substantial damage NTSB LAX70FUD05Accident · No injuriesClosedCessna 172H · Malibu, CAMar 6, 1970 · N770LW · Substantial damage NTSB OAK70D0196Accident · No injuriesClosedCessna 172 · Laytonville, CADec 6, 1969 · N8100L · Substantial damage NTSB LAX70F0214Accident · No injuriesClosedCessna 172H · Santa Ana, CANov 28, 1969 · N8265L · Substantial damage NTSB OAK70D0155Accident · No injuriesClosedCessna 172 · Stewarts Pt, CANov 8, 1969 · N2740L · Substantial damage NTSB OAK70A0019Accident · 1 fatalClosedCessna 172H · Sacramento, CASep 12, 1969 · N3774R · Destroyed NTSB LAX70D0086Accident · No injuriesClosedCessna 172 · Sunfair, CAJul 24, 1969 · N8044L · Substantial damage NTSB LAX70D0034Accident · No injuriesClosedCessna 172 · Escondido, CAJul 2, 1969 · N8161L · Substantial damage NTSB LAX69D0303Accident · No injuriesClosedCessna 172 · Bermuda Dunes, CAMar 22, 1969 · N8283L · Substantial damage NTSB OAK69D0254Accident · No injuriesClosedCessna 172 · Vacaville, CAFeb 16, 1969 · N8188L · Substantial damage