# NTSB investigations, CA: Near midair/TCAS alert/loss of separation

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 DCA24LA316](https://openairdocs.org/ntsb/DCA24LA316.md): Boeing 757-224 · Dunnigan, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 19, 2024 · N12125 · No damage
  > The abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.
- [NTSB DCA24WA308](https://openairdocs.org/ntsb/DCA24WA308.md): Boeing 737-8 · San Francisco, CA · Incident · Class 5 · Foreign · Sep 16, 2024 · N105JS · No damage
- [NTSB OPS10IA163](https://openairdocs.org/ntsb/OPS10IA163.md): Bombardier CL-600-2B19 · Burbank, CA · Incident · No injuries · Incident investigation · Final report · Apr 29, 2010 · N953SW · 2 aircraft · No damage
  > The local controller’s failure to issue control instructions necessary to ensure positive control/standard separation of traffic operating within the Class C airspace.
- [NTSB OPS10IA020](https://openairdocs.org/ntsb/OPS10IA020.md): Boeing 777-222 · San Francisco, CA · Incident · No injuries · Incident investigation · Final report · Mar 27, 2010 · N216UA · 2 aircraft · No damage
  > The local controller's issuance of a takeoff clearance to the Boeing 777 without ensuring that approved separation would exist with the Cessna 182. Contributing to the incident were tower procedures that permitted transitioning aircraft to cross the runway 28…

## 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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '260' 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/260/sequence?state=CA

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