Fatal NTSB investigations: Cessna 195B

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

19672026

Fatal NTSB investigations: Cessna 195B per year, 1967–2026: 6 cases
1967	1
1968	2
1975	1
1977	1
1983	1

Where

Open the map

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 ('2073112')) 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 ('2073112'))
  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 ('2073112'))
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 FTW84FA014Accident · 1 fatalField investigationFinal reportCessna 195B · Alanreed, TXA recovered flt log indicated a route of flt via tulsa, OK; klahoma city,OK; sayre,OK; amarillo, TX; then tucumcari,NM. While taxiing for takeoff at the departure arpt, the plt received a wx briefing along the route to Oklahoma city. The accident site was 44…Oct 8, 1983 · N3048B · Destroyed NTSB NYC77FA089Accident · 1 fatalClosedCessna 195B · Mt Holley Spgs, PAAug 28, 1977 · N4404C · Destroyed NTSB SEA76AS004Accident · 3 fatalClosedCessna 195 · North Bend, WAJul 10, 1975 · N2179C · Destroyed NTSB MKC69A0021Accident · 1 fatalClosedCessna 195B · Loup City, NEOct 9, 1968 · N502E · Destroyed NTSB DIA69A0003Accident · 3 fatalClosedCessna 195 · Stuart, VAJul 19, 1968 · N3054B · Destroyed NTSB CHI68A0001Accident · 5 fatalClosedCessna 195B · Port Clinton, OHJul 1, 1967 · N4464C · Destroyed