# NTSB investigations, Place not recorded

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.

Page 4 of 5 · 203 cases

## Cases, newest first

- [NTSB MIA70A0031](https://openairdocs.org/ntsb/MIA70A0031.md): Brittnorman BN-2A · Missing Aircraft · Accident · 2 fatal · Closed · Oct 11, 1969 · N852JA · Destroyed
- [NTSB ANC70A0019](https://openairdocs.org/ntsb/ANC70A0019.md): Cessna 150 · Missing Aircraft · Accident · 1 fatal · Closed · Aug 31, 1969 · N3028S · Destroyed
- [NTSB FTW70A0026](https://openairdocs.org/ntsb/FTW70A0026.md): Cessna 150 · Missing Aircraft · Accident · 1 fatal · Closed · Aug 23, 1969 · N50509 · Destroyed
- [NTSB MIA70A0036](https://openairdocs.org/ntsb/MIA70A0036.md): Piper PA-22 · Missing Aircraft · Accident · 2 fatal · Closed · Aug 3, 1969 · N8971C · Destroyed
- [NTSB CHI70A0008](https://openairdocs.org/ntsb/CHI70A0008.md): Cessna 182 · Missing Aircraft · Accident · 2 fatal · Closed · Jul 18, 1969 · N3117R · Destroyed
- [NTSB MIA69A0097](https://openairdocs.org/ntsb/MIA69A0097.md): Beech B95 · Missing Aircraft · Accident · 1 fatal · Closed · Jun 29, 1969 · N590T · Destroyed
- [NTSB CHI69A0097](https://openairdocs.org/ntsb/CHI69A0097.md): Beech 35 · Missing Aircraft · Accident · 4 fatal · Closed · May 21, 1969 · N3358V · Destroyed
- [NTSB NYC69A0091](https://openairdocs.org/ntsb/NYC69A0091.md): Piper PA-23 · Missing Aircraft · Accident · 6 fatal · Closed · Mar 29, 1969 · N6116Y · Destroyed
- [NTSB MIA69A0056](https://openairdocs.org/ntsb/MIA69A0056.md): Beech 50 · Missing Aircraft · Accident · 2 fatal · Closed · Mar 22, 1969 · N609R · Destroyed
- [NTSB NYC69A0086](https://openairdocs.org/ntsb/NYC69A0086.md): Douglas DC-4 · Missing Aircraft · Accident · 3 fatal · Closed · Mar 8, 1969 · N3821 · Destroyed
- [NTSB MIA69A0047](https://openairdocs.org/ntsb/MIA69A0047.md): Beech 95-C55 · Missing Aircraft · Accident · 1 fatal · Closed · Feb 15, 1969 · N9490S · Destroyed
- [NTSB ANC69A0035](https://openairdocs.org/ntsb/ANC69A0035.md): Cessna 185 · Missing Aircraft · Accident · 1 fatal · Closed · Jan 9, 1969 · N1656Z · Destroyed
- [NTSB DIA69A0032](https://openairdocs.org/ntsb/DIA69A0032.md): Piper PA-24 · Missing Aircraft · Accident · 2 fatal · Closed · Jan 5, 1969 · N8653P · Destroyed
- [NTSB OAK69A0035](https://openairdocs.org/ntsb/OAK69A0035.md): Beech 23 · Z · Accident · 2 fatal · Closed · Nov 27, 1968 · N2353L · Destroyed
- [NTSB NYC68A0138](https://openairdocs.org/ntsb/NYC68A0138.md): Cessna 150F · Z · Accident · 2 fatal · Closed · Jun 19, 1968 · N8676S · Destroyed
- [NTSB SEA68A0072](https://openairdocs.org/ntsb/SEA68A0072.md): Aeronca O-58B · Z · Accident · 2 fatal · Closed · Jun 15, 1968 · N1061N · Destroyed
- [NTSB CHI68A0102](https://openairdocs.org/ntsb/CHI68A0102.md): Cessna 120 · Z · Accident · 1 fatal · Closed · May 11, 1968 · N2357N · Destroyed
- [NTSB DIA68A0038](https://openairdocs.org/ntsb/DIA68A0038.md): Piper PA-24 · Z · Accident · 2 fatal · Closed · Mar 10, 1968 · N6377P · Destroyed
- [NTSB OAK68A0059](https://openairdocs.org/ntsb/OAK68A0059.md): Piper PA-22 · Accident · 2 fatal · Closed · Feb 10, 1968 · N4940Z
- [NTSB MIA68O0006](https://openairdocs.org/ntsb/MIA68O0006.md): Piper PA-28 · Z · Accident · 4 fatal · Closed · Nov 22, 1967 · N9443J · Destroyed
- [NTSB MIA68O0004](https://openairdocs.org/ntsb/MIA68O0004.md): Cessna 182 · Accident · 4 fatal · Closed · Nov 8, 1967 · N7121E · Destroyed
- [NTSB SEA68A0038](https://openairdocs.org/ntsb/SEA68A0038.md): Mooney M-18LA · Accident · 1 fatal · Closed · Oct 28, 1967 · N4074 · Destroyed
- [NTSB MIA68A0038](https://openairdocs.org/ntsb/MIA68A0038.md): Piper PA-30 · Accident · 3 fatal · Closed · Oct 10, 1967 · N8051Y · Destroyed
- [NTSB MIA68A0036](https://openairdocs.org/ntsb/MIA68A0036.md): Piper PA-28 · Accident · 1 fatal · Closed · Oct 3, 1967 · N3775K · Destroyed
- [NTSB MIA68A0019](https://openairdocs.org/ntsb/MIA68A0019.md): Piper PA-28 · Accident · 3 fatal · Closed · Aug 6, 1967 · N8165W · Destroyed
- [NTSB ANC67A0063](https://openairdocs.org/ntsb/ANC67A0063.md): Lockheed PV-2 · Accident · 1 fatal · Closed · Jun 12, 1967 · N7266C · Destroyed
- [NTSB OAK67A0085](https://openairdocs.org/ntsb/OAK67A0085.md): Piper PA-28 · Accident · 3 fatal · Closed · Jun 2, 1967 · N4389J · Destroyed
- [NTSB NYC67A0147](https://openairdocs.org/ntsb/NYC67A0147.md): Cessna 172 · Accident · 2 fatal · Closed · Apr 23, 1967 · N1609F · Destroyed
- [NTSB MIA67A0079](https://openairdocs.org/ntsb/MIA67A0079.md): Piper PA-23 · Accident · 3 fatal · Closed · Jan 17, 1967 · N4129P · Destroyed
- [NTSB MIA67A0078](https://openairdocs.org/ntsb/MIA67A0078.md): Beech J35 · Accident · 4 fatal · Closed · Jan 14, 1967 · N7210B · Destroyed
- [NTSB CHI67A0089](https://openairdocs.org/ntsb/CHI67A0089.md): Cessna 170 · Accident · 3 fatal · Closed · Jan 14, 1967 · N9201A · Destroyed
- [NTSB ANC67A0036](https://openairdocs.org/ntsb/ANC67A0036.md): Piper PA-16 · Z · Accident · 1 fatal · Closed · Oct 8, 1966 · N6801K · Destroyed
- [NTSB MIA67A0038](https://openairdocs.org/ntsb/MIA67A0038.md): Piper PA-24 · Z · Accident · 2 fatal · Closed · Sep 20, 1966 · N7090P · Destroyed
- [NTSB ANC67A0030](https://openairdocs.org/ntsb/ANC67A0030.md): Stinson 108-2 · Z · Accident · 1 fatal · Closed · Sep 20, 1966 · N9293K · Destroyed
- [NTSB CHI67A0034](https://openairdocs.org/ntsb/CHI67A0034.md): Piper PA-23 · Z · Accident · 3 fatal · Closed · Aug 27, 1966 · N5951Y · Destroyed
- [NTSB OAK67A0008](https://openairdocs.org/ntsb/OAK67A0008.md): Piper PA-22 · Z · Accident · 1 fatal · Closed · Jul 7, 1966 · N2598A · Destroyed
- [NTSB LAX66A0086](https://openairdocs.org/ntsb/LAX66A0086.md): Beech 35 · Z · Accident · 1 fatal · Closed · May 8, 1966 · N3918N · Destroyed
- [NTSB MIA66A0114](https://openairdocs.org/ntsb/MIA66A0114.md): N.American B-25 · Z · Accident · 3 fatal · Closed · Apr 5, 1966 · N92877 · Destroyed
- [NTSB LAX66A0075](https://openairdocs.org/ntsb/LAX66A0075-201504.md): Cessna 150 · Z · Accident · 1 fatal · Closed · Apr 1, 1966 · N7926Z · Destroyed
- [NTSB CHI66A0075](https://openairdocs.org/ntsb/CHI66A0075.md): Piper PA-30 · Z · Accident · 1 fatal · Closed · Mar 17, 1966 · N7659Y · Destroyed
- [NTSB MIA66A0073](https://openairdocs.org/ntsb/MIA66A0073.md): Piper PA-24 · Accident · 3 fatal · Closed · Dec 29, 1965 · N6077P · Destroyed
- [NTSB OAK66A0030](https://openairdocs.org/ntsb/OAK66A0030.md): Piper J3C-S · Palau · Accident · 2 fatal · Closed · Dec 6, 1965 · N42289 · Destroyed
- [NTSB MIA66A0065](https://openairdocs.org/ntsb/MIA66A0065.md): Ercoupe F01 · Unkown · Accident · 2 fatal · Closed · Dec 6, 1965 · N99660 · Destroyed
- [NTSB OAK66A0011](https://openairdocs.org/ntsb/OAK66A0011.md): Piper PA-18A · Z · Accident · 1 fatal · Closed · Sep 4, 1965 · N8763C · Destroyed
- [NTSB FTW66A0008](https://openairdocs.org/ntsb/FTW66A0008.md): Beech B35 · Unkown · Accident · 1 fatal · Closed · Jul 11, 1965 · N5024C · Destroyed
- [NTSB MIA66A0004](https://openairdocs.org/ntsb/MIA66A0004.md): Piper PA-23 · Z · Accident · 1 fatal · Closed · Jul 6, 1965 · N5382Y · Destroyed
- [NTSB OAK66A0001](https://openairdocs.org/ntsb/OAK66A0001.md): Luscombe 8A · Hawaiin Ilnd Area · Accident · 1 fatal · Closed · Jun 25, 1965 · N1628K · Destroyed
- [NTSB ANC65A0054](https://openairdocs.org/ntsb/ANC65A0054.md): Mooney MK-20C · Z · Accident · 2 fatal · Closed · Jun 5, 1965 · N6285U · Destroyed
- [NTSB SEA65A0063](https://openairdocs.org/ntsb/SEA65A0063.md): Cessna 180C · Z · Accident · 3 fatal · Closed · May 16, 1965 · N9256T · Destroyed
- [NTSB NYC65A0122](https://openairdocs.org/ntsb/NYC65A0122.md): Piper PA-23 · Z · Accident · 1 fatal · Closed · Apr 12, 1965 · N2032P · Destroyed

Next page: https://openairdocs.org/ntsb.md?state=UN&page=5

## 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."eventStateOrRegion" = 'UN' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?page=4&state=UN

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