# NTSB investigations: Embraer EMB-145LR: Runway excursion

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 DCA21WA010](https://openairdocs.org/ntsb/DCA21WA010.md): Embraer EMB145 · Freeport, Bahamas · Accident · Minor injuries · Class 5 · Foreign · Oct 24, 2020 · N674RJ · Substantial damage
- [NTSB DCA20LA013](https://openairdocs.org/ntsb/DCA20LA013.md): Embraer EMB145 · Chicago, IL · Accident · No injuries · Class 3 · Limited · Final report · Nov 11, 2019 · N619AE · Substantial damage
  > The flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…
- [NTSB CEN11WA628](https://openairdocs.org/ntsb/CEN11WA628.md): Embraer EMB-145LR · Ottawa, Canada · Accident · No injuries · Foreign investigation · Sep 4, 2011 · N840HK · Substantial damage
- [NTSB OPS11IA271](https://openairdocs.org/ntsb/OPS11IA271.md): Embraer EMB-145LR · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Feb 1, 2011 · N13964 · Minor damage
  > The pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.
- [NTSB DCA10RA069](https://openairdocs.org/ntsb/DCA10RA069.md): Embraer EMB-145LR · Ottawa, Canada · Accident · Minor injuries · Foreign investigation · Jun 16, 2010 · N847HK · Substantial damage

## 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 ('3260212')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/300/sequence?model=3260212

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