# NTSB investigations: Continental GTSIO-520-C, 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 NYC00FA001](https://openairdocs.org/ntsb/NYC00FA001.md): Cessna 401B · Caldwell, NJ · Accident · Serious injuries · Field investigation · Final report · Oct 2, 1999 · N88VA · Destroyed
  > The pilot's inadequate preflight, which resulted in an attempted takeoff with the pitot covers installed. An additional cause was the pilot's delayed decision to abort the takeoff, while factors included the misleading airspeed indications, and the proximity…
- [NTSB NYC80FA040](https://openairdocs.org/ntsb/NYC80FA040.md): Cessna 411 · Vineland, NJ · Accident · 4 fatal · Closed · May 9, 1980 · N4973T · Destroyed
- [NTSB NYC73INO54](https://openairdocs.org/ntsb/NYC73INO54.md): Cessna 411 · Marlton, NJ · Accident · No injuries · Closed · Oct 24, 1972 · N4910T · Substantial damage
- [NTSB NYC69A0074](https://openairdocs.org/ntsb/NYC69A0074.md): Cessna 402 · Morristown, NJ · Accident · No injuries · Closed · Jan 16, 1969 · N3269Q · 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.engine_model_code IN ('17035'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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