# Fatal NTSB investigations: Embraer EMB-120RT

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 DCA97MA017](https://openairdocs.org/ntsb/DCA97MA017.md): Embraer EMB-120RT · Monroe, MI · Accident · 29 fatal · Class 1 · Major · Final report · Jan 9, 1997 · N265CA · Destroyed
  > The Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…
- [NTSB DCA91MA052](https://openairdocs.org/ntsb/DCA91MA052.md): Embraer 120 · Eagle Lake, TX · Accident · 14 fatal · Class 1 · Major · Final report · Sep 11, 1991 · N33701 · Destroyed
  > The failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…
- [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 ATL90FA095](https://openairdocs.org/ntsb/ATL90FA095.md): Embraer EMB-120 · Gadsden, AL · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1990 · N217AS · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.

## 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."highestInjuryLevel" = 'Fatal'
  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?fatal=1&model=3260202

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