# NTSB investigations: Cessna 150E, 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.

## Latest cases

- [NTSB ATL86LA140](https://openairdocs.org/ntsb/ATL86LA140.md): Cessna 150E · Gulfshore, AL · Accident · No injuries · Limited investigation · Final report · May 23, 1986 · N6108T · Substantial damage
  > The pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel…
- [NTSB ATL85LA136](https://openairdocs.org/ntsb/ATL85LA136.md): Cessna 150E · Seale, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1985 · N3080J · Substantial damage
  > While performing a soft fld takeoff the plt reportedly applied full pwr with the control yoke pulled full aft. The acft became airborne at aprx 35 KTS with the stall warning horn sounding. The acft drifted left of the centerline and the plt over corrected…
- [NTSB MIA74DKJ09](https://openairdocs.org/ntsb/MIA74DKJ09-201619.md): Cessna 150C · Arley, AL · Accident · No injuries · Closed · Aug 3, 1973 · N6246T · Substantial damage
- [NTSB MIA71FKJ42](https://openairdocs.org/ntsb/MIA71FKJ42.md): Cessna 150 · Hatchechubbee, AL · Accident · Serious injuries · Closed · Mar 18, 1971 · N3946U · Substantial damage
- [NTSB MIA70DKJ07](https://openairdocs.org/ntsb/MIA70DKJ07.md): Cessna 150 · Bay Minette, AL · Accident · No injuries · Closed · Jan 23, 1970 · N4049U · Substantial damage
- [NTSB MIA67D0387](https://openairdocs.org/ntsb/MIA67D0387.md): Cessna 150 · Phil Campbell, AL · Accident · Minor injuries · Closed · Jul 23, 1966 · N6211T · Substantial damage
- [NTSB MIA66D0421](https://openairdocs.org/ntsb/MIA66D0421.md): Cessna 150 · Anniston, AL · Accident · No injuries · Closed · Feb 19, 1966 · N3987U · Substantial damage
- [NTSB MIA66F0369](https://openairdocs.org/ntsb/MIA66F0369.md): Cessna 150E · Theodore, AL · Accident · No injuries · Closed · Oct 24, 1965 · N3082J · Substantial damage
- [NTSB MIA66D0198](https://openairdocs.org/ntsb/MIA66D0198.md): Cessna 150 · Birmingham, AL · Accident · No injuries · Closed · Sep 13, 1965 · N3987U · Substantial damage
- [NTSB UNK65X0698](https://openairdocs.org/ntsb/UNK65X0698.md): Cessna 150E · Tuscaloosa, AL · Accident · No injuries · Closed · Nov 14, 1964 · N6197T · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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