# NTSB investigations: Piper PA-34-220T, MI

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 CHI03LA279](https://openairdocs.org/ntsb/CHI03LA279.md): Piper PA-34-220T · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · Jul 16, 2003 · N5359J · Substantial damage
  > The pilot misjudging the flare during landing, and his inadequate remedial action resulting in the inadvertent porpoise of the airplane.
- [NTSB CHI02IA110](https://openairdocs.org/ntsb/CHI02IA110.md): Piper PA-34-220T · Sturgis, MI · Incident · No injuries · Incident investigation · Final report · Apr 20, 2002 · N92721 · Minor damage
  > The flightcrew not following the landing checklist, the flightcrew not lowering the landing gear, and the flight examiner's inadequate supervision of the flight.
- [NTSB CHI01LA078](https://openairdocs.org/ntsb/CHI01LA078.md): Piper PA-34-220T · Charlevoix, MI · Accident · No injuries · Limited investigation · Final report · Feb 2, 2001 · N4123K · Substantial damage
  > The pilot failed to maintain directional control of the airplane due to inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, the icy runway, and the snow bank.
- [NTSB CHI98LA364](https://openairdocs.org/ntsb/CHI98LA364.md): Piper PA-34-220T · Marshall, MI · Accident · No injuries · Limited investigation · Final report · Sep 28, 1998 · N9267W · Substantial damage
  > the pilot-in-command (CFI)'s inadequate supervision of the student, his not obtaining control of the airplane, and his lack of total experience in the type of operation. A factor was the dual student's not maintaining control of the airplane.
- [NTSB CHI87LA025](https://openairdocs.org/ntsb/CHI87LA025.md): Piper PA-34-220T · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N8161K · Substantial damage
  > Upon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…

## 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" = 'MI' 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 ('7103420', '7103223'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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