Final NTSB investigations: Embraer EMB-120RT
11 cases on aircraft the registry lists as Embraer EMB-120RT. 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
| 1987 | 2 |
|---|---|
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3260202'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3260202'))
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 DCA01MA031Accident · No injuriesMajor investigationFinal reportEmbraer EMB-120 · West Palm Beach, FLthe failure of the flight crew to maintain airspeed during an encounter with severe icing conditions, which resulted in an inadvertent stall, loss of control, and structural damage to the airplane.NTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…NTSB MIA96FA162Accident · No injuriesField investigationFinal reportEmbraer 120 · Orlando, FLthe aircraft manufacture's inadequate written procedures in the airplane flight manual/quick reference handbook, which resulted in a failure of the landing gear to extend and a wheels up emergency landing, due to hydraulic blockage in the landing gear…NTSB FTW93MA143Accident · Minor injuriesMajor investigationFinal reportEmbraer EMB-120 RT · Pine Bluff, ARThe captain's failure to maintain professional cockpit discipline, his consequent inattention to flight instruments and ice accretion, and his selection of an improper autoflight vertical mode, all of which led to an aerodynamic stall, loss of control, and a…NTSB DEN92IA074Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 RT · Denver, COOpen air ground circuit breakers that allowed the propellers to overspeed. A factor was: clear air turbulence.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB FTW90IA169Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · College Station, TXPropeller and engine (powerplant) overspeed.NTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB MIA88FA058Accident · No injuriesField investigationFinal reportEmbraer EMB 120 · Columbus, MSThe acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected…NTSB ATL87FA210Accident · No injuriesField investigationFinal reportEmbraer EMB-120 · Atlanta, GAThe commuter airline pilot competency/proficiency check flight was progressing normally, according to the crew, until the sound of the propellers contacting the runway interrupted the routine. No mechanical, electrical, or hydraulic problem was found. The…