# NTSB investigations: Piper PA-31-350, 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 CEN15LA147](https://openairdocs.org/ntsb/CEN15LA147.md): Piper PA 31-350 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Feb 16, 2015 · N727SC · Substantial damage
  > The collapse of the nose and right main landing gears during landing for reasons that could not be determined because examination of the landing gear system revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN12FA086](https://openairdocs.org/ntsb/CEN12FA086.md): Piper PA-31-350 · Riverwoods, IL · Accident · 3 fatal · Field investigation · Final report · Nov 29, 2011 · N59773 · Substantial damage
  > The pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.
- [NTSB CHI90LA141](https://openairdocs.org/ntsb/CHI90LA141.md): Piper PA-31-350 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · May 30, 1990 · N62869 · Substantial damage
  > The pilot's failure to insure that the landing gear was extended and locked prior to touchdown.
- [NTSB CHI83LA424](https://openairdocs.org/ntsb/CHI83LA424.md): Piper PA-31-350 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N62971 · Substantial damage
  > The acft went off the rwy and collapsed the landing gear after power loss during takeoff. Three of the passengers furnished statements and 2 seemed to think that the left engine quit. The acft turned to the right but the pilot did notknow which engine quit.…

## 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 ('7103110', '7103125'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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