Skip to content

NTSB investigations: Cessna 195A, CA

21 cases on aircraft the registry lists as Cessna 195A. 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

19652026

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 ('2073110')) 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 ('2073110'))
  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 ('2073110'))
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 WPR23LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Calexico, CAThe pilot’s failure to maintain directional control during the landing roll in gusting wind.Jan 20, 2023 · N95U · Substantial damage NTSB WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Dec 31, 2013 · N369JJ · Substantial damage NTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.May 16, 2013 · N4026A · Substantial damage NTSB WPR09CA465Accident · No injuriesData collectionFinal reportCessna 195A · Upland, CAThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Sep 25, 2009 · N195MD · Substantial damage NTSB LAX01LA096Accident · No injuriesLimited investigationFinal reportCessna 195A · Palm Springs, CAThe flight instructor's inadequate supervision of his dual student who lost directional control on landing.Feb 10, 2001 · N95U · Substantial damage NTSB LAX94FA271Accident · 2 fatalField investigationFinal reportCessna 195A · Santa Paula, CAthe noninstrument-rated pilot's intentional VFR flight into IMC conditions and the resultant in-flight loss of control.Jul 3, 1994 · N9300A · Destroyed NTSB LAX92LA132Accident · Minor injuriesLimited investigationFinal reportCessna 195A · San Jose, CAThe pilot's improper compensation for the existing wind conditions and improper recovery from a bounced landing. Contributing to the accident was the left quartering tail/crosswind.Feb 29, 1992 · N3451V · Substantial damage NTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.Nov 5, 1991 · N195MD · Substantial damage NTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…Dec 21, 1987 · N4026A · 2 aircraft · Minor damage NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…Oct 19, 1987 · N4372N · Substantial damage NTSB LAX86LA189Accident · Serious injuriesLimited investigationFinal reportCessna 195A · San Rafael, CAThe two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…Apr 23, 1986 · N4496C · 2 aircraft · Substantial damage NTSB LAX83LA130Accident · No injuriesLimited investigationFinal reportCessna 195 · Concord, CAAt about 50 ft AGL during the takeoff portion of a touch-and-go, the eng loss power & the acft crashed into a fence. Thecarburetor bowl was drained & about 2/3 of the fluid was determined to be water. The fuel strainer also contained water.Mar 8, 1983 · N1560D · Substantial damage NTSB LAX81FUQ18Accident · No injuriesClosedCessna 195A · Santa Barbara, CAApr 26, 1981 · N1054D · Substantial damage NTSB LAX79DUM06Accident · No injuriesClosedCessna 195A · San Diego, CAFeb 3, 1979 · N3446V · Substantial damage NTSB OAK76FVG61Accident · No injuriesClosedCessna 195A · Sloughhouse, CAMar 25, 1976 · N195DC · Substantial damage NTSB LAX75FUG18Accident · No injuriesClosedCessna 195A · Rubidoux, CANov 8, 1974 · N9858A · Substantial damage NTSB LAX73FWA17Accident · No injuriesClosedCessna 195 · Santa Ana, CAOct 23, 1972 · N3074B · Substantial damage NTSB OAK73FVG28Accident · No injuriesClosedCessna 195 · Vacaville, CAOct 18, 1972 · N4324N · Substantial damage NTSB LAX72FUG20Accident · No injuriesClosedCessna 195A · Chino, CAOct 2, 1971 · N1004D · Substantial damage NTSB OAK71DVM37Accident · No injuriesClosedCessna 195 · Monterey, CAJan 18, 1971 · N9894A · Substantial damage NTSB OAK65F0067Accident · No injuriesClosedCessna 195A · Santa Rosa, CAMay 8, 1965 · N1010D · Substantial damage