# NTSB investigations: Canadair CL-600-2B19: On ground/water collision with object

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 IAD98LA036](https://openairdocs.org/ntsb/IAD98LA036.md): Canadair CL600-2B19 · Covington, KY · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1998 · N937CA · Substantial damage
  > The driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.
- [NTSB LAX94LA357](https://openairdocs.org/ntsb/LAX94LA357.md): Canadair CL600 · Burbank, CA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1994 · N403SW · Substantial damage
  > the ground crew's failure to follow company procedures. The failure of the operator to provide headsets to communicate with the flightcrew and the poor lighting conditions were factors in this accident.

## 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 ('1900309')
    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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1900309&occurrence=310

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