# NTSB investigations: Socata TB-20 TRINIDAD, CA

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 WPR17FA105](https://openairdocs.org/ntsb/WPR17FA105.md): Socata TB 20 Trinidad · Sierraville, CA · Accident · 2 fatal · Field investigation · Final report · Apr 17, 2017 · N28070 · Destroyed
  > The pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.
- [NTSB WPR10LA259](https://openairdocs.org/ntsb/WPR10LA259.md): Socata TB-20 · Happy Camp, CA · Accident · 1 fatal · Limited investigation · Final report · May 22, 2010 · N3041Y · Substantial damage
  > The pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…
- [NTSB LAX04LA251](https://openairdocs.org/ntsb/LAX04LA251.md): Socata TB-20 · Perris, CA · Accident · No injuries · Limited investigation · Final report · Jun 28, 2004 · N110U · Substantial damage
  > A loss of engine power due to oil exhaustion as a result of the mechanic's use of an incorrect gasket during the installation of the vacuum pump.
- [NTSB LAX97LA281](https://openairdocs.org/ntsb/LAX97LA281.md): Aerospatiale TB-20 · Borrego, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1997 · N577JL · Substantial damage
  > The pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.
- [NTSB LAX92LA223](https://openairdocs.org/ntsb/LAX92LA223.md): Aerospatiale TB-20 · Groveland, CA · Accident · No injuries · Limited investigation · Final report · May 25, 1992 · N2824F · Substantial damage
  > The pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.
- [NTSB LAX89LA039](https://openairdocs.org/ntsb/LAX89LA039.md): Aerospatiale TB-20 · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Nov 5, 1988 · N94TB · Substantial damage
  > The student plt and the CFI agreed that the acft developed a high sink rate as it passed over the departure end of the dirt rwy. The acft collided with the ground about 3/4 mile from the rwys end. The winds were variable but basically from the south at 15-20…

## 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" = 'CA' AND c."eventCountry" = 'USA'
  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&state=CA

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