# NTSB investigations: Cessna 172E 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 7 of 10 · 455 cases ## Cases, newest first - [NTSB FTW68D0102](https://openairdocs.org/ntsb/FTW68D0102.md): Cessna 172 · Freemason Isle, LA · Accident · No injuries · Closed · Aug 2, 1967 · N3679S · Substantial damage - [NTSB CHI68F0150](https://openairdocs.org/ntsb/CHI68F0150.md): Cessna 172E · Hobart, IN · Accident · No injuries · Closed · Jul 20, 1967 · N7727U · Substantial damage - [NTSB MKC68D0080](https://openairdocs.org/ntsb/MKC68D0080.md): Cessna 182 · Oskaloosa, IA · Accident · No injuries · Closed · Jul 15, 1967 · N2611G · 2 aircraft · No damage - [NTSB LAX68F0054](https://openairdocs.org/ntsb/LAX68F0054.md): Cessna 172 · Arcadia, CA · Accident · No injuries · Closed · Jul 2, 1967 · N3879S · Substantial damage - [NTSB FTW68D0082](https://openairdocs.org/ntsb/FTW68D0082.md): Cessna 172 · Huttig, AR · Accident · Minor injuries · Closed · Jul 2, 1967 · N3624S · Substantial damage - [NTSB FTW68D0062](https://openairdocs.org/ntsb/FTW68D0062.md): Cessna 172 · Griffithville, AR · Accident · No injuries · Closed · Jul 1, 1967 · N3620S · Substantial damage - [NTSB NYC67F0671](https://openairdocs.org/ntsb/NYC67F0671.md): Cessna 172 · Caribou, ME · Accident · No injuries · Closed · May 27, 1967 · N3738S · Substantial damage - [NTSB FTW67D0643](https://openairdocs.org/ntsb/FTW67D0643.md): Cessna 172 · Earle, AR · Accident · No injuries · Closed · May 27, 1967 · N3867S · Substantial damage - [NTSB LAX67D0390](https://openairdocs.org/ntsb/LAX67D0390.md): Cessna 172 · Murrieta, CA · Accident · No injuries · Closed · May 7, 1967 · N5504T · Substantial damage - [NTSB SEA67F0327](https://openairdocs.org/ntsb/SEA67F0327.md): Cessna 172E · Vancouver, WA · Accident · Minor injuries · Closed · Apr 17, 1967 · N7705U · Substantial damage - [NTSB NYC67D0624](https://openairdocs.org/ntsb/NYC67D0624.md): Cessna 172E · Block Island, RI · Accident · No injuries · Closed · Mar 25, 1967 · N3500S · Substantial damage - [NTSB MIA67A0096](https://openairdocs.org/ntsb/MIA67A0096.md): Cessna 172E · Donalsonville, GA · Accident · 2 fatal · Closed · Mar 25, 1967 · N7730U · Destroyed - [NTSB LAX67F0333](https://openairdocs.org/ntsb/LAX67F0333.md): Cessna 172 · Phoenix, AZ · Accident · 1 fatal · Closed · Mar 9, 1967 · N3959S · Substantial damage - [NTSB FTW67F0479](https://openairdocs.org/ntsb/FTW67F0479.md): Cessna 172 · Hughes, AR · Accident · No injuries · Closed · Feb 22, 1967 · N7749U · Substantial damage - [NTSB LAX67F0273](https://openairdocs.org/ntsb/LAX67F0273.md): Cessna 172 · Van Nuys, CA · Accident · No injuries · Closed · Feb 11, 1967 · N5504T · Substantial damage - [NTSB SEA67D0238](https://openairdocs.org/ntsb/SEA67D0238.md): Cessna 172 · Pasco, WA · Accident · No injuries · Closed · Jan 29, 1967 · N3034U · Substantial damage - [NTSB MKC67F0438](https://openairdocs.org/ntsb/MKC67F0438.md): Cessna 172 · Blaine, MN · Accident · No injuries · Closed · Jan 28, 1967 · N3024U · Substantial damage - [NTSB FTW67F0423](https://openairdocs.org/ntsb/FTW67F0423.md): Cessna 172 · Fort Worth, TX · Accident · No injuries · Closed · Jan 26, 1967 · N3691S · Substantial damage - [NTSB NYC67F0419](https://openairdocs.org/ntsb/NYC67F0419.md): Cessna 172E · Lakeville, PA · Accident · No injuries · Closed · Jan 8, 1967 · N3790S · Substantial damage - [NTSB NYC67D0465](https://openairdocs.org/ntsb/NYC67D0465.md): Cessna 172 · Middletown, NY · Accident · No injuries · Closed · Jan 2, 1967 · N5506T · Substantial damage - [NTSB FTW67D0400](https://openairdocs.org/ntsb/FTW67D0400.md): Cessna 172 · Lawton, OK · Accident · No injuries · Closed · Jan 2, 1967 · N3693S · Substantial damage - [NTSB NYC67D0494](https://openairdocs.org/ntsb/NYC67D0494.md): Cessna 172 · Moorestown, NJ · Accident · No injuries · Closed · Dec 30, 1966 · N5563T · Substantial damage - [NTSB OAK67F0209](https://openairdocs.org/ntsb/OAK67F0209.md): Cessna 172 · Bishop, CA · Accident · No injuries · Closed · Dec 22, 1966 · N3579S · Destroyed - [NTSB MKC67F0394](https://openairdocs.org/ntsb/MKC67F0394.md): Cessna 172E · Farmington, MO · Accident · Serious injuries · Closed · Dec 19, 1966 · N5732T · Destroyed - [NTSB CHI67D0418](https://openairdocs.org/ntsb/CHI67D0418.md): Cessna 172 · Kasbeer, IL · Accident · Minor injuries · Closed · Nov 26, 1966 · N3588S · Substantial damage - [NTSB MIA67D0311](https://openairdocs.org/ntsb/MIA67D0311.md): Cessna 172 · Ft-Bassinger, FL · Accident · No injuries · Closed · Nov 4, 1966 · N3582S · Substantial damage - [NTSB MIA67F0212](https://openairdocs.org/ntsb/MIA67F0212.md): Cessna 172E · Tampa, FL · Accident · No injuries · Closed · Sep 20, 1966 · N3685S · Substantial damage - [NTSB MKC67F0257](https://openairdocs.org/ntsb/MKC67F0257.md): Cessna 172E · St.Charles, MO · Accident · No injuries · Closed · Sep 5, 1966 · N7730U · Substantial damage - [NTSB MKC67A0018](https://openairdocs.org/ntsb/MKC67A0018.md): Cessna 172E · Knox City, MO · Accident · 1 fatal · Closed · Aug 28, 1966 · N3915S · Destroyed - [NTSB NYC67F0239](https://openairdocs.org/ntsb/NYC67F0239.md): Cessna 172 · Neptune, NJ · Accident · No injuries · Closed · Aug 18, 1966 · N5414T · Substantial damage - [NTSB CHI67D0146](https://openairdocs.org/ntsb/CHI67D0146-201158.md): Cessna 172 · Reed City, MI · Accident · No injuries · Closed · Jul 31, 1966 · N5407T · Substantial damage - [NTSB LAX67D0082](https://openairdocs.org/ntsb/LAX67D0082.md): Cessna 172 · Santa Ynez, CA · Accident · Minor injuries · Closed · Jul 30, 1966 · N3946S · Substantial damage - [NTSB NYC67D0105](https://openairdocs.org/ntsb/NYC67D0105.md): Cessna 172 · Madison, CT · Accident · No injuries · Closed · Jul 17, 1966 · N3597S · Substantial damage - [NTSB OAK67F0013](https://openairdocs.org/ntsb/OAK67F0013.md): Cessna 172E · Vacaville, CA · Accident · Serious injuries · Closed · Jun 26, 1966 · N3911S · Substantial damage - [NTSB OAK67F0027](https://openairdocs.org/ntsb/OAK67F0027.md): Cessna 172E · Fresno, CA · Accident · No injuries · Closed · Jun 12, 1966 · N5386T · Substantial damage - [NTSB FTW67F0013](https://openairdocs.org/ntsb/FTW67F0013.md): Cessna 172 · Hackberry, LA · Accident · No injuries · Closed · Jun 12, 1966 · N3719S · Substantial damage - [NTSB LAX66A0093](https://openairdocs.org/ntsb/LAX66A0093.md): Cessna 172E · Wendover, NV · Accident · 2 fatal · Closed · May 26, 1966 · N3887S · Destroyed - [NTSB MIA66A0128](https://openairdocs.org/ntsb/MIA66A0128.md): Cessna 172E · Clearwater, FL · Accident · 2 fatal · Closed · May 5, 1966 · N3907S · Destroyed - [NTSB LAX66D0340](https://openairdocs.org/ntsb/LAX66D0340.md): Cessna 172 · Adelanto, CA · Accident · No injuries · Closed · Apr 17, 1966 · N5647T · Substantial damage - [NTSB CHI66F0685](https://openairdocs.org/ntsb/CHI66F0685.md): Cessna 172E · Beaver Dam, WI · Accident · No injuries · Closed · Apr 10, 1966 · N5361T · Substantial damage - [NTSB CHI66D0713](https://openairdocs.org/ntsb/CHI66D0713.md): Cessna 172E · Albany, KY · Accident · Minor injuries · Closed · Apr 7, 1966 · N5737T · Destroyed - [NTSB MKC66D0490](https://openairdocs.org/ntsb/MKC66D0490.md): Cessna 172 · Moberly, MO · Accident · No injuries · Closed · Apr 2, 1966 · N5652T · Substantial damage - [NTSB MKC66D0527](https://openairdocs.org/ntsb/MKC66D0527.md): Cessna 172 · Creston, IA · Accident · No injuries · Closed · Mar 31, 1966 · N3940S · Substantial damage - [NTSB MIA66D0503](https://openairdocs.org/ntsb/MIA66D0503.md): Cessna 172 · Dalton, GA · Accident · No injuries · Closed · Mar 31, 1966 · N3792S · Substantial damage - [NTSB MIA66D0510](https://openairdocs.org/ntsb/MIA66D0510.md): Cessna 172 · Moncks Corner, SC · Accident · No injuries · Closed · Mar 27, 1966 · N5340T · Substantial damage - [NTSB FTW66D0583](https://openairdocs.org/ntsb/FTW66D0583.md): Cessna 172 · Randlett, OK · Accident · Minor injuries · Closed · Mar 26, 1966 · N3773S · Substantial damage - [NTSB DEN66F0253](https://openairdocs.org/ntsb/DEN66F0253.md): Cessna 172E · Denver, CO · Accident · No injuries · Closed · Mar 17, 1966 · N5718T · Destroyed - [NTSB FTW66D0525](https://openairdocs.org/ntsb/FTW66D0525.md): Cessna 172 · Oklahoma City, OK · Accident · No injuries · Closed · Mar 5, 1966 · N5747T · Substantial damage - [NTSB CHI66F0621](https://openairdocs.org/ntsb/CHI66F0621.md): Cessna 172E · E Alton, IL · Accident · No injuries · Closed · Mar 4, 1966 · N3501S · Substantial damage - [NTSB LAX66F0252](https://openairdocs.org/ntsb/LAX66F0252.md): Cessna 172 · Bakersfield, CA · Accident · No injuries · Closed · Feb 22, 1966 · N5720T · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=2072412&page=8 ## 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 ('2072412')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=2072412&page=7 --- 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.