# NTSB investigations: Bombardier CL-600-2B19: Miscellaneous/other

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 ERA11CA010](https://openairdocs.org/ntsb/ERA11CA010.md): Bombardier CL-600-2B19 · New York, NY · Accident · Serious injuries · Data collection · Final report · Oct 4, 2010 · N414ZW · No damage
  > The passenger's loss of balance while deplaning.
- [NTSB DCA10IA022](https://openairdocs.org/ntsb/DCA10IA022.md): Bombardier CL600 · Charleston, WV · Incident · No injuries · Incident investigation · Final report · Jan 19, 2010 · N246PS · Minor damage
  > (1) The flight crewmembers’ unprofessional behavior, including their nonadherence to sterile cockpit procedures by engaging in nonpertinent conversation, which distracted them from their primary flight-related duties and led to their failure to correctly set…
- [NTSB SEA08IA080](https://openairdocs.org/ntsb/SEA08IA080.md): Bombardier CL-600 · Hilo, HI · Incident · No injuries · Incident investigation · Final report · Feb 13, 2008 · N651BR · No damage
  > The captain and first officer inadvertently falling asleep during the cruise phase of flight. Contributing to the incident were the captain's undiagnosed obstructive sleep apnea and the flight crew’s recent work schedules, which included several consecutive…

## 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 ('1390008')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/sequence?model=1390008

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