# NTSB investigations: Beech 23, 1987

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 BFO88LA004](https://openairdocs.org/ntsb/BFO88LA004.md): Beech 23 · Front Royal, VA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1987 · N2387Q · Substantial damage
  > While flying at abt 2000 ft AGL, the plt noticed a change in eng sound. The tach indcn dropped below 1000 RPM & the suction gauge went below the green arc. During a subsequent emerg lndg, the nose & left main gear collapsed in soft terrain. No preimpact part…
- [NTSB SEA87LA195](https://openairdocs.org/ntsb/SEA87LA195.md): Beech 23 · Basin City, WA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N2330Q · Substantial damage
  > The pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…
- [NTSB MIA87FA250](https://openairdocs.org/ntsb/MIA87FA250.md): Commonwealth 185 · St. Petersburg, FL · Accident · 3 fatal · Field investigation · Final report · Sep 19, 1987 · N92919 · 2 aircraft · Destroyed
  > The pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…
- [NTSB MIA87FA189](https://openairdocs.org/ntsb/MIA87FA189.md): Beech 23 · Miramar, FL · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1987 · N2387J · Destroyed
  > After the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…
- [NTSB ATL87LA078](https://openairdocs.org/ntsb/ATL87LA078.md): Beech 23 · Augusta, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1987 · N2355Z · Substantial damage
  > The acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…

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

This list as a web page: https://openairdocs.org/ntsb?model=1151202&year=1987

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