# NTSB investigations, 1973, 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 FTW74DRG47](https://openairdocs.org/ntsb/FTW74DRG47.md): Cessna 177RG · Reynosa, Mexico · Accident · No injuries · Closed · Dec 27, 1973 · N1955Q · Substantial damage
- [NTSB LAX74OL051](https://openairdocs.org/ntsb/LAX74OL051.md): Cessna 310 · Mazatlan, Mexico · Accident · No injuries · Closed · Dec 26, 1973 · N3092D · Substantial damage
- [NTSB LAX74OL049](https://openairdocs.org/ntsb/LAX74OL049.md): Mooney M20C · Mulege, Mexico · Accident · 4 fatal · Closed · Dec 22, 1973 · N9082V · Destroyed
- [NTSB OAK74DVD33](https://openairdocs.org/ntsb/OAK74DVD33.md): Cessna 205 · Yecora, Mexico · Accident · 3 fatal · Closed · Oct 28, 1973 · N8299Z · Destroyed
- [NTSB IAD74DLQ16](https://openairdocs.org/ntsb/IAD74DLQ16.md): Piper PA-28 · Renosa, Mexico · Accident · No injuries · Closed · Oct 14, 1973 · N15091 · Substantial damage
- [NTSB LAX74OL032](https://openairdocs.org/ntsb/LAX74OL032.md): Aero Comdr 100 · Hermosillo, Mexico · Accident · 2 fatal · Closed · Sep 29, 1973 · N4038X · Substantial damage
- [NTSB DEN74DQA15](https://openairdocs.org/ntsb/DEN74DQA15.md): Bellanca 17-30 · Chihuahua, Mexico · Accident · No injuries · Closed · Aug 26, 1973 · N4925V · Substantial damage
- [NTSB LAX74OL022](https://openairdocs.org/ntsb/LAX74OL022.md): Beech 35 · Mulege, Mexico · Accident · No injuries · Closed · Aug 25, 1973 · N520B · Substantial damage
- [NTSB FTW74DRG14](https://openairdocs.org/ntsb/FTW74DRG14.md): Piper PA-28 · Coahuila, Mexico · Accident · 2 fatal · Closed · Aug 18, 1973 · N1876T · Destroyed
- [NTSB FTW74DRA15](https://openairdocs.org/ntsb/FTW74DRA15.md): Piper PA-28 · Empalme, Mexico · Accident · 1 fatal · Closed · Jul 31, 1973 · N5198L · Destroyed
- [NTSB LAX74OL007](https://openairdocs.org/ntsb/LAX74OL007.md): Cessna 172L · Sonoyta, Mexico · Accident · No injuries · Closed · Jul 14, 1973 · N1256T · Substantial damage
- [NTSB LAX74OL009](https://openairdocs.org/ntsb/LAX74OL009.md): Piper PA-28 · Tiburon, Mexico · Accident · No injuries · Closed · Jul 7, 1973 · N4801T · Destroyed
- [NTSB DEN74OD010](https://openairdocs.org/ntsb/DEN74OD010.md): Cessna TP206B · Tahuahueto, Mexico · Accident · Minor injuries · Closed · Jun 10, 1973 · N4751F · Substantial damage
- [NTSB OAK73DVD36](https://openairdocs.org/ntsb/OAK73DVD36.md): Piper PA-24 · Mazatlan, Mexico · Accident · No injuries · Closed · May 11, 1973 · N9468P · Substantial damage
- [NTSB OAK73DVG63](https://openairdocs.org/ntsb/OAK73DVG63-189859.md): Cessna T210L · Mexicali, Mexico · Accident · Serious injuries · Closed · Apr 30, 1973 · N1160Q · Substantial damage
- [NTSB FTW73DRG65](https://openairdocs.org/ntsb/FTW73DRG65.md): Cessna 150 · Matamoros, Mexico · Accident · No injuries · Closed · Apr 1, 1973 · N7160C · Substantial damage
- [NTSB SEA73OYE32](https://openairdocs.org/ntsb/SEA73OYE32.md): Cessna 172K · Baja, Mexico · Accident · Minor injuries · Closed · Mar 13, 1973 · N7473G · Substantial damage
- [NTSB FTW73DPD26](https://openairdocs.org/ntsb/FTW73DPD26.md): Piper PA-32 · Ojinaga, Mexico · Accident · No injuries · Closed · Mar 10, 1973 · N4138W · Substantial damage
- [NTSB FTW73DRG86](https://openairdocs.org/ntsb/FTW73DRG86.md): Cessna 182P · Charcas, Mexico · Accident · No injuries · Closed · Mar 3, 1973 · N21445 · Substantial damage
- [NTSB CHI73DEP41](https://openairdocs.org/ntsb/CHI73DEP41.md): Piper PA-28 · Hermosa, Mexico · Accident · Serious injuries · Closed · Feb 26, 1973 · N9809W · Destroyed
- [NTSB FTW73DRG42](https://openairdocs.org/ntsb/FTW73DRG42.md): Cessna 210L · Muzquiz, Mexico · Accident · No injuries · Closed · Jan 15, 1973 · N4616Q · Substantial damage
- [NTSB MKC73DCA16](https://openairdocs.org/ntsb/MKC73DCA16.md): Beechcraft K35 · Cardenas, Mexico · Accident · No injuries · Closed · Jan 11, 1973 · N805R · 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") = 1973
  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=1973

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