NTSB investigations: Cessna 195A
13 cases on aircraft the registry lists as Cessna 195A, 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
| 1986 | 2 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1991 | 2 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 2 |
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 ('2073110')
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 ('2073110')
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 SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB CHI05LA099Accident · No injuriesLimited investigationFinal reportCessna 195A · Jackson, MIThe fracture of the left brake master cylinder piston rod, which resulted in the total failure of the left-side brake system and the subsequent loss of directional control during landing roll. An additional cause was the encountered ground-loop.NTSB LAX01LA096Accident · No injuriesLimited investigationFinal reportCessna 195A · Palm Springs, CAThe flight instructor's inadequate supervision of his dual student who lost directional control on landing.NTSB CHI00FA229Accident · No injuriesField investigationFinal reportCessna 195A · Oshkosh, WIThe pilots failure to maintain directional control. A factor was the landing gear being out of alignment.NTSB LAX98LA069Accident · No injuriesLimited investigationFinal reportCessna 195A · Tucson, AZThe student's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors in this accident were the inadequate supervision of the flight by the flight instructor, and the student's failure to relinquish the…NTSB FTW95LA152Accident · No injuriesLimited investigationFinal reportCessna 195A · Albuquerque, NMA partial failure of the airplane brake system (left brake). A factor was the right quartering tailwind.NTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.NTSB ATL91LA036Accident · No injuriesLimited investigationFinal reportCessna 195B · La Grange, GAThe failure of the tailwheel steering spring.NTSB ATL88LA209Accident · No injuriesLimited investigationFinal reportCessna 195A · Memphis, TNThe plt reported that the left wheel separated from the airplane during ldg rollout on rwy 27, allowing the left gear to drag on the rwy. The airplane then bounced, veered to the right, and skidded to a stop. The left ldg gear collapsed as the acft stopped.…NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…NTSB BFO87LA043Accident · No injuriesLimited investigationFinal reportCessna 195A · Cambridge, MDAfter purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally…NTSB ANC86LA164Accident · No injuriesLimited investigationFinal reportCessna 195A · Willow, AKThe pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure.NTSB MIA86LA206Accident · No injuriesLimited investigationFinal reportCessna 195A · Orlando, FLThe plt stated that the left main gear collapsed while he was trying to recover from a 45 degree swerve to the right during lanidng.