Skip to content

NTSB investigations: Cessna 175, CA

41 cases on aircraft the registry lists as Cessna 175. 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

19642026

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 ('2072502')) 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 ('2072502'))
  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 ('2072502'))
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 WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.Jun 5, 2020 · N9217B · Substantial damage NTSB WPR20CA055Accident · No injuriesData collectionFinal reportCessna 175 · Elk, CAThe pilot's failure to arrest the descent rate during an aborted simulated engine-out approach, which resulted in impact with vegetation and a subsequent cartwheel.Dec 31, 2019 · N7095M · Substantial damage NTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…May 27, 2017 · N6832D · Substantial damage NTSB WPR13LA272Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Needles, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning. Contributing to the severity of the front passenger’s injuries was the pilot’s decision to depart with more passengers than available seats, which resulted in…Jun 16, 2013 · N9370B · Substantial damage NTSB LAX02LA174Accident · No injuriesLimited investigationFinal reportCessna 175 · Anaheim, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.May 24, 2002 · N6713E · Substantial damage NTSB LAX01LA235Accident · No injuriesLimited investigationFinal reportCessna 175 · Monterey, CAThe pilot's improper recovery from a bounced landing.Jul 4, 2001 · N9287B · Substantial damage NTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.Jan 2, 1995 · N7098M · Substantial damage NTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…Feb 5, 1994 · N7597M · 2 aircraft · Substantial damage NTSB LAX94LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Palm Springs, CAfuel exhaustion due to the pilot's failure to adequately monitor the fuel consumption during the flight.Nov 4, 1993 · N7646M · Substantial damage NTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…May 3, 1993 · N9494B · Destroyed NTSB LAX89LA054Accident · No injuriesLimited investigationFinal reportCessna 175 · Tracy, CAThe airplane was found nosed over and abandoned short of the airport. The owner of the airplane was identified as the pilot, however, he does not hold a pilots license nor a medical certificate. Inspection of the airplane revealed that the fuel tanks were…Nov 20, 1988 · N6641E · Substantial damage NTSB LAX88LA283Accident · No injuriesLimited investigationFinal reportCessna 175 · Needles, CAWhile at cruise flight, the pilot noticed that the oil pressure was low and shutdown the engine. During the emergency landing, the prop freewheeled, vibrated severely, and smoke filled the cockpit. The acft landed on a pipeline right of way causing…Aug 7, 1988 · N7355M · Substantial damage NTSB LAX87LA271Accident · No injuriesLimited investigationFinal reportCessna 175 · Jackson, CAJust after takeoff the engine began missing then quit at an altitude of aprx 200 ft AGL. The plt attempted to return and land at the airport but was unable to reach the runway. Inspection of the engine revealed that the number 5 cylinderbarrel was cracked at…Jul 18, 1987 · N7499M · Substantial damage NTSB LAX86LA281Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Atwater, CAA Cessna 175 collided with a tree after a total loss of power during a VFR x-country flt. The plt indicated he experienced an eng failure at 2,000 ft MSL, while on descent, aprx 15 mi from his dest. He reported that the eng began to vibrate slightly. The…Jul 6, 1986 · N7108M · Substantial damage NTSB LAX80FA048Accident · 3 fatalClosedPiper PA-28 · El Segundo, CAFeb 8, 1980 · N44126 · 2 aircraft · Destroyed NTSB LAX80FUA04Accident · Minor injuriesClosedCessna 175 · Huntington Bch, CADec 7, 1979 · N7355M · Substantial damage NTSB LAX79FA087Accident · 1 fatalClosedCessna 175 · Hollister, CASep 21, 1979 · N9466B · Destroyed NTSB LAX79FUG10Accident · No injuriesClosedCessna 175 · Upland, CAJan 6, 1979 · N9356B · 2 aircraft · Substantial damage NTSB LAX77DUM36Accident · No injuriesClosedCessna 175 · Calipatria, CAAug 29, 1977 · N7466M · Destroyed NTSB LAX77DVA06Accident · No injuriesClosedCessna 175 · Lost Hills, CAOct 11, 1976 · N7409M · Substantial damage NTSB OAK75DVG16Accident · No injuriesClosedCessna 175 · Redding, CAAug 17, 1974 · N9287B · Substantial damage NTSB LAX74FUG24Accident · No injuriesClosedCessna 175 · Palm Sprngs, CAOct 13, 1973 · N9422B · Substantial damage NTSB OAK74FVA06Accident · Minor injuriesClosedCessna 175 · Mariposa, CAJul 22, 1973 · N7463M · Substantial damage NTSB LAX73FUG60Accident · Minor injuriesClosedCessna 175 · Big Bear Cy, CAMay 31, 1973 · N6586E · Substantial damage NTSB OAK73DXQ32Accident · Minor injuriesClosedCessna 175 · Cedarville, CAMay 20, 1973 · N7166M · Substantial damage NTSB OAK72DVA61Accident · No injuriesClosedCessna 175 · Hanford, CAApr 1, 1972 · N9308B · Substantial damage NTSB LAX72FUG36Accident · Minor injuriesClosedN.American P-51D · Chino, CANov 26, 1971 · N3333E · 2 aircraft · Substantial damage NTSB ANC72AA026Accident · 4 fatalClosedCessna 175 · Willits, CANov 23, 1971 · N7055M · Destroyed NTSB LAX71DVA02Accident · No injuriesClosedCessna 175 · Lone Pine, CAJul 7, 1970 · N6586E · Substantial damage NTSB OAK70D0157Accident · Minor injuriesClosedCessna 175 · Downieville, CAOct 9, 1969 · N7052M · Substantial damage NTSB OAK70A0011Accident · 1 fatalClosedCessna 175 · Colusa, CAAug 10, 1969 · N6535E · Destroyed NTSB LAX69D0346Accident · Serious injuriesClosedCessna 175 · Rialto, CAMay 1, 1969 · N6679E · Substantial damage NTSB OAK69D0217Accident · No injuriesClosedCessna 175 · Oceano, CAJan 5, 1969 · N9323B · Substantial damage NTSB LAX69A0013Accident · 3 fatalClosedCessna 175 · Beaumont, CASep 3, 1968 · N9239B · Destroyed NTSB LAX68A0082Accident · 3 fatalClosedCessna 175 · Corona, CAMar 1, 1968 · N7614M · Destroyed NTSB LAX68A0018Accident · 1 fatalClosedCessna 175 · Saugus, CAAug 6, 1967 · N7014M · Destroyed NTSB OAK66F0118Accident · 1 fatalClosedCessna 175 · Redding, CAOct 31, 1965 · N9229B · Substantial damage NTSB LAX66A0031Accident · 3 fatalClosedCessna 175 · Upland, CASep 23, 1965 · N6590E · Destroyed NTSB LAX66F0027Accident · No injuriesClosedCessna 175 · Ontario, CAApr 22, 1965 · N6616E · Substantial damage NTSB LAX65D0021Accident · No injuriesClosedCessna 175 · Famosa, CAMar 14, 1965 · N7076M · Substantial damage NTSB UNK65X1060Accident · 1 fatalClosedCessna 175 · Cloverdale, CADec 19, 1964 · N7226M · Destroyed