# NTSB investigations: Cessna 172H 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 12 · 570 cases ## Cases, newest first - [NTSB NYC71DFM20](https://openairdocs.org/ntsb/NYC71DFM20.md): Cessna 172H · Ansonia, CT · Accident · Minor injuries · Closed · Oct 18, 1970 · N3924R · Substantial damage - [NTSB MIA71FLG12](https://openairdocs.org/ntsb/MIA71FLG12.md): Cessna 172H · Greenville, SC · Accident · Minor injuries · Closed · Sep 30, 1970 · N8205L · Destroyed - [NTSB NYC71FGM16](https://openairdocs.org/ntsb/NYC71FGM16.md): Cessna 172H · Smethport, PA · Accident · Minor injuries · Closed · Sep 28, 1970 · N3241L · Substantial damage - [NTSB FTW71FQG32](https://openairdocs.org/ntsb/FTW71FQG32.md): Cessna 172H · Lubbock, TX · Accident · Serious injuries · Closed · Sep 12, 1970 · N1442F · Substantial damage - [NTSB SEA71DVQ11](https://openairdocs.org/ntsb/SEA71DVQ11.md): Cessna 172H · Ashland, OR · Accident · Serious injuries · Closed · Sep 5, 1970 · N3783R · Destroyed - [NTSB OAK71DVD09](https://openairdocs.org/ntsb/OAK71DVD09.md): Cessna 172 · Concord, CA · Accident · Minor injuries · Closed · Aug 28, 1970 · N2439L · Substantial damage - [NTSB OAK71DXQ05](https://openairdocs.org/ntsb/OAK71DXQ05.md): Cessna 172 · Lake Tahoe, CA · Accident · No injuries · Closed · Jul 22, 1970 · N2461L · Substantial damage - [NTSB NYC71FHG02](https://openairdocs.org/ntsb/NYC71FHG02.md): Cessna 172H · New Cumberland, PA · Accident · No injuries · Closed · Jul 20, 1970 · N3772F · Substantial damage - [NTSB OAK71DVM03](https://openairdocs.org/ntsb/OAK71DVM03.md): Cessna 172 · San Jose, CA · Accident · No injuries · Closed · Jul 13, 1970 · N1604F · Substantial damage - [NTSB MKC71DDM09](https://openairdocs.org/ntsb/MKC71DDM09.md): Cessna 172H · Pequot Lakes, MN · Accident · No injuries · Closed · Jul 2, 1970 · N3246L · Substantial damage - [NTSB CHI70DBJ41](https://openairdocs.org/ntsb/CHI70DBJ41.md): Cessna 172 · Ionia, MI · Accident · No injuries · Closed · Jun 14, 1970 · N8057L · Substantial damage - [NTSB NYC70DFJ09](https://openairdocs.org/ntsb/NYC70DFJ09.md): Cessna 172H · Hilton, NY · Accident · No injuries · Closed · May 24, 1970 · N3027U · Substantial damage - [NTSB MKC70DCG27](https://openairdocs.org/ntsb/MKC70DCG27.md): Cessna 172H · Maryville, MO · Accident · No injuries · Closed · May 9, 1970 · N2733L · Substantial damage - [NTSB MIA70AM080](https://openairdocs.org/ntsb/MIA70AM080.md): Cessna 172H · St Petersburg, FL · Accident · 1 fatal · Closed · Apr 6, 1970 · N2506L · Destroyed - [NTSB ANC70DAG09](https://openairdocs.org/ntsb/ANC70DAG09.md): Cessna 172 · Anchorage, AK · Accident · No injuries · Closed · Mar 8, 1970 · N2857L · Substantial damage - [NTSB LAX70FUD05](https://openairdocs.org/ntsb/LAX70FUD05.md): Cessna 172H · Malibu, CA · Accident · No injuries · Closed · Mar 6, 1970 · N770LW · Substantial damage - [NTSB DEN70DXD19](https://openairdocs.org/ntsb/DEN70DXD19.md): Cessna 172 · Parlin, CO · Accident · No injuries · Closed · Feb 12, 1970 · N1492F · Substantial damage - [NTSB NYC70FFJ05](https://openairdocs.org/ntsb/NYC70FFJ05.md): Cessna 172 · Buffalo, NY · Accident · Minor injuries · Closed · Feb 4, 1970 · N2771L · Substantial damage - [NTSB DEN70FQD03](https://openairdocs.org/ntsb/DEN70FQD03.md): Cessna 172H · Tyrone, NM · Accident · Minor injuries · Closed · Feb 1, 1970 · N3777F · Substantial damage - [NTSB MIA70DKA01](https://openairdocs.org/ntsb/MIA70DKA01.md): Cessna 172 · Guayma, PR · Accident · Serious injuries · Closed · Jan 24, 1970 · N3218L · Substantial damage - [NTSB FTW70F0367](https://openairdocs.org/ntsb/FTW70F0367.md): Cessna 172H · Tyronza, AR · Accident · No injuries · Closed · Dec 7, 1969 · N2420L · Substantial damage - [NTSB OAK70D0196](https://openairdocs.org/ntsb/OAK70D0196.md): Cessna 172 · Laytonville, CA · Accident · No injuries · Closed · Dec 6, 1969 · N8100L · Substantial damage - [NTSB LAX70F0214](https://openairdocs.org/ntsb/LAX70F0214.md): Cessna 172H · Santa Ana, CA · Accident · No injuries · Closed · Nov 28, 1969 · N8265L · Substantial damage - [NTSB DEN70D0147](https://openairdocs.org/ntsb/DEN70D0147.md): Cessna 172 · Sedalia, CO · Accident · No injuries · Closed · Nov 15, 1969 · N2643L · Substantial damage - [NTSB OAK70D0155](https://openairdocs.org/ntsb/OAK70D0155.md): Cessna 172 · Stewarts Pt, CA · Accident · No injuries · Closed · Nov 8, 1969 · N2740L · Substantial damage - [NTSB LAX70D0180](https://openairdocs.org/ntsb/LAX70D0180.md): Cessna 172 · St Johns, AZ · Accident · No injuries · Closed · Nov 8, 1969 · N8110L · Substantial damage - [NTSB DEN70D0112](https://openairdocs.org/ntsb/DEN70D0112.md): Cessna 172 · Pagosa Spgs, CO · Accident · No injuries · Closed · Oct 27, 1969 · N3726F · Substantial damage - [NTSB FTW70F0251](https://openairdocs.org/ntsb/FTW70F0251.md): Cessna 172H · Fort Worth, TX · Accident · Serious injuries · Closed · Oct 10, 1969 · N2879L · Substantial damage - [NTSB MIA70A0027](https://openairdocs.org/ntsb/MIA70A0027.md): Cessna 172H · Philadelphia, MS · Accident · 2 fatal · Closed · Oct 5, 1969 · N3837R · Destroyed - [NTSB CHI71F0001](https://openairdocs.org/ntsb/CHI71F0001.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Sep 14, 1969 · N3941R · Substantial damage - [NTSB OAK70A0019](https://openairdocs.org/ntsb/OAK70A0019.md): Cessna 172H · Sacramento, CA · Accident · 1 fatal · Closed · Sep 12, 1969 · N3774R · Destroyed - [NTSB OAK70A0020](https://openairdocs.org/ntsb/OAK70A0020.md): Cessna 172H · Lovelock, NV · Accident · 4 fatal · Closed · Sep 11, 1969 · N2716L · Destroyed - [NTSB MKC70A0008](https://openairdocs.org/ntsb/MKC70A0008.md): Cessna 172H · Newton, IA · Accident · 3 fatal · Closed · Aug 31, 1969 · N3149X · Destroyed - [NTSB MKC70D0148](https://openairdocs.org/ntsb/MKC70D0148.md): Cessna 172H · Hill City, KS · Accident · No injuries · Closed · Aug 22, 1969 · N3744F · Substantial damage - [NTSB DEN70A0008](https://openairdocs.org/ntsb/DEN70A0008.md): Cessna 172H · Albuquerque, NM · Accident · 1 fatal · Closed · Aug 3, 1969 · N1662F · Destroyed - [NTSB LAX70D0086](https://openairdocs.org/ntsb/LAX70D0086.md): Cessna 172 · Sunfair, CA · Accident · No injuries · Closed · Jul 24, 1969 · N8044L · Substantial damage - [NTSB LAX70D0034](https://openairdocs.org/ntsb/LAX70D0034.md): Cessna 172 · Escondido, CA · Accident · No injuries · Closed · Jul 2, 1969 · N8161L · Substantial damage - [NTSB CHI70F0061](https://openairdocs.org/ntsb/CHI70F0061.md): Cessna 172H · Union, OH · Accident · Minor injuries · Closed · Jun 26, 1969 · N2861L · Substantial damage - [NTSB MKC69F0472](https://openairdocs.org/ntsb/MKC69F0472.md): Cessna 172 · Winterset, IA · Accident · No injuries · Closed · Jun 10, 1969 · N1478F · Substantial damage - [NTSB FTW70F0048](https://openairdocs.org/ntsb/FTW70F0048.md): Cessna 172H · Oil City, LA · Accident · No injuries · Closed · Jun 7, 1969 · N1490F · Substantial damage - [NTSB MIA69A0087](https://openairdocs.org/ntsb/MIA69A0087.md): Cessna 172 · No.Atlantic Ocean (Atlantic Ocean) · Accident · 2 fatal · Closed · Jun 6, 1969 · N8040L · Destroyed - [NTSB CHI70D0044](https://openairdocs.org/ntsb/CHI70D0044.md): Cessna 172H · Hobart, IN · Accident · No injuries · Closed · May 30, 1969 · N8260L · Substantial damage - [NTSB MKC69D0458](https://openairdocs.org/ntsb/MKC69D0458.md): Cessna 172H · Manhattan, KS · Accident · No injuries · Closed · May 21, 1969 · N2663L · Substantial damage - [NTSB CHI69D0621](https://openairdocs.org/ntsb/CHI69D0621.md): Cessna 172H · Hillsboro, OH · Accident · Serious injuries · Closed · May 3, 1969 · N2678L · Substantial damage - [NTSB MIA69F0442](https://openairdocs.org/ntsb/MIA69F0442.md): Cessna 172 · Opelika, AL · Accident · No injuries · Closed · Apr 21, 1969 · N1429F · Substantial damage - [NTSB LAX69D0303](https://openairdocs.org/ntsb/LAX69D0303.md): Cessna 172 · Bermuda Dunes, CA · Accident · No injuries · Closed · Mar 22, 1969 · N8283L · Substantial damage - [NTSB OAK69D0254](https://openairdocs.org/ntsb/OAK69D0254.md): Cessna 172 · Vacaville, CA · Accident · No injuries · Closed · Feb 16, 1969 · N8188L · Substantial damage - [NTSB FTW69F0378](https://openairdocs.org/ntsb/FTW69F0378-191726.md): Cessna 172H · Amarillo, TX · Accident · No injuries · Closed · Feb 1, 1969 · N3876R · Substantial damage - [NTSB DEN69D0217](https://openairdocs.org/ntsb/DEN69D0217.md): Cessna 172 · Fort Carson, CO · Accident · No injuries · Closed · Jan 26, 1969 · N3901R · Substantial damage - [NTSB FTW69D0395](https://openairdocs.org/ntsb/FTW69D0395.md): Cessna 172 · Dougherty, TX · Accident · No injuries · Closed · Jan 12, 1969 · N1454F · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=2072424&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 ('2072424')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=2072424&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.