# NTSB investigations: Continental 0-300 series 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 48 of 63 · 3,125 cases ## Cases, newest first - [NTSB DIA68D0050](https://openairdocs.org/ntsb/DIA68D0050.md): Cessna 172G · Chapel Hill, NC · Accident · No injuries · Closed · Jul 20, 1967 · N5899R · 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 CHI68F0311](https://openairdocs.org/ntsb/CHI68F0311.md): Cessna 172 · Canton, IL · Accident · No injuries · Closed · Jul 18, 1967 · N5173A · Substantial damage - [NTSB CHI68D0188](https://openairdocs.org/ntsb/CHI68D0188.md): Cessna 172 · New Phila., OH · Accident · No injuries · Closed · Jul 18, 1967 · N1383F · Substantial damage - [NTSB MIA68D0124](https://openairdocs.org/ntsb/MIA68D0124.md): Cessna 172 · Glenville, GA · Accident · No injuries · Closed · Jul 17, 1967 · N4134L · Substantial damage - [NTSB OAK68D0053](https://openairdocs.org/ntsb/OAK68D0053.md): Cessna 172H · Firebaugh, CA · Accident · No injuries · Closed · Jul 16, 1967 · N1604F · 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 LAX68D0096](https://openairdocs.org/ntsb/LAX68D0096.md): Cessna 172 · Holbrook, AZ · Accident · No injuries · Closed · Jul 15, 1967 · N6323E · Destroyed - [NTSB NYC68D0077](https://openairdocs.org/ntsb/NYC68D0077.md): Cessna 172 · Millinocket, ME · Accident · Minor injuries · Closed · Jul 14, 1967 · N3861L · Substantial damage - [NTSB MIA68F0025](https://openairdocs.org/ntsb/MIA68F0025.md): Cessna 172A · Winnsboro, SC · Accident · No injuries · Closed · Jul 14, 1967 · N7550T · Substantial damage - [NTSB MIA68D0120](https://openairdocs.org/ntsb/MIA68D0120.md): Cessna 172B · Villa Rica, GA · Accident · No injuries · Closed · Jul 14, 1967 · N7710X · Destroyed - [NTSB MKC68D0121](https://openairdocs.org/ntsb/MKC68D0121.md): Cessna 172 · Forest City, MO · Accident · Minor injuries · Closed · Jul 11, 1967 · N7860U · Substantial damage - [NTSB FTW68D0088](https://openairdocs.org/ntsb/FTW68D0088.md): Cessna 172H · Alpine, TX · Accident · No injuries · Closed · Jul 10, 1967 · N2595L · Substantial damage - [NTSB MKC68D0296](https://openairdocs.org/ntsb/MKC68D0296.md): Cessna 172 · St Joseph, MO · Accident · No injuries · Closed · Jul 6, 1967 · N8040B · Substantial damage - [NTSB DIA68F0035](https://openairdocs.org/ntsb/DIA68F0035.md): Cessna 172G · Virginia Beach, VA · Accident · Minor injuries · Closed · Jul 6, 1967 · N5759R · Substantial damage - [NTSB FTW68F0045](https://openairdocs.org/ntsb/FTW68F0045.md): Cessna 172G · Washington, OK · Accident · Minor injuries · Closed · Jul 5, 1967 · N4346W · Substantial damage - [NTSB DIA68F0027](https://openairdocs.org/ntsb/DIA68F0027.md): Cessna 172G · Clinton, MD · Accident · No injuries · Closed · Jul 5, 1967 · N3876L · Substantial damage - [NTSB DEN68D0078](https://openairdocs.org/ntsb/DEN68D0078.md): Cessna 172 · Cowles, NM · Accident · No injuries · Closed · Jul 5, 1967 · N5062A · 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 LAX68D0058](https://openairdocs.org/ntsb/LAX68D0058.md): Cessna 172 · Riverside, CA · Accident · No injuries · Closed · Jun 30, 1967 · N9803T · Substantial damage - [NTSB NYC68F0051](https://openairdocs.org/ntsb/NYC68F0051.md): Cessna 172 · Snow Shoe, PA · Accident · No injuries · Closed · Jun 25, 1967 · N6909X · Destroyed - [NTSB CHI68D0060](https://openairdocs.org/ntsb/CHI68D0060.md): Cessna 172 · Northbrook, IL · Accident · No injuries · Closed · Jun 25, 1967 · N5738R · Substantial damage - [NTSB MIA68D0047](https://openairdocs.org/ntsb/MIA68D0047.md): Cessna 172 · St Thomas, VI · Accident · No injuries · Closed · Jun 22, 1967 · N8624U · Substantial damage - [NTSB MIA68D0067](https://openairdocs.org/ntsb/MIA68D0067.md): Cessna 172C · Savannah Beach, GA · Accident · No injuries · Closed · Jun 20, 1967 · N1628Y · Substantial damage - [NTSB DEN68D0017](https://openairdocs.org/ntsb/DEN68D0017.md): Cessna 172 · Vernon, UT · Accident · No injuries · Closed · Jun 18, 1967 · N7998B · Substantial damage - [NTSB FTW68D0015](https://openairdocs.org/ntsb/FTW68D0015.md): Cessna 172 · Ponca City, OK · Accident · No injuries · Closed · Jun 17, 1967 · N7982U · Substantial damage - [NTSB DEN68D0020](https://openairdocs.org/ntsb/DEN68D0020.md): Cessna 170 · Mountainair, NM · Accident · No injuries · Closed · Jun 17, 1967 · N5724C · Substantial damage - [NTSB FTW67D0648](https://openairdocs.org/ntsb/FTW67D0648.md): Cessna 172 · Luling, LA · Accident · No injuries · Closed · Jun 15, 1967 · N1623F · Substantial damage - [NTSB MKC68F0097](https://openairdocs.org/ntsb/MKC68F0097.md): Cessna 172 · Augusta, KS · Accident · Minor injuries · Closed · Jun 14, 1967 · N3919L · Destroyed - [NTSB CHI68A0048](https://openairdocs.org/ntsb/CHI68A0048-201125.md): Cessna 172 · Palmyra, WI · Accident · No injuries · Closed · Jun 14, 1967 · N7130A · Substantial damage - [NTSB NYC68D0016](https://openairdocs.org/ntsb/NYC68D0016.md): Cessna 172G · Sherman, ME · Accident · Minor injuries · Closed · Jun 13, 1967 · N3653L · Substantial damage - [NTSB LAX68D0093](https://openairdocs.org/ntsb/LAX68D0093.md): Cessna 172 · Lancaster, CA · Accident · No injuries · Closed · Jun 12, 1967 · N4667L · Substantial damage - [NTSB DIA68F0032](https://openairdocs.org/ntsb/DIA68F0032.md): Cessna 172 · Greenville, NC · Accident · Serious injuries · Closed · Jun 12, 1967 · N1605F · Destroyed - [NTSB NYC68F0020](https://openairdocs.org/ntsb/NYC68F0020.md): Cessna 172F · East Hanover, NJ · Accident · No injuries · Closed · Jun 11, 1967 · N8808U · Substantial damage - [NTSB FTW67F0650](https://openairdocs.org/ntsb/FTW67F0650.md): Cessna 172 · Freemason Isle, LA · Accident · No injuries · Closed · Jun 11, 1967 · N7983U · Substantial damage - [NTSB CHI67F0673](https://openairdocs.org/ntsb/CHI67F0673.md): Cessna 172 · Franklin, IN · Accident · No injuries · Closed · Jun 6, 1967 · N3920F · Substantial damage - [NTSB LAX68D0017](https://openairdocs.org/ntsb/LAX68D0017.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Closed · Jun 5, 1967 · N8014L · Substantial damage - [NTSB DIA68D0009](https://openairdocs.org/ntsb/DIA68D0009.md): Cessna 172 · Middletown, DE · Accident · No injuries · Closed · Jun 4, 1967 · N1413F · 2 aircraft · Minor damage - [NTSB MKC68F0244](https://openairdocs.org/ntsb/MKC68F0244.md): Cessna 172 · Vandalia, MO · Accident · Minor injuries · Closed · Jun 3, 1967 · N1491Y · Substantial damage - [NTSB SEA68F0058](https://openairdocs.org/ntsb/SEA68F0058.md): Maule M-4 · Polson, MT · Accident · No injuries · Closed · Jun 2, 1967 · N4602T · Substantial damage - [NTSB FTW67A0113](https://openairdocs.org/ntsb/FTW67A0113.md): Cessna 172F · Houma, LA · Accident · 1 fatal · Closed · May 30, 1967 · N8806U · 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 FTW67D0626](https://openairdocs.org/ntsb/FTW67D0626.md): Cessna 172 · Chandeleur Isl, LA · Accident · No injuries · Closed · May 27, 1967 · N4021F · Substantial damage - [NTSB NYC67F0692](https://openairdocs.org/ntsb/NYC67F0692.md): Cessna 172 · Cresson, PA · Accident · No injuries · Closed · May 25, 1967 · N6670A · Substantial damage - [NTSB LAX68D0004](https://openairdocs.org/ntsb/LAX68D0004.md): Cessna 172 · Palm Sprgs, CA · Accident · No injuries · Closed · May 25, 1967 · N2723L · Substantial damage - [NTSB DEN68D0004](https://openairdocs.org/ntsb/DEN68D0004.md): Cessna 172 · Colo.Springs, CO · Accident · No injuries · Closed · May 25, 1967 · N4338L · Destroyed - [NTSB MKC68D0001](https://openairdocs.org/ntsb/MKC68D0001.md): Cessna 172 · Marion, IA · Accident · No injuries · Closed · May 24, 1967 · N2526Y · Substantial damage - [NTSB MIA67D0579](https://openairdocs.org/ntsb/MIA67D0579.md): Cessna 172 · Palmetto, GA · Accident · No injuries · Closed · May 24, 1967 · N9168B · Substantial damage Next page: https://openairdocs.org/ntsb.md?engine=17022&page=49 ## 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.engine_model_code IN ('17022')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?engine=17022&page=48 --- 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.