# NTSB investigations: Cessna 172D 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 5 of 7 · 330 cases ## Cases, newest first - [NTSB CHI69F0214](https://openairdocs.org/ntsb/CHI69F0214.md): Cessna 172 · Columbus, OH · Accident · No injuries · Closed · Aug 31, 1968 · N2470U · Substantial damage - [NTSB SEA69A0017](https://openairdocs.org/ntsb/SEA69A0017.md): Cessna 172 · Lopez, WA · Accident · 2 fatal · Closed · Aug 28, 1968 · N2520Y · Destroyed - [NTSB NYC69D0153](https://openairdocs.org/ntsb/NYC69D0153.md): Cessna 172 · Lincoln, ME · Accident · No injuries · Closed · Aug 25, 1968 · N2633U · Substantial damage - [NTSB MKC69D0201](https://openairdocs.org/ntsb/MKC69D0201.md): Cessna 172 · Springfield, MO · Accident · No injuries · Closed · Jul 16, 1968 · N2145Y · Substantial damage - [NTSB NYC69D0042](https://openairdocs.org/ntsb/NYC69D0042.md): Cessna 172 · Edinburg, NY · Accident · No injuries · Closed · Jul 11, 1968 · N2359U · Substantial damage - [NTSB DEN69F0033](https://openairdocs.org/ntsb/DEN69F0033.md): Cessna 172 · Salt Lake City, UT · Accident · No injuries · Closed · Jul 8, 1968 · N2590Y · Substantial damage - [NTSB MKC69F0006](https://openairdocs.org/ntsb/MKC69F0006.md): Cessna 172 · Memphis, MO · Accident · Minor injuries · Closed · Apr 18, 1968 · N2961U · Substantial damage - [NTSB DIA68D0194](https://openairdocs.org/ntsb/DIA68D0194.md): Cessna 172D · New Market, VA · Accident · Minor injuries · Closed · Apr 14, 1968 · N2570Y · Substantial damage - [NTSB SEA68F0301](https://openairdocs.org/ntsb/SEA68F0301.md): Cessna 172 · Hammond, MT · Accident · No injuries · Closed · Apr 7, 1968 · N2049Y · Substantial damage - [NTSB ANC68D0106](https://openairdocs.org/ntsb/ANC68D0106.md): Cessna 172 · Wrangell, AK · Accident · No injuries · Closed · Mar 29, 1968 · N2658U · Destroyed - [NTSB MKC68D0480](https://openairdocs.org/ntsb/MKC68D0480.md): Cessna 172D · St Marys, KS · Accident · Minor injuries · Closed · Mar 5, 1968 · N2467Y · Destroyed - [NTSB MIA68D0434](https://openairdocs.org/ntsb/MIA68D0434.md): Cessna 172 · Isabela, PR · Accident · Minor injuries · Closed · Feb 23, 1968 · N2670U · Substantial damage - [NTSB OAK68D0300](https://openairdocs.org/ntsb/OAK68D0300.md): Cessna 172 · Tahoe City, CA · Accident · Minor injuries · Closed · Feb 16, 1968 · N2529Y · Destroyed - [NTSB MKC68D0416](https://openairdocs.org/ntsb/MKC68D0416.md): Cessna 172D · Chadron, NE · Accident · No injuries · Closed · Jan 3, 1968 · N2651U · Substantial damage - [NTSB NYC68F0339](https://openairdocs.org/ntsb/NYC68F0339.md): Cessna 172 · Gardenville, NY · Accident · No injuries · Closed · Jan 1, 1968 · N2583U · Substantial damage - [NTSB MIA68D0430](https://openairdocs.org/ntsb/MIA68D0430.md): Cessna 172D · Chester, SC · Accident · Minor injuries · Closed · Dec 7, 1967 · N2839U · Destroyed - [NTSB FTW68F0237](https://openairdocs.org/ntsb/FTW68F0237.md): Cessna 172 · Houston, TX · Accident · No injuries · Closed · Sep 17, 1967 · N2802U · Destroyed - [NTSB MIA68F0160](https://openairdocs.org/ntsb/MIA68F0160.md): Cessna 172 · Salinas, PR · Accident · No injuries · Closed · Sep 6, 1967 · N2160Y · Substantial damage - [NTSB MIA68D0156](https://openairdocs.org/ntsb/MIA68D0156.md): Cessna 172 · Vero Beach, FL · Accident · No injuries · Closed · Aug 21, 1967 · N2494U · Substantial damage - [NTSB MIA68F0118](https://openairdocs.org/ntsb/MIA68F0118.md): Cessna 172 · Bruce, MS · Accident · No injuries · Closed · Aug 16, 1967 · N2580Y · Substantial damage - [NTSB NYC68F0023](https://openairdocs.org/ntsb/NYC68F0023.md): Cessna 172 · Central City, PA · Accident · Minor injuries · Closed · Jun 15, 1967 · N2749U · Substantial damage - [NTSB MKC68D0001](https://openairdocs.org/ntsb/MKC68D0001.md): Cessna 172 · Marion, IA · Accident · No injuries · Closed · May 24, 1967 · N2526Y · Substantial damage - [NTSB DIA67F0104](https://openairdocs.org/ntsb/DIA67F0104.md): Cessna 172 · New Bern, NC · Accident · Minor injuries · Closed · May 20, 1967 · N2512Y · Substantial damage - [NTSB CHI67D0648](https://openairdocs.org/ntsb/CHI67D0648.md): Cessna 172 · Plainville, IL · Accident · No injuries · Closed · May 9, 1967 · N2181Y · Substantial damage - [NTSB OAK67D0294](https://openairdocs.org/ntsb/OAK67D0294.md): Cessna 172 · Reno, NV · Accident · No injuries · Closed · Apr 22, 1967 · N2133Y · Substantial damage - [NTSB MKC67D0455](https://openairdocs.org/ntsb/MKC67D0455.md): Cessna 172 · Dodge Cntr, MN · Accident · No injuries · Closed · Feb 14, 1967 · N159AE · Substantial damage - [NTSB ANC67D0079](https://openairdocs.org/ntsb/ANC67D0079.md): Cessna 172D · Wrangell, AK · Accident · No injuries · Closed · Feb 8, 1967 · N2658U · Substantial damage - [NTSB MIA67D0001](https://openairdocs.org/ntsb/MIA67D0001-118919.md): Cessna 172D · Ridgeland, SC · Accident · Minor injuries · Closed · Jan 22, 1967 · N2732U · Substantial damage - [NTSB CHI67D0506](https://openairdocs.org/ntsb/CHI67D0506.md): Cessna 172 · Port Clinton, OH · Accident · No injuries · Closed · Jan 12, 1967 · N2144Y · Substantial damage - [NTSB MIA67D0359](https://openairdocs.org/ntsb/MIA67D0359.md): Cessna 172 · Sanford, FL · Accident · Minor injuries · Closed · Jan 7, 1967 · N2611U · Substantial damage - [NTSB CHI67D0417](https://openairdocs.org/ntsb/CHI67D0417.md): Cessna 172 · Bloomingdale, IN · Accident · No injuries · Closed · Dec 26, 1966 · N2558U · Substantial damage - [NTSB CHI67A0081](https://openairdocs.org/ntsb/CHI67A0081.md): Cessna 172 · Ashtabula, OH · Accident · 4 fatal · Closed · Dec 19, 1966 · N2347U · Destroyed - [NTSB FTW67F0267](https://openairdocs.org/ntsb/FTW67F0267.md): Cessna 172 · Fort Worth, TX · Accident · Minor injuries · Closed · Nov 11, 1966 · N2320U · Substantial damage - [NTSB LAX67D0223](https://openairdocs.org/ntsb/LAX67D0223.md): Cessna 172 · Crestline, CA · Accident · Minor injuries · Closed · Nov 6, 1966 · N2775U · Substantial damage - [NTSB OAK67D0154](https://openairdocs.org/ntsb/OAK67D0154.md): Cessna 172D · Sunnyside, NV · Accident · No injuries · Closed · Nov 5, 1966 · N2582Y · Substantial damage - [NTSB NYC67D0335](https://openairdocs.org/ntsb/NYC67D0335.md): Cessna 172 · Flushing, NY · Accident · No injuries · Closed · Oct 9, 1966 · N2549Y · Substantial damage - [NTSB NYC67F0262](https://openairdocs.org/ntsb/NYC67F0262.md): Cessna 172D · Leesburg, VA · Accident · No injuries · Closed · Sep 24, 1966 · N2486Y · Substantial damage - [NTSB MIA67D0200](https://openairdocs.org/ntsb/MIA67D0200.md): Cessna 172 · Mulberry, FL · Accident · No injuries · Closed · Sep 24, 1966 · N2523U · Substantial damage - [NTSB SEA67D0132](https://openairdocs.org/ntsb/SEA67D0132.md): Cessna 172 · Dutton, MT · Accident · Minor injuries · Closed · Sep 4, 1966 · N2328U · Destroyed - [NTSB CHI67D0137](https://openairdocs.org/ntsb/CHI67D0137.md): Cessna 172 · Muncie, IN · Accident · No injuries · Closed · Aug 6, 1966 · N2558U · Substantial damage - [NTSB LAX67D0066](https://openairdocs.org/ntsb/LAX67D0066.md): Cessna 172 · Van Nuys, CA · Accident · No injuries · Closed · Jul 15, 1966 · N2931U · Substantial damage - [NTSB CAN F0404](https://openairdocs.org/ntsb/CAN%20%20F0404.md): Cessna 172 · St.Laurent, Canada · Accident · No injuries · Closed · Jul 4, 1966 · N2382U · Substantial damage - [NTSB UNK66X0151](https://openairdocs.org/ntsb/UNK66X0151.md): Cessna 172 · Parrsboro, Canada · Accident · No injuries · Closed · Jun 25, 1966 · N2474Y · Substantial damage - [NTSB MIA66F0519](https://openairdocs.org/ntsb/MIA66F0519.md): Cessna 172 · Clemmons, NC · Accident · Minor injuries · Closed · May 5, 1966 · N2815U · Substantial damage - [NTSB MKC66F0506](https://openairdocs.org/ntsb/MKC66F0506.md): Cessna 172 · Lincoln, NE · Accident · No injuries · Closed · Apr 13, 1966 · N2843U · Substantial damage - [NTSB NYC66A0112](https://openairdocs.org/ntsb/NYC66A0112.md): Cessna 172D · Princeton, WV · Accident · 2 fatal · Closed · Apr 5, 1966 · N2486U · Destroyed - [NTSB DEN66F0293](https://openairdocs.org/ntsb/DEN66F0293.md): Cessna 172 · Sandy, UT · Accident · No injuries · Closed · Apr 3, 1966 · N2590Y · Substantial damage - [NTSB MKC66F0508](https://openairdocs.org/ntsb/MKC66F0508.md): Cessna 172D · Kearney, NE · Accident · Serious injuries · Closed · Apr 2, 1966 · N2407Y · Substantial damage - [NTSB MIA66D0514](https://openairdocs.org/ntsb/MIA66D0514.md): Cessna 172 · Chamblee, GA · Accident · No injuries · Closed · Mar 31, 1966 · N2526U · Substantial damage - [NTSB LAX66A0074](https://openairdocs.org/ntsb/LAX66A0074.md): Cessna 172D · Newhall, CA · Accident · 1 fatal · Closed · Mar 27, 1966 · N2958U · Destroyed Next page: https://openairdocs.org/ntsb.md?model=2072410&page=6 ## 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 ('2072410')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=2072410&page=5 --- 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.