# Fatal NTSB investigations: Cessna 172A

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 WPR11FA005](https://openairdocs.org/ntsb/WPR11FA005.md): Cessna 172 · Panguitch, UT · Accident · 2 fatal · Field investigation · Final report · Oct 8, 2010 · N8437A · Substantial damage
  > The pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.
- [NTSB NYC06FA025](https://openairdocs.org/ntsb/NYC06FA025.md): Cessna 172A · Pohatcong, NJ · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2005 · N7467T · 2 aircraft · Substantial damage
  > The inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.
- [NTSB IAD97LA009](https://openairdocs.org/ntsb/IAD97LA009.md): Cessna 172A · Lebanon, OH · Accident · 1 fatal · Limited investigation · Final report · Oct 20, 1996 · N9890T · Destroyed
  > improper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.
- [NTSB ANC95FA104](https://openairdocs.org/ntsb/ANC95FA104.md): Cessna 172A · Naknek, AK · Accident · 2 fatal · Field investigation · Final report · Jul 15, 1995 · N9827T · 2 aircraft · Destroyed
  > Inadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.
- [NTSB ATL87FA235](https://openairdocs.org/ntsb/ATL87FA235.md): Cessna 172A · Camilia, GA · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1987 · N7559T · Destroyed
  > This flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…
- [NTSB ATL85FA237](https://openairdocs.org/ntsb/ATL85FA237.md): Cessna 172A · Glencoe, KY · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1985 · N7279T · Substantial damage
  > The acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…
- [NTSB FTW85FA060](https://openairdocs.org/ntsb/FTW85FA060.md): Cessna 172A · Hammond, LA · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1984 · N7415T · Destroyed
  > Non-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to…
- [NTSB DEN83FA039](https://openairdocs.org/ntsb/DEN83FA039.md): Cessna 172A · Leadville, CO · Accident · 1 fatal · Field investigation · Final report · Dec 26, 1982 · N7611T · Substantial damage
  > When a witness arrived at the arpt, the acft was at the fuel pumps & the plt had the preheater attached. The witness rprtd there was frost on the acft & the plt brushed the loose frost off with his hands. The plt asked for a window scraper, which was…
- [NTSB FTW81FA090](https://openairdocs.org/ntsb/FTW81FA090.md): Cessna 172A · Verda, LA · Accident · 1 fatal · Closed · May 13, 1981 · N7232T · Destroyed
- [NTSB LAX81FA082](https://openairdocs.org/ntsb/LAX81FA082.md): Cessna 172A · Silver Peak, NV · Accident · 2 fatal · Closed · May 3, 1981 · N7458T · Destroyed
- [NTSB ATL81FA006](https://openairdocs.org/ntsb/ATL81FA006.md): Cessna 172 · Roanoke, VA · Accident · 4 fatal · Closed · Oct 10, 1980 · N7644T · Destroyed
- [NTSB LAX80FXQ28](https://openairdocs.org/ntsb/LAX80FXQ28.md): Cessna 172A · Tahoe City, CA · Accident · 2 fatal · Closed · May 25, 1980 · N7803T · Substantial damage
- [NTSB IAD79FA048](https://openairdocs.org/ntsb/IAD79FA048.md): Cessna 172A · Albany, KY · Accident · 2 fatal · Closed · May 5, 1979 · N7687T · Destroyed
- [NTSB DEN79FA012](https://openairdocs.org/ntsb/DEN79FA012.md): Cessna 172A · Park Valley, UT · Accident · 1 fatal · Closed · Dec 27, 1978 · N7678T · Substantial damage
- [NTSB MIA76AM088](https://openairdocs.org/ntsb/MIA76AM088.md): Cessna 172A · Milledgeville, GA · Accident · 1 fatal · Closed · May 27, 1976 · N7848T · Destroyed
- [NTSB OAK76FP050](https://openairdocs.org/ntsb/OAK76FP050.md): Cessna 172A · Planada, CA · Accident · 2 fatal · Closed · Apr 10, 1976 · N7705T · Destroyed
- [NTSB FTW75FPJ27](https://openairdocs.org/ntsb/FTW75FPJ27.md): Cessna 172A · Enid, OK · Accident · 1 fatal · Closed · Jun 28, 1975 · N7686T · Destroyed
- [NTSB MKC75AK025](https://openairdocs.org/ntsb/MKC75AK025.md): Cessna 172 · Abilene, KS · Accident · 1 fatal · Closed · Oct 25, 1974 · N7300T · Destroyed
- [NTSB IAD75FKW06](https://openairdocs.org/ntsb/IAD75FKW06.md): Cessna 172 · Twinton, TN · Accident · 1 fatal · Closed · Sep 14, 1974 · N7549T · Destroyed
- [NTSB SEA74AS034](https://openairdocs.org/ntsb/SEA74AS034.md): Cessna 172A · Waterville, WA · Accident · 3 fatal · Closed · Mar 1, 1974 · N7820T · Destroyed
- [NTSB FTW74AF062](https://openairdocs.org/ntsb/FTW74AF062.md): Cessna 172A · Hot Springs, AR · Accident · 1 fatal · Closed · Feb 17, 1974 · N6839X · Destroyed
- [NTSB MIA74AM059](https://openairdocs.org/ntsb/MIA74AM059.md): Cessna 172A · Jackson, GA · Accident · 3 fatal · Closed · Jan 18, 1974 · N7779T · Destroyed
- [NTSB FTW73AF046](https://openairdocs.org/ntsb/FTW73AF046.md): Cessna 172 · Salt Flat, TX · Accident · 2 fatal · Closed · Feb 20, 1973 · N7546T · Destroyed
- [NTSB NYC73ANO74](https://openairdocs.org/ntsb/NYC73ANO74.md): Cessna 172 · Missing Aircraft · Accident · 1 fatal · Closed · Nov 29, 1972 · N7344T · Destroyed
- [NTSB LAX74FUJ03](https://openairdocs.org/ntsb/LAX74FUJ03.md): Cessna 172A · Indian Wlls, AZ · Accident · 2 fatal · Closed · Jul 2, 1972 · N7551T · Destroyed
- [NTSB LAX72AL030](https://openairdocs.org/ntsb/LAX72AL030.md): Cessna 172A · Bagdad, AZ · Accident · 1 fatal · Closed · Oct 25, 1971 · N7570T · Destroyed
- [NTSB CHI70AC086](https://openairdocs.org/ntsb/CHI70AC086.md): Cessna 172 · Missing Aircraft · Accident · 1 fatal · Closed · May 31, 1970 · N7487T · Destroyed
- [NTSB NYC70AN100](https://openairdocs.org/ntsb/NYC70AN100.md): Cessna 172A · N.Branford, CT · Accident · 2 fatal · Closed · Mar 15, 1970 · N7796T · Destroyed
- [NTSB FTW70A0037](https://openairdocs.org/ntsb/FTW70A0037.md): Cessna 172 · Saginaw, TX · Accident · 2 fatal · Closed · Nov 26, 1969 · N7271T · Destroyed
- [NTSB FTW70A0031](https://openairdocs.org/ntsb/FTW70A0031.md): Cessna 172 · Mena, AR · Accident · 1 fatal · Closed · Nov 11, 1969 · N7180T · Destroyed
- [NTSB LAX69A0046](https://openairdocs.org/ntsb/LAX69A0046.md): Cessna 172 · Tehachapi, CA · Accident · 3 fatal · Closed · Jan 27, 1969 · N7285T · Destroyed
- [NTSB NYC68A0125](https://openairdocs.org/ntsb/NYC68A0125.md): Cessna 172 · Berlin, NJ · Accident · 1 fatal · Closed · Jun 2, 1968 · N7372T · Destroyed
- [NTSB LAX67A0092](https://openairdocs.org/ntsb/LAX67A0092.md): Cessna 172A · Alberhill, CA · Accident · 2 fatal · Closed · Mar 31, 1967 · N7172T · Destroyed
- [NTSB OAK67A0024](https://openairdocs.org/ntsb/OAK67A0024.md): Cessna 172A · Davis, CA · Accident · 2 fatal · Closed · Aug 14, 1966 · N9742T · Destroyed
- [NTSB OAK67A0009](https://openairdocs.org/ntsb/OAK67A0009.md): Cessna 172 · San Carlos, CA · Accident · 2 fatal · Closed · Jul 12, 1966 · N7484T · Destroyed
- [NTSB NYC66A0035](https://openairdocs.org/ntsb/NYC66A0035.md): Cessna 172 · West Dover, VT · Accident · 2 fatal · Closed · Sep 13, 1965 · N9809T · Destroyed
- [NTSB UNK64X3524](https://openairdocs.org/ntsb/UNK64X3524.md): Cessna 172 · Macon, GA · Accident · 1 fatal · Closed · Aug 21, 1964 · N7364T · Destroyed
- [NTSB UNK64X0822](https://openairdocs.org/ntsb/UNK64X0822.md): Cessna 172 · Big Bear City, CA · Accident · 2 fatal · Closed · Mar 6, 1964 · N7778T · Substantial damage
- [NTSB UNK64X0735](https://openairdocs.org/ntsb/UNK64X0735.md): Cessna 172A · Quincy, CA · Accident · 1 fatal · Closed · Feb 28, 1964 · N7260T · 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 ('2072404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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