NTSB investigations: GE CF34 series, KY
8 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
| 1998 | 1 |
|---|---|
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2009 | 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\" = 'KY' 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" = 'KY' 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 DCA09CA069Accident · Serious injuriesData collectionFinal reportBombardier CL-600-2B19 · Louisville, KYan inadvertent encounter with convective turbulence.NTSB DCA06MA064Accident · 49 fatalClass 1 · MajorFinal reportBombardier CRJ-100 · Lexington, KYthe flight crewmembers's failure to use available cues and aids to identify the airplane's location on the airport surface during taxi and their failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the…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 NYC02IA097Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Covington, KYThe manufacturer's failure to provide inspection criteria for the BPSU compartment aileron control pulleys, which resulted in eventual pulley corrosion, and subsequent control stiffness when seized pulleys and water-soaked aileron cables froze together at…NTSB NYC01IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Covington, KYMissing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.NTSB MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB IAD98LA036Accident · Minor injuriesLimited investigationFinal reportCanadair CL600-2B19 · Covington, KYThe driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.