# NTSB investigations: Cessna 172C, 1983

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 LAX84LA001](https://openairdocs.org/ntsb/LAX84LA001.md): Cessna 172 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N8426X · Substantial damage
  > The acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…
- [NTSB ATL83LA356](https://openairdocs.org/ntsb/ATL83LA356.md): Cessna 172C · Portsmouth Isl., NC · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N8338X · Substantial damage
  > Before hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the…
- [NTSB LAX83LA108](https://openairdocs.org/ntsb/LAX83LA108.md): Cessna 172C · Rubidoux, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1983 · N8347X · Destroyed
  > The acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…
- [NTSB SEA83LA047](https://openairdocs.org/ntsb/SEA83LA047.md): Cessna 172 · Payette, ID · Accident · No injuries · Limited investigation · Final report · Jan 30, 1983 · N1415Y · Substantial damage
  > The acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.

## 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 year(c."eventDate") = 1983
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072408&year=1983

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