# Fatal NTSB investigations: Cessna 175B

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DFW05FA240](https://openairdocs.org/ntsb/DFW05FA240.md): Cessna 175B · Cleveland, TX · Accident · 3 fatal · Field investigation · Final report · Sep 15, 2005 · N8285T · Destroyed
  > The pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.
- [NTSB SEA02FA171](https://openairdocs.org/ntsb/SEA02FA171.md): Cessna 175B · Arlington, WA · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2002 · N8195T · Substantial damage
  > A partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.
- [NTSB LAX93FA297](https://openairdocs.org/ntsb/LAX93FA297.md): Cessna 175B · Blythe, CA · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1993 · N8264T · Destroyed
  > The pilot's failure to see and avoid the cable due to drug impairment. Factors which contributed to the accident were: the pilot's intentional buzzing, his ostentatious display, and his failure to maintain an adequate altitude over the river.
- [NTSB LAX84FA005](https://openairdocs.org/ntsb/LAX84FA005.md): Cessna 175B · Burbank, CA · Accident · 1 fatal · Field investigation · Final report · Oct 5, 1983 · N8146T · Destroyed
  > Relatives expected the plt to return home on the evening of 10/4/83. When he did not return, relatives report the acft was overdue. The acft was found where it collided with a mountain at an elevation of about 3580 ft, 10 mi north of the destination arpt.…
- [NTSB SEA82FA002](https://openairdocs.org/ntsb/SEA82FA002.md): Cessna 175B · Springfield, ID · Accident · 1 fatal · Closed · Nov 5, 1981 · N8197T · Destroyed
- [NTSB IAD79FA016](https://openairdocs.org/ntsb/IAD79FA016.md): Cessna 175B · Rileyville, VA · Accident · 1 fatal · Closed · Nov 21, 1978 · N8140T · Destroyed
- [NTSB CHI70FBJ31](https://openairdocs.org/ntsb/CHI70FBJ31.md): Cessna 175B · Birch Run, MI · Accident · 1 fatal · Closed · Jun 5, 1970 · N8090T · Substantial damage
- [NTSB DIA69A0042](https://openairdocs.org/ntsb/DIA69A0042.md): Cessna 175 · Linville Falls, NC · Accident · 1 fatal · Closed · Feb 6, 1969 · N8287T · Destroyed
- [NTSB MKC69A0033](https://openairdocs.org/ntsb/MKC69A0033.md): Cessna 175B · Custer, SD · Accident · 2 fatal · Closed · Nov 19, 1968 · N8290T · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 ('2072506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=2072506

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
