NTSB investigations: GE CF34 series
8 cases on aircraft whose registry engine model is GE CF34 series, where the first occurrence was “On ground/water collision with object”. 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 |
|---|---|
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30015')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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 ('30015')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 LAX06LA154Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2D24 · Las Vegas, NVThe failure of ground service personnel to properly set the parking brake on the lead baggage cart.NTSB NYC05LA013Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAThe flightcrew's misjudged clearance from a parked airport vehicle while taxiing. A factor was the vehicle operator's improper decision to park within a taxiway safety area.NTSB ATL04LA053Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Miami, FLThe tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.NTSB CHI03IA070Incident · No injuriesIncident investigationFinal reportCanadair CRJ-600 · Bloomington, ILThe pilot's improper in-flight decision to land on a runway with a tailwind component that exceeded the airplane's tailwind limitation and his failure to perform a go-around which resulted in the proper touchdown point not being attained and the airplane…NTSB CHI03FA014Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe driver of the bus not maintaining clearance from the taxiing airplane.NTSB CHI01LA066Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe vehicle driver's inadvertent failure to place the column shifter into the parking gear. A factor to the accident was the vehicle.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.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.