# NTSB investigations: Embraer EMB-145LR, IL

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 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 OPS15IA011](https://openairdocs.org/ntsb/OPS15IA011.md): Embraer EMB 145LR · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Feb 18, 2015 · N698CB · 2 aircraft · No damage
  > The flight crew's failure to manage cockpit tasks during taxi resulting in a loss of situation awareness and subsequently taxiing past a required turn point and onto an active runway without clearance. Contributing to the runway incursion was the ground…
- [NTSB CEN13CA117](https://openairdocs.org/ntsb/CEN13CA117.md): Embraer EMB-145LR · Chicago, IL · Accident · Serious injuries · Data collection · Final report · Dec 29, 2012 · N619AE · No damage
  > The presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.
- [NTSB OPS11IA819](https://openairdocs.org/ntsb/OPS11IA819.md): Embraer EMB-135KL · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 8, 2011 · N377SK · 2 aircraft · No damage
  > The improper air traffic control takeoff clearance issued by the local controller because of his lack of monitoring and lack of awareness of the conflicting arrival airplane.
- [NTSB OPS08IA011](https://openairdocs.org/ntsb/OPS08IA011.md): Learjet 60 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 21, 2008 · N252RP · 2 aircraft · No damage
  > The LC-10 controller's failure to ensure the appropriate separation between two airplanes operating on runways where flight paths intersect.

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

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

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