# NTSB investigations: Piper PA-28R-201, IN

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 CHI96LA155](https://openairdocs.org/ntsb/CHI96LA155.md): Piper PA-28R-201 · Lafayette, IN · Accident · No injuries · Limited investigation · Final report · May 9, 1996 · N9816C · Substantial damage
  > the flight instructor's inadequate supervision and the dual student's failure to extend the landing gear. Factors were the distraction of the flight instructor and the student's failure to use checklist procedures.
- [NTSB CHI89LA190](https://openairdocs.org/ntsb/CHI89LA190.md): Piper PA-28R-201 · Delphi, IN · Accident · No injuries · Limited investigation · Final report · Sep 17, 1989 · N9816C · Substantial damage
  > The pilot-in-command's failure to properly compensate for the high sink rate that developed on final approach to land. Factors related to the accident were: the downdraft and the student pilot's failure to maintain a proper rate of descent on final approach.
- [NTSB CHI88LA139](https://openairdocs.org/ntsb/CHI88LA139.md): Piper PA-28R-201 · Noblesville, IN · Accident · No injuries · Limited investigation · Final report · Jun 22, 1988 · N36472 · Substantial damage
  > During initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102816&state=IN

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