# NTSB investigations, AL

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 29 of 51 · 2,501 cases

## Cases, newest first

- [NTSB MIA78FA101](https://openairdocs.org/ntsb/MIA78FA101.md): Piper PA-28R · Courtland, AL · Accident · 2 fatal · Closed · Jul 1, 1978 · N47975 · Destroyed
- [NTSB MIA78FA100](https://openairdocs.org/ntsb/MIA78FA100.md): Beechcraft 65-80 · Mobile, AL · Accident · 1 fatal · Closed · Jun 27, 1978 · N975SQ · Destroyed
- [NTSB MIA78FA099](https://openairdocs.org/ntsb/MIA78FA099.md): Beech E18S · Birmingham, AL · Accident · No injuries · Closed · Jun 26, 1978 · N5644D · Substantial damage
- [NTSB MIA78FKJ55](https://openairdocs.org/ntsb/MIA78FKJ55.md): Cessna 182 · Elberta, AL · Accident · Minor injuries · Closed · Jun 25, 1978 · N6306B · Substantial damage
- [NTSB MIA78FKJ54](https://openairdocs.org/ntsb/MIA78FKJ54.md): Maule M-4 · Brewton, AL · Accident · No injuries · Closed · Jun 24, 1978 · N4130C · Substantial damage
- [NTSB MIA78FKJ53](https://openairdocs.org/ntsb/MIA78FKJ53.md): Beech 100 · Muscle Shoals, AL · Accident · Serious injuries · Closed · Jun 22, 1978 · N941K · Substantial damage
- [NTSB MIA78DKJ50](https://openairdocs.org/ntsb/MIA78DKJ50.md): Cessna 172 · Huntsville, AL · Accident · Minor injuries · Closed · Jun 12, 1978 · N6136E · Substantial damage
- [NTSB MIA78FKJ49](https://openairdocs.org/ntsb/MIA78FKJ49.md): Cessna 150 · Auburn, AL · Accident · No injuries · Closed · Jun 11, 1978 · N7195F · Substantial damage
- [NTSB MIA78FKJ48](https://openairdocs.org/ntsb/MIA78FKJ48.md): Grumman G-164 · Elmore, AL · Accident · No injuries · Closed · Jun 8, 1978 · N4778T · Substantial damage
- [NTSB MIA78DKJ47](https://openairdocs.org/ntsb/MIA78DKJ47.md): Bell 47G2 · Henagar, AL · Accident · No injuries · Closed · Jun 5, 1978 · N12KH · Substantial damage
- [NTSB MIA78FKJ41](https://openairdocs.org/ntsb/MIA78FKJ41.md): Beech D95A · Montgomery, AL · Accident · No injuries · Closed · May 31, 1978 · N8965M · Substantial damage
- [NTSB MIA78FKJ40](https://openairdocs.org/ntsb/MIA78FKJ40.md): Cessna 172 · Chipley, AL · Accident · No injuries · Closed · May 27, 1978 · N8374U · Substantial damage
- [NTSB MIA78FA091](https://openairdocs.org/ntsb/MIA78FA091.md): Mooney M20C · Jackson, AL · Accident · 3 fatal · Closed · May 26, 1978 · N7813V · Destroyed
- [NTSB MIA78DKJ37](https://openairdocs.org/ntsb/MIA78DKJ37.md): Piper PA-34 · Eufaula, AL · Accident · No injuries · Closed · May 22, 1978 · N577SA · Substantial damage
- [NTSB MIA78DKJ36](https://openairdocs.org/ntsb/MIA78DKJ36.md): Cessna 182 · Tuscaloosa, AL · Accident · No injuries · Closed · May 20, 1978 · N52587 · Substantial damage
- [NTSB MIA78FA079](https://openairdocs.org/ntsb/MIA78FA079.md): Swearingen 226-TC · Muscle Shoals, AL · Incident · No injuries · Closed · May 8, 1978 · N70A · Minor damage
- [NTSB MIA78FA077](https://openairdocs.org/ntsb/MIA78FA077.md): Hamilton T-28A · Huntsville, AL · Accident · 2 fatal · Closed · May 6, 1978 · N3314G · Destroyed
- [NTSB MIA78DKJ34](https://openairdocs.org/ntsb/MIA78DKJ34.md): Cessna 182 · Gadsden, AL · Accident · No injuries · Closed · Apr 29, 1978 · N8787T · Substantial damage
- [NTSB MIA78DKJ35](https://openairdocs.org/ntsb/MIA78DKJ35.md): Piper PA-22 · Lacey Springs, AL · Accident · No injuries · Closed · Apr 16, 1978 · N3553P · Substantial damage
- [NTSB MIA78DKJ31](https://openairdocs.org/ntsb/MIA78DKJ31.md): Cessna 177 · Alabaster, AL · Accident · No injuries · Closed · Apr 9, 1978 · N13484 · Substantial damage
- [NTSB MIA78DKJ30](https://openairdocs.org/ntsb/MIA78DKJ30.md): Bellanca 7KCAB · Wetumpka, AL · Accident · Minor injuries · Closed · Apr 9, 1978 · N1131E · Destroyed
- [NTSB MIA78FKJ29](https://openairdocs.org/ntsb/MIA78FKJ29.md): Enstrom 280C · Smith Lake, AL · Accident · No injuries · Closed · Apr 4, 1978 · N660H · Destroyed
- [NTSB MIA78FKJ28](https://openairdocs.org/ntsb/MIA78FKJ28.md): Beech H18 · Birmingham, AL · Accident · No injuries · Closed · Mar 29, 1978 · N787Q · Substantial damage
- [NTSB MIA78FKJ26](https://openairdocs.org/ntsb/MIA78FKJ26.md): Cessna 305 · Gainesville, AL · Accident · No injuries · Closed · Mar 15, 1978 · N5223G · Substantial damage
- [NTSB MIA78FKJ24](https://openairdocs.org/ntsb/MIA78FKJ24.md): Cessna 421A · Muscle Shoals, AL · Accident · No injuries · Closed · Mar 13, 1978 · N2245Q · Substantial damage
- [NTSB MIA780KJ23](https://openairdocs.org/ntsb/MIA780KJ23.md): Piper PA-18A · Ashland, AL · Accident · No injuries · Closed · Feb 25, 1978 · N9776D · Substantial damage
- [NTSB MIA78FA037](https://openairdocs.org/ntsb/MIA78FA037.md): Cessna 402B · Tuscaloosa, AL · Accident · 1 fatal · Closed · Feb 1, 1978 · N8210Q · Destroyed
- [NTSB MIA78DKJ20](https://openairdocs.org/ntsb/MIA78DKJ20.md): Cessna 150 · Jacksonville, AL · Accident · No injuries · Closed · Jan 31, 1978 · N714LQ · Substantial damage
- [NTSB MIA78DKJ19](https://openairdocs.org/ntsb/MIA78DKJ19.md): Mooney M20E · Gadsden, AL · Accident · No injuries · Closed · Jan 8, 1978 · N7115U · Substantial damage
- [NTSB MIA78FKJ18](https://openairdocs.org/ntsb/MIA78FKJ18.md): Beech D-55 · Mobile, AL · Accident · No injuries · Closed · Jan 6, 1978 · N77DC · Substantial damage
- [NTSB MIA78FA029](https://openairdocs.org/ntsb/MIA78FA029.md): Piper PA-31 · Anniston, AL · Accident · 1 fatal · Closed · Jan 6, 1978 · TIAFY · Destroyed
- [NTSB MIA78DKJ16](https://openairdocs.org/ntsb/MIA78DKJ16.md): Piper PA-32R · Selma, AL · Accident · No injuries · Closed · Dec 27, 1977 · N3570Q · Substantial damage
- [NTSB MIA78DKJ15](https://openairdocs.org/ntsb/MIA78DKJ15.md): Cessna 177B · Tuscaloosa, AL · Accident · No injuries · Closed · Dec 23, 1977 · N18643 · Substantial damage
- [NTSB MIA78AF019](https://openairdocs.org/ntsb/MIA78AF019.md): Cessna 150 · Dauphin Island, AL · Accident · 1 fatal · Closed · Dec 17, 1977 · N6589T · Destroyed
- [NTSB MIA78FKJI4](https://openairdocs.org/ntsb/MIA78FKJI4.md): Cessna 421C · Bay Minette, AL · Accident · No injuries · Closed · Dec 16, 1977 · N8305G · Substantial damage
- [NTSB MIA78FKJ11](https://openairdocs.org/ntsb/MIA78FKJ11.md): Cessna 177 · Scearcy, AL · Accident · Minor injuries · Closed · Dec 4, 1977 · N76HS · Substantial damage
- [NTSB MIA78FKJ08](https://openairdocs.org/ntsb/MIA78FKJ08.md): Beech A23 · Redhill, AL · Accident · No injuries · Closed · Nov 29, 1977 · N8790M · Substantial damage
- [NTSB MIA78DKJ10](https://openairdocs.org/ntsb/MIA78DKJ10.md): Beech J35 · Huntsville, AL · Accident · No injuries · Closed · Nov 16, 1977 · N8318D · Substantial damage
- [NTSB MIA78FA013](https://openairdocs.org/ntsb/MIA78FA013.md): Cessna 441 · Greensboro, AL · Accident · 7 fatal · Closed · Nov 15, 1977 · N9971G · Destroyed
- [NTSB MIA78DKJ07](https://openairdocs.org/ntsb/MIA78DKJ07.md): Cessna 182 · Wetumpka, AL · Accident · No injuries · Closed · Nov 15, 1977 · N1264S · Substantial damage
- [NTSB MIA78FKJ05](https://openairdocs.org/ntsb/MIA78FKJ05.md): Stinson 108-1 · Gurley, AL · Accident · No injuries · Closed · Oct 30, 1977 · N9170K · Destroyed
- [NTSB MIA78DKJ04](https://openairdocs.org/ntsb/MIA78DKJ04.md): Grum Amer AA1-B · Haleyville, AL · Accident · No injuries · Closed · Oct 15, 1977 · N9943L · Substantial damage
- [NTSB MIA78DKJ03](https://openairdocs.org/ntsb/MIA78DKJ03.md): Beech T34 · Headland, AL · Accident · No injuries · Closed · Oct 15, 1977 · N10554 · Substantial damage
- [NTSB MIA78DKJ01](https://openairdocs.org/ntsb/MIA78DKJ01.md): Piper PA28 · Toxey, AL · Accident · No injuries · Closed · Oct 5, 1977 · N3293Q · Substantial damage
- [NTSB MIA78DKJ02](https://openairdocs.org/ntsb/MIA78DKJ02.md): Cessna 172P · Clanton, AL · Accident · No injuries · Closed · Oct 4, 1977 · N4667K · Substantial damage
- [NTSB MIA77FA093](https://openairdocs.org/ntsb/MIA77FA093.md): Beech 100 · Auburn, AL · Accident · 1 fatal · Closed · Sep 27, 1977 · N925BD · Destroyed
- [NTSB MIA77FKJ83](https://openairdocs.org/ntsb/MIA77FKJ83.md): Piper PA-24 · Birmingham, AL · Accident · No injuries · Closed · Sep 17, 1977 · N5779P · Substantial damage
- [NTSB MIA78FKJ81](https://openairdocs.org/ntsb/MIA78FKJ81.md): Cessna 172 · Grove Hill, AL · Accident · No injuries · Closed · Sep 3, 1977 · N64260 · Minor damage
- [NTSB MIA77FKJ80](https://openairdocs.org/ntsb/MIA77FKJ80.md): Cessna 188 · Coosada, AL · Accident · Minor injuries · Closed · Sep 3, 1977 · N3564Q · Destroyed
- [NTSB MIA77FKJ88](https://openairdocs.org/ntsb/MIA77FKJ88.md): Cessna 172 · Weaver, AL · Accident · Serious injuries · Closed · Aug 31, 1977 · N8302B · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=AL&page=30

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

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

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