# NTSB investigations: Cessna 172

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 16 of 22 · 1,096 cases

## Cases, newest first

- [NTSB FTW69D0066](https://openairdocs.org/ntsb/FTW69D0066.md): Cessna 172 · Junction, TX · Accident · No injuries · Closed · Apr 9, 1968 · N8811B · Substantial damage
- [NTSB SEA68A0060](https://openairdocs.org/ntsb/SEA68A0060.md): Cessna 172 · Puyallup, WA · Accident · 4 fatal · Closed · Mar 24, 1968 · N6069A · 2 aircraft · Destroyed
- [NTSB DIA68D0186](https://openairdocs.org/ntsb/DIA68D0186.md): Cessna 172 · Rose Hill, NC · Accident · No injuries · Closed · Mar 22, 1968 · N6342E · Substantial damage
- [NTSB MKC68F0482](https://openairdocs.org/ntsb/MKC68F0482.md): Cessna 172 · Dodge City, KS · Accident · Serious injuries · Closed · Mar 17, 1968 · N8364B · Substantial damage
- [NTSB OAK68F0322](https://openairdocs.org/ntsb/OAK68F0322.md): Cessna 172 · Coalinga, CA · Accident · Serious injuries · Closed · Mar 15, 1968 · N6745A · Destroyed
- [NTSB MKC68D0483](https://openairdocs.org/ntsb/MKC68D0483.md): Cessna 172 · Chanute, KS · Accident · No injuries · Closed · Mar 14, 1968 · N4078F · Substantial damage
- [NTSB DEN68F0240](https://openairdocs.org/ntsb/DEN68F0240.md): Cessna 172 · Mountainair, NM · Accident · No injuries · Closed · Mar 9, 1968 · N7069T · Substantial damage
- [NTSB OAK68D0310](https://openairdocs.org/ntsb/OAK68D0310.md): Cessna 172 · Huron, CA · Accident · Minor injuries · Closed · Mar 3, 1968 · N6378E · Substantial damage
- [NTSB FTW68D0506](https://openairdocs.org/ntsb/FTW68D0506.md): Cessna 172 · Fairview, OK · Accident · No injuries · Closed · Mar 1, 1968 · N6250E · Substantial damage
- [NTSB OAK68D0299](https://openairdocs.org/ntsb/OAK68D0299.md): Cessna 172 · Sacramento, CA · Accident · No injuries · Closed · Feb 25, 1968 · N5660A · Substantial damage
- [NTSB FTW68D0469](https://openairdocs.org/ntsb/FTW68D0469.md): Cessna 172 · Wabash, AR · Accident · No injuries · Closed · Feb 24, 1968 · N7263A · Substantial damage
- [NTSB CHI68D0604](https://openairdocs.org/ntsb/CHI68D0604.md): Cessna 172 · Grayslake, IL · Accident · No injuries · Closed · Feb 15, 1968 · N8001B · Substantial damage
- [NTSB FTW68D0479](https://openairdocs.org/ntsb/FTW68D0479.md): Cessna 172 · New Braunfels, TX · Accident · No injuries · Closed · Feb 4, 1968 · N6278E · Substantial damage
- [NTSB CHI68F0567](https://openairdocs.org/ntsb/CHI68F0567.md): Cessna 172 · Princeton, IL · Accident · Serious injuries · Closed · Jan 30, 1968 · N1121F · Destroyed
- [NTSB MIA68D0387](https://openairdocs.org/ntsb/MIA68D0387.md): Cessna 172 · Nashville, TN · Accident · No injuries · Closed · Jan 29, 1968 · N4207F · Substantial damage
- [NTSB LAX68D0307](https://openairdocs.org/ntsb/LAX68D0307.md): Cessna 172 · Blythe, CA · Accident · Minor injuries · Closed · Jan 24, 1968 · N7174A · Substantial damage
- [NTSB CHI68A0064](https://openairdocs.org/ntsb/CHI68A0064.md): Cessna 172 · Liberty, IN · Accident · 2 fatal · Closed · Jan 21, 1968 · N4142F · Destroyed
- [NTSB LAX68D0287](https://openairdocs.org/ntsb/LAX68D0287.md): Cessna 172 · Rubidoux, CA · Accident · Minor injuries · Closed · Jan 13, 1968 · N9124B · Destroyed
- [NTSB LAX68D0273](https://openairdocs.org/ntsb/LAX68D0273.md): Cessna 185 · Lakeside, CA · Accident · No injuries · Closed · Jan 7, 1968 · N4084F · Substantial damage
- [NTSB MIA68F0354](https://openairdocs.org/ntsb/MIA68F0354.md): Cessna 172 · High Springs, FL · Accident · No injuries · Closed · Jan 2, 1968 · N5064A · Substantial damage
- [NTSB FTW68D0402](https://openairdocs.org/ntsb/FTW68D0402.md): Cessna 172 · Stigler, OK · Accident · No injuries · Closed · Dec 25, 1967 · N3958F · Substantial damage
- [NTSB MKC68D0389](https://openairdocs.org/ntsb/MKC68D0389.md): Cessna 172 · Ames, KS · Accident · No injuries · Closed · Dec 20, 1967 · N7048T · Substantial damage
- [NTSB CHI68D0510](https://openairdocs.org/ntsb/CHI68D0510.md): Cessna 172 · Greenwood, IN · Accident · No injuries · Closed · Dec 20, 1967 · N4033F · Substantial damage
- [NTSB MIA68D0358](https://openairdocs.org/ntsb/MIA68D0358.md): Cessna 172 · Dunedin, FL · Accident · Minor injuries · Closed · Dec 19, 1967 · N8074L · Destroyed
- [NTSB LAX68D0262](https://openairdocs.org/ntsb/LAX68D0262.md): Cessna 172A · Baker, CA · Accident · No injuries · Closed · Dec 16, 1967 · N7211T · Substantial damage
- [NTSB FTW68F0392](https://openairdocs.org/ntsb/FTW68F0392.md): Cessna 172 · Jasper, TX · Accident · No injuries · Closed · Dec 4, 1967 · N8140B · Substantial damage
- [NTSB CHI68F0464](https://openairdocs.org/ntsb/CHI68F0464.md): Cessna 172 · S.Rockwood, MI · Accident · No injuries · Closed · Nov 29, 1967 · N6998A · Substantial damage
- [NTSB MKC68D0410](https://openairdocs.org/ntsb/MKC68D0410.md): Cessna 172 · Kansas City, MO · Accident · No injuries · Closed · Nov 24, 1967 · N8673B · Substantial damage
- [NTSB MIA68F0294](https://openairdocs.org/ntsb/MIA68F0294.md): Cessna 172 · Cleveland, MS · Accident · Minor injuries · Closed · Nov 24, 1967 · N6321E · Substantial damage
- [NTSB MIA68F0295](https://openairdocs.org/ntsb/MIA68F0295.md): Cessna 172 · Yazoo City, MS · Accident · No injuries · Closed · Nov 18, 1967 · N4070F · Substantial damage
- [NTSB MKC68F0358](https://openairdocs.org/ntsb/MKC68F0358.md): Cessna 172 · Hill City, MN · Accident · No injuries · Closed · Nov 13, 1967 · N5686A · Substantial damage
- [NTSB SEA68F0224](https://openairdocs.org/ntsb/SEA68F0224.md): Cessna 172 · Castle Rock, WA · Accident · Minor injuries · Closed · Nov 12, 1967 · N7045T · Substantial damage
- [NTSB SEA68D0209](https://openairdocs.org/ntsb/SEA68D0209.md): Cessna 172 · Wolf Point, MT · Accident · No injuries · Closed · Nov 11, 1967 · N3910F · Substantial damage
- [NTSB MKC68D0346](https://openairdocs.org/ntsb/MKC68D0346.md): Cessna 172 · Blair, NE · Accident · No injuries · Closed · Nov 11, 1967 · N6976A · Substantial damage
- [NTSB DEN68D0146](https://openairdocs.org/ntsb/DEN68D0146.md): Cessna 172 · Richfield, UT · Accident · Minor injuries · Closed · Nov 10, 1967 · N4091F · Destroyed
- [NTSB MKC68D0345](https://openairdocs.org/ntsb/MKC68D0345.md): Cessna 172 · Newport, NE · Accident · No injuries · Closed · Nov 9, 1967 · N8241B · Substantial damage
- [NTSB FTW68F0347](https://openairdocs.org/ntsb/FTW68F0347.md): Cessna 172 · Lubbock, TX · Accident · No injuries · Closed · Nov 2, 1967 · N8839B · Substantial damage
- [NTSB MKC68F0325](https://openairdocs.org/ntsb/MKC68F0325.md): Cessna 172 · Lexington, NE · Accident · 1 fatal · Closed · Oct 22, 1967 · N8727B · Destroyed
- [NTSB MIA68F0332](https://openairdocs.org/ntsb/MIA68F0332.md): Cessna 172 · Jacksonville, FL · Accident · No injuries · Closed · Oct 14, 1967 · N6909A · Substantial damage
- [NTSB CHI68D0374](https://openairdocs.org/ntsb/CHI68D0374.md): Cessna 172 · Beecher, IL · Accident · No injuries · Closed · Oct 14, 1967 · N8795B · Substantial damage
- [NTSB OAK68A0034](https://openairdocs.org/ntsb/OAK68A0034.md): Cessna 150G · Las Vegas, NV · Accident · 2 fatal · Closed · Oct 8, 1967 · N3229J · 2 aircraft · Destroyed
- [NTSB MIA68A0035](https://openairdocs.org/ntsb/MIA68A0035.md): Cessna 172 · Villa Rica, GA · Accident · 3 fatal · Closed · Oct 8, 1967 · N5625A · Destroyed
- [NTSB MIA68A0034](https://openairdocs.org/ntsb/MIA68A0034.md): Cessna 172 · Isle Culebra, PR · Accident · 2 fatal · Closed · Oct 8, 1967 · N8372U · Destroyed
- [NTSB CHI68D0356](https://openairdocs.org/ntsb/CHI68D0356.md): Cessna 172 · Findlay, OH · Accident · No injuries · Closed · Oct 8, 1967 · N6148E · Substantial damage
- [NTSB 3AK68D0148](https://openairdocs.org/ntsb/3AK68D0148.md): Cessna 172 · Firebaugh, CA · Accident · No injuries · Closed · Oct 4, 1967 · N8611B · Substantial damage
- [NTSB NYC68D0224](https://openairdocs.org/ntsb/NYC68D0224.md): Cessna 172 · Mahopac, NY · Accident · No injuries · Closed · Sep 30, 1967 · N6114E · Substantial damage
- [NTSB MKC68F0242](https://openairdocs.org/ntsb/MKC68F0242-201110.md): Cessna 172 · Green Isle, MN · Accident · Minor injuries · Closed · Sep 24, 1967 · N6389E · Destroyed
- [NTSB OAK68D0197](https://openairdocs.org/ntsb/OAK68D0197.md): Cessna 172 · Napa, CA · Accident · No injuries · Closed · Sep 21, 1967 · N6986A · Substantial damage
- [NTSB SEA68A0027](https://openairdocs.org/ntsb/SEA68A0027.md): Cessna 172 · Portland, OR · Accident · 1 fatal · Closed · Sep 16, 1967 · N5907A · Destroyed
- [NTSB MKC68D0187](https://openairdocs.org/ntsb/MKC68D0187.md): Cessna 172 · Corydon, IA · Accident · No injuries · Closed · Sep 15, 1967 · N6800A · Substantial damage

Next page: https://openairdocs.org/ntsb.md?model=2072402&page=17

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

This list as a web page: https://openairdocs.org/ntsb?model=2072402&page=16

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