# NTSB investigations: Champion 7KCAB, 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 NYC84LA222](https://openairdocs.org/ntsb/NYC84LA222.md): Champion 7KCAB · Egg Harbor Town, NJ · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N8888N · Destroyed
  > According to the pilot at 350 to 400 ft AGL and aprx 85 KTS the acft abruptly pitched nose down. Recovery was attempted but, the pilot related, the flt controls were jammed. Impact occurred in 30 ft deep water about 45 degrees nose down. During recovery the…
- [NTSB NYC78FHD18](https://openairdocs.org/ntsb/NYC78FHD18.md): Champion 7KCAB · Point Pleasant, NJ · Accident · No injuries · Closed · Jun 28, 1978 · N6315N · 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 ('21101P3'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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