# NTSB investigations, 1975, Mexico

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 LAX76O0009](https://openairdocs.org/ntsb/LAX76O0009.md): Piper PA-24 · Palenque, Mexico · Accident · Minor injuries · Closed · Dec 26, 1975 · N7888P · Substantial damage
- [NTSB LAX7600014](https://openairdocs.org/ntsb/LAX7600014.md): Cessna 210 · Culiacan, Mexico · Accident · No injuries · Closed · Dec 25, 1975 · N5279V · Substantial damage
- [NTSB LAX7600017](https://openairdocs.org/ntsb/LAX7600017.md): Piper PA-32 · Bachiniva, Mexico · Accident · Serious injuries · Closed · Dec 4, 1975 · N5227S · Substantial damage
- [NTSB FTW76FPA16](https://openairdocs.org/ntsb/FTW76FPA16.md): Cessna 402 · Cerralvo, Mexico · Accident · No injuries · Closed · Dec 1, 1975 · N33WT · Substantial damage
- [NTSB LAX76O0013](https://openairdocs.org/ntsb/LAX76O0013.md): Piper PA-32 · Mulege, Mexico · Accident · No injuries · Closed · Nov 5, 1975 · N4147R · Substantial damage
- [NTSB LAX76A0008](https://openairdocs.org/ntsb/LAX76A0008.md): Piper PA-32 · Navajoa, Mexico · Accident · No injuries · Closed · Sep 17, 1975 · N43152 · Substantial damage
- [NTSB LAX76O0002](https://openairdocs.org/ntsb/LAX76O0002.md): Navion B · Ensenada, Mexico · Accident · 1 fatal · Closed · Aug 25, 1975 · N5273K · Destroyed
- [NTSB FTW76OQD05](https://openairdocs.org/ntsb/FTW76OQD05.md): Cessna P206A · Juarez, Mexico · Accident · No injuries · Closed · Aug 24, 1975 · N4663F · Destroyed
- [NTSB LAX7600003](https://openairdocs.org/ntsb/LAX7600003.md): Cessna 195A · Mulege, Mexico · Accident · Serious injuries · Closed · Aug 18, 1975 · N1076D · Substantial damage
- [NTSB LAX76O0001](https://openairdocs.org/ntsb/LAX76O0001.md): Cessna T337 · Mulege, Mexico · Accident · Serious injuries · Closed · Jul 28, 1975 · N23664 · Destroyed
- [NTSB LAX7500027](https://openairdocs.org/ntsb/LAX7500027.md): Cessna 150 · Mexicali, Mexico · Accident · No injuries · Closed · May 3, 1975 · N3955J · Substantial damage
- [NTSB FTW75OPG89](https://openairdocs.org/ntsb/FTW75OPG89.md): Beech D18S · Jalisco, Mexico · Accident · No injuries · Closed · May 3, 1975 · N64R · Destroyed
- [NTSB LAX75O0031](https://openairdocs.org/ntsb/LAX75O0031.md): Cessna 182 · Loreto, Mexico · Accident · No injuries · Closed · Apr 28, 1975 · N52315 · Substantial damage
- [NTSB LAX7500026](https://openairdocs.org/ntsb/LAX7500026.md): Cessna 182 · Loreto, Mexico · Accident · No injuries · Closed · Apr 28, 1975 · N52315 · Substantial damage
- [NTSB MKC75OK003](https://openairdocs.org/ntsb/MKC75OK003.md): Cessna T210L · Valles, Mexico · Accident · No injuries · Closed · Apr 12, 1975 · N22430 · Destroyed
- [NTSB LAX76O0012](https://openairdocs.org/ntsb/LAX76O0012.md): Lockheed PV-1 · Culiacan, Mexico · Accident · 2 fatal · Closed · Apr 1, 1975 · N730EG · Substantial damage
- [NTSB LAX75O0021](https://openairdocs.org/ntsb/LAX75O0021.md): Grum Amer AA5 · Puertecitos, Mexico · Accident · No injuries · Closed · Mar 22, 1975 · N7291L · Substantial damage
- [NTSB LAX75O0018](https://openairdocs.org/ntsb/LAX75O0018.md): Cessna 172 · Puertecitos, Mexico · Accident · Minor injuries · Closed · Mar 6, 1975 · N18674 · Substantial damage
- [NTSB FTW75ORG72](https://openairdocs.org/ntsb/FTW75ORG72.md): Cessna 205 · Muzquin, Mexico · Accident · Minor injuries · Closed · Feb 17, 1975 · N8318Z · Destroyed
- [NTSB LAX7500025](https://openairdocs.org/ntsb/LAX7500025.md): Cessna 180 · Vecora, Mexico · Accident · 3 fatal · Closed · Jan 26, 1975 · N4659A · 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 year(c."eventDate") = 1975
  AND c."eventStateOrRegion" = 'MX' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=MX&year=1975

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