# Fatal NTSB investigations: North American SNJ-4

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 LAX94LA368](https://openairdocs.org/ntsb/LAX94LA368.md): North American SNJ-5 · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · Sep 18, 1994 · N8540Z · 2 aircraft · Destroyed
  > that the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.
- [NTSB DCA87MA029](https://openairdocs.org/ntsb/DCA87MA029.md): Cessna 340A · Orlando, FL · Accident · 4 fatal · Class 1 · Major · Final report · May 1, 1987 · N8716K · 2 aircraft · Destroyed
  > The two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt…
- [NTSB OAK78DA055](https://openairdocs.org/ntsb/OAK78DA055.md): N.American SNJ-4 · Reno, NV · Accident · 2 fatal · Closed · Sep 16, 1978 · N7038C · 2 aircraft · Destroyed
- [NTSB MKC78FA051](https://openairdocs.org/ntsb/MKC78FA051.md): N American SNJ-4 · Gravois Mills, MO · Accident · 1 fatal · Closed · Jun 25, 1978 · N9589C · Destroyed
- [NTSB IAD74FLJ06](https://openairdocs.org/ntsb/IAD74FLJ06.md): N.American AT-6C · Clarkton, NC · Accident · 1 fatal · Closed · Jul 29, 1973 · N6419D · Substantial damage
- [NTSB MKC73AK003](https://openairdocs.org/ntsb/MKC73AK003.md): N.American SNJ-4 · Thief Rvr Fl, MN · Accident · 2 fatal · Closed · Jul 6, 1972 · N7056C · Destroyed
- [NTSB NYC71AN008](https://openairdocs.org/ntsb/NYC71AN008.md): N American SNJ-4 · Billings, NY · Accident · 1 fatal · Closed · Jul 18, 1970 · N733L · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6400414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=6400414

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