# NTSB investigations: Martin 404

A list on [Martin 404](https://openairdocs.org/model/martin-404.md).

Matched to the registry by N-number and event date, newest first.

- [NTSB DEN86FA175](https://openairdocs.org/ntsb/DEN86FA175.md): Martin 404 · Buffalo, WY · Accident · 3 fatal · Field investigation · Final report · Jun 27, 1986 · N40443 · Destroyed
  > N40443 was contracted by the Wyoming dept of ag to spray grasshoppers. Investigation revealed the plt held a pvt certificate with asmel ratings. His medical certificate was denied because he failed to provide information concerning high blood pressure and…
- [NTSB LAX82FA174](https://openairdocs.org/ntsb/LAX82FA174.md): Martin 404 · Madera, CA · Accident · No injuries · Field investigation · Final report · May 15, 1982 · N40445 · Destroyed
  > After takeoff the aircraft was observed to trail a brown substance. About 3 miles from the airport the right engine oil pressure dropped. The pilot decided to return to the airport. When he thought the runway was attainable he lowered the flaps; however, a…
- [NTSB DCA80AA021](https://openairdocs.org/ntsb/DCA80AA021.md): Martin 404 · Tusayan, AZ · Accident · Fatal · Closed · Nov 16, 1979 · N40438 · Destroyed
- [NTSB FTW79FQG45](https://openairdocs.org/ntsb/FTW79FQG45.md): Martin 404 · Miami, TX · Accident · Serious injuries · Closed · Jun 29, 1979 · N40408 · Destroyed
- [NTSB UNK79X0102](https://openairdocs.org/ntsb/UNK79X0102.md): Martin 404 · Gulf Of Venezuela, Venezuela · Accident · No injuries · Closed · Nov 18, 1978 · N13415 · Destroyed
- [NTSB MIA75IM088](https://openairdocs.org/ntsb/MIA75IM088.md): Martin 404 · Key West, FL · Incident · No injuries · Closed · Jun 16, 1975 · N40425 · Minor damage
- [NTSB MIA73AM023](https://openairdocs.org/ntsb/MIA73AM023.md): Martin 404 · Ft.Lauderdale, FL · Accident · No injuries · Closed · Aug 25, 1972 · N469M · Substantial damage
- [NTSB MIA72IM084](https://openairdocs.org/ntsb/MIA72IM084.md): Martin 404 · Columbus, MS · Incident · No injuries · Closed · Feb 21, 1972 · N259S · Minor damage
- [NTSB MIA71AM045](https://openairdocs.org/ntsb/MIA71AM045.md): Martin 404 · Atlanta, GA · Accident · No injuries · Closed · Dec 10, 1970 · N143S · Minor damage
- [NTSB DCA71AZ004](https://openairdocs.org/ntsb/DCA71AZ004.md): Martin 404 · Silver Plume, CO · Accident · 30 fatal · Closed · Oct 2, 1970 · N464M · Destroyed
- [NTSB MIA70AM093](https://openairdocs.org/ntsb/MIA70AM093.md): Martin 404 · Atlanta, GA · Accident · 1 fatal · Closed · May 30, 1970 · N40412 · Destroyed
- [NTSB IAD70II043](https://openairdocs.org/ntsb/IAD70II043.md): Martin 404 · Rocky Mount, NC · Incident · No injuries · Closed · Feb 10, 1970 · N40402 · Minor damage
- [NTSB DIA67A0019](https://openairdocs.org/ntsb/DIA67A0019.md): Martin M-404 · Wilmington, NC · Accident · Serious injuries · Closed · May 19, 1967 · N40414 · No damage
- [NTSB CHI67A0084](https://openairdocs.org/ntsb/CHI67A0084.md): Martin 404 · Cleveland, OH · Accident · No injuries · Closed · Jan 7, 1967 · N478A · Substantial damage
- [NTSB MIA67A0058](https://openairdocs.org/ntsb/MIA67A0058.md): Martin M-404 · New Bern, NC · Accident · 3 fatal · Closed · Nov 20, 1966 · N40406 · Destroyed
- [NTSB NYC67A0007](https://openairdocs.org/ntsb/NYC67A0007.md): Martin M-404 · Roanoke, VA · Accident · Serious injuries · Closed · Jul 9, 1966 · N40446 · Substantial damage
- [NTSB OAK66A0012](https://openairdocs.org/ntsb/OAK66A0012.md): Martin M-404 · San Jose, CA · Accident · No injuries · Closed · Sep 19, 1965 · N444A · No damage
- [NTSB MIA66I0005](https://openairdocs.org/ntsb/MIA66I0005.md): Martin M-404 · Winston Salem, NC · Incident · No injuries · Closed · Jul 9, 1965 · N40448 · Minor damage
- [NTSB NYC65 0096](https://openairdocs.org/ntsb/NYC65%200096.md): Martin M-404 · Weyers Cave, VA · Accident · No injuries · Closed · Jan 21, 1965 · N40448 · Substantial damage
- [NTSB NYC65I0094](https://openairdocs.org/ntsb/NYC65I0094.md): Martin M-404 · Roanoke, VA · Incident · No injuries · Closed · Jan 9, 1965 · N40415 · Minor damage
- [NTSB UNK64X0737](https://openairdocs.org/ntsb/UNK64X0737.md): Martin M-404 · Binghamton, NY · Accident · No injuries · Closed · Feb 29, 1964 · N472M · Substantial damage
- [NTSB DCA64A0008](https://openairdocs.org/ntsb/DCA64A0008.md): Martin 404 · Rochester, NY · Accident · 7 fatal · Closed · Jul 2, 1963 · N449A · Destroyed
- [NTSB FTW63A0173](https://openairdocs.org/ntsb/FTW63A0173.md): Martin 404 · Baton Rouge, LA · Accident · No injuries · Closed · Jun 17, 1963 · N145S · Substantial damage
- [NTSB MIA62A0062](https://openairdocs.org/ntsb/MIA62A0062.md): Martin 404 · Wilmington, NC · Accident · Minor injuries · Closed · Aug 22, 1962 · N40401 · Destroyed
- [NTSB MIA62A0055](https://openairdocs.org/ntsb/MIA62A0055.md): Martin 404 · Rocky Mount, NC · Accident · No injuries · Closed · Aug 6, 1962 · N40415 · Substantial damage
- [NTSB LAX62A0038](https://openairdocs.org/ntsb/LAX62A0038.md): Martin 404 · Lompoc, CA · Accident · No injuries · Closed · Apr 17, 1962 · N40436 · 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5450702')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/model/martin-404/ntsb

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