# NTSB investigations: Continental O-200A, TX

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 DEN08FA140](https://openairdocs.org/ntsb/DEN08FA140.md): Aircraft Mfg & Dev. CH601XLi · Farmersville, TX · Accident · Serious injuries · Field investigation · Final report · Aug 14, 2008 · N451BB · Substantial damage
  > The inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…
- [NTSB FTW83LA020](https://openairdocs.org/ntsb/FTW83LA020.md): Piper J-3 · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Oct 24, 1982 · N38449 · Substantial damage
  > When the confederate air force failed to show up for an airshow the pilot was asked to make some low passes over the airport and explosive charges were to be set off to simulate bomb bursts. During one low pass the charges were exploded too soon. The…

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

This list as a web page: https://openairdocs.org/ntsb?engine=17404&state=TX

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