Cessna 195
NTSB investigations · 192
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.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 NYC93FA013Accident · 1 fatalField investigationFinal reportCessna 195 · Shenandoah, PAA loss of control due to pilot incapacitation.NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.NTSB CHI91LA190Accident · No injuriesLimited investigationFinal reportCessna 195 · Detroit, MIFailure to maintain directional control, and inadequate aircraft preflight. A factor related to the accident is the instructor pilot's lack of experience in the type aircraft.NTSB BFO91FA040Accident · 2 fatalField investigationFinal reportCessna 195 · California, MDThe loss of power for undetermined reasons.NTSB FTW91LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · N. Little Rock, ARThe failure of the right brake system to release after application for unknown reasons.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 MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.NTSB FTW90LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195 · San Antonio, TXPilot's improper recovery from a bounced landing and subsequent stall of the aircraft.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 MKC88LA169Accident · No injuriesLimited investigationFinal reportCessna 195 · Keokuk, IAThe new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.…NTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYNTSB NYC88LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Meriden, CTAfter performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…NTSB DEN87LA239Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Colorado Sprgs, COThe plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and…NTSB LAX86LA351Accident · No injuriesLimited investigationFinal reportCessna 195 · Porterville, CAAfter a normal landing the pilot said he began to apply moderate brake pressure to make the mid-field taxiway turn off and felt what he described as 'a light jerk in the left gear' followed by a 'snapping sound which occurred two or three times.' The pilot…NTSB LAX86LA306Accident · No injuriesLimited investigationFinal reportCessna 195 · Ramona, CAThe aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a…NTSB LAX86LA290Accident · No injuriesLimited investigationFinal reportCessna 195B · San Diego, CAThe airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2…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 ATL85LA133Accident · No injuriesLimited investigationFinal reportCessna 195 · Lexington, KYDuring ldg roll-out the plt applied brake press in order to turn onto the taxiway & the rt brake grabbed causing the acft to ground loop. The left landing gear spring strut separated from the fuselage attachment point.NTSB LAX85LA237Accident · No injuriesLimited investigationFinal reportCessna 195 · Tucson, AZThe student lost control & ground looped the acft during rollout from the fifth landing while practicing for his bfr. The CFI reported that the accident might have been prevented had he been more attentive and/or provided better supervision.NTSB LAX85FUG01Accident · No injuriesFinal reportCessna 195 · Riverside, CAThe acft nosed over during a landing roll following a loss of control.NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…NTSB LAX84LA081Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot stated that the acft veered to the right during landing. The pilot tried left brake with no success. The acft groundlooped and the left gear failed. The brakes were examined after the accident but due to the damage to the lines & and fittings no…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…NTSB LAX83LA045Accident · No injuriesLimited investigationFinal reportCessna 195B · Peoria, AZThe pilot reported that he took off to flight test the aircraft. After takeoff, he turned downwind to stay in the traffic pattern. On downwind, the power was reduced to maintain spacing behind a Cessna 150. When this was accomplished, the engine power began…NTSB LAX82FA256Accident · 1 fatalField investigationFinal reportCessna 195 · Carson City, NVIt was reported the plt was going to make some touch & go landings before starting out on the cross-country. On the third approach the acft was observed on final approach, about 300 yds from the rwy, making a left turn of about 360 deg at a low altitude. At…NTSB SEA80FYE36Accident · Minor injuriesClosedCessna 195 · Yelm, WANTSB MKC79FA047Accident · 1 fatalClosedCessna 195 · Ely, MNNTSB OAK79FA031Accident · 2 fatalClosedCessna 195 · Laytonville, CANTSB LAX79DUQ27Accident · Minor injuriesClosedCessna 195 · Ojai, CANTSB LAX79FUA08Accident · No injuriesClosedCessna 195 · Long Beach, CANTSB LAX79DUJ68Accident · No injuriesClosedCessna 195 · Phoenix, AZNTSB MKC78FCA42Accident · Serious injuriesClosedCessna 195 · Rolla, MONTSB DEN78FQA21Accident · No injuriesClosedCessna 195 · Socorro, NMNTSB MKC78FCA13Accident · No injuriesClosedCessna 195 · Willow Springs, MONTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORNTSB OAK77FVD34Accident · No injuriesClosedCessna 195 · Stockton, CANTSB LAX77FUA08Accident · No injuriesClosedCessna 195 · Torrance, CANTSB NYC77FA049Accident · 4 fatalClosedCessna 195 · Reading, PANTSB FTW77FRG35Accident · No injuriesClosedCessna 195 · Port O'Connor, TXNTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INNTSB MKC76FER94Accident · No injuriesClosedCessna 195 · Mora, MNNTSB NYC76AN118Accident · 1 fatalClosedCessna 195 · Newburg, PANTSB NYC76FHD32Accident · Minor injuriesClosedCessna 195 · Lakewood, NJNTSB OAK76DVG69Accident · No injuriesClosedCessna 195 · Foresthill, CANTSB LAX76DUJ71Accident · Minor injuriesClosedCessna 195 · Show Low, AZNTSB OAK76DXQ21Accident · No injuriesClosedCessna 195B · Reno, NVNTSB LAX76FUA07Accident · No injuriesClosedCessna 195 · S.Juan Cpstrno, CA
Back to Cessna 195