# NTSB investigations: Piper PA-28-150 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 3 of 3 · 136 cases ## Cases, newest first - [NTSB FTW67F0057](https://openairdocs.org/ntsb/FTW67F0057.md): Piper PA-28 · New Mannford, OK · Accident · No injuries · Closed · May 30, 1966 · N5860W · Substantial damage - [NTSB LAX66A0089](https://openairdocs.org/ntsb/LAX66A0089.md): Piper PA-28 · Santa Ynez, CA · Accident · No injuries · Closed · May 18, 1966 · N5914W · 2 aircraft · Minor damage - [NTSB NYC66F0632](https://openairdocs.org/ntsb/NYC66F0632.md): Piper PA-28 · Sadsburyville, PA · Accident · No injuries · Closed · Apr 23, 1966 · N5721W · Substantial damage - [NTSB CHI66F0660](https://openairdocs.org/ntsb/CHI66F0660.md): Piper PA-28 · Grand Rapids, MI · Accident · No injuries · Closed · Mar 28, 1966 · N5719W · Substantial damage - [NTSB DEN66D0291](https://openairdocs.org/ntsb/DEN66D0291.md): Piper PA-28 · Superior, AZ · Accident · No injuries · Closed · Mar 12, 1966 · N5863W · Substantial damage - [NTSB NYC66D0550](https://openairdocs.org/ntsb/NYC66D0550.md): Piper PA-28 · Buffalo, NY · Accident · No injuries · Closed · Mar 4, 1966 · N5784W · Substantial damage - [NTSB LAX66F0291](https://openairdocs.org/ntsb/LAX66F0291.md): Piper PA-28 · Chino, CA · Accident · Serious injuries · Closed · Mar 2, 1966 · N5887W · Substantial damage - [NTSB MIA66A0099](https://openairdocs.org/ntsb/MIA66A0099.md): Piper PA-28 · Oak Hill, FL · Accident · 4 fatal · Closed · Feb 27, 1966 · N5832W · Destroyed - [NTSB NYC66A0078](https://openairdocs.org/ntsb/NYC66A0078.md): Piper PA-28 · Warwick, RI · Accident · 3 fatal · Closed · Jan 22, 1966 · N5562W · 2 aircraft · Destroyed - [NTSB NYC66D0472](https://openairdocs.org/ntsb/NYC66D0472.md): Piper PA-28 · Nottingham, PA · Accident · No injuries · Closed · Jan 19, 1966 · N5721W · Substantial damage - [NTSB DEN66D0206](https://openairdocs.org/ntsb/DEN66D0206.md): Piper PA-28 · Logan, UT · Accident · No injuries · Closed · Jan 19, 1966 · N5071W · Substantial damage - [NTSB CHI66F0576](https://openairdocs.org/ntsb/CHI66F0576.md): Piper PA-28 · Columbia, IL · Accident · Serious injuries · Closed · Jan 15, 1966 · N5835W · Destroyed - [NTSB MIA66D0373](https://openairdocs.org/ntsb/MIA66D0373.md): Piper PA-28 · Savannah, GA · Accident · No injuries · Closed · Dec 10, 1965 · N5797W · Substantial damage - [NTSB LAX66F0175](https://openairdocs.org/ntsb/LAX66F0175.md): Piper PA-28 · Hawthorne, CA · Accident · No injuries · Closed · Dec 3, 1965 · N5757W · Substantial damage - [NTSB NYC66D0480](https://openairdocs.org/ntsb/NYC66D0480.md): Piper PA-28 · Pitman, NJ · Accident · No injuries · Closed · Nov 25, 1965 · N5814W · Substantial damage - [NTSB OAK66F0169](https://openairdocs.org/ntsb/OAK66F0169.md): Piper PA-28 · Honolulu, HI · Accident · No injuries · Closed · Nov 5, 1965 · N5794W · Substantial damage - [NTSB MIA66D0268](https://openairdocs.org/ntsb/MIA66D0268.md): Piper PA-28 · Jonesboro, GA · Accident · No injuries · Closed · Oct 2, 1965 · N5824W · Substantial damage - [NTSB CHI66D0427](https://openairdocs.org/ntsb/CHI66D0427.md): Piper PA-28 · Alliance, OH · Accident · No injuries · Closed · Sep 8, 1965 · N5760W · Substantial damage - [NTSB CHI66D0155](https://openairdocs.org/ntsb/CHI66D0155.md): Piper PA-28 · Perrysville, OH · Accident · No injuries · Closed · Aug 12, 1965 · N5872W · Substantial damage - [NTSB CHI66F0148](https://openairdocs.org/ntsb/CHI66F0148.md): Piper PA-28 · Georgetown, KY · Accident · No injuries · Closed · Jul 31, 1965 · N5873W · Substantial damage - [NTSB LAX66F0044](https://openairdocs.org/ntsb/LAX66F0044.md): Piper PA-28 · Corona, CA · Accident · Serious injuries · Closed · Jun 12, 1965 · N5775W · Destroyed - [NTSB NYC66F0037](https://openairdocs.org/ntsb/NYC66F0037.md): Piper PA-28 · Bainbridge, MD · Accident · Minor injuries · Closed · May 18, 1965 · N5697W · Substantial damage - [NTSB OAK65F0060](https://openairdocs.org/ntsb/OAK65F0060.md): Piper PA-28 · Turlock, CA · Accident · No injuries · Closed · May 8, 1965 · N5848W · Substantial damage - [NTSB LAX65F0005](https://openairdocs.org/ntsb/LAX65F0005.md): Piper PA-28 · San Diego, CA · Accident · No injuries · Closed · Feb 13, 1965 · N5732W · Substantial damage - [NTSB OAK65D0005](https://openairdocs.org/ntsb/OAK65D0005.md): Piper PA28 · San Jose, CA · Accident · No injuries · Closed · Jan 27, 1965 · N5700W · Substantial damage - [NTSB UNK65X1227](https://openairdocs.org/ntsb/UNK65X1227.md): Piper PA28 · Mt Pleasant, CA · Accident · No injuries · Closed · Jan 3, 1965 · N5706W · Substantial damage - [NTSB UNK65X0602](https://openairdocs.org/ntsb/UNK65X0602.md): Piper PA-28 · Springville, CA · Accident · 2 fatal · Closed · Nov 7, 1964 · N5756W · Destroyed - [NTSB UNK64X3735](https://openairdocs.org/ntsb/UNK64X3735.md): Piper PA28 · Cape May, NJ · Accident · No injuries · Closed · Sep 2, 1964 · N5707W · Substantial damage - [NTSB UNK64X3394](https://openairdocs.org/ntsb/UNK64X3394.md): Piper PA-28 · Lebanon, NH · Accident · No injuries · Closed · Aug 15, 1964 · N5604W · Substantial damage - [NTSB UNK64X3197](https://openairdocs.org/ntsb/UNK64X3197.md): Piper PA28 · Van Nuys, CA · Accident · No injuries · Closed · Aug 3, 1964 · N5734W · Substantial damage - [NTSB UNK64X2833](https://openairdocs.org/ntsb/UNK64X2833.md): Piper PA-28 · Reno, NV · Accident · 3 fatal · Closed · Jul 14, 1964 · N5493W · Destroyed - [NTSB UNK64X2631](https://openairdocs.org/ntsb/UNK64X2631.md): Piper PA-28 · Fresno, CA · Accident · No injuries · Closed · Jul 4, 1964 · N5346W · Substantial damage - [NTSB UNK64X2287](https://openairdocs.org/ntsb/UNK64X2287.md): Piper PA28 · Burwell, NE · Accident · No injuries · Closed · Jun 14, 1964 · N5152W · Substantial damage - [NTSB UNK64X0893](https://openairdocs.org/ntsb/UNK64X0893.md): Piper PA28 · Norwood, MA · Accident · No injuries · Closed · Mar 12, 1964 · N5449W · Substantial damage - [NTSB UNK64X0445](https://openairdocs.org/ntsb/UNK64X0445.md): Piper PA28 · Haddonfield, NJ · Accident · No injuries · Closed · Feb 2, 1964 · N5732W · Substantial damage - [NTSB UNK64X0387](https://openairdocs.org/ntsb/UNK64X0387.md): Piper PA28 · Lumberton, NJ · Accident · No injuries · Closed · Jan 28, 1964 · N5707W · Substantial damage ## 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 ('7102804')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=7102804&page=3 --- 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.