# NTSB investigations: Collision avoidance alert

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 CEN23FA084](https://openairdocs.org/ntsb/CEN23FA084.md): Piper PA46 · Yoakum, TX · Accident · 4 fatal · Class 3 · Field · Final report · Jan 17, 2023 · N963MA · Substantial damage
  > The pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.
- [NTSB DCA17LA183](https://openairdocs.org/ntsb/DCA17LA183.md): Bombardier CL 600 2C10 · McKellar, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 22, 2017 · N745SK · No damage
  > An encounter with convective turbulence while maneuvering to avoid conflicting traffic.
- [NTSB CEN17FA072](https://openairdocs.org/ntsb/CEN17FA072.md): Cessna 525 · Cleveland, OH · Accident · 6 fatal · Field investigation · Final report · Dec 30, 2016 · N614SB · Destroyed
  > Controlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…
- [NTSB ERA16LA115](https://openairdocs.org/ntsb/ERA16LA115.md): Beech 95 C55 · Plymouth, MA · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 2016 · N482S · Substantial damage
  > The pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.
- [NTSB DCA13WA107](https://openairdocs.org/ntsb/DCA13WA107.md): Boeing 737-800 · Sydney, Australia · Incident · No injuries · Foreign investigation · Jun 10, 2013 · VH-VUX · No damage
  > The Australian Transport Safety Bureau (ATSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on June 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…
- [NTSB ERA12LA401](https://openairdocs.org/ntsb/ERA12LA401.md): Beech 400A · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2012 · N826JH · Substantial damage
  > The flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…
- [NTSB OPS11IA246](https://openairdocs.org/ntsb/OPS11IA246.md): Boeing 777 · 80 SE of JFK (Atlantic Ocean), NY · Incident · No injuries · Incident investigation · Final report · Jan 21, 2011 · N766AN · No damage
  > Incomplete and incorrect coordination between air traffic controllers that resulted in the 777 and the two C17s being cleared to maintain the same altitude. Contributing to the incident was the controllers’ non-adherence to established communications…
- [NTSB DCA10LA083](https://openairdocs.org/ntsb/DCA10LA083.md): Embraer ERJ 170 100 SE · Summit, MS · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2010 · N856RW · No damage
  > the abrupt maneuver that was appropriately initiated to comply with the TCAS resolution advisory caused by the momentary projected loss of separation from converging traffic. Contributing to the accident was a passenger's decision to disregard the seatbelt…
- [NTSB WPR10LA134](https://openairdocs.org/ntsb/WPR10LA134.md): Boeing 737-7H4 · Santa Clarita, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 2010 · N221WN · No damage
  > The pilot’s abrupt airplane pitch change maneuver. Contributing to the accident was the flight crew’s failure to maintain the heading specified by the air traffic controller, which would have avoided the near collision course with an unidentified airplane…
- [NTSB ERA10LA041](https://openairdocs.org/ntsb/ERA10LA041.md): Boeing 717-200 · Pleasant Grove, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2009 · N935AT · No damage
  > The captain's excessive maneuver in response to a traffic alert and collision avoidance system (TCAS) alert, which resulted in a serious injury to a flight attendant. Contributing to the accident was the operator's inadequate TCAS training and guidance.
- [NTSB OPS08IA014](https://openairdocs.org/ntsb/OPS08IA014.md): Boeing B744 · Atlantic Ocean · Incident · No injuries · Incident investigation · Final report · Aug 28, 2008 · UKNOWN · 2 aircraft · No damage
  > The San Juan CERAP controllers failure to ensure the two aircraft were properly separated using non-radar separation standards.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '420' 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/420/sequence

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