# NTSB investigations: Cessna 172L, 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 IAD98LA100](https://openairdocs.org/ntsb/IAD98LA100.md): Cessna 172L · Lincoln Park, NJ · Accident · No injuries · Limited investigation · Final report · Jul 13, 1998 · N19667 · Substantial damage
  > Inadequate visual lookout by the pilot, which resulted in his failure to see and avoid the fuel truck. Related factors were the truck and the pilot was unfamiliar with that area.
- [NTSB NYC83FHD04](https://openairdocs.org/ntsb/NYC83FHD04.md): Cessna 172L · Atlantic City, NJ · Accident · No injuries · Final report · Aug 2, 1983 · N9862G · Substantial damage
  > The plt made 2 attempts to takeoff. On the second attempt, the acft lifted off to about 30 ft. the plt stated that the eng lost RPM (from 2450 to 1700 RPM), so he aborted the takeoff. The acft porpoised about 3 times & continued off the end of the rwy & came…
- [NTSB NYC77FHA23](https://openairdocs.org/ntsb/NYC77FHA23.md): Cessna 172 · Basking Ridge, NJ · Accident · Serious injuries · Closed · Jun 3, 1977 · N3831Q · Substantial damage
- [NTSB NYC74FHD38](https://openairdocs.org/ntsb/NYC74FHD38.md): Cessna 172L · Millville, NJ · Accident · No injuries · Closed · May 23, 1974 · N7907G · Substantial damage
- [NTSB NYC74FHA30](https://openairdocs.org/ntsb/NYC74FHA30.md): Cessna 172L · Whitehouse Stn, NJ · Accident · No injuries · Closed · May 16, 1974 · N7220Q · Substantial damage
- [NTSB NYC74FHD32](https://openairdocs.org/ntsb/NYC74FHD32.md): Cessna 172 · Toms River, NJ · Accident · No injuries · Closed · Mar 20, 1974 · N7062Q · Substantial damage
- [NTSB NYC73FHM04](https://openairdocs.org/ntsb/NYC73FHM04.md): Cessna 172L · Oakland, NJ · Accident · No injuries · Closed · Aug 8, 1972 · N4320Q · Substantial damage
- [NTSB NYC71FHM31](https://openairdocs.org/ntsb/NYC71FHM31.md): Cessna 172 · Fairfield, NJ · Accident · Minor injuries · Closed · Jun 20, 1971 · N7811G · 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 ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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