# NTSB investigations: Embraer EMB-120

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 LAX97FA189](https://openairdocs.org/ntsb/LAX97FA189.md): Embraer EMB-120 · San Diego, CA · Accident · No injuries · Field investigation · Final report · May 21, 1997 · N198SW · Substantial damage
  > The failure of maintenance personnel to allow adequate time for the engine oil to drain back into the engine oil reservoir prior to adding additional oil, thereby overfilling the reservoir, which resulted in an engine fire and subsequent damage to hydraulic…
- [NTSB DCA95MA054](https://openairdocs.org/ntsb/DCA95MA054.md): Embraer EMB-120RT · Carrollton, GA · Accident · 8 fatal · Class 1 · Major · Final report · Aug 21, 1995 · N256AS · Destroyed
  > the in-flight fatigue fracture and separation of a propeller blade resulting in distortion of the left engine nacelle, causing excessive drag, loss of wing lift, and reduced directional control of the airplane. The fracture was caused by a fatigue crack from…

## 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 ('3260201'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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