# NTSB investigations: Piper PA-28-235, Outside the U.S.

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.

## Latest cases

- [NTSB CEN13WA123](https://openairdocs.org/ntsb/CEN13WA123.md): Piper PA-28-235 · Guatemala City, Guatemala · Accident · 2 fatal · Foreign investigation · Dec 29, 2012 · N64KW · Substantial damage
- [NTSB LAX93WA145](https://openairdocs.org/ntsb/LAX93WA145.md): Piper PA-28-235 · Loreto, Mexico · Accident · 3 fatal · Foreign investigation · Feb 27, 1993 · N166DP · Destroyed
- [NTSB LAX75OL014](https://openairdocs.org/ntsb/LAX75OL014.md): Piper PA-28 · La Paz, Mexico · Accident · No injuries · Closed · Nov 27, 1974 · N101YT · Substantial damage
- [NTSB FTW74ORG72](https://openairdocs.org/ntsb/FTW74ORG72.md): Piper PA-28 · San Juan, Mexico · Accident · No injuries · Closed · Feb 4, 1974 · N15153 · Substantial damage
- [NTSB FTW74DRG61](https://openairdocs.org/ntsb/FTW74DRG61.md): Piper PA-28 · Jaco, Serbia · Accident · No injuries · Closed · Jan 27, 1974 · N8993W · Substantial damage
- [NTSB LAX74OL034](https://openairdocs.org/ntsb/LAX74OL034.md): Piper PA-28 · Buena Vista, Mexico · Accident · Serious injuries · Closed · Sep 10, 1973 · N8761W · Substantial damage
- [NTSB FTW71DRG47](https://openairdocs.org/ntsb/FTW71DRG47.md): Piper PA-28 · Rancho S.J., Mexico · Accident · No injuries · Closed · Oct 31, 1970 · N9395W · Substantial damage
- [NTSB UNK65X1515](https://openairdocs.org/ntsb/UNK65X1515.md): Piper PA-28 · Tascha Lake, Canada · Accident · No injuries · Closed · Jul 7, 1965 · N8644W · Substantial damage
- [NTSB DEN66D0047](https://openairdocs.org/ntsb/DEN66D0047.md): Piper PA-28 · Bahia Kino, Mexico · Accident · No injuries · Closed · Jul 3, 1965 · N8947W · Substantial damage
- [NTSB UNK65X1491](https://openairdocs.org/ntsb/UNK65X1491.md): Piper PA-28 · Mulege, Mexico · Accident · No injuries · Closed · May 1, 1965 · N8679W · Substantial damage
- [NTSB UNK65X1219](https://openairdocs.org/ntsb/UNK65X1219.md): Piper PA-28 · El Fuerte, Mexico · Accident · 1 fatal · Closed · Jan 3, 1965 · N8865W · Destroyed

## 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."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102810&state=OF

---
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.