# NTSB investigations: Piper PA-24 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 6 of 9 · 425 cases ## Cases, newest first - [NTSB CHI69D0398](https://openairdocs.org/ntsb/CHI69D0398.md): Piper PA-24 · Mt.Vernon, IN · Accident · No injuries · Closed · Nov 28, 1968 · N7880P · Substantial damage - [NTSB FTW69A0036](https://openairdocs.org/ntsb/FTW69A0036.md): Piper PA-24 · Lampasas, TX · Accident · 3 fatal · Closed · Nov 27, 1968 · N8153P · Destroyed - [NTSB MIA69F0263](https://openairdocs.org/ntsb/MIA69F0263.md): Piper PA-24 · Lawrenceburg, TN · Accident · Serious injuries · Closed · Nov 25, 1968 · N5781P · Destroyed - [NTSB CHI69D0372](https://openairdocs.org/ntsb/CHI69D0372.md): Piper PA-24 · Roselle, IL · Accident · No injuries · Closed · Nov 24, 1968 · N7668P · Substantial damage - [NTSB CHI69F0357](https://openairdocs.org/ntsb/CHI69F0357.md): Piper PA-24 · Sparta, MI · Accident · No injuries · Closed · Nov 21, 1968 · N5031P · Substantial damage - [NTSB NYC69A0047](https://openairdocs.org/ntsb/NYC69A0047.md): Piper PA-24 · Fleming, PA · Accident · 2 fatal · Closed · Oct 26, 1968 · N5025P · Destroyed - [NTSB NYC69D0233](https://openairdocs.org/ntsb/NYC69D0233.md): Piper PA-24 · Montauk, NY · Accident · No injuries · Closed · Oct 5, 1968 · N5759P · Substantial damage - [NTSB DEN69D0123](https://openairdocs.org/ntsb/DEN69D0123.md): Piper PA-24 · Columbus, NM · Accident · No injuries · Closed · Sep 28, 1968 · N7551P · Substantial damage - [NTSB DEN69F0116](https://openairdocs.org/ntsb/DEN69F0116.md): Piper PA-24 · Grnd Juncton, CO · Accident · Serious injuries · Closed · Sep 23, 1968 · N7294P · Destroyed - [NTSB MIA69A0010](https://openairdocs.org/ntsb/MIA69A0010.md): Piper PA-24 · Bradenton, FL · Accident · 2 fatal · Closed · Aug 26, 1968 · N7413P · Destroyed - [NTSB FTW69F0169](https://openairdocs.org/ntsb/FTW69F0169.md): Piper PA-24 · Texas City, TX · Accident · No injuries · Closed · Aug 24, 1968 · N6568P · Substantial damage - [NTSB MIA69D0108](https://openairdocs.org/ntsb/MIA69D0108.md): Piper PA-24 · Chapel Hill, TN · Accident · No injuries · Closed · Aug 11, 1968 · N7677P · Substantial damage - [NTSB NYC69F0103](https://openairdocs.org/ntsb/NYC69F0103.md): Piper PA-24 · Thomasville, PA · Accident · Minor injuries · Closed · Aug 3, 1968 · N7373P · Substantial damage - [NTSB CHI69D0114](https://openairdocs.org/ntsb/CHI69D0114.md): Piper PA-24 · Trout Lake, MI · Accident · No injuries · Closed · Jul 18, 1968 · N5486P · Substantial damage - [NTSB MIA69F0012](https://openairdocs.org/ntsb/MIA69F0012.md): Piper PA-24 · Gainesville, FL · Accident · No injuries · Closed · May 8, 1968 · N5377P · Substantial damage - [NTSB CHI68F0757](https://openairdocs.org/ntsb/CHI68F0757.md): Piper PA-24 · Michigan City, IN · Accident · No injuries · Closed · May 5, 1968 · N5959P · Substantial damage - [NTSB MKC68F0564](https://openairdocs.org/ntsb/MKC68F0564.md): Piper PA-24 · North Platte, NE · Accident · No injuries · Closed · Apr 28, 1968 · N6149P · Substantial damage - [NTSB MIA68D0499](https://openairdocs.org/ntsb/MIA68D0499.md): Piper PA-24 · Anderson, SC · Accident · No injuries · Closed · Apr 28, 1968 · N7027P · Substantial damage - [NTSB CHI68D0724](https://openairdocs.org/ntsb/CHI68D0724.md): Piper PA-24 · Milwaukee, WI · Accident · No injuries · Closed · Apr 28, 1968 · N5078P · Substantial damage - [NTSB MKC68A0059](https://openairdocs.org/ntsb/MKC68A0059.md): Cessna 150 · Kansas City, MO · Accident · 1 fatal · Closed · Apr 10, 1968 · N6386S · 2 aircraft · Substantial damage - [NTSB CHI68F0652](https://openairdocs.org/ntsb/CHI68F0652.md): Piper PA-24 · Chesapeake, OH · Accident · No injuries · Closed · Mar 18, 1968 · N7013P · Substantial damage - [NTSB LAX68F0326](https://openairdocs.org/ntsb/LAX68F0326.md): Piper PA-24 · Hawthorne, CA · Accident · No injuries · Closed · Mar 1, 1968 · N7398P · Substantial damage - [NTSB NYC68D0387](https://openairdocs.org/ntsb/NYC68D0387.md): Piper PA-24 · Stratford, CT · Accident · No injuries · Closed · Feb 23, 1968 · N870W · Substantial damage - [NTSB DIA68F0165](https://openairdocs.org/ntsb/DIA68F0165.md): Piper PA-24 · Raleigh, NC · Accident · No injuries · Closed · Feb 16, 1968 · N8124P · Substantial damage - [NTSB MIA68F0390](https://openairdocs.org/ntsb/MIA68F0390.md): Piper PA-24 · Sarasota, FL · Accident · No injuries · Closed · Jan 23, 1968 · N7113P · Substantial damage - [NTSB NYC68D0331](https://openairdocs.org/ntsb/NYC68D0331.md): Piper PA-24 · White Plains, NY · Accident · No injuries · Closed · Dec 24, 1967 · N7037P · Substantial damage - [NTSB DIA68A0042](https://openairdocs.org/ntsb/DIA68A0042.md): Piper PA-24 · Robbinsville, NC · Accident · 2 fatal · Closed · Dec 22, 1967 · N6238P · Destroyed - [NTSB LAX68D0207](https://openairdocs.org/ntsb/LAX68D0207.md): Piper PA-24 · Carlsbad, CA · Accident · No injuries · Closed · Nov 22, 1967 · N6836P · Substantial damage - [NTSB MIA68D0284](https://openairdocs.org/ntsb/MIA68D0284.md): Piper PA-24 · Sumter, SC · Accident · No injuries · Closed · Oct 16, 1967 · N5043P · Substantial damage - [NTSB MIA68F0235](https://openairdocs.org/ntsb/MIA68F0235.md): Piper PA-24 · Marietta, GA · Accident · No injuries · Closed · Oct 4, 1967 · N6310P · Substantial damage - [NTSB MIA68F0242](https://openairdocs.org/ntsb/MIA68F0242.md): Piper PA-24 · Winter Haven, FL · Accident · No injuries · Closed · Sep 23, 1967 · N6579P · Substantial damage - [NTSB OAK68F0102](https://openairdocs.org/ntsb/OAK68F0102.md): Piper PA-24 · Honolulu, HI · Accident · No injuries · Closed · Sep 14, 1967 · N6326P · Substantial damage - [NTSB DEN68D0115](https://openairdocs.org/ntsb/DEN68D0115.md): Piper PA-24 · Grady, NM · Accident · No injuries · Closed · Sep 14, 1967 · N8029P · Substantial damage - [NTSB SEA68D0176](https://openairdocs.org/ntsb/SEA68D0176.md): Piper PA-24 · Auburn, WA · Accident · No injuries · Closed · Sep 4, 1967 · N5727P · Destroyed - [NTSB MKC68F0290](https://openairdocs.org/ntsb/MKC68F0290.md): Piper PA-24 · Ashley, ND · Accident · No injuries · Closed · Sep 3, 1967 · N5088P · Substantial damage - [NTSB LAX68D0141](https://openairdocs.org/ntsb/LAX68D0141.md): Piper PA-24 · Ojai, CA · Accident · No injuries · Closed · Aug 27, 1967 · N7364P · Substantial damage - [NTSB MKC68F0185](https://openairdocs.org/ntsb/MKC68F0185.md): Piper PA-24 · Des Moines, IA · Accident · No injuries · Closed · Aug 23, 1967 · N6001P · Substantial damage - [NTSB SEA68D0108](https://openairdocs.org/ntsb/SEA68D0108.md): Piper PA-24 · Gannett, ID · Accident · No injuries · Closed · Aug 20, 1967 · N6319P · Substantial damage - [NTSB SEA68D0172](https://openairdocs.org/ntsb/SEA68D0172.md): Piper PA-24 · Klamath Fall, OR · Accident · No injuries · Closed · Aug 17, 1967 · N6097P · Substantial damage - [NTSB SEA68F0142](https://openairdocs.org/ntsb/SEA68F0142.md): Piper PA-24 · Columbus, MT · Accident · No injuries · Closed · Aug 14, 1967 · N5384P · Destroyed - [NTSB MIA68F0221](https://openairdocs.org/ntsb/MIA68F0221.md): Piper PA-24 · Greenville, SC · Accident · No injuries · Closed · Aug 11, 1967 · N7140P · Substantial damage - [NTSB OAK68D0179](https://openairdocs.org/ntsb/OAK68D0179.md): Piper PA-24 · Fort Bragg, CA · Accident · No injuries · Closed · Aug 7, 1967 · N6611P · Substantial damage - [NTSB NYC68F0110](https://openairdocs.org/ntsb/NYC68F0110.md): Piper PA-24 · Nottingham, PA · Accident · Serious injuries · Closed · Aug 6, 1967 · N8090P · Destroyed - [NTSB NYC68F0108](https://openairdocs.org/ntsb/NYC68F0108.md): Piper PA-24 · Philadelphia, PA · Accident · No injuries · Closed · Aug 6, 1967 · N7027P · Substantial damage - [NTSB CHI68D0275](https://openairdocs.org/ntsb/CHI68D0275.md): Piper PA-24 · Oshkosh, WI · Accident · No injuries · Closed · Aug 5, 1967 · N6704P · Substantial damage - [NTSB CHI68F0159](https://openairdocs.org/ntsb/CHI68F0159.md): Piper PA-24 · Sonora, KY · Accident · No injuries · Closed · Jul 3, 1967 · N7502P · Substantial damage - [NTSB MKC68D0039](https://openairdocs.org/ntsb/MKC68D0039.md): Piper PA-24 · Gettysburg, SD · Accident · Minor injuries · Closed · Jun 15, 1967 · N5936P · Substantial damage - [NTSB CHI67F0681](https://openairdocs.org/ntsb/CHI67F0681.md): Piper PA-24 · Fraser, MI · Accident · No injuries · Closed · Jun 12, 1967 · N7113P · Substantial damage - [NTSB CHI68F0135](https://openairdocs.org/ntsb/CHI68F0135.md): Piper PA-24 · Valmeyer, IL · Accident · No injuries · Closed · May 25, 1967 · N8074P · Substantial damage - [NTSB MIA67D0555](https://openairdocs.org/ntsb/MIA67D0555.md): Piper PA-24 · Oak Ridge, TN · Accident · No injuries · Closed · May 19, 1967 · N7598P · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=7102402&page=7 ## 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 ('7102402')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=7102402&page=6 --- 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.