NTSB investigations: Bombardier CL-600-2B19
9 cases on aircraft the registry lists as Bombardier CL-600-2B19, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 2000 | 2 |
|---|---|
| 2001 | 1 |
| 2003 | 2 |
| 2005 | 3 |
| 2007 | 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.aircraft_model_code IN ('1390008')
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\" = 130))
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.aircraft_model_code IN ('1390008')
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" = 130))
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 DEN07IA055Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Cripple Creek, COA fatigue fracture, which resulted in the separation of the No.1 engine fan disk. Contributing factors in the accident were the operators' maintenance personnel lack of training to be able to detect arc-out damage on the fan disk, and the fan disk…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 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 CHI05FA077Accident · No injuriesField investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIthe captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…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.NTSB LAX03IA199Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZthe simultaneous failure of both horizontal stabilizer trim channels on two separate occasions for undetermined reasons.NTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.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 LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.