NTSB investigations: Cessna 195B
7 cases on aircraft the registry lists as Cessna 195B, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 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 ('2073112')
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\" = 260))
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 ('2073112')
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" = 260))
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 FTW01LA105Accident · No injuriesLimited investigationFinal reportCessna 195B · Conroe, TXthe pilot's failure to compensate for the wind conditions during takeoff, which resulted in a ground loop.NTSB LAX98LA087Accident · No injuriesLimited investigationFinal reportCessna 195 · Carefree, AZThe pilot's misjudging the wind direction and his selection of the wrong runway for the landing attempt.NTSB NYC94LA177Accident · No injuriesLimited investigationFinal reportCessna 195 B · Richmond, VAThe pilot's failure to maintain directional control which resulted in a ground loop. Contributing factors are excessive airspeed, fatigue, and improper recovery from a bounced landing.NTSB LAX93LA205Accident · No injuriesLimited investigationFinal reportCessna 195B · Placerville, CAThe unreliability of the normal brake system and the leaking master cylinderNTSB DEN88LA173Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Watkins, COThe new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another…NTSB CHI85LA111Accident · No injuriesLimited investigationFinal reportCessna 195B · Galena, OHThe acft nosed over when the main lndg gear hit a snowbank during lndg. Te plt stated that he had a x-wind from the rt side. He allowed the acft to drift left into the snow.NTSB CHI82DA310Accident · No injuriesFinal reportCessna 195A · Dixon, ILThe pilot landed downwind on runway 26 and the aircraft groundlooped during the landing roll. The main landing gear and left wing tip were damaged during the swerve.