Skip to content

Fatal NTSB investigations: Cessna 195

26 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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 WPR26FA233Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 195 · Pasco, WAOn June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…Jun 24, 2026 · N3877V · Substantial damage NTSB MIA06LA041Accident · 3 fatalLimited investigationFinal reportCessna 195 · St. Augustine, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.Dec 18, 2005 · N22L · Substantial damage NTSB MIA05FA035Accident · 2 fatalField investigationFinal reportCessna 195 · Kilmichael, MSThe pilot's ostentatious display, flying at low altitude, resulting in collision with a static wire power line, in-flight loss of control, and collision with terrain. A factor in the accident was sun glare.Nov 25, 2004 · N195DD · Destroyed NTSB DEN00FA127Accident · 4 fatalField investigationFinal reportCessna 195 · Aspen, COthe pilot's poor in-flight decision to fly up a valley with rapidly rising terrain, which resulted in the airplane colliding with the terrain due to its climb performance being exceeded. A contributing factors was the high, rapidly rising, mountainous terrain.Jul 8, 2000 · N4377V · Destroyed NTSB NYC00FA068Accident · 1 fatalField investigationFinal reportCessna 195 · Willard, KYThe pilot's continued VFR flight into IMC conditions. Factors were the pilot's inadequate preflight planning and snow showers.Jan 18, 2000 · N3448V · Substantial damage NTSB NYC98FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 195 · Cape May, NJUndetermined.Apr 5, 1998 · N4477C · Destroyed NTSB NYC93FA013Accident · 1 fatalField investigationFinal reportCessna 195 · Shenandoah, PAA loss of control due to pilot incapacitation.Oct 10, 1992 · N4308V · Destroyed NTSB BFO91FA040Accident · 2 fatalField investigationFinal reportCessna 195 · California, MDThe loss of power for undetermined reasons.Apr 6, 1991 · N1504D · Destroyed NTSB CHI91FA022Accident · 2 fatalField investigationFinal reportCessna 195 · Flint, MIThe pilot-in-command's inadequate preflight inspection of the fuel tank system. Factor(s) were: water contamination in the fuel.Oct 31, 1990 · N4325N · Destroyed NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…Oct 4, 1984 · N3086B · Destroyed NTSB LAX82FA256Accident · 1 fatalField investigationFinal reportCessna 195 · Carson City, NVIt was reported the plt was going to make some touch & go landings before starting out on the cross-country. On the third approach the acft was observed on final approach, about 300 yds from the rwy, making a left turn of about 360 deg at a low altitude. At…Jul 14, 1982 · N301M · Destroyed NTSB MKC79FA047Accident · 1 fatalClosedCessna 195 · Ely, MNAug 14, 1979 · N9320A · Substantial damage NTSB OAK79FA031Accident · 2 fatalClosedCessna 195 · Laytonville, CAMay 19, 1979 · N9877A · Destroyed NTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORAug 18, 1977 · N4304V · Destroyed NTSB NYC77FA049Accident · 4 fatalClosedCessna 195 · Reading, PAApr 9, 1977 · N4377N · 2 aircraft · Destroyed NTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INDec 10, 1976 · N169CB · Destroyed NTSB NYC76AN118Accident · 1 fatalClosedCessna 195 · Newburg, PAAug 4, 1976 · N193C · Destroyed NTSB SEA7KAS006Accident · 2 fatalClosedCessna 195A · Lincoln City, ORJul 28, 1975 · N1529D · Destroyed NTSB NYC75AN045Accident · 1 fatalClosedCessna 195 · Albion, NJOct 10, 1974 · N3461V · Destroyed NTSB UNK74X0109Accident · 2 fatalClosedCessna 195 · San Felipe, MexicoMay 28, 1974 · N4382N · Destroyed NTSB DEN74AD011Accident · 1 fatalClosedCessna 195 · Worland, WYAug 25, 1973 · N4332N · Destroyed NTSB CAN69ACAIOAccident · 1 fatalClosedCessna 195 · Flat Lake, CanadaMay 22, 1969 · N4350N · Destroyed NTSB OAK68A0032Accident · 3 fatalClosedCessna 195 · Shasta, CAMar 11, 1967 · N9388A · Destroyed NTSB FTW67D0026Accident · 3 fatalClosedCessna 195 · Santa Rosalia, MexicoMar 27, 1966 · N4328N · Destroyed NTSB UNK65X0711Accident · 5 fatalClosedCessna 195 · Warner Sprs, CANov 14, 1964 · N4303V · Destroyed NTSB UNK64X0342Accident · 4 fatalClosedCessna 195 · Winter Park, COJan 24, 1964 · N4351N · Destroyed