Fatal NTSB investigations: Cessna 175
55 cases on aircraft the registry lists as Cessna 175. 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 5 |
| 1969 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 1 |
| 1977 | 1 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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 WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.NTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.NTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.NTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB CEN16FA210Accident · 1 fatalField investigationFinal reportCessna 175 · Pine Bluff, ARA loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…NTSB WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.NTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.NTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.NTSB DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.NTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…NTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.NTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.NTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…NTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.NTSB LAX89WA326Accident · 1 fatalForeign investigationCessna 175 · Muiege, MexicoNTSB FTW87WA070Accident · 3 fatalForeign investigationCessna 175 · La Union Morale, MexicoNTSB CHI81FA096Accident · 1 fatalClosedCessna 175 · Fenton, ILNTSB CHI80FEI15Accident · 1 fatalClosedCessna 175 · New Phila, OHNTSB LAX80FA048Accident · 3 fatalClosedPiper PA-28 · El Segundo, CANTSB MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSNTSB LAX79FA087Accident · 1 fatalClosedCessna 175 · Hollister, CANTSB IAD79FA042Accident · 2 fatalClosedCessna 175 · Livingston, TNNTSB LAX79FA025Accident · 4 fatalClosedCessna 175 · Wickenburg, AZNTSB DEN78FA011Accident · 2 fatalClosedCessna 175 · Leadville, CONTSB MIA74AM076Accident · 1 fatalClosedCessna 175 · Fairburn, GANTSB FTW74AF025Accident · 2 fatalClosedCessna 175 · Wister, OKNTSB SEA74AS003Accident · 2 fatalClosedCessna 175 · Neah Bay, WANTSB LAX74OL025Accident · 3 fatalClosedCessna 175 · San L Gonzaga, MexicoNTSB CHI72AC087Accident · 2 fatalClosedCessna 175A · Boonville, INNTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSNTSB ANC72AA026Accident · 4 fatalClosedCessna 175 · Willits, CANTSB DEN70A0024Accident · 1 fatalClosedCessna 175 · Eureka, MTNTSB OAK70A0011Accident · 1 fatalClosedCessna 175 · Colusa, CANTSB SEA69A0049Accident · 3 fatalClosedCessna 175 · Four Buttes, MTNTSB LAX69A0013Accident · 3 fatalClosedCessna 175 · Beaumont, CANTSB MIA69A0011Accident · 2 fatalClosedCessna 175 · Eastman, GANTSB SEA68A0066Accident · 3 fatalClosedCessna 175 · Cascade, MTNTSB LAX68A0082Accident · 3 fatalClosedCessna 175 · Corona, CANTSB NYC68A0093Accident · 2 fatalClosedCessna 150 · Buzzards Bay, MANTSB FTW68A0038Accident · 1 fatalClosedCessna 175 · Willis, TXNTSB LAX68A0018Accident · 1 fatalClosedCessna 175 · Saugus, CANTSB UNK67X0132Accident · 2 fatalClosedCessna 175 · Armstrong, CanadaNTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LANTSB SEA66A0043Accident · 4 fatalClosedCessna 175 · Bonneville, ORNTSB OAK66F0118Accident · 1 fatalClosedCessna 175 · Redding, CANTSB LAX66A0031Accident · 3 fatalClosedCessna 175 · Upland, CA