# NTSB investigations: Beech C23, NJ

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 ERA09FA100](https://openairdocs.org/ntsb/ERA09FA100.md): Beech C23 · Linden, NJ · Accident · Serious injuries · Field investigation · Final report · Dec 21, 2008 · N2109W · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB NYC91FA199](https://openairdocs.org/ntsb/NYC91FA199.md): Beech C23 · Pleasantville, NJ · Accident · 3 fatal · Field investigation · Final report · Aug 4, 1991 · N9375S · Destroyed
  > A power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…
- [NTSB NYC90LA149](https://openairdocs.org/ntsb/NYC90LA149.md): Beech C23 · Allaire, NJ · Accident · No injuries · Limited investigation · Final report · Jul 5, 1990 · N24630 · Substantial damage
  > The pilot's improper flare for the landing.
- [NTSB NYC84FHM04](https://openairdocs.org/ntsb/NYC84FHM04.md): Beech C23 · Farmingdale, NJ · Accident · Serious injuries · Final report · Dec 30, 1983 · N37123 · Destroyed
  > The plt reported that 'at 450 MSL fuel pressure went to zero. The plt verified the boost pump was on, then the eng quit. He lowered the nose, switched fuel tanks. He could not make runway and saw clearing to the left of the runway. Witnesses reported hearing…
- [NTSB NYC82DA224](https://openairdocs.org/ntsb/NYC82DA224.md): Beech C23 · Hammonton, NJ · Accident · Minor injuries · Final report · Sep 9, 1982 · N23965 · Substantial damage
  > The aircraft lost power at 300 feet after takeoff. The pilot stated he changed the fuel selector and tried a restart. The aircraft began to stall, but the pilot lowered the nose, then rotated to settle into trees. The aircraft flipped inverted. No malfunction…
- [NTSB NYC76FHA48](https://openairdocs.org/ntsb/NYC76FHA48.md): Beech C23 · Pluckimen, NJ · Accident · No injuries · Closed · Aug 13, 1976 · N2172W · Substantial damage
- [NTSB NYC76FHD02](https://openairdocs.org/ntsb/NYC76FHD02.md): Beech C23 · Smithville, NJ · Accident · No injuries · Closed · Jul 23, 1975 · N2172W · 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" = 'NJ' 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 ('1151242'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151242&state=NJ

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