Skip to content

NTSB investigations: Cessna 195, CA

36 cases on aircraft the registry lists as Cessna 195. 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 ('2073102')) 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 ('2073102'))
  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 ('2073102'))
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 WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.Mar 20, 2026 · N9368A · Substantial damage NTSB WPR22LA308Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 195 · El Cajon, CAThe pilot’s failure to verify the fuel quantity prior to departure, which led to a loss of engine power due to fuel exhaustion.Aug 18, 2022 · N1097D · Substantial damage NTSB SEA07CA230Accident · No injuriesData collectionFinal reportCessna 195 · San Diego, CAThe pilot's inadequate compensation for a wind gust that ballooned the airplane during the landing flare, which resulted in a hard landing. A contributing factor was the wind gust.Aug 12, 2007 · N1031D · Substantial damage NTSB LAX04LA199Accident · No injuriesLimited investigationFinal reportCessna 195 · Riverside, CAthe pilot's failure to maintain directional control, resulting in a veer off the runway and collision with terrain.May 1, 2004 · N195AF · Substantial damage NTSB LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.Aug 21, 2002 · N4344V · Substantial damage NTSB LAX97LA283Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Santa Ana, CAWater contamination in the fuel system due to the failure of the mechanic who performed the last annual inspection to adequately comply with the AD which required inspection of the fuel tank filler area for proper sealing, and the pilot's inadequate preflight…Aug 11, 1997 · N9328A · Substantial damage NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.Nov 8, 1992 · N3899V · Substantial damage NTSB LAX86LA351Accident · No injuriesLimited investigationFinal reportCessna 195 · Porterville, CAAfter a normal landing the pilot said he began to apply moderate brake pressure to make the mid-field taxiway turn off and felt what he described as 'a light jerk in the left gear' followed by a 'snapping sound which occurred two or three times.' The pilot…Sep 15, 1986 · N3879V · Substantial damage NTSB LAX86LA306Accident · No injuriesLimited investigationFinal reportCessna 195 · Ramona, CAThe aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a…Jul 28, 1986 · N3899V · Substantial damage NTSB LAX86LA290Accident · No injuriesLimited investigationFinal reportCessna 195B · San Diego, CAThe airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2…Jul 13, 1986 · N195JB · Substantial damage NTSB LAX85FUG01Accident · No injuriesFinal reportCessna 195 · Riverside, CAThe acft nosed over during a landing roll following a loss of control.Oct 31, 1984 · N3879V · Substantial damage NTSB LAX84LA081Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot stated that the acft veered to the right during landing. The pilot tried left brake with no success. The acft groundlooped and the left gear failed. The brakes were examined after the accident but due to the damage to the lines & and fittings no…Nov 29, 1983 · N9335A · Substantial damage NTSB OAK79FA031Accident · 2 fatalClosedCessna 195 · Laytonville, CAMay 19, 1979 · N9877A · Destroyed NTSB LAX79DUQ27Accident · Minor injuriesClosedCessna 195 · Ojai, CAApr 5, 1979 · N4321V · Destroyed NTSB LAX79FUA08Accident · No injuriesClosedCessna 195 · Long Beach, CAApr 4, 1979 · N1563D · Substantial damage NTSB OAK77FVD34Accident · No injuriesClosedCessna 195 · Stockton, CAMay 20, 1977 · N1563D · Substantial damage NTSB LAX77FUA08Accident · No injuriesClosedCessna 195 · Torrance, CAApr 10, 1977 · N9826A · Substantial damage NTSB OAK76DVG69Accident · No injuriesClosedCessna 195 · Foresthill, CAMay 6, 1976 · N4398N · Substantial damage NTSB LAX76FUA07Accident · No injuriesClosedCessna 150 · S.Juan Cpstrno, CASep 17, 1975 · N2825V · 2 aircraft · Substantial damage NTSB LAX75DUG39Accident · No injuriesClosedCessna 195 · Palm Springs, CAMar 23, 1975 · N99T · Substantial damage NTSB LAX75FUD04Accident · No injuriesClosedCessna 195 · Santa Monica, CAFeb 2, 1975 · N9334A · Substantial damage NTSB LAX74FUD01Accident · No injuriesClosedPiper PA-28 · Snta Monica, CAAug 1, 1973 · N4915T · 2 aircraft · Substantial damage NTSB LAX72FUG48Accident · No injuriesClosedCessna 195 · Bg Bear Cty, CAJan 2, 1972 · N3431V · Substantial damage NTSB LAX71FUA52Accident · No injuriesClosedCessna 195 · Avalon, CAMar 14, 1971 · N4333V · Substantial damage NTSB LAX71DUG36Accident · No injuriesClosedCessna 195 · Upland, CAJan 19, 1971 · N9399A · Substantial damage NTSB OAK71DVA09Accident · No injuriesClosedCessna 195 · Lone Pine, CAJul 11, 1970 · N195BD · Substantial damage NTSB OAK70D0066Accident · No injuriesClosedCessna 195 · Upper Lake, CAAug 2, 1969 · N4303N · Substantial damage NTSB LAX68D0303Accident · No injuriesClosedCessna 195 · Bakersfield, CAJan 24, 1968 · N4337V · Substantial damage NTSB OAK68D0092Accident · No injuriesClosedCessna 195 · Fall R.Mils, CAAug 19, 1967 · N9341A · Substantial damage NTSB OAK68A0032Accident · 3 fatalClosedCessna 195 · Shasta, CAMar 11, 1967 · N9388A · Destroyed NTSB OAK67D0095Accident · No injuriesClosedCessna 195 · Calistoga, CASep 25, 1966 · N3891V · Substantial damage NTSB LAX66F0251Accident · No injuriesClosedCessna 195 · Pomona, CADec 24, 1965 · N3429V · Substantial damage NTSB LAX65D0057Accident · No injuriesClosedCessna 195 · El Monte, CAFeb 6, 1965 · N1594D · Substantial damage NTSB UNK65X0711Accident · 5 fatalClosedCessna 195 · Warner Sprs, CANov 14, 1964 · N4303V · Destroyed NTSB UNK64X4156Accident · No injuriesClosedCessna 195 · Santa Monica, CASep 26, 1964 · N3464V · Substantial damage NTSB UNK64X3305Accident · No injuriesClosedCessna 195 · Inyokern, CAAug 9, 1964 · N9817A · Substantial damage