# NTSB investigations, TX: Oversight of operation

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 CEN23MA034](https://openairdocs.org/ntsb/CEN23MA034.md): Boeing B17 · Dallas, TX · Accident · 6 fatal · Class 1 · Major · Final report · Nov 12, 2022 · N7227C · 2 aircraft · Destroyed
  > the air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…
- [NTSB CEN13IA563](https://openairdocs.org/ntsb/CEN13IA563.md): Pilatus PC-12/47E · Austin, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 12, 2013 · N617BG · Minor damage
  > The pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…
- [NTSB CEN09IA234](https://openairdocs.org/ntsb/CEN09IA234.md): Bell 206L-3 · Abilene, TX · Incident · No injuries · Incident investigation · Final report · Mar 29, 2009 · N708M · Minor damage
  > The formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…
- [NTSB DFW08LA118](https://openairdocs.org/ntsb/DFW08LA118.md): Vickers Spitfire · Galveston, TX · Accident · No injuries · Limited investigation · Final report · Apr 26, 2008 · N308WK · 2 aircraft · Substantial damage
  > The Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '04032015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/04032015/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
