NTSB investigations: Cessna 195B, FL

8 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

NTSB investigations: Cessna 195B, FL per year, 1967–2026: 8 cases
1967	2
1971	1
1979	2
1989	1
2016	1
2019	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."eventStateOrRegion" = 'FL' 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 ('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.\"eventStateOrRegion\" = 'FL' 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 ('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."eventStateOrRegion" = 'FL' 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 ('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 GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.Mar 29, 2019 · N195PC · Substantial damage NTSB GAA17CA097Accident · No injuriesData collectionFinal reportCessna 195 · Jacksonville, FLThe other pilot’s failure to see and avoid the stationary airplane during taxi.Dec 11, 2016 · N195PC · 2 aircraft · Substantial damage NTSB MIA89LA216Accident · No injuriesLimited investigationFinal reportCessna 195B · Hollywood, FLThe failure of the left main landing gear spring due to low cycle fatigue, resulting in the loss of control of the ground.Aug 6, 1989 · N841DP · Substantial damage NTSB MIA79DLD90Accident · No injuriesClosedCessna 195 · Kissimmee, FLAug 25, 1979 · N3095B · Substantial damage NTSB MIA79DLD46Accident · No injuriesClosedCessna 195 · St Petersburg, FLMar 3, 1979 · N2180C · Minor damage NTSB MIA72DKT03Accident · No injuriesClosedCessna 195B · Punta Gorda, FLJul 23, 1971 · N4462C · Substantial damage NTSB MIA67D0471Accident · No injuriesClosedCessna 195 · Tampa, FLFeb 22, 1967 · N2195C · Substantial damage NTSB MIA67D0407Accident · No injuriesClosedCessna 195 · Green Cove Sp, FLFeb 5, 1967 · N2133C · Substantial damage