# Final 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 2 of 5 · 203 cases

## Cases, newest first

- [NTSB MIA78DA089](https://openairdocs.org/ntsb/MIA78DA089.md): Piper PA-28 · Missing Aircraft · Accident · 4 fatal · Closed · May 19, 1978 · N47910 · Destroyed
- [NTSB MIA78DA087](https://openairdocs.org/ntsb/MIA78DA087.md): Piper PA-32 · Nassau · Accident · No injuries · Closed · May 12, 1978 · N44196 · Destroyed
- [NTSB MIA78DA083](https://openairdocs.org/ntsb/MIA78DA083.md): Cessna 172 · Missing Aircraft · Accident · 1 fatal · Closed · Apr 30, 1978 · N1GH · Destroyed
- [NTSB MIA78DA074](https://openairdocs.org/ntsb/MIA78DA074.md): Ted Smith 601 · Missing Aircraft · Accident · 1 fatal · Closed · Apr 27, 1978 · N555BU · Destroyed
- [NTSB ANC78DA031](https://openairdocs.org/ntsb/ANC78DA031.md): Cessna 170B · Missing Aircraft · Accident · 3 fatal · Closed · Apr 15, 1978 · N3540C · Destroyed
- [NTSB LAX78DUQ22](https://openairdocs.org/ntsb/LAX78DUQ22.md): Beech E18S · Unknown/Nr · Accident · No injuries · Closed · Apr 4, 1978 · N2067C · Substantial damage
- [NTSB MIA78DA080](https://openairdocs.org/ntsb/MIA78DA080.md): Aero Comdr 680 · Missing Aircraft · Accident · 2 fatal · Closed · Mar 25, 1978 · N128C · Destroyed
- [NTSB NYC78FA025](https://openairdocs.org/ntsb/NYC78FA025.md): Cessna 150 · Missing Aircraft · Accident · 1 fatal · Closed · Jan 16, 1978 · N19031 · Destroyed
- [NTSB ANC78FA003](https://openairdocs.org/ntsb/ANC78FA003.md): Brittnorman BN2A-8 · Missing Aircraft · Accident · 2 fatal · Closed · Nov 21, 1977 · N36MN · Destroyed
- [NTSB CHI77FA072](https://openairdocs.org/ntsb/CHI77FA072.md): Cessna 177RG · Missing Aircraft · Accident · 4 fatal · Closed · Sep 17, 1977 · N7531V · Destroyed
- [NTSB OAK77DA053](https://openairdocs.org/ntsb/OAK77DA053.md): Cessna 210 · Missing Aircraft · Accident · 1 fatal · Closed · Aug 15, 1977 · N6542X · Destroyed
- [NTSB CHI77FA057](https://openairdocs.org/ntsb/CHI77FA057.md): Cessna 150J · Missing Aircraft · Accident · 2 fatal · Closed · Jul 4, 1977 · N50935 · Destroyed
- [NTSB OAK77DA039](https://openairdocs.org/ntsb/OAK77DA039.md): Aero Comdr 112 · Missing Aircraft · Accident · 2 fatal · Closed · Jun 19, 1977 · N1168J · Destroyed
- [NTSB DEN77DA031](https://openairdocs.org/ntsb/DEN77DA031.md): Cessna 210L · Missing Aircraft · Accident · 2 fatal · Closed · Mar 16, 1977 · N1630X · Destroyed
- [NTSB MIA77DA022](https://openairdocs.org/ntsb/MIA77DA022.md): Piper PA-23 · Missing Aircraft · Accident · 6 fatal · Closed · Dec 28, 1976 · N4573P · Destroyed
- [NTSB MIA77DA004](https://openairdocs.org/ntsb/MIA77DA004.md): Beech E-50 · Missing Aircraft · Accident · 1 fatal · Closed · Oct 24, 1976 · N5665D · Destroyed
- [NTSB FTW76O0008](https://openairdocs.org/ntsb/FTW76O0008.md): Piper PA-28 · Missing Acft · Accident · 1 fatal · Closed · Aug 8, 1976 · N6377J · Destroyed
- [NTSB NYC76AN121](https://openairdocs.org/ntsb/NYC76AN121.md): Cessna 177 · Missing Aircraft · Accident · 1 fatal · Closed · Jul 8, 1976 · N34204 · Destroyed
- [NTSB MIA76AM093](https://openairdocs.org/ntsb/MIA76AM093.md): Beech D50 · Missing Aircraft · Accident · 2 fatal · Closed · Jun 4, 1976 · N1157 · Destroyed
- [NTSB MIA76AM091](https://openairdocs.org/ntsb/MIA76AM091.md): Cessna 150 · Missing Aircraft · Accident · 1 fatal · Closed · Jun 2, 1976 · N5953J · Destroyed
- [NTSB ANC76AA089](https://openairdocs.org/ntsb/ANC76AA089.md): Cessna 206 · Missing Aircraft · Accident · 1 fatal · Closed · May 11, 1976 · N59186 · Substantial damage
- [NTSB NYC76AN065](https://openairdocs.org/ntsb/NYC76AN065.md): Piper PA-28R · Missing Aircraft · Accident · 1 fatal · Closed · Jan 13, 1976 · N15496 · Destroyed
- [NTSB MIA76AM052](https://openairdocs.org/ntsb/MIA76AM052.md): Cessna 172 · Missing Aircraft · Accident · 1 fatal · Closed · Dec 9, 1975 · N5182R · Destroyed
- [NTSB SEA76AS030](https://openairdocs.org/ntsb/SEA76AS030.md): Piper PA-28 · Missing Aircraft · Accident · 1 fatal · Closed · Nov 28, 1975 · N3435K · Destroyed
- [NTSB LAX76AL034](https://openairdocs.org/ntsb/LAX76AL034.md): Aeronca 7AC · Missing Aircraft · Accident · 1 fatal · Closed · Nov 4, 1975 · N3342E · Destroyed
- [NTSB SEA76AS024](https://openairdocs.org/ntsb/SEA76AS024.md): Cessna 150F · Missing Aircraft · Accident · 1 fatal · Closed · Nov 2, 1975 · N8462G · Destroyed
- [NTSB FTW76AF044](https://openairdocs.org/ntsb/FTW76AF044.md): Beech E18S · Missing Aircraft · Accident · 2 fatal · Closed · Oct 28, 1975 · N5657D · Destroyed
- [NTSB FTW76AF030](https://openairdocs.org/ntsb/FTW76AF030.md): Cessna 210E · Missing Aircraft · Accident · 1 fatal · Closed · Sep 27, 1975 · N2334F · Destroyed
- [NTSB ANC76AA043](https://openairdocs.org/ntsb/ANC76AA043.md): Beech D18C-T · Missing Aircraft · Accident · 1 fatal · Closed · Sep 22, 1975 · N3674G · Destroyed
- [NTSB MIA76AM011](https://openairdocs.org/ntsb/MIA76AM011.md): Cessna 172 · Missing Aircraft · Accident · 1 fatal · Closed · Jul 28, 1975 · N8936V · Destroyed
- [NTSB CHI76AC027](https://openairdocs.org/ntsb/CHI76AC027.md): Piper PA-28 · Missing Aircraft · Accident · 1 fatal · Closed · Jul 27, 1975 · N8041N · Destroyed
- [NTSB DEN75AD058](https://openairdocs.org/ntsb/DEN75AD058.md): Cessna 172M · Missing Aircraft · Accident · 3 fatal · Closed · Jun 4, 1975 · N92354 · Destroyed
- [NTSB SEA75AS040](https://openairdocs.org/ntsb/SEA75AS040.md): Piper J-3 · Missing Aircraft · Accident · 1 fatal · Closed · May 2, 1975 · N98722 · Destroyed
- [NTSB MIA75AM081](https://openairdocs.org/ntsb/MIA75AM081.md): Cessna 337D · Missing Aircraft · Accident · 1 fatal · Closed · May 2, 1975 · N86011 · Destroyed
- [NTSB NYC75AN101](https://openairdocs.org/ntsb/NYC75AN101.md): Piper PA-32 · Missing Aircraft · Accident · 7 fatal · Closed · Apr 27, 1975 · N294HA · Destroyed
- [NTSB MIA7KAM065](https://openairdocs.org/ntsb/MIA7KAM065.md): Piper PA-30 · Missing Aircraft · Accident · 1 fatal · Closed · Feb 25, 1975 · N414DG · Destroyed
- [NTSB ANC75AA050](https://openairdocs.org/ntsb/ANC75AA050.md): Dehavilland DHC-2 · Missing Aircraft · Accident · 5 fatal · Closed · Jan 13, 1975 · N1944 · Destroyed
- [NTSB DEN75ID032](https://openairdocs.org/ntsb/DEN75ID032.md): Douglas DC-8 · Las Vegas · Incident · No injuries · Closed · Dec 15, 1974 · N8015U · No damage
- [NTSB ANC75AA045](https://openairdocs.org/ntsb/ANC75AA045.md): Grumman G-21 · Missing Aircraft · Accident · 5 fatal · Closed · Dec 11, 1974 · N1583V · Destroyed
- [NTSB ANC75FAA22](https://openairdocs.org/ntsb/ANC75FAA22.md): Piper PA-22 · Missing Aircraft · Accident · 2 fatal · Closed · Nov 30, 1974 · N9686D · Destroyed
- [NTSB OAK75DJA03](https://openairdocs.org/ntsb/OAK75DJA03.md): Beech A36 · Missing Aircraft · Accident · 1 fatal · Closed · Oct 12, 1974 · N8132R · Destroyed
- [NTSB ANC74AA034](https://openairdocs.org/ntsb/ANC74AA034-143071.md): Grumman G-73 · Missing Aircraft · Accident · 4 fatal · Closed · Sep 30, 1974 · N2965 · Destroyed
- [NTSB MIA75AM018](https://openairdocs.org/ntsb/MIA75AM018.md): Cessna 172M · Missing Aircraft · Accident · 3 fatal · Closed · Aug 30, 1974 · N5142R · Destroyed
- [NTSB MIA75AM015](https://openairdocs.org/ntsb/MIA75AM015.md): Beech K35 · Missing Aircraft · Accident · 2 fatal · Closed · Aug 11, 1974 · N632Q · Destroyed
- [NTSB MIA75AM007](https://openairdocs.org/ntsb/MIA75AM007.md): Piper PA-32 · Missing Aircraft · Accident · 6 fatal · Closed · Jul 13, 1974 · N83CA · Destroyed
- [NTSB OAK74AP069](https://openairdocs.org/ntsb/OAK74AP069.md): Amer Avco AA5 · Missing Aircraft · Accident · 2 fatal · Closed · Jun 21, 1974 · N5885L · Destroyed
- [NTSB NYC75AN002](https://openairdocs.org/ntsb/NYC75AN002.md): Gatch LH1 · Missing Aircraft · Accident · 1 fatal · Closed · Feb 21, 1974 · N7TG · Destroyed
- [NTSB OAK74DJA15](https://openairdocs.org/ntsb/OAK74DJA15.md): Cessna 182 · Missing Aircraft · Accident · 1 fatal · Closed · Feb 19, 1974 · N52356 · Destroyed
- [NTSB NYC74AN069](https://openairdocs.org/ntsb/NYC74AN069.md): Mooney M20 · Missing Aircraft · Accident · 4 fatal · Closed · Feb 15, 1974 · N1368 · Destroyed
- [NTSB MIA74AM068](https://openairdocs.org/ntsb/MIA74AM068.md): Cessna 414 · Missing Aircraft · Accident · 1 fatal · Closed · Feb 10, 1974 · N8103Q · Destroyed

Next page: https://openairdocs.org/ntsb.md?status=final&state=UN&page=3

## 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'
  AND c."completionStatus" = 'Completed'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
