# NTSB investigations, MA: 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 NYC00FA058](https://openairdocs.org/ntsb/NYC00FA058.md): Cessna 172P · Leominster, MA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1999 · N96273 · 2 aircraft · Destroyed
  > The student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…
- [NTSB NYC99FA222](https://openairdocs.org/ntsb/NYC99FA222.md): Cessna 337C · North Adams, MA · Accident · 2 fatal · Field investigation · Final report · Sep 12, 1999 · N973FS · 2 aircraft · Destroyed
  > the failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.
- [NTSB NYC95FA224](https://openairdocs.org/ntsb/NYC95FA224.md): Boeing A75N1 · Marlborough, MA · Accident · 1 fatal · Field investigation · Final report · Sep 24, 1995 · N89X · 2 aircraft · Minor damage
  > the Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.
- [NTSB BFO93LA136](https://openairdocs.org/ntsb/BFO93LA136.md): Piper PA-28-180 · Pittsfield, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1993 · N9044J · 2 aircraft · Substantial damage
  > The failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.
- [NTSB NYC89FA146](https://openairdocs.org/ntsb/NYC89FA146.md): Cessna T210N · Hubbardston, MA · Accident · 1 fatal · Field investigation · Final report · Jun 12, 1989 · N212FS · 2 aircraft · Substantial damage
  > Failure of both pilots to see-and-avoid (attain visual lookout for) conflicting traffic.
- [NTSB NYC88LA012](https://openairdocs.org/ntsb/NYC88LA012.md): Cessna 172P · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N97313 · 2 aircraft · Substantial damage
  > A Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…
- [NTSB NYC87FA027](https://openairdocs.org/ntsb/NYC87FA027.md): Piper PA-31-325 · Mansfield, MA · Accident · Serious injuries · Field investigation · Final report · Oct 30, 1986 · N200GG · 2 aircraft · Substantial damage
  > Piper PA-31, N200GG, was on a VFR flt to boston, MA. The PA-31 plt contacted boston TRACON & adzd he had ATIS info & would be lndg at boston. TRACON suggested a hdg & alt of 070 deg & 2500' for rwy 33R & told the plt to maint VFR. At aprx the same time, a…
- [NTSB ATL86MA114](https://openairdocs.org/ntsb/ATL86MA114.md): Bell 206L-3 · Holliston, MA · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1986 · N302MC · 2 aircraft · Destroyed
  > The Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a…
- [NTSB NYC84LA147](https://openairdocs.org/ntsb/NYC84LA147.md): Cessna 152 · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N45945 · 2 aircraft · No damage
  > The plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and…

## 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" = 'MA' 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=MA

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