# NTSB investigations: Bombardier CL-600-2C10, NC

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 DCA19CA102](https://openairdocs.org/ntsb/DCA19CA102.md): Bombardier CL 600 2C10 · Charlotte, NC · Accident · Minor injuries · Class 4 · Data collection · Final report · Mar 10, 2019 · N530EA · 2 aircraft · Substantial damage
  > failure of the ground crew to maintain visual separation and avoid the holding aircraft.
- [NTSB DCA17CA064](https://openairdocs.org/ntsb/DCA17CA064.md): Bombardier CL 600 2C10 · Charlotte, NC · Accident · No injuries · Data collection · Final report · Feb 15, 2017 · N709PS · Substantial damage
  > collision with a deer during takeoff.
- [NTSB NYC08LA234](https://openairdocs.org/ntsb/NYC08LA234.md): Bombardier CL-600-2C10 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Jun 28, 2008 · N725PS · 2 aircraft · Substantial damage
  > The tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.

## 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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1390015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1390015&state=NC

---
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.