# NTSB investigations: Piper PA-22, FL

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 MIA02LA122](https://openairdocs.org/ntsb/MIA02LA122.md): Piper PA-22-20 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jul 1, 2002 · N1693A · Substantial damage
  > The failure of the solo student/owner to maintain directional control of the airplane during takeoff in a crosswind, which resulted in the airplane veering off the runway, a collision with a runway light, and a ground loop.
- [NTSB MIA83FA145](https://openairdocs.org/ntsb/MIA83FA145.md): Piper PA-22 · Pompano Beach, FL · Accident · 1 fatal · Field investigation · Final report · May 23, 1983 · N8983C · Destroyed
  > The surviving pax stated that about 1 mi from the rwy their alt was 1,000 ft & 'lots of speed.' The plt was cleared to land on rwy 13. The plt then reported 'we go around again...' He was advised by the tower to make left traffic. He was then observed…
- [NTSB MIA81DKT16](https://openairdocs.org/ntsb/MIA81DKT16.md): Piper PA-22 · Palm Beach, FL · Accident · Minor injuries · Closed · Jan 3, 1981 · N2379A · Destroyed
- [NTSB MIA72FLD43](https://openairdocs.org/ntsb/MIA72FLD43.md): Piper PA-22 · Avon Park, FL · Accident · Minor injuries · Closed · Jan 29, 1972 · N882A · Substantial damage
- [NTSB MIA67D0207](https://openairdocs.org/ntsb/MIA67D0207.md): Piper PA-22 · Perky, FL · Accident · No injuries · Closed · Sep 12, 1966 · N8748C · Substantial damage
- [NTSB MIA66F0528](https://openairdocs.org/ntsb/MIA66F0528.md): Piper PA-22 · Riverview, FL · Accident · Serious injuries · Closed · Apr 12, 1966 · N1997P · 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" = 'FL' 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 ('7102202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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