# Fatal NTSB investigations: Cessna R172E

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 FTW95FA147](https://openairdocs.org/ntsb/FTW95FA147.md): Cessna R172E · Gladewater, TX · Accident · 1 fatal · Field investigation · Final report · Mar 27, 1995 · N1438Z · Destroyed
  > The pilot's failure to maintain an airspeed above stall speed, resulting in an inadvertent stall. A factor was the pilot's performance of an abrupt maneuver immediately after takeoff.
- [NTSB DEN84FA251](https://openairdocs.org/ntsb/DEN84FA251.md): Cessna R172E · Farmington, NM · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1984 · N601SP · Destroyed
  > After being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…
- [NTSB LAX80FJA11](https://openairdocs.org/ntsb/LAX80FJA11.md): Cessna 172E · Lanai City, HI · Accident · 2 fatal · Closed · Feb 15, 1980 · N9982Q · Destroyed
- [NTSB FTW79FA092](https://openairdocs.org/ntsb/FTW79FA092.md): Cessna 340 · Ashdown, AR · Accident · 7 fatal · Closed · Jul 3, 1979 · N345B · 2 aircraft · Destroyed
- [NTSB MIA77FA005](https://openairdocs.org/ntsb/MIA77FA005-201372.md): Cessna R172E · Jonesboro, GA · Accident · 1 fatal · Closed · Oct 29, 1976 · N3CD · Destroyed
- [NTSB SEA76AS031](https://openairdocs.org/ntsb/SEA76AS031.md): Cessna R172 · Klamath Falls, OR · Accident · 3 fatal · Closed · Dec 21, 1975 · N12987 · Destroyed
- [NTSB MIA75AM044](https://openairdocs.org/ntsb/MIA75AM044.md): Cessna R172E · Huntsville, AL · Accident · 2 fatal · Closed · Jan 15, 1975 · N6095 · 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 ('2072413'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.