# NTSB investigations: Luscombe 8E, 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 CHI04CA153](https://openairdocs.org/ntsb/CHI04CA153.md): Luscombe 8E · Joliet, IL · Accident · Minor injuries · Data collection · Final report · Jun 12, 2004 · N1970K · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.
- [NTSB CHI75FEV03](https://openairdocs.org/ntsb/CHI75FEV03.md): Luscombe 8E · Gillespie, IL · Accident · Minor injuries · Closed · Sep 4, 1974 · N1829K · Substantial damage
- [NTSB CHI74FEE21](https://openairdocs.org/ntsb/CHI74FEE21.md): Luscombe 8E · Grayslake, IL · Accident · No injuries · Closed · Sep 15, 1973 · N2600K · Substantial damage
- [NTSB CHI72FEV36](https://openairdocs.org/ntsb/CHI72FEV36.md): Stits SA-3A · Pittsfield, IL · Accident · No injuries · Closed · Jun 25, 1972 · N1039Z · 2 aircraft · Substantial damage
- [NTSB CHI72DEE70](https://openairdocs.org/ntsb/CHI72DEE70.md): Luscombe 8E · Rockton, IL · Accident · No injuries · Closed · Apr 8, 1972 · N2351K · Substantial damage
- [NTSB CHI70D0185](https://openairdocs.org/ntsb/CHI70D0185.md): Luscombe 8E · Addison, IL · Accident · No injuries · Closed · Jul 31, 1969 · N1557B · Substantial damage
- [NTSB CHI68F0342](https://openairdocs.org/ntsb/CHI68F0342.md): Luscombe 8E · Pleasant Hill, IL · Accident · Minor injuries · Closed · Sep 26, 1967 · N2993K · Substantial damage
- [NTSB CHI66F0764](https://openairdocs.org/ntsb/CHI66F0764.md): Luscombe 8E · Cahokia, IL · Accident · No injuries · Closed · May 29, 1966 · N1829K · Substantial damage
- [NTSB CHI66D0440](https://openairdocs.org/ntsb/CHI66D0440.md): Luscombe 8E · Collinsville, IL · Accident · No injuries · Closed · Nov 27, 1965 · N1573B · Substantial damage
- [NTSB CHI66F0211](https://openairdocs.org/ntsb/CHI66F0211.md): Luscombe 8E · Plainfield, IL · Accident · Minor injuries · Closed · Aug 15, 1965 · N71911 · 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" = '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 ('8190112'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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