NTSB investigations: GE CF34-10E6
10 cases on aircraft whose registry engine model is GE CF34-10E6. 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 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.engine_model_code IN ('30023'))
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.engine_model_code IN ('30023'))
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 DCA23WA294Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ 190-100 IGW · Queretaro, MexicoNTSB DCA23LA191Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ 190-100 IGW · New York, NYElectrical sparking caused by a faulty connection between the aircraft and ground power unit resulting in a serious injury to a ground service agent.NTSB DCA22WA096IncidentClass 5 · ForeignEmbraer E190 · Los Mochis, MexicoNTSB DCA20CA043Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ190 · Disputanta, VAan encounter with clear air turbulence during cruise flight.NTSB DCA17CA101Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190 100 IGW · Orlando, FLan inadvertent encounter with convective turbulence, which resulted in a serious injury to a flight attendant.NTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN15LA140Accident · Minor injuriesClass 3 · LimitedFinal reportEmbraer ERJ 190 100 IGW · Houston, TXAn undetermined malfunction of the nosewheel steering control module, which resulted in the nose landing gear being jammed in the gear bay. Contributing to the accident was the improper rigging of the nosewheel steering feedback sensors during installation.NTSB DCA14WA086Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Kingston, JamaicaNTSB DCA11CA036Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190-100 IGW · New York, NYImproper latching of the aft galley cart prior to landing.NTSB ENG09IA017Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ 190-100 IGW · Nassau, Bahamasfailure of the engine high pressure turbine active clearance control valve fuel rod supply tube coupling seal due to a cross-threaded B-nut as installed during original manufacture.