NTSB investigations: GE CF34 series, NC
7 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
| 2003 | 1 |
|---|---|
| 2005 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2017 | 2 |
| 2021 | 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.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
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 DCA21LA226Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Asheville, NCThe fuel truck driver backing up in the direction of the airplane without the use of marshallers.NTSB DCA17CA197Accident · Serious injuriesData collectionFinal reportBombardier CL 600 2B19 · Charlotte, NCthe tug operator's initiation of a right turn onto the perpendicular terminal road in proximity to the airplane.NTSB DCA17CA064Accident · No injuriesData collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCcollision with a deer during takeoff.NTSB OPS09IA005Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B1 · Charlotte, NCThe Charlotte local control east controller's failure to ensure that the runway was clear prior to authorizing N409DR to enter the runway.NTSB NYC08LA234Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Charlotte, NCThe tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.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 ATL03IA126Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Raleigh Durham, NCThe failure of a utility bus relay which resulted in an electrical fire and subsequent smoke in the cockpit.