# 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 9 of 10 · 455 cases ## Cases, newest first - [NTSB LAX65A0061](https://openairdocs.org/ntsb/LAX65A0061.md): Cessna 172E · Fullerton, CA · Accident · 4 fatal · Closed · Jan 24, 1965 · N3974S · Destroyed - [NTSB CHI65D0014](https://openairdocs.org/ntsb/CHI65D0014.md): Cessna 172 · Youngstown, OH · Accident · No injuries · Closed · Jan 21, 1965 · N5470T · Substantial damage - [NTSB UNK65X1318](https://openairdocs.org/ntsb/UNK65X1318.md): Cessna 172 · Wellsburg, WV · Accident · Serious injuries · Closed · Jan 19, 1965 · N7775U · Substantial damage - [NTSB UNK65X1135](https://openairdocs.org/ntsb/UNK65X1135.md): Cessna 172 · Belle Glade, FL · Accident · No injuries · Closed · Dec 26, 1964 · N3723S · Substantial damage - [NTSB UNK65X1109](https://openairdocs.org/ntsb/UNK65X1109.md): Cessna 172E · San Antonio, TX · Accident · No injuries · Closed · Dec 24, 1964 · N5743T · Substantial damage - [NTSB UNK65X1069](https://openairdocs.org/ntsb/UNK65X1069.md): Cessna 172E · Miami, FL · Accident · No injuries · Closed · Dec 20, 1964 · N3920S · Substantial damage - [NTSB UNK65X1050](https://openairdocs.org/ntsb/UNK65X1050.md): Cessna 172 · Mesquite, NV · Accident · No injuries · Closed · Dec 19, 1964 · N5503T · Substantial damage - [NTSB UNK65X1031](https://openairdocs.org/ntsb/UNK65X1031.md): Cessna 172 · Middleburg, VA · Accident · No injuries · Closed · Dec 16, 1964 · N7790U · Substantial damage - [NTSB UNK65X1018](https://openairdocs.org/ntsb/UNK65X1018.md): Cessna 172 · Teterboro, NJ · Accident · No injuries · Closed · Dec 15, 1964 · N5413T · Substantial damage - [NTSB UNK65X0947](https://openairdocs.org/ntsb/UNK65X0947.md): Cessna 172 · Riverside, CA · Accident · No injuries · Closed · Dec 7, 1964 · N3090U · Substantial damage - [NTSB UNK65X0870](https://openairdocs.org/ntsb/UNK65X0870.md): Cessna 172 · Philadelphia, PA · Accident · 4 fatal · Closed · Nov 28, 1964 · N3558S · Destroyed - [NTSB UNK65X0597](https://openairdocs.org/ntsb/UNK65X0597.md): Cessna 172 · Lawton, OK · Accident · No injuries · Closed · Nov 7, 1964 · N3062U · Substantial damage - [NTSB UNK65X0573](https://openairdocs.org/ntsb/UNK65X0573.md): Cessna 172B · Mattituck, NY · Accident · 2 fatal · Closed · Nov 5, 1964 · N5789T · Destroyed - [NTSB UNK65X0485](https://openairdocs.org/ntsb/UNK65X0485.md): Cessna 172E · Lubec, ME · Accident · No injuries · Closed · Oct 30, 1964 · N5561T · Substantial damage - [NTSB UNK65X0393](https://openairdocs.org/ntsb/UNK65X0393.md): Cessna 172 · Marks, MS · Accident · No injuries · Closed · Oct 24, 1964 · N3864S · Substantial damage - [NTSB UNK65X0361](https://openairdocs.org/ntsb/UNK65X0361.md): Cessna 172 · Covington, LA · Accident · Minor injuries · Closed · Oct 21, 1964 · N3719S · Substantial damage - [NTSB UNK65X0319](https://openairdocs.org/ntsb/UNK65X0319.md): Cessna 172 · Rancho Mirage, CA · Accident · 1 fatal · Closed · Oct 18, 1964 · N3593S · Destroyed - [NTSB UNK64X4097](https://openairdocs.org/ntsb/UNK64X4097.md): Cessna 172E · Festus, MO · Accident · No injuries · Closed · Sep 22, 1964 · N5347T · Substantial damage - [NTSB UNK64X4047](https://openairdocs.org/ntsb/UNK64X4047.md): Cessna 172 · Hagerstown, MD · Accident · Minor injuries · Closed · Sep 19, 1964 · N3703S · Substantial damage - [NTSB UNK64X3954](https://openairdocs.org/ntsb/UNK64X3954.md): Cessna 172E · Boling, TX · Accident · 1 fatal · Closed · Sep 13, 1964 · N5391T · Destroyed - [NTSB UNK64X3900](https://openairdocs.org/ntsb/UNK64X3900.md): Cessna 172 · Detroit, MI · Accident · No injuries · Closed · Sep 10, 1964 · N3661S · Substantial damage - [NTSB UNK64X3815](https://openairdocs.org/ntsb/UNK64X3815.md): Cessna 172E · Flippin, AR · Accident · No injuries · Closed · Sep 6, 1964 · N5427T · Substantial damage - [NTSB UNK64X3761](https://openairdocs.org/ntsb/UNK64X3761.md): Cessna 172E · Champaign, IL · Accident · No injuries · Closed · Sep 4, 1964 · N5715T · Substantial damage - [NTSB UNK64X3738](https://openairdocs.org/ntsb/UNK64X3738.md): Cessna 172E · Eielson Afb, AK · Accident · 2 fatal · Closed · Sep 2, 1964 · N5450T · Destroyed - [NTSB UNK64X3624](https://openairdocs.org/ntsb/UNK64X3624.md): Cessna 172 · Lafayette, IN · Accident · No injuries · Closed · Aug 27, 1964 · N3020U · Substantial damage - [NTSB UNK64X3603](https://openairdocs.org/ntsb/UNK64X3603.md): Cessna 172 · Miami, FL · Accident · No injuries · Closed · Aug 26, 1964 · N5600T · Substantial damage - [NTSB UNK64X3382](https://openairdocs.org/ntsb/UNK64X3382.md): Cessna 172 · Ft Atkinson, WI · Accident · No injuries · Closed · Aug 14, 1964 · N5681T · Substantial damage - [NTSB UNK64X3239](https://openairdocs.org/ntsb/UNK64X3239.md): Cessna 172 · Ypsilanti, MI · Accident · No injuries · Closed · Aug 6, 1964 · N5418T · Destroyed - [NTSB UNK64X3207](https://openairdocs.org/ntsb/UNK64X3207.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Aug 4, 1964 · N5519T · Substantial damage - [NTSB UNK64X3112](https://openairdocs.org/ntsb/UNK64X3112.md): Cessna 172E · Ft Lauderdale, FL · Accident · Serious injuries · Closed · Jul 29, 1964 · N5456T · No damage - [NTSB UNK64X3064](https://openairdocs.org/ntsb/UNK64X3064.md): Cessna 172 · Wilmington, DE · Accident · No injuries · Closed · Jul 27, 1964 · N7790U · Substantial damage - [NTSB UNK64X2777](https://openairdocs.org/ntsb/UNK64X2777.md): Cessna 172E · Milpitas, CA · Accident · 1 fatal · Closed · Jul 12, 1964 · N5554T · Destroyed - [NTSB UNK64X2566](https://openairdocs.org/ntsb/UNK64X2566.md): Cessna 172 · Roscoe, NY · Accident · Minor injuries · Closed · Jun 29, 1964 · N3088U · Destroyed - [NTSB UNK64X2426](https://openairdocs.org/ntsb/UNK64X2426.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Jun 21, 1964 · N5508T · Substantial damage - [NTSB UNK64X2362](https://openairdocs.org/ntsb/UNK64X2362.md): Cessna 172 · Anglemont Bc, Canada · Accident · No injuries · Closed · Jun 19, 1964 · N3578S · Substantial damage - [NTSB UNK64X2162](https://openairdocs.org/ntsb/UNK64X2162.md): Cessna 172 · Sunset Beach, CA · Accident · No injuries · Closed · Jun 7, 1964 · N3859S · Substantial damage - [NTSB UNK64X2102](https://openairdocs.org/ntsb/UNK64X2102.md): Cessna 172E · Canton, MS · Accident · No injuries · Closed · Jun 4, 1964 · N3805S · Substantial damage - [NTSB UNK64X2031](https://openairdocs.org/ntsb/UNK64X2031.md): Cessna 172 · Nenana, AK · Accident · Minor injuries · Closed · May 30, 1964 · N3562S · Substantial damage - [NTSB UNK64X1936](https://openairdocs.org/ntsb/UNK64X1936.md): Cessna 172E · Wheeling, IL · Accident · No injuries · Closed · May 24, 1964 · N3742S · Substantial damage - [NTSB UNK64X1914](https://openairdocs.org/ntsb/UNK64X1914.md): Cessna 172 · Eagles Mere, PA · Accident · No injuries · Closed · May 23, 1964 · N5424T · Substantial damage - [NTSB UNK64X1763](https://openairdocs.org/ntsb/UNK64X1763.md): Cessna 172 · Mt Vernon, IN · Accident · No injuries · Closed · May 14, 1964 · N5328T · Substantial damage - [NTSB UNK64X1610](https://openairdocs.org/ntsb/UNK64X1610.md): Cessna 172 · Ambler, PA · Accident · No injuries · Closed · May 4, 1964 · N3057U · Substantial damage - [NTSB UNK64X1591](https://openairdocs.org/ntsb/UNK64X1591.md): Cessna 172 · Casper, WY · Accident · No injuries · Closed · May 3, 1964 · N3741S · Substantial damage - [NTSB UNK64X1507](https://openairdocs.org/ntsb/UNK64X1507.md): Cessna 172 · Picayune, MS · Accident · No injuries · Closed · Apr 29, 1964 · N3980S · Substantial damage - [NTSB UNK64X1497](https://openairdocs.org/ntsb/UNK64X1497.md): Cessna 172 · Santa Ana, CA · Accident · No injuries · Closed · Apr 28, 1964 · N3879S · Substantial damage - [NTSB UNK64X1419](https://openairdocs.org/ntsb/UNK64X1419.md): Cessna 172E · Lancaster, OH · Accident · Minor injuries · Closed · Apr 23, 1964 · N3702S · Substantial damage - [NTSB UNK64X1403](https://openairdocs.org/ntsb/UNK64X1403.md): Cessna 172 · Chillicothe, MO · Accident · No injuries · Closed · Apr 21, 1964 · N3586S · Substantial damage - [NTSB UNK64X1278](https://openairdocs.org/ntsb/UNK64X1278.md): Cessna 172E · Malibu, CA · Accident · Minor injuries · Closed · Apr 12, 1964 · N3051U · Destroyed - [NTSB UNK64X1235](https://openairdocs.org/ntsb/UNK64X1235.md): Cessna 172E · Prudence Is, RI · Accident · No injuries · Closed · Apr 9, 1964 · N3558S · Substantial damage - [NTSB UNK64X1088](https://openairdocs.org/ntsb/UNK64X1088.md): Cessna 172D · Wellington, KS · Accident · No injuries · Closed · Mar 29, 1964 · N3835S · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=2072412&page=10 ## 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=9 --- 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.