# NTSB investigations: Canadair CL-600-2A12

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DCA18WA029](https://openairdocs.org/ntsb/DCA18WA029.md): Canadair CL 600 2A12 · Caracas, Venezuela · Accident · No injuries · Foreign investigation · Dec 4, 2017 · N45WL · Substantial damage
  > The government of Venezuela has notified the NTSB of an accident involving a CANADAIR LTD CL 600 2A12 airplane that occurred on December 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation…
- [NTSB CEN12IA662](https://openairdocs.org/ntsb/CEN12IA662.md): Canadair CL-600 Challenger · Denver, CO · Incident · No injuries · Incident investigation · Final report · Sep 21, 2012 · N125PS · No damage
  > The internal failure of the galley heater mat’s thermostat, which resulted in an overheat condition.
- [NTSB DEN05MA029](https://openairdocs.org/ntsb/DEN05MA029.md): Canadair CL-600-2A12 · Montrose, CO · Accident · 3 fatal · Class 1 · Major · Final report · Nov 28, 2004 · N873G · Destroyed
  > the flight crew's failure to ensure that the airplane’s wings were free of ice or snow contamination that accumulated while the airplane was on the ground, which resulted in an attempted takeoff with upper wing contamination that induced the subsequent stall…
- [NTSB SEA88IA028](https://openairdocs.org/ntsb/SEA88IA028.md): Canadair CL600-2A12 · Twentynine Plms, CA · Incident · No injuries · Incident investigation · Final report · Dec 6, 1987 · N125PS · No damage
  > The water filter housing lower seal was mis-installed which allowed water to seep out and run down the housing case. Over time the water dropped onto a lavatory drain line, followed the line to a low point & collected on the stab aug computer box. The fluid…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 ('1900304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1900304

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.