# NTSB investigations: Bombardier CL-600-2B19: Landing gear not configured

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 CEN11IA615](https://openairdocs.org/ntsb/CEN11IA615.md): Bombardier CL-600-2B19 · Baton Rouge, LA · Incident · No injuries · Incident investigation · Final report · Sep 1, 2011 · N875AS · Minor damage
  > The improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…
- [NTSB CEN11IA379](https://openairdocs.org/ntsb/CEN11IA379.md): Bombardier CL-600-2B19 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Jun 7, 2011 · N866AS · Minor damage
  > The failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…
- [NTSB ENG10IA055](https://openairdocs.org/ntsb/ENG10IA055.md): Bombardier CL600 2B19 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Sep 28, 2010 · N498CA · Minor damage
  > The failure of the left main landing gear (MLG) to extend normally and manually for reasons that could not be conclusively determined.
- [NTSB WPR10IA256](https://openairdocs.org/ntsb/WPR10IA256.md): Bombardier CL-600-2B19 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · May 23, 2010 · N925SW · Minor damage
  > Failure of the airplane’s nose landing gear to extend for undetermined reasons.

## 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" = '095' 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/095/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.
