# NTSB investigations: Aerotek PITTS S-2A, 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 CHI95LA318](https://openairdocs.org/ntsb/CHI95LA318.md): Maule M-5 · Belvidere, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1995 · N5669P · 2 aircraft · Substantial damage
  > inadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.
- [NTSB CHI86LA237](https://openairdocs.org/ntsb/CHI86LA237.md): Pitts S2A · Peru, IL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N70JJ · Substantial damage
  > Pilot elected to land on runway 18 because the windsock was indicating wind to be fromthe south. Upon touchdown in the first third of the runway the aircraft skipped slightly. Pilot chose to try to stop rather than attempt a go-around and applied heavy…
- [NTSB CHI83FA387](https://openairdocs.org/ntsb/CHI83FA387.md): Aerotek Pitts S-2A · Waukegan, IL · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1983 · N80016 · Destroyed
  > While on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…
- [NTSB CHI79DEE55](https://openairdocs.org/ntsb/CHI79DEE55.md): Pitts S-2A · Rockford, IL · Accident · Minor injuries · Closed · May 12, 1979 · N7UD · Destroyed

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

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