NTSB investigations: Cessna 195
6 cases on aircraft the registry lists as Cessna 195, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1997 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 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…NTSB NYC93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Great Barrington, MAThe inadequate pre-flight by the pilot ensuring fuel cap security. A factor in this accident was the pilots complacency in fuel management.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.NTSB MIA89LA110Accident · No injuriesLimited investigationFinal reportCessna 195 · Moore Haven, FLInadequate preflight by the pilot which resulted in fuel exhaustion due to inadequate fuel supply. A contributing factor was a ditch which the aircraft hit as the pilot was applying brakes to avoid a fence.NTSB CHI86LA147Accident · No injuriesLimited investigationFinal reportCessna 195 · Port Huron, MIThe flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed…NTSB ATL83LA202Accident · No injuriesLimited investigationFinal reportCessna 195 · Florence, SCAccording to the plt, the eng lost power about 3 mi from the arpt after he switched from the right to the left fuel tank. He reported that he switched the boost pump to the 'high' position, but was unable to restart the eng. He estimated there was 5 to 7 gal…