# NTSB investigations: VHF communication system

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 WPR23FA092](https://openairdocs.org/ntsb/WPR23FA092.md): Cessna 414 · Modesto, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 18, 2023 · N4765G · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…
- [NTSB ERA22LA364](https://openairdocs.org/ntsb/ERA22LA364.md): Aerotek Pitts Special S-1S · Erwinna, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 6, 2022 · N49310 · 2 aircraft · Substantial damage
  > The inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…
- [NTSB ERA18LA268](https://openairdocs.org/ntsb/ERA18LA268.md): Diamond DA20 · Sebring, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 2018 · N397JA · 2 aircraft · Substantial damage
  > The inability of the pilot of the Piper and the student pilot and flight instructor of the Diamond to see and avoid the other airplane. Contributing to the collision was the Piper pilot’s failure to use the correct common traffic advisory frequency to…
- [NTSB ERA16FA312](https://openairdocs.org/ntsb/ERA16FA312.md): Beech F33 · Carrollton, GA · Accident · 3 fatal · Field investigation · Final report · Sep 7, 2016 · N6027K · 2 aircraft · Substantial damage
  > The failure of the Beech pilot to see and avoid the Diamond that was in front of and below his airplane on final approach and his use of an incorrect radio communication frequency for the airport.
- [NTSB WPR11LA068](https://openairdocs.org/ntsb/WPR11LA068.md): Taylorcraft BC-65 · Madras, OR · Accident · No injuries · Limited investigation · Final report · Dec 1, 2010 · N23619 · 2 aircraft · Minor damage
  > The failure of both pilots to see and avoid the other airplane while in the traffic pattern to land, which resulted in a midair collision.
- [NTSB ANC10LA094](https://openairdocs.org/ntsb/ANC10LA094.md): Piper PA-18 · Dillingham, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 2010 · N9699P · 2 aircraft · Substantial damage
  > Both pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01022312'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01022312/cases

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