# NTSB investigations: Cessna 140A, 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 GAA16CA212](https://openairdocs.org/ntsb/GAA16CA212.md): Cessna 140 · Poplar Grove, IL · Accident · No injuries · Data collection · Final report · Apr 30, 2016 · N4242H · Substantial damage
  > The pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.
- [NTSB CEN10CA095](https://openairdocs.org/ntsb/CEN10CA095.md): Cessna 140A · Urbana, IL · Accident · No injuries · Data collection · Final report · Jan 13, 2010 · N5353C · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during the crosswind landing.
- [NTSB CHI94LA246](https://openairdocs.org/ntsb/CHI94LA246.md): Cessna 140 · Lomax, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1994 · N9409A · Substantial damage
  > the pilot's failure to maintain clearance from a transmission wire, and the pilot's failure to maintain an appropriate altitude. A factor associated with the accident is the transmission wire.
- [NTSB CHI90LA007](https://openairdocs.org/ntsb/CHI90LA007.md): Cessna 140A · Peoria, IL · Accident · No injuries · Limited investigation · Final report · Oct 10, 1989 · N9658A · Substantial damage
  > Inadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.
- [NTSB CHI76DEE78](https://openairdocs.org/ntsb/CHI76DEE78.md): Cessna 140A · Kankakee, IL · Accident · No injuries · Closed · Sep 12, 1976 · N9445A · Substantial damage
- [NTSB CHI70DBQ13](https://openairdocs.org/ntsb/CHI70DBQ13.md): Cessna 140 · El Paso, IL · Accident · No injuries · Closed · May 3, 1970 · N5650C · Substantial damage
- [NTSB CHI69F0390](https://openairdocs.org/ntsb/CHI69F0390.md): Cessna 140A · Lincoln, IL · Accident · No injuries · Closed · Nov 24, 1968 · N9454A · Substantial damage
- [NTSB UNK64X0944](https://openairdocs.org/ntsb/UNK64X0944.md): Cessna 140 · Lincoln, IL · Accident · Minor injuries · Closed · Mar 15, 1964 · N5310C · 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 ('2071604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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