# NTSB investigations: Socata TB-20 TRINIDAD, 2007

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 MIA07CA139](https://openairdocs.org/ntsb/MIA07CA139.md): Trinidad TB-20 · White Plains, NY · Accident · Minor injuries · Data collection · Final report · Sep 2, 2007 · N84GT · Substantial damage
  > The pilot's failure to obtain adequate airspeed for takeoff which resulted in a stall, runway overrun down an embankment, and collision with a fence. A factor in accident was the pilot not utilizing the full length of the runway for takeoff.
- [NTSB CHI07FA279](https://openairdocs.org/ntsb/CHI07FA279.md): Socata TB-20 Trinidad · Pointe Aux Pins, MI · Accident · 2 fatal · Field investigation · Final report · Aug 24, 2007 · N96DF · Substantial damage
  > Undetermined.
- [NTSB DFW07FA149](https://openairdocs.org/ntsb/DFW07FA149.md): Socata TB-20 · Groesbeck, TX · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2007 · N2801W · Destroyed
  > The pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.
- [NTSB CHI07LA092](https://openairdocs.org/ntsb/CHI07LA092.md): Socata TB-20 Trinidad · Rhinelander, WI · Accident · No injuries · Limited investigation · Final report · Mar 19, 2007 · N900Y · Substantial damage
  > The failure of the pilot to maintain directional control of the airplane during taxi. A contributing factor was the gusting winds and sign.

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

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

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