# NTSB investigations, 1971, 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 FTW72DRG56](https://openairdocs.org/ntsb/FTW72DRG56.md): Cessna 182H · Tijuana, Mexico · Accident · No injuries · Closed · Dec 30, 1971 · N376LA · Substantial damage
- [NTSB FTW72DRG43](https://openairdocs.org/ntsb/FTW72DRG43.md): Cessna 210E · Tresimilio, Mexico · Accident · Minor injuries · Closed · Dec 17, 1971 · N1801F · Substantial damage
- [NTSB FTW72DQD17](https://openairdocs.org/ntsb/FTW72DQD17.md): Cessna 172L · Hermosillo, Mexico · Accident · No injuries · Closed · Nov 28, 1971 · N7624G · Substantial damage
- [NTSB FTW72DRA24](https://openairdocs.org/ntsb/FTW72DRA24.md): Beech K35 · Matamoros, Mexico · Accident · No injuries · Closed · Nov 13, 1971 · N6060E · Substantial damage
- [NTSB FTW72DQD16](https://openairdocs.org/ntsb/FTW72DQD16.md): Cessna 172E · S.Buenaventra, Mexico · Accident · 4 fatal · Closed · Nov 5, 1971 · N3602S · Destroyed
- [NTSB FTW72DRG36](https://openairdocs.org/ntsb/FTW72DRG36.md): Cessna T-337 · Lapaz, Mexico · Accident · No injuries · Closed · Oct 28, 1971 · N222AC · Destroyed
- [NTSB LAX72DUM20](https://openairdocs.org/ntsb/LAX72DUM20.md): Cessna 172B · Baja, Mexico · Accident · Minor injuries · Closed · Oct 24, 1971 · N6920X · Substantial damage
- [NTSB FTW72DRG19](https://openairdocs.org/ntsb/FTW72DRG19.md): Piper PA-24 · Trincheras, Mexico · Accident · No injuries · Closed · Aug 15, 1971 · N9284P · Substantial damage
- [NTSB FTW72DRG11](https://openairdocs.org/ntsb/FTW72DRG11.md): Piper PA-32 · Navajoa, Mexico · Accident · Serious injuries · Closed · Aug 6, 1971 · N3693W · Destroyed
- [NTSB FTW71DRH35](https://openairdocs.org/ntsb/FTW71DRH35.md): Maule M4210C · Botapelis, Mexico · Accident · Serious injuries · Closed · May 10, 1971 · N2001U · Substantial damage
- [NTSB FTW71DRH10](https://openairdocs.org/ntsb/FTW71DRH10.md): Cessna 310 · Guadalupe, Mexico · Accident · Serious injuries · Closed · Apr 6, 1971 · N804Q · Substantial damage
- [NTSB FTW71DRH15](https://openairdocs.org/ntsb/FTW71DRH15.md): Cessna 182G · Puertocitos, Mexico · Accident · No injuries · Closed · Apr 4, 1971 · N3400S · Substantial damage
- [NTSB FTW71DQG67](https://openairdocs.org/ntsb/FTW71DQG67.md): Beech 95 · Sinaloa, Mexico · Accident · No injuries · Closed · Mar 25, 1971 · N2741Y · Substantial damage
- [NTSB FTW71DPA25](https://openairdocs.org/ntsb/FTW71DPA25.md): Piper PA-24 · Baborigane, Mexico · Accident · 1 fatal · Closed · Mar 14, 1971 · N9104D · Destroyed
- [NTSB FTW71DRG93](https://openairdocs.org/ntsb/FTW71DRG93.md): Beech N35 · Mulege, Mexico · Accident · No injuries · Closed · Mar 9, 1971 · N1205Z · Substantial damage
- [NTSB FTW71DRG91](https://openairdocs.org/ntsb/FTW71DRG91.md): Piper PA-28 · Ensenada, Mexico · Accident · Serious injuries · Closed · Mar 4, 1971 · N6366W · Substantial damage
- [NTSB FTW71DRG89](https://openairdocs.org/ntsb/FTW71DRG89.md): Cessna 206 · Lagunitas, Mexico · Accident · 1 fatal · Closed · Mar 1, 1971 · N2660X · Destroyed
- [NTSB FTW71DRH07](https://openairdocs.org/ntsb/FTW71DRH07.md): Cessna 172 · Guaymas, Mexico · Accident · Minor injuries · Closed · Feb 24, 1971 · N8853U · Substantial damage
- [NTSB FTW71DRA35](https://openairdocs.org/ntsb/FTW71DRA35.md): Cessna 182M · Chihuahua, Mexico · Accident · No injuries · Closed · Jan 5, 1971 · N71456 · 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 year(c."eventDate") = 1971
  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=1971

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