# NTSB investigations: Piper PA-28RT-201: In flight collision with object

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 NYC07CA137](https://openairdocs.org/ntsb/NYC07CA137.md): Piper PA-28RT-201 · Tinicum, PA · Accident · Minor injuries · Data collection · Final report · Jun 13, 2007 · N3023U · Substantial damage
  > The instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.
- [NTSB ATL88FA068](https://openairdocs.org/ntsb/ATL88FA068.md): Piper PA-28RT-201 · Rutherfordton, NC · Accident · 4 fatal · Field investigation · Final report · Dec 25, 1987 · N2869C · Destroyed
  > The pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…
- [NTSB CHI85FA354](https://openairdocs.org/ntsb/CHI85FA354.md): Piper PA-28RT-201 · Wilmington, OH · Accident · 1 fatal · Field investigation · Final report · Aug 20, 1985 · N3074K · Destroyed
  > The pilot was flying on a south casterly heading of approximately 150' at a low altitude when he struck a set of static lines at approximately 170' AGL. The aircraft flipped over and hit the terrain at approximately 60, nose down in a stand of corn. The pilot…
- [NTSB NYC83LA094](https://openairdocs.org/ntsb/NYC83LA094.md): Piper PA-28RT-201 · West Chester, PA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1983 · N2943F · Substantial damage
  > The plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…
- [NTSB CHI82FA228](https://openairdocs.org/ntsb/CHI82FA228.md): Piper PA-28RT-201 · Washington, IL · Accident · Serious injuries · Field investigation · Final report · Jun 30, 1982 · N2124U · Destroyed
  > During takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102818')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102818&occurrence=220

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