# NTSB investigations: Embraer EMB-120ER: On ground/water collision with object

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 DEN06IA020](https://openairdocs.org/ntsb/DEN06IA020.md): Embraer EMB-120ER · Denver, CO · Incident · No injuries · Incident investigation · Final report · Nov 29, 2005 · N299UX · Minor damage
  > the pilot's failure to maintain clearance from the taxiway light. Factors contributing to the incident were the crew's inadequate visual lookout and the taxiway light.
- [NTSB DEN03LA096](https://openairdocs.org/ntsb/DEN03LA096.md): Embraer EMB-120ER · Denver, CO · Accident · No injuries · Limited investigation · Final report · Jun 2, 2003 · N299UX · Substantial damage
  > the ground personnel's failure to maintain aircraft/ground vehicle clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel and the airport vehicle.
- [NTSB DEN03IA054](https://openairdocs.org/ntsb/DEN03IA054.md): Embraer EMB-120ER · Cedar City, UT · Incident · No injuries · Incident investigation · Final report · Mar 17, 2003 · N214SW · Minor damage
  > the captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.
- [NTSB NYC01LA054](https://openairdocs.org/ntsb/NYC01LA054.md): Embraer 120RT · Charleston, WV · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 2000 · N504AS · Substantial damage
  > Deer on the runway. Factors included reduced visibility due to nighttime lighting and light snow conditions, breaches in the perimeter fence, increased seasonal deer activity, and the rural location of the airport.
- [NTSB LAX95LA255](https://openairdocs.org/ntsb/LAX95LA255.md): Embraer EMB-120 RT · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1995 · N268UE · Substantial damage
  > the captain's decision to taxi across a non-movement aircraft parking area instead of using the designated taxi lane to exit the ramp. A factor in the accident was the dark night environmental lighting conditions.

## 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 ('3260203')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3260203&occurrence=310

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