NTSB investigations: GE CF34 series, CA
11 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
| 1994 | 1 |
|---|---|
| 2000 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2016 | 2 |
| 2021 | 1 |
| 2022 | 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\" = 'CA' 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" = 'CA' 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 WPR22LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Van Nuys, CAThe student pilot’s failure to maintain sufficient distance behind a jet airplane which, resulted in his loss of airplane control due to the jet airplane’s jet blast and the flight instructor’s delayed remedial action.NTSB DCA21LA096Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · Los Angeles, CAthe improper retraction of the main cabin door, which resulted in the flight attendant falling when she opened the door at the destination.NTSB OPS17IA008IncidentClass 3 · IncidentFinal reportBombardier CL 600 2B19 · San Francisco, CAThe captain’s inadvertent turn onto the incorrect taxiway and subsequent entry onto an active runway without a clearance, which resulted in the runway incursion.NTSB DCA16CA139Accident · No injuriesData collectionFinal reportBombardier CL 600 2B19 · San Francisco, CAThe tug driver's failure to comply with the wing walkers direction to stop, which resulted in the towed airplane colliding with N961SW.NTSB DCA12CA035Accident · No injuriesData collectionFinal reportBombardier CL600 2B19 · San Francisco, CAthe driver's failure to ensure that the belt loader was clear of the airplane before turning.NTSB WPR10IA256Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Ontario, CAFailure of the airplane’s nose landing gear to extend for undetermined reasons.NTSB OPS10IA163Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Burbank, CAThe local controller’s failure to issue control instructions necessary to ensure positive control/standard separation of traffic operating within the Class C airspace.NTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…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 LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.NTSB LAX94LA357Accident · No injuriesLimited investigationFinal reportCanadair CL600 · Burbank, CAthe ground crew's failure to follow company procedures. The failure of the operator to provide headsets to communicate with the flightcrew and the poor lighting conditions were factors in this accident.