# NTSB investigations: Cessna 150E, MD

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 BFO88FA025](https://openairdocs.org/ntsb/BFO88FA025.md): Cessna 150E · Mitchellville, MD · Accident · No injuries · Field investigation · Final report · Mar 2, 1988 · N6202T · Substantial damage
  > The student plt elected to initiate the flt even though the flaps malfunctioned during the previous flt. Shortly after takeoff the plt was unable to keep the flaps in the extended position. The plt had not been feeling well on the morning of the flt and felt…
- [NTSB BFO85FA077](https://openairdocs.org/ntsb/BFO85FA077.md): Cessna 150E · Clinton, MD · Accident · Serious injuries · Field investigation · Final report · Sep 18, 1985 · N3518J · Destroyed
  > Plt stated that on initial climb from a normal takeoff, a partial engine pwr loss was experienced. Control of the airplane was lost while maneuvering for a suitable forced landing area. A flight instructor that witnessed the takeoff stated that it appeared to…
- [NTSB IAD75FIA09](https://openairdocs.org/ntsb/IAD75FIA09.md): Cessna 150E · Clinton, MD · Accident · No injuries · Closed · Nov 29, 1974 · N3518J · Substantial damage
- [NTSB DIA69D0114](https://openairdocs.org/ntsb/DIA69D0114.md): Cessna 150 · Brookeville, MD · Accident · No injuries · Closed · Nov 28, 1968 · N3029J · Substantial damage
- [NTSB NYC67D0362](https://openairdocs.org/ntsb/NYC67D0362.md): Cessna 150 · Lower Marlboro, MD · Accident · No injuries · Closed · Nov 13, 1966 · N2553J · Substantial damage
- [NTSB NYC66D0058](https://openairdocs.org/ntsb/NYC66D0058.md): Cessna 150 · Friendly, MD · Accident · No injuries · Closed · Jun 29, 1965 · N6193T · 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" = 'MD' 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=MD

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