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

Page 5 of 5 · 248 cases

## Cases, newest first

- [NTSB MKC66D0365](https://openairdocs.org/ntsb/MKC66D0365.md): Cessna 172 · Trimont, MN · Accident · No injuries · Closed · Jan 1, 1966 · N7694T · Substantial damage
- [NTSB FTW66F0460](https://openairdocs.org/ntsb/FTW66F0460.md): Cessna 172A · College Sta, TX · Accident · Serious injuries · Closed · Dec 19, 1965 · N7190T · Substantial damage
- [NTSB NYC66F0398](https://openairdocs.org/ntsb/NYC66F0398.md): Cessna 172 · Gaithersburg, MD · Accident · No injuries · Closed · Dec 11, 1965 · N6836X · Substantial damage
- [NTSB MIA66F0381](https://openairdocs.org/ntsb/MIA66F0381.md): Cessna 172 · Baxley, GA · Accident · Serious injuries · Closed · Nov 26, 1965 · N9709T · Destroyed
- [NTSB FTW66D0440](https://openairdocs.org/ntsb/FTW66D0440.md): Cessna 172 · Oklahoma City, OK · Accident · No injuries · Closed · Nov 24, 1965 · N6812X · Substantial damage
- [NTSB CHI66F0430](https://openairdocs.org/ntsb/CHI66F0430.md): Cessna 172 · Fort Wayne, IN · Accident · No injuries · Closed · Nov 1, 1965 · N7227T · 2 aircraft · Substantial damage
- [NTSB MKC66D0290](https://openairdocs.org/ntsb/MKC66D0290.md): Cessna 172 · Reed Springs, MO · Accident · No injuries · Closed · Oct 23, 1965 · N7286T · Substantial damage
- [NTSB MIA66F0314](https://openairdocs.org/ntsb/MIA66F0314.md): Cessna 172 · Ludowici, GA · Accident · No injuries · Closed · Oct 21, 1965 · N7367T · Substantial damage
- [NTSB NYC66D0295](https://openairdocs.org/ntsb/NYC66D0295.md): Cessna 172 · Moorestown, NJ · Accident · No injuries · Closed · Oct 14, 1965 · N7320T · Substantial damage
- [NTSB NYC66F0244](https://openairdocs.org/ntsb/NYC66F0244.md): Cessna 172 · Harwinton, CT · Accident · No injuries · Closed · Oct 3, 1965 · N7459T · Substantial damage
- [NTSB NYC66A0035](https://openairdocs.org/ntsb/NYC66A0035.md): Cessna 172 · West Dover, VT · Accident · 2 fatal · Closed · Sep 13, 1965 · N9809T · Destroyed
- [NTSB FTW66D0306](https://openairdocs.org/ntsb/FTW66D0306.md): Cessna 172 · Booker, TX · Accident · No injuries · Closed · Sep 3, 1965 · N9869T · Substantial damage
- [NTSB SEA66F0092](https://openairdocs.org/ntsb/SEA66F0092.md): Cessna 172 · Kent, WA · Accident · No injuries · Closed · Aug 15, 1965 · N9739T · Substantial damage
- [NTSB CHI65F0148](https://openairdocs.org/ntsb/CHI65F0148.md): Cessna 172 · Ionia, MI · Accident · No injuries · Closed · May 14, 1965 · N7897T · Substantial damage
- [NTSB NYC65F0131](https://openairdocs.org/ntsb/NYC65F0131.md): Cessna 172A · Westminster, MD · Accident · No injuries · Closed · Apr 12, 1965 · N9787T · Substantial damage
- [NTSB FTW66F0206](https://openairdocs.org/ntsb/FTW66F0206.md): Cessna 172 · San Antonio, TX · Accident · No injuries · Closed · Mar 26, 1965 · N7795T · Substantial damage
- [NTSB CHI65D0146](https://openairdocs.org/ntsb/CHI65D0146.md): Cessna 172A · Jacksonville, IL · Accident · No injuries · Closed · Mar 13, 1965 · N7470T · Substantial damage
- [NTSB SEA65F0021](https://openairdocs.org/ntsb/SEA65F0021.md): Cessna 172 · Pullman, WA · Accident · No injuries · Closed · Mar 4, 1965 · N7200T · Substantial damage
- [NTSB SEA65D0027](https://openairdocs.org/ntsb/SEA65D0027.md): Cessna 172A · Seattle, WA · Accident · No injuries · Closed · Mar 2, 1965 · N7377T · Substantial damage
- [NTSB NYC65F0047](https://openairdocs.org/ntsb/NYC65F0047.md): Cessna 172 · Tewksbury, MA · Accident · No injuries · Closed · Feb 21, 1965 · N7611T · Substantial damage
- [NTSB UNK65X1345](https://openairdocs.org/ntsb/UNK65X1345.md): Cessna 172 · Victoria, TX · Accident · No injuries · Closed · Jan 25, 1965 · N7262T · Destroyed
- [NTSB UNK65X1306](https://openairdocs.org/ntsb/UNK65X1306.md): Cessna 172 · Manchester, KY · Accident · No injuries · Closed · Jan 18, 1965 · N7879T · Substantial damage
- [NTSB UNK65X0818](https://openairdocs.org/ntsb/UNK65X0818.md): Cessna 172 · Mesa, WA · Accident · No injuries · Closed · Nov 24, 1964 · N7362T · Destroyed
- [NTSB UNK65X0716](https://openairdocs.org/ntsb/UNK65X0716.md): Cessna 172 · Saco, MT · Accident · No injuries · Closed · Nov 15, 1964 · N9857T · Substantial damage
- [NTSB UNK65X0640](https://openairdocs.org/ntsb/UNK65X0640.md): Cessna 172 · Gualala, CA · Accident · No injuries · Closed · Nov 10, 1964 · N6831X · Destroyed
- [NTSB UNK65X0391](https://openairdocs.org/ntsb/UNK65X0391.md): Cessna 172 · Ralls, TX · Accident · Serious injuries · Closed · Oct 23, 1964 · N7321T · Destroyed
- [NTSB UNK65X0244](https://openairdocs.org/ntsb/UNK65X0244.md): Cessna 172 · El Monte, CA · Accident · No injuries · Closed · Oct 11, 1964 · N7842T · Substantial damage
- [NTSB UNK65X0241](https://openairdocs.org/ntsb/UNK65X0241.md): Cessna 172 · Windom, KS · Accident · No injuries · Closed · Oct 11, 1964 · N7536T · Substantial damage
- [NTSB UNK65X0177](https://openairdocs.org/ntsb/UNK65X0177.md): Cessna 172A · Orlando, FL · Accident · No injuries · Closed · Oct 7, 1964 · N7230T · Substantial damage
- [NTSB UNK64X3986](https://openairdocs.org/ntsb/UNK64X3986.md): Cessna 172 · Wheeling, IL · Accident · Minor injuries · Closed · Sep 14, 1964 · N7695T · Substantial damage
- [NTSB UNK64X3711](https://openairdocs.org/ntsb/UNK64X3711.md): Cessna 172 · Delavan, WI · Accident · No injuries · Closed · Aug 31, 1964 · N7481T · Substantial damage
- [NTSB UNK64X3562](https://openairdocs.org/ntsb/UNK64X3562.md): Cessna 172 · Colo Springs, CO · Accident · No injuries · Closed · Aug 23, 1964 · N7490T · Substantial damage
- [NTSB UNK64X3524](https://openairdocs.org/ntsb/UNK64X3524.md): Cessna 172 · Macon, GA · Accident · 1 fatal · Closed · Aug 21, 1964 · N7364T · Destroyed
- [NTSB UNK64X3134](https://openairdocs.org/ntsb/UNK64X3134.md): Cessna 172 · Thousand Is, NY · Accident · Minor injuries · Closed · Jul 31, 1964 · N6803X · Substantial damage
- [NTSB UNK64X2465](https://openairdocs.org/ntsb/UNK64X2465.md): Cessna 172 · Freemason Is, LA · Accident · Minor injuries · Closed · Jun 24, 1964 · N7368T · Destroyed
- [NTSB UNK64X2358](https://openairdocs.org/ntsb/UNK64X2358.md): Cessna 172 · Chicago, IL · Accident · Minor injuries · Closed · Jun 18, 1964 · N7863T · Substantial damage
- [NTSB UNK64X1643](https://openairdocs.org/ntsb/UNK64X1643.md): Cessna 172A · Garden City, KS · Accident · No injuries · Closed · May 7, 1964 · N7452T · Substantial damage
- [NTSB UNK64X1177](https://openairdocs.org/ntsb/UNK64X1177.md): Cessna 172 · Morehead, KY · Accident · No injuries · Closed · Apr 5, 1964 · N7544T · Substantial damage
- [NTSB UNK64X1093](https://openairdocs.org/ntsb/UNK64X1093.md): Cessna 172 · Honesdale, PA · Accident · No injuries · Closed · Mar 29, 1964 · N9884T · Substantial damage
- [NTSB UNK64X1036](https://openairdocs.org/ntsb/UNK64X1036.md): Cessna 172B · Winona, MN · Accident · No injuries · Closed · Mar 25, 1964 · N7621T · Substantial damage
- [NTSB UNK64X0968](https://openairdocs.org/ntsb/UNK64X0968.md): Cessna 172 · Turlock, CA · Accident · No injuries · Closed · Mar 18, 1964 · N7405T · Substantial damage
- [NTSB UNK64X0899](https://openairdocs.org/ntsb/UNK64X0899.md): Cessna 172 · Auburn, CA · Accident · Serious injuries · Closed · Mar 13, 1964 · N9818T · 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
- [NTSB UNK64X0265](https://openairdocs.org/ntsb/UNK64X0265.md): Cessna 172A · Cheyenne, WY · Accident · No injuries · Closed · Jan 17, 1964 · N7763T · Substantial damage
- [NTSB UNK64X0226](https://openairdocs.org/ntsb/UNK64X0226.md): Cessna 172A · Milton, NH · Accident · No injuries · Closed · Jan 12, 1964 · N9809T · Substantial damage
- [NTSB UNK64X0146](https://openairdocs.org/ntsb/UNK64X0146.md): Cessna 172 · Scottsdale, AZ · Accident · No injuries · Closed · Jan 4, 1964 · N7452T · Substantial damage
- [NTSB UNK64X0141](https://openairdocs.org/ntsb/UNK64X0141.md): Cessna 172A · Easton, PA · Accident · No injuries · Closed · Jan 3, 1964 · N7446T · Substantial damage

## 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."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?model=2072404&page=5

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