NTSB investigations: Cessna 195, TX
15 cases on aircraft the registry lists as Cessna 195. 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1977 | 1 |
| 1989 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2013 | 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 ('2073102'))
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 ('2073102'))
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 CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.NTSB CEN09CA246Accident · No injuriesData collectionFinal reportCessna 195 · Burnet, TXThe pilot's inadequate compensation for the gusting crosswinds during landing.NTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.NTSB FTW90LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195 · San Antonio, TXPilot's improper recovery from a bounced landing and subsequent stall of the aircraft.NTSB FTW77FRG35Accident · No injuriesClosedCessna 195 · Port O'Connor, TXNTSB FTW71FRH30Accident · No injuriesClosedCessna 195A · San Antonio, TXNTSB FTW70F0245Accident · No injuriesClosedCessna 195 · Panola, TXNTSB FTW70D0162Accident · No injuriesClosedCessna 195 · San Antonio, TXNTSB FTW68F0470Accident · No injuriesClosedCessna 195 · Dallas, TXNTSB FTW67D0271Accident · No injuriesClosedCessna 195 · Port Isabel, TXNTSB FTW67F0098Accident · No injuriesClosedCessna 195 · Odessa, TXNTSB FTW66F0356Accident · No injuriesClosedCessna 195 · Odessa, TXNTSB UNK65X0471Accident · No injuriesClosedCessna 195 · Del Rio, TXNTSB UNK64X3723Accident · No injuriesClosedCessna 195 · Austin, TXNTSB UNK64X2605Accident · No injuriesClosedCessna 195 · Ft Worth, TX