# NTSB investigations: Luscombe 8A, 2004

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 SEA04CA174](https://openairdocs.org/ntsb/SEA04CA174.md): Luscombe 8A · Nampa, ID · Accident · No injuries · Data collection · Final report · Aug 27, 2004 · N1983B · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.
- [NTSB CHI04CA189](https://openairdocs.org/ntsb/CHI04CA189.md): Luscombe 8A · Merrill, WI · Accident · Minor injuries · Data collection · Final report · Jul 21, 2004 · N45628 · Substantial damage
  > The dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…

## 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 year(c."eventDate") = 2004
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8190104', '8190111'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8190104&year=2004

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