# 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 19 of 22 · 1,096 cases ## Cases, newest first - [NTSB MKC67F0028](https://openairdocs.org/ntsb/MKC67F0028.md): Cessna 172 · Berger, MO · Accident · No injuries · Closed · Jun 17, 1966 · N7287A · Substantial damage - [NTSB OAK66A0056](https://openairdocs.org/ntsb/OAK66A0056.md): Cessna 172 · Seigler Sprgs, CA · Accident · 2 fatal · Closed · Jun 11, 1966 · N7204A · Destroyed - [NTSB FTW67D0037](https://openairdocs.org/ntsb/FTW67D0037.md): Cessna 172 · Alba, TX · Accident · No injuries · Closed · Jun 11, 1966 · N5621A · Substantial damage - [NTSB SEA66D0290](https://openairdocs.org/ntsb/SEA66D0290.md): Cessna 172 · Camas Prairi, MT · Accident · No injuries · Closed · Jun 5, 1966 · N5008A · Substantial damage - [NTSB MIA67F0158](https://openairdocs.org/ntsb/MIA67F0158.md): Cessna 172 · Palatka, FL · Accident · Serious injuries · Closed · Jun 4, 1966 · N4139F · Substantial damage - [NTSB NYC67F0002](https://openairdocs.org/ntsb/NYC67F0002.md): Cessna 172 · Northfield, CT · Accident · Minor injuries · Closed · Jun 3, 1966 · N8790B · Substantial damage - [NTSB MKC67D0069](https://openairdocs.org/ntsb/MKC67D0069.md): Cessna 172 · St.Charles, MO · Accident · No injuries · Closed · May 28, 1966 · N5643A · Substantial damage - [NTSB FTW66A0109](https://openairdocs.org/ntsb/FTW66A0109.md): Cessna 172 · Boyce, LA · Accident · 1 fatal · Closed · May 28, 1966 · N5886A · Destroyed - [NTSB NYC66D0705](https://openairdocs.org/ntsb/NYC66D0705.md): Cessna 172 · Penn Yan, NY · Accident · No injuries · Closed · May 27, 1966 · N6197E · Substantial damage - [NTSB CHI66D0777](https://openairdocs.org/ntsb/CHI66D0777.md): Cessna 172 · Middleton, WI · Accident · Minor injuries · Closed · May 26, 1966 · N8795B · Substantial damage - [NTSB SEA66A0060](https://openairdocs.org/ntsb/SEA66A0060.md): Cessna 172 · Metaline Fls, WA · Accident · 3 fatal · Closed · May 24, 1966 · N7230A · Substantial damage - [NTSB NYC66A0714](https://openairdocs.org/ntsb/NYC66A0714.md): Cessna 172 · Clinton, MD · Accident · Serious injuries · Closed · May 20, 1966 · N6117E · Destroyed - [NTSB MKC66D0545](https://openairdocs.org/ntsb/MKC66D0545.md): Cessna 172 · Worthington, MN · Accident · No injuries · Closed · May 19, 1966 · N7040T · Substantial damage - [NTSB SEA66D0265](https://openairdocs.org/ntsb/SEA66D0265.md): Cessna 172 · Havre, MT · Accident · No injuries · Closed · May 12, 1966 · N7285A · Substantial damage - [NTSB DEN67D0013](https://openairdocs.org/ntsb/DEN67D0013.md): Cessna 172 · Sierra Vista, AZ · Accident · No injuries · Closed · May 11, 1966 · N9180Z · Substantial damage - [NTSB SEA67F0041](https://openairdocs.org/ntsb/SEA67F0041.md): Cessna 172 · Ocean Shores, WA · Accident · Serious injuries · Closed · May 8, 1966 · N5949A · Destroyed - [NTSB OAK66D0289](https://openairdocs.org/ntsb/OAK66D0289.md): Cessna 172 · Tracy, CA · Accident · No injuries · Closed · May 7, 1966 · N5023A · Substantial damage - [NTSB CHI66F0720](https://openairdocs.org/ntsb/CHI66F0720.md): Cessna 172 · Dimondale, MI · Accident · No injuries · Closed · May 7, 1966 · N6428B · Substantial damage - [NTSB CHI66D0722](https://openairdocs.org/ntsb/CHI66D0722.md): Cessna 172 · Leonidas, MI · Accident · No injuries · Closed · May 2, 1966 · N8363B · Substantial damage - [NTSB CHI66D0746](https://openairdocs.org/ntsb/CHI66D0746.md): Cessna 172 · Angola, IN · Accident · No injuries · Closed · Apr 29, 1966 · N5999A · Substantial damage - [NTSB DEN66D0322](https://openairdocs.org/ntsb/DEN66D0322.md): Cessna 172 · Elroy, AZ · Accident · No injuries · Closed · Apr 24, 1966 · N4170F · Substantial damage - [NTSB FTW66D0623](https://openairdocs.org/ntsb/FTW66D0623.md): Cessna 172 · Freemason Is, LA · Accident · No injuries · Closed · Apr 8, 1966 · N7967B · Substantial damage - [NTSB NYC66D0605](https://openairdocs.org/ntsb/NYC66D0605.md): Cessna 172 · Taylorsville, MD · Accident · No injuries · Closed · Apr 3, 1966 · N7046A · Substantial damage - [NTSB MKC66D0532](https://openairdocs.org/ntsb/MKC66D0532.md): Cessna 172 · Faribault, MN · Accident · No injuries · Closed · Mar 31, 1966 · N8264B · Substantial damage - [NTSB MKC66D0531](https://openairdocs.org/ntsb/MKC66D0531.md): Cessna 172 · Minneapolis, MN · Accident · Minor injuries · Closed · Mar 31, 1966 · N8159B · Substantial damage - [NTSB MKC66D0524](https://openairdocs.org/ntsb/MKC66D0524.md): Cessna 172 · Yankton, SD · Accident · No injuries · Closed · Mar 31, 1966 · N5600A · Substantial damage - [NTSB DEN66F0265](https://openairdocs.org/ntsb/DEN66F0265.md): Cessna 172 · Kearns, UT · Accident · No injuries · Closed · Mar 24, 1966 · N8307B · Substantial damage - [NTSB FTW66D0528](https://openairdocs.org/ntsb/FTW66D0528.md): Cessna 172 · Franklin, LA · Accident · No injuries · Closed · Mar 12, 1966 · N5757A · Substantial damage - [NTSB MKC66F0486](https://openairdocs.org/ntsb/MKC66F0486.md): Cessna 172 · Dexter, MN · Accident · No injuries · Closed · Mar 8, 1966 · N5100A · Substantial damage - [NTSB DEN66D0313](https://openairdocs.org/ntsb/DEN66D0313.md): Cessna 172 · San Simon, AZ · Accident · No injuries · Closed · Feb 8, 1966 · N5942A · Substantial damage - [NTSB NYC66D0532](https://openairdocs.org/ntsb/NYC66D0532.md): Cessna 172 · Warwick, NY · Accident · No injuries · Closed · Feb 6, 1966 · N8508B · Substantial damage - [NTSB FTW66F0493](https://openairdocs.org/ntsb/FTW66F0493.md): Cessna 172 · Amarillo, TX · Accident · No injuries · Closed · Jan 31, 1966 · N6364E · Substantial damage - [NTSB DEN66D0241](https://openairdocs.org/ntsb/DEN66D0241.md): Cessna 172 · Nunn, CO · Accident · No injuries · Closed · Jan 30, 1966 · N6221E · Substantial damage - [NTSB NYC66D0468](https://openairdocs.org/ntsb/NYC66D0468.md): Cessna 172 · Emlenton, PA · Accident · No injuries · Closed · Jan 29, 1966 · N6258E · Substantial damage - [NTSB LAX66D0283](https://openairdocs.org/ntsb/LAX66D0283.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Closed · Jan 23, 1966 · N5380R · Substantial damage - [NTSB CHI66A0063](https://openairdocs.org/ntsb/CHI66A0063.md): Piper PA-22 · Rockton, IL · Accident · 5 fatal · Closed · Jan 23, 1966 · N2712P · 2 aircraft · Destroyed - [NTSB LAX66F0320](https://openairdocs.org/ntsb/LAX66F0320.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Closed · Jan 18, 1966 · N5773A · Substantial damage - [NTSB CHI66F0513](https://openairdocs.org/ntsb/CHI66F0513.md): Cessna 172 · Greenville, MI · Accident · Minor injuries · Closed · Jan 16, 1966 · N7053A · Substantial damage - [NTSB FTW66D0467](https://openairdocs.org/ntsb/FTW66D0467.md): Cessna 172 · Conway, AR · Accident · No injuries · Closed · Jan 9, 1966 · N6876A · Substantial damage - [NTSB NYC66F0427](https://openairdocs.org/ntsb/NYC66F0427.md): Cessna 172 · Lewiston, ME · Accident · No injuries · Closed · Dec 23, 1965 · N8197B · Substantial damage - [NTSB FTW66F0453](https://openairdocs.org/ntsb/FTW66F0453.md): Cessna 172 · Houston, TX · Accident · No injuries · Closed · Dec 9, 1965 · N8935B · Substantial damage - [NTSB MIA66A0062](https://openairdocs.org/ntsb/MIA66A0062.md): Cessna 172 · St Marys, GA · Accident · 1 fatal · Closed · Nov 27, 1965 · N6232E · Destroyed - [NTSB DEN66F0156](https://openairdocs.org/ntsb/DEN66F0156.md): Cessna 172 · Usaf Academy, CO · Accident · No injuries · Closed · Nov 14, 1965 · N346TC · Substantial damage - [NTSB NYC66D0342](https://openairdocs.org/ntsb/NYC66D0342.md): Cessna 172 · College Park, MD · Accident · No injuries · Closed · Nov 13, 1965 · N6225E · Substantial damage - [NTSB CHI66D0431](https://openairdocs.org/ntsb/CHI66D0431.md): Cessna 172 · Canton, OH · Accident · No injuries · Closed · Nov 10, 1965 · N9170B · Substantial damage - [NTSB LAX66D0170](https://openairdocs.org/ntsb/LAX66D0170.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Closed · Nov 7, 1965 · N5380R · Substantial damage - [NTSB CHI66A0046](https://openairdocs.org/ntsb/CHI66A0046.md): Cessna 172 · West Salem, OH · Accident · 3 fatal · Closed · Nov 7, 1965 · N7346A · Destroyed - [NTSB MKC66D0308](https://openairdocs.org/ntsb/MKC66D0308.md): Cessna 172 · Maple Plain, MN · Accident · No injuries · Closed · Oct 29, 1965 · N6345E · Substantial damage - [NTSB MIA66D0359](https://openairdocs.org/ntsb/MIA66D0359.md): Cessna 172 · Aliceville, AL · Accident · No injuries · Closed · Oct 17, 1965 · N8385B · Substantial damage - [NTSB CHI66D0379](https://openairdocs.org/ntsb/CHI66D0379.md): Cessna 172 · Greenwood, IN · Accident · No injuries · Closed · Oct 17, 1965 · N6105E · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=2072402&page=20 ## 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=19 --- 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.