NTSB investigations: Embraer S A ERJ 170-200 LR
15 cases on aircraft the registry lists as Embraer S A ERJ 170-200 LR. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2014 | 1 |
|---|---|
| 2015 | 1 |
| 2017 | 3 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 ('3260415'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 ('3260415'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA26LA047Accident · No injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Chicago, ILUnited Airlines flight crew’s failure to maintain adequate clearance from the parked Envoy Airlines airplane while taxiing in winter weather conditions.NTSB OPS25LA025IncidentClass 4 · LimitedInvestigation openBoeing 737-823 · Goodyear, AZNTSB DCA25LA045Accident · Serious injuriesClass 3 · LimitedPreliminary reportEmbraer S A ERJ 170-200 LR · Warnock, OHOn November 20, 2024, about 1846 eastern standard time (2346 UTC), a Mesa Airlines, Inc., Embraer SA ERJ 170-200 LR, N85352, dba as United Express flight 6149, encountered “moderate to severe” turbulence during descent to its destination, Cleveland Hopkins…NTSB DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…NTSB DCA23LA090Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Taneytown, MDAn encounter with turbulence during descent.NTSB DCA22LA015Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Miami, FLAn abrupt jerk of the airplane as the captain applied the parking brake during the tow that caused a flight attendant to fall and break her wrist.NTSB DCA22LA005Accident · No injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Chicago, ILA ground collision by SkyWest flight 5845 that resulted in substantial damage to Republic Airlines flight 3594.NTSB OPS21LA003Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-8H4 · San Diego, CAThe blocked go-around radio instruction from the air traffic control tower to the arrival aircraft which resulted in the arrival aircraft continuing the landing approach. This led to a loss of separation between the landing aircraft and the aircraft awaiting…NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB DCA20WA096Incident · No injuriesForeign investigationEmbraer ERJ170-200LR · Apodaca, MexicoNTSB DCA18CA049Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Saint Louis, MOthe abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.NTSB DCA17CA155Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer S A ERJ170-200LR · Minneapolis, MNAn encounter with convective turbulence.NTSB OPS17IA014IncidentClass 3 · IncidentFinal reportEmbraer S A ERJ 170-200 LR · San Francisco, CAThe local controller's issuance of a landing clearance for runway 28L to the ERJ170, and the subsequent issuance of line up and wait instructions to the A320 for runway 28L, resulting in a runway incursion.NTSB WPR15LA239Accident · Serious injuriesLimited investigationFinal reportEmbraer E175 · South Lake Tahoe, CAThe airplane's encounter with moderate turbulence during descent, which resulted in a serious injury to a flight attendant who was not securely seated. Contributing to the accident was the flight attendant's decision to continue to secure items before the…NTSB CEN14CA455Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Hemphill, TXThe airplane's inadvertent encounter with wake turbulence during cruise flight, which resulted in a serious injury to a flight attendant.