NTSB investigations: Cessna 195B, TX
14 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.
Cases per year
| 1966 | 1 |
|---|---|
| 1971 | 2 |
| 1974 | 1 |
| 1976 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'TX' 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" = 'TX' 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" 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 CEN15LA099Accident · No injuriesLimited investigationFinal reportCessna 195B · Llano, TXThe pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.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 FTW99LA156Accident · No injuriesLimited investigationFinal reportCessna 195 · Conroe, TXThe fatigue fracture of the left main landing gear spring at the clamping mechanism, as a result of fretting.NTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.NTSB FTW85LA160Accident · No injuriesLimited investigationFinal reportCessna 195B · Bay City, TXCessna exhaust stack failed at weld. Hot exhaust burned through magnrto p leads and eng failed. During forced landing on a narrow farm road with a quartering tailwind. The acft drifted off the side of the road during the landing roll and nosed over.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…NTSB FTW81FQG45Accident · No injuriesClosedCessna 195B · Lubbock, TXNTSB FTW79DRJ15Accident · Minor injuriesClosedCessna 195B · Tyler, TXNTSB FTW76FRG46Accident · Minor injuriesClosedCessna 195 · New Braunfels, TXNTSB FTW76DQG45Accident · No injuriesClosedCessna 195B · Midland, TXNTSB FTW74FRG82Accident · Minor injuriesClosedCessna 195 · San Antonio, TXNTSB FTW72FRG05Accident · No injuriesClosedCessna 195 · San Antonio, TXNTSB FTW71FRJ36Accident · No injuriesClosedCessna 195B · Mt.Enterprise, TXNTSB FTW67F0243Accident · No injuriesClosedCessna 195 · Crosby, TX