# NTSB investigations: Franklin 6A4150 series, 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 NYC88LA187](https://openairdocs.org/ntsb/NYC88LA187.md): Stinson 108-1 · Robbinsville, NJ · Accident · No injuries · Limited investigation · Final report · Jun 10, 1988 · N97954 · Substantial damage
  > The acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3…
- [NTSB NYC87LA077](https://openairdocs.org/ntsb/NYC87LA077.md): Stinson 108 · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Feb 5, 1987 · N97202 · Substantial damage
  > The plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said…
- [NTSB NYC81FA039](https://openairdocs.org/ntsb/NYC81FA039.md): Stinson 108-1 · Manahawkin, NJ · Accident · No injuries · Closed · Apr 13, 1981 · N9075K · Destroyed
- [NTSB NYC72FHD30](https://openairdocs.org/ntsb/NYC72FHD30.md): Piper PA-22 · Medford, NJ · Accident · No injuries · Closed · Mar 4, 1972 · N2930Z · 2 aircraft · Substantial damage
- [NTSB NYC68D0375](https://openairdocs.org/ntsb/NYC68D0375.md): Stinson 108-3 · Berlin, NJ · Accident · No injuries · Closed · Dec 23, 1967 · N97062 · Substantial damage
- [NTSB NYC68F0196](https://openairdocs.org/ntsb/NYC68F0196.md): Bellanca 14-13 · So.Plainfield, NJ · Accident · Serious injuries · Closed · Sep 22, 1967 · N6503N · Substantial damage
- [NTSB NYC67D0339](https://openairdocs.org/ntsb/NYC67D0339.md): Stinson 108-1 · Linden, NJ · Accident · No injuries · Closed · Oct 13, 1966 · N40152 · Substantial damage
- [NTSB UNK64X1029](https://openairdocs.org/ntsb/UNK64X1029.md): Stinson 108-1 · Vineland, NJ · Accident · No injuries · Closed · Mar 24, 1964 · N9110K · Destroyed

## 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.engine_model_code IN ('27024'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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