# NTSB investigations: Cessna 150E, GA

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 ERA19LA037](https://openairdocs.org/ntsb/ERA19LA037.md): Cessna 150 · Woodstock, GA · Accident · 1 fatal · Limited investigation · Final report · Nov 4, 2018 · N3515J · Substantial damage
  > The pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.
- [NTSB MIA79FKG36](https://openairdocs.org/ntsb/MIA79FKG36.md): Cessna 150 · Springfield, GA · Accident · No injuries · Closed · May 6, 1979 · N6298T · Substantial damage
- [NTSB MIA77FKG24](https://openairdocs.org/ntsb/MIA77FKG24.md): Cessna 150 · Monroe, GA · Accident · No injuries · Closed · Apr 11, 1977 · N3524J · Substantial damage
- [NTSB MIA73FKG09](https://openairdocs.org/ntsb/MIA73FKG09.md): Cessna 150E · Atlanta, GA · Accident · Serious injuries · Closed · Jul 23, 1972 · N2568J · Substantial damage
- [NTSB MIA70FKG08](https://openairdocs.org/ntsb/MIA70FKG08.md): Cessna 150E · Atlanta, GA · Accident · No injuries · Closed · Feb 2, 1970 · N3972U · Destroyed
- [NTSB MIA70F0202](https://openairdocs.org/ntsb/MIA70F0202.md): Cessna 150 · Atlanta, GA · Accident · Minor injuries · Closed · Jun 24, 1969 · N6293T · Substantial damage
- [NTSB MIA69D0394](https://openairdocs.org/ntsb/MIA69D0394.md): Cessna 150 · Morrow, GA · Accident · No injuries · Closed · Mar 1, 1969 · N3908U · Substantial damage
- [NTSB MIA69D0121](https://openairdocs.org/ntsb/MIA69D0121.md): Cessna 150 · Midway, GA · Accident · No injuries · Closed · Jul 27, 1968 · N6137T · Substantial damage
- [NTSB MIA68D0492](https://openairdocs.org/ntsb/MIA68D0492.md): Cessna 150 · Jonesboro, GA · Accident · No injuries · Closed · May 4, 1968 · N3521J · Substantial damage
- [NTSB MIA67D0575](https://openairdocs.org/ntsb/MIA67D0575.md): Cessna 150 · Fairburn, GA · Accident · No injuries · Closed · May 23, 1967 · N3585J · Substantial damage
- [NTSB MIA67F0556](https://openairdocs.org/ntsb/MIA67F0556.md): Cessna 150E · Dawson, GA · Accident · No injuries · Closed · Apr 26, 1967 · N4010U · Substantial damage
- [NTSB MIA66D0078](https://openairdocs.org/ntsb/MIA66D0078.md): Cessna 150 · Atlanta, GA · Accident · No injuries · Closed · Jun 15, 1966 · N3972U · Substantial damage
- [NTSB MIA66A0131](https://openairdocs.org/ntsb/MIA66A0131.md): Cessna 150 · Lagrange, GA · Accident · 1 fatal · Closed · May 13, 1966 · N3513J · Destroyed
- [NTSB MIA66F0407](https://openairdocs.org/ntsb/MIA66F0407.md): Cessna 150E · Fairburn, GA · Accident · Minor injuries · Closed · Jan 1, 1966 · N3054J · Destroyed
- [NTSB MIA66F0220](https://openairdocs.org/ntsb/MIA66F0220-176076.md): Cessna 150 · Griffin, GA · Accident · No injuries · Closed · Sep 10, 1965 · N3080J · Substantial damage
- [NTSB MIA66F0061](https://openairdocs.org/ntsb/MIA66F0061.md): Cessna 150 · Atlanta, GA · Accident · No injuries · Closed · Jul 3, 1965 · N6137T · 2 aircraft · Minor damage
- [NTSB MIA65F0012](https://openairdocs.org/ntsb/MIA65F0012.md): Cessna 150E · Griffin, GA · Accident · No injuries · Closed · Apr 4, 1965 · N3080J · 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" = 'GA' 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=GA

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