# 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 47 of 63 · 3,125 cases ## Cases, newest first - [NTSB 3AK68D0148](https://openairdocs.org/ntsb/3AK68D0148.md): Cessna 172 · Firebaugh, CA · Accident · No injuries · Closed · Oct 4, 1967 · N8611B · Substantial damage - [NTSB FTW68D0245](https://openairdocs.org/ntsb/FTW68D0245.md): Cessna 172 · Pine Grove, LA · Accident · No injuries · Closed · Oct 3, 1967 · N1417F · Substantial damage - [NTSB NYC68D0224](https://openairdocs.org/ntsb/NYC68D0224.md): Cessna 172 · Mahopac, NY · Accident · No injuries · Closed · Sep 30, 1967 · N6114E · Substantial damage - [NTSB DIA68D0102](https://openairdocs.org/ntsb/DIA68D0102.md): Cessna 172 · Davis, NC · Accident · No injuries · Closed · Sep 30, 1967 · N4117L · Substantial damage - [NTSB MIA68F0196](https://openairdocs.org/ntsb/MIA68F0196.md): Cessna 172E · Murfreesboro, TN · Accident · Minor injuries · Closed · Sep 29, 1967 · N8693U · Substantial damage - [NTSB LAX68F0150](https://openairdocs.org/ntsb/LAX68F0150.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Closed · Sep 24, 1967 · N5781R · Substantial damage - [NTSB NYC68F0211](https://openairdocs.org/ntsb/NYC68F0211.md): Cessna 172 · Monroeville, PA · Accident · No injuries · Closed · Sep 22, 1967 · N3932L · Substantial damage - [NTSB DIA68A0015](https://openairdocs.org/ntsb/DIA68A0015.md): Cessna 172H · Asheboro, NC · Accident · No injuries · Closed · Sep 22, 1967 · N3244L · Substantial damage - [NTSB OAK68D0197](https://openairdocs.org/ntsb/OAK68D0197.md): Cessna 172 · Napa, CA · Accident · No injuries · Closed · Sep 21, 1967 · N6986A · Substantial damage - [NTSB NYC68D0204](https://openairdocs.org/ntsb/NYC68D0204.md): Cessna 172H · Mays Landing, NJ · Accident · No injuries · Closed · Sep 20, 1967 · N3281L · Substantial damage - [NTSB FTW68F0237](https://openairdocs.org/ntsb/FTW68F0237.md): Cessna 172 · Houston, TX · Accident · No injuries · Closed · Sep 17, 1967 · N2802U · Destroyed - [NTSB SEA68A0027](https://openairdocs.org/ntsb/SEA68A0027.md): Cessna 172 · Portland, OR · Accident · 1 fatal · Closed · Sep 16, 1967 · N5907A · Destroyed - [NTSB MKC68D0187](https://openairdocs.org/ntsb/MKC68D0187.md): Cessna 172 · Corydon, IA · Accident · No injuries · Closed · Sep 15, 1967 · N6800A · Substantial damage - [NTSB MKC68D0251](https://openairdocs.org/ntsb/MKC68D0251.md): Cessna 172 · Clinton, MO · Accident · Minor injuries · Closed · Sep 11, 1967 · N3738L · Substantial damage - [NTSB MKC68D0215](https://openairdocs.org/ntsb/MKC68D0215.md): Cessna 172G · Ladner, SD · Accident · No injuries · Closed · Sep 11, 1967 · N6074R · Substantial damage - [NTSB MKC68F0232](https://openairdocs.org/ntsb/MKC68F0232.md): Cessna 172 · Mercer, ND · Accident · Minor injuries · Closed · Sep 10, 1967 · N8165B · Substantial damage - [NTSB MIA68F0160](https://openairdocs.org/ntsb/MIA68F0160.md): Cessna 172 · Salinas, PR · Accident · No injuries · Closed · Sep 6, 1967 · N2160Y · Substantial damage - [NTSB ANC68A0017](https://openairdocs.org/ntsb/ANC68A0017.md): Cessna 172 · AK · Accident · 2 fatal · Closed · Sep 6, 1967 · N3789L · Destroyed - [NTSB NYC68D0162](https://openairdocs.org/ntsb/NYC68D0162.md): Cessna 172 · East Berlin, PA · Accident · No injuries · Closed · Sep 4, 1967 · N5754R · Substantial damage - [NTSB CHI68D0364](https://openairdocs.org/ntsb/CHI68D0364.md): Cessna 172 · Lodi, OH · Accident · No injuries · Closed · Sep 4, 1967 · N4141L · Substantial damage - [NTSB NYC68F0261](https://openairdocs.org/ntsb/NYC68F0261.md): Cessna 172 · Ogdensburg, NY · Accident · No injuries · Closed · Sep 2, 1967 · N8345U · Substantial damage - [NTSB NYC68D0149](https://openairdocs.org/ntsb/NYC68D0149.md): Cessna 172E · Ea.Hampton, CT · Accident · Serious injuries · Closed · Sep 2, 1967 · N5308T · Substantial damage - [NTSB NYC68I0033](https://openairdocs.org/ntsb/NYC68I0033.md): Cessna 172 · Flushing, NY · Incident · No injuries · Closed · Aug 28, 1967 · N8819U · Substantial damage - [NTSB NYC68D0114](https://openairdocs.org/ntsb/NYC68D0114.md): Cessna 172 · Andover, NJ · Accident · No injuries · Closed · Aug 28, 1967 · N3251L · Substantial damage - [NTSB SEA68D0147](https://openairdocs.org/ntsb/SEA68D0147.md): Cessna 172 · Snohomish, WA · Accident · No injuries · Closed · Aug 27, 1967 · N5674A · Substantial damage - [NTSB OAK68D0136](https://openairdocs.org/ntsb/OAK68D0136.md): Cessna 172 · Concord, CA · Accident · No injuries · Closed · Aug 27, 1967 · N2718L · Substantial damage - [NTSB MIA68F0141](https://openairdocs.org/ntsb/MIA68F0141.md): Cessna 172 · Lucedale, MS · Accident · Minor injuries · Closed · Aug 26, 1967 · N3994S · Substantial damage - [NTSB SEA68D0156](https://openairdocs.org/ntsb/SEA68D0156.md): Maule M-4 · Moore, MT · Accident · No injuries · Closed · Aug 24, 1967 · N12010 · Substantial damage - [NTSB FTW68F0177](https://openairdocs.org/ntsb/FTW68F0177.md): Cessna 170A · Pearland, TX · Accident · No injuries · Closed · Aug 24, 1967 · N9980A · Substantial damage - [NTSB NYC68D0118](https://openairdocs.org/ntsb/NYC68D0118.md): Cessna 172 · New Hope, PA · Accident · No injuries · Closed · Aug 19, 1967 · N7393T · Substantial damage - [NTSB CHI68F0318](https://openairdocs.org/ntsb/CHI68F0318.md): Cessna 172 · Pekin, IL · Accident · No injuries · Closed · Aug 18, 1967 · N8754B · Substantial damage - [NTSB MKC68D0201](https://openairdocs.org/ntsb/MKC68D0201.md): Cessna 172C · Clyde, KS · Accident · No injuries · Closed · Aug 13, 1967 · N9151B · Substantial damage - [NTSB OAK68D0222](https://openairdocs.org/ntsb/OAK68D0222.md): Cessna 172 · Auburn, CA · Accident · No injuries · Closed · Aug 8, 1967 · N4361L · Substantial damage - [NTSB SEA68D0102](https://openairdocs.org/ntsb/SEA68D0102.md): Cessna 172 · Gates, OR · Accident · No injuries · Closed · Aug 7, 1967 · N3739F · Substantial damage - [NTSB NYC68D0083](https://openairdocs.org/ntsb/NYC68D0083.md): Cessna 172 · Newburyport, MA · Accident · No injuries · Closed · Aug 6, 1967 · N5358R · Substantial damage - [NTSB MKC68D0247](https://openairdocs.org/ntsb/MKC68D0247.md): Cessna 172G · Eudora, KS · Accident · No injuries · Closed · Aug 6, 1967 · N3682L · Substantial damage - [NTSB LAX68A0018](https://openairdocs.org/ntsb/LAX68A0018.md): Cessna 175 · Saugus, CA · Accident · 1 fatal · Closed · Aug 6, 1967 · N7014M · Destroyed - [NTSB CHI68F0185](https://openairdocs.org/ntsb/CHI68F0185.md): Cessna 172G · Greenwood, IL · Accident · Minor injuries · Closed · Aug 3, 1967 · N4492L · Substantial damage - [NTSB FTW68D0102](https://openairdocs.org/ntsb/FTW68D0102.md): Cessna 172 · Freemason Isle, LA · Accident · No injuries · Closed · Aug 2, 1967 · N3679S · Substantial damage - [NTSB DEN68D0065](https://openairdocs.org/ntsb/DEN68D0065.md): Cessna 172 · Casper, WY · Accident · No injuries · Closed · Aug 1, 1967 · N3901R · Substantial damage - [NTSB CHI68D0260](https://openairdocs.org/ntsb/CHI68D0260.md): Cessna 172 · Kent, OH · Accident · No injuries · Closed · Jul 31, 1967 · N3239L · Substantial damage - [NTSB FTW68D0144](https://openairdocs.org/ntsb/FTW68D0144.md): Cessna 172 · Harlingen, TX · Accident · No injuries · Closed · Jul 30, 1967 · N1439F · Substantial damage - [NTSB SEA68D0083](https://openairdocs.org/ntsb/SEA68D0083.md): Cessna 172 · Vashon Is., WA · Accident · No injuries · Closed · Jul 29, 1967 · N4618L · Substantial damage - [NTSB NYC68F0188](https://openairdocs.org/ntsb/NYC68F0188.md): Maule M-4 · New Alexandria, PA · Accident · No injuries · Closed · Jul 27, 1967 · N9858M · Substantial damage - [NTSB FTW68D0123](https://openairdocs.org/ntsb/FTW68D0123.md): Cessna 172 · Winnie, TX · Accident · No injuries · Closed · Jul 26, 1967 · N8233B · Substantial damage - [NTSB CHI68F0219](https://openairdocs.org/ntsb/CHI68F0219.md): Cessna 172 · Lexington, IL · Accident · Minor injuries · Closed · Jul 24, 1967 · N3605L · Substantial damage - [NTSB CHI68D0383](https://openairdocs.org/ntsb/CHI68D0383.md): Cessna 172 · Milwaukee, WI · Accident · No injuries · Closed · Jul 24, 1967 · N6078R · Substantial damage - [NTSB CHI68D0375](https://openairdocs.org/ntsb/CHI68D0375.md): Cessna 172 · Ft.Atkinson, WI · Accident · No injuries · Closed · Jul 24, 1967 · N7248T · Substantial damage - [NTSB OAK68D0067](https://openairdocs.org/ntsb/OAK68D0067.md): Cessna 172 · Petaluma, CA · Accident · No injuries · Closed · Jul 22, 1967 · N2718L · Substantial damage - [NTSB MKC68F0095](https://openairdocs.org/ntsb/MKC68F0095.md): Cessna 172 · Devils Lake, ND · Accident · No injuries · Closed · Jul 22, 1967 · N6225E · No damage Next page: https://openairdocs.org/ntsb.md?engine=17022&page=48 ## 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=47 --- 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.