# NTSB investigations, AL: Miscellaneous/other

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 MIA00LA232](https://openairdocs.org/ntsb/MIA00LA232.md): Cessna P337H · Alabaster, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2000 · N5HN · Substantial damage
  > a loss of engine power for undetermined reasons resulting in a forced landing and subsequent impact with the ground. A factor in this accident was that the pilot did not obtain the proper touchdown point upon landing and landed long.
- [NTSB MIA98LA031](https://openairdocs.org/ntsb/MIA98LA031.md): de Havilland DHC-6-6 · Elberta, AL · Accident · 1 fatal · Limited investigation · Final report · Nov 8, 1997 · N1022S · Minor damage
  > a passenger's inadvertent encounter with a rotating propeller.
- [NTSB ATL95LA080](https://openairdocs.org/ntsb/ATL95LA080.md): Let Blanik L-13 · Brownsboro, AL · Accident · No injuries · Limited investigation · Final report · Apr 8, 1995 · N48039 · Substantial damage
  > The student pilot's inadvertent use of spoilers during takeoff. Factors related to the accident were: the glider instructor's failure to identify the extended spoilers, and the proximity of trees in the emergency landing area.
- [NTSB ATL90LA083](https://openairdocs.org/ntsb/ATL90LA083.md): Cessna 172G · Gulf Shores, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1990 · N4373L · Substantial damage
  > Failure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.
- [NTSB ATL88LA166](https://openairdocs.org/ntsb/ATL88LA166.md): Piper J5C · Gulf Shores, AL · Accident · 1 fatal · Limited investigation · Final report · May 6, 1988 · N41333 · Substantial damage
  > A witness reported that the airplane encountered a 'downdraft' while attempting to pick up a banner. The main ldg gear caught the banner pick-up line and carried the banner aloft. The witness radioed the plt to advise him of the situation, but received no…
- [NTSB ATL86LA045](https://openairdocs.org/ntsb/ATL86LA045.md): Cessna C-172M · Andalusia, AL · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N509R · Substantial damage
  > The acft battery power was depleted. The plt hand propped the engine with his wife at the controls. The engine started with the throttle advanced and acft taxied into trees and over an embankment. The wife was not a rated pilot.
- [NTSB ATL84LA176](https://openairdocs.org/ntsb/ATL84LA176.md): Cessna 172N · Leeds, AL · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N734ZP · Substantial damage
  > The plt made a flt of about 30 min to practice landings, then landed to pick up 2 passengers. About 10 min after taking off on the 2nd flt, he began having symptoms of a medical problem. He said he felt hot & the air felt stagnant & stale. The vents & a…
- [NTSB MIA08CA076](https://openairdocs.org/ntsb/MIA08CA076.md): Beech C24R · Mobile, AL · Accident · 1 fatal · Data collection · Final report · Mar 16, 1982 · N18878 · Substantial damage
  > Undetermined.

## 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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=430&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.
