# NTSB investigations, TX: Nose down

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 FTW00LA145](https://openairdocs.org/ntsb/FTW00LA145.md): Bell 47G · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · May 9, 2000 · N14408 · Substantial damage
  > The improper touchdown performed by the flight instructor.
- [NTSB FTW99LA268](https://openairdocs.org/ntsb/FTW99LA268.md): Cessna 140A · Tyler, TX · Accident · No injuries · Limited investigation · Final report · Sep 25, 1999 · N76731 · Substantial damage
  > The locked left brake, which made normal braking impossible, and resulted in the airplane nosing down.
- [NTSB FTW85LA337](https://openairdocs.org/ntsb/FTW85LA337.md): Piper PA-28-181 · Westbrook, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1985 · N8043C · Substantial damage
  > There were no known eye witnesses to the accident. Available evidence reveals that the pilot most probably made a successful landing in the remotely located field and rolled to a stop. The sheriff reported that the engine oil was drained onto the ground at…
- [NTSB FTW82DA125](https://openairdocs.org/ntsb/FTW82DA125.md): Bellanca 7ECA · Lubbock, TX · Accident · No injuries · Final report · Mar 12, 1982 · N4193Y · Substantial damage
  > While taxiing to takeoff the pilot noticed an increase in wind and decided to return to the ramp. As he turned left the wind picked up the right wing and flipped the aircraft over. The wind was at 24 KTS. Gusting to 34 KTS.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 290)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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