# NTSB investigations: Embraer EMB-120RT, GA

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 DCA91MA033](https://openairdocs.org/ntsb/DCA91MA033.md): Embraer EMB-120RT · Brunswick, GA · Accident · 23 fatal · Class 1 · Major · Final report · Apr 5, 1991 · N270AS · Destroyed
  > The loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…
- [NTSB ATL87FA210](https://openairdocs.org/ntsb/ATL87FA210.md): Embraer EMB-120 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Jul 14, 1987 · N211AS · Substantial damage
  > The commuter airline pilot competency/proficiency check flight was progressing normally, according to the crew, until the sound of the propellers contacting the runway interrupted the routine. No mechanical, electrical, or hydraulic problem was found. 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" = 'GA' 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 ('3260202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3260202&state=GA

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