# NTSB investigations, VA: Midair collision

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 NYC94FA119](https://openairdocs.org/ntsb/NYC94FA119.md): Cessna 172RG · Kiptopeka, VA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1994 · N6624R · 2 aircraft · Destroyed
  > Inadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.
- [NTSB BFO93LA006](https://openairdocs.org/ntsb/BFO93LA006.md): Cessna 182 · Suffolk, VA · Accident · No injuries · Limited investigation · Final report · Nov 11, 1992 · N91868 · 2 aircraft · Substantial damage
  > Failure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.
- [NTSB BFO89LA008](https://openairdocs.org/ntsb/BFO89LA008.md): Cessna 207 · Topping, VA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N73114 · 2 aircraft · Minor damage
  > The pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…
- [NTSB BFO88LA006](https://openairdocs.org/ntsb/BFO88LA006.md): Cessna U-206 · Front Royal, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1987 · N756KP · 2 aircraft · Minor damage
  > The aircraft was involved in a midair collision with N756KP, a Cessna U206 aircraft, while both aircraft were on the final approach to runway 27 at the uncontrolled Front Royal, VA airport. Excellent VFR weather prevailed with 15 miles visibility reported.…

## 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" = 'VA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 270)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=270&state=VA

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