# NTSB investigations: Socata TAMPICO TB 9C

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 ERA19LA274](https://openairdocs.org/ntsb/ERA19LA274.md): Socata TB9 · Fort Meade, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2019 · N2824R · Substantial damage
  > The failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.
- [NTSB GAA16CA125](https://openairdocs.org/ntsb/GAA16CA125.md): Socata Tampico TB 9 · Fort Smith, AR · Accident · No injuries · Data collection · Final report · Feb 13, 2016 · N505PC · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in runway excursion, impact with terrain and an airport sign, and a postimpact fire.
- [NTSB NYC02LA052](https://openairdocs.org/ntsb/NYC02LA052.md): Socata TB-9 · Marlborough, MA · Accident · No injuries · Limited investigation · Final report · Jan 26, 2002 · N28239 · Substantial damage
  > The pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.
- [NTSB CHI99LA110](https://openairdocs.org/ntsb/CHI99LA110.md): Socata TB-9C · Cahokia, IL · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 1999 · N508PC · Substantial damage
  > the in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…
- [NTSB MIA91LA131](https://openairdocs.org/ntsb/MIA91LA131.md): Piper PA-28-161 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 30, 1991 · N150ER · 2 aircraft · Minor damage
  > Failure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.

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

This list as a web page: https://openairdocs.org/ntsb?model=8680693

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