# NTSB investigations: Piper PA-32RT-300, IL

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 CHI95LA192](https://openairdocs.org/ntsb/CHI95LA192.md): Piper PA-32RT-300 · Peru, IL · Accident · No injuries · Limited investigation · Final report · Jun 17, 1995 · N21873 · Substantial damage
  > the pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.
- [NTSB CHI95LA097](https://openairdocs.org/ntsb/CHI95LA097.md): Piper PA-32RT · Joliet, IL · Accident · No injuries · Limited investigation · Final report · Mar 1, 1995 · N1978J · Substantial damage
  > the failure of the number four cylinder due to a loose cylinder hold down stud. A factor in the accident was the embankment.
- [NTSB CHI90FA087](https://openairdocs.org/ntsb/CHI90FA087.md): Piper PA-32RT-300 · Lostant, IL · Accident · 3 fatal · Field investigation · Final report · Feb 23, 1990 · N3063B · Destroyed
  > Flight into known adverse weather conditions by the pilot and structural (wing) icing. Factors related to the accident were: the adverse weather conditions and the pilot's overconfidence in the aircraft's ability.
- [NTSB CHI84FA315](https://openairdocs.org/ntsb/CHI84FA315.md): Piper PA-32RT-300 · Sandwich, IL · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1984 · N36219 · Destroyed
  > Pilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.
- [NTSB CHI78DEE63](https://openairdocs.org/ntsb/CHI78DEE63.md): Piper PA-32R · Princeton, IL · Accident · No injuries · Closed · Aug 22, 1978 · N101DR · 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" = 'IL' 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 ('7103215'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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