NTSB investigations: GE CF34 series, 2005
6 cases on aircraft whose registry engine model is GE CF34 series. 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
| 1993 | 1 |
|---|---|
| 1994 | 1 |
| 1998 | 1 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 8 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30015'))
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 year(c."eventDate") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30015'))
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 CHI06LA016Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Covington, KYThe passenger falling while exiting the aircraft using the door-stair during normal deplaning.NTSB CHI06IA011Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · West Grove, PAThe separation of the left engine exhaust nozzle during cruise climb due to inadequately designed attachment hardware.NTSB ATL05IA116Incident · Minor injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Greensboro, NCThe inadequate assembly of the nose landing gear selector valve by a parts supplier, which resulted in internal seal damage and a hydraulic leak that led to the collapse of the nose landing gear. A factor was the insufficient information provided by the…NTSB LAX05FA202Accident · No injuriesField investigationFinal reportBombardier Aerospace CL-600-2B19 · Los Angeles, CAfailure of the nose landing gear to extend to the down and locked position for undetermined reasons.NTSB DCA05MA070Accident · 1 fatalMajor investigationFinal reportEmbraer 170 · Washington, DCThe inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.NTSB DCA05MA071Accident · Serious injuriesMajor investigationFinal reportBombardier CL-600-2B19 · Chicago O'Hare, ILThe opening of the service door when the airplane was pressurized. Contributing to the accident was the captain's failure to ensure that one of the airplane doors was open while a ground-cooling cart was connected, which resulted in pressurizing the airplane…