NTSB investigations: Embraer EMB-110P1
5 cases on aircraft the registry lists as Embraer EMB-110P1, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
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 ('3260122')
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\" = 130))
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 ('3260122')
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" = 130))
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 FTW88IA090Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Wichita Falls, TXThe right engine upper cowling separated during initial climb, went rearward, and shattered a window at the right rearmost passenger seat which was not occupied. The pilot secured the engine and made an uneventful landing. The cowling separated due to…NTSB CHI86IA037Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Detroit, MIThe acft suffered a failure of the left rear axle during taxi to takeoff.NTSB MIA84IA160Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Miami, FLThe plt reported that during a descending turn at aprx 8000 ft & 200 KTS, the acft encountered turbulence & a lateral gust. He stated that this caused the acft to roll into about a 70 deg bank. He initiated a recovery, but the acft had gotten in a 20 deg nose…NTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…NTSB ATL82IA034Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Clarksburg, WVDuring taxi out from greensboro, NC, the captain noted that the aircraft was pulling to the right. The problem alleviated itself when the pilot tapped the right brake. After a normal takeoff, the copilot noticed during gear retraction that the right main…