OpenAirDocs.org

NTSB investigations, 1987

25 cases where the first occurrence was “Midair collision”.

Cases per year

19822026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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 year(c.\"eventDate\") = 1987
    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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.Dec 19, 1987 · N675B · 2 aircraft · DestroyedNTSB MIA88LA057Accident · No injuriesLimited investigationFinal reportBeech E-18S · Natchez, MSThe two acft were registered to the same person & the pilots were friends of each other. The acft departed from the same airport at about the same time & were bound for the same destination on an IFR flt plan, N24JE at 8000 ft, N492DM at 4000 ft. later both…Dec 9, 1987 · N24JE · 2 aircraft · Substantial damageNTSB BFO88LA006Accident · Minor injuriesLimited investigationFinal reportCessna U-206 · Front Royal, VAThe 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.…Oct 25, 1987 · N756KP · 2 aircraft · Minor damageNTSB NYC88LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Bedford, MAA 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…Oct 17, 1987 · N97313 · 2 aircraft · Substantial damageNTSB DEN88LA010Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMTwo balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally…Oct 5, 1987 · N36988 · 2 aircraft · Substantial damageNTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…Sep 19, 1987 · N92919 · 2 aircraft · DestroyedNTSB MIA87FA236Accident · 1 fatalField investigationFinal reportCessna 152 · Opa Locka, FLA student plt & instructor (CFI) in Cessna 152, N48864, took off & entered rgt traffic to practice lndgs on rwy 9R. Soonthereafter, a helicopter plt (h/p) in a bell 47G-2, N6728D, took off & entered rgt traffic to practice lndgs in a desig-nated helicopter…Aug 31, 1987 · N48864 · 2 aircraft · Substantial damageNTSB FTW87FA206Accident · 3 fatalField investigationFinal reportCessna U206G · Lissie, TXThe Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16…Aug 23, 1987 · N4745U · 2 aircraft · DestroyedNTSB SEA87FA162Accident · 2 fatalField investigationFinal reportHughes 369D · Ketchikan, AKN58318 (Hughes 369, under contract with us geological survey) was inbnd fm se to lnd at Ketchikan-temsco heliport (6Z4) as N73WS (Cessna 185 amphibian) was depg se fm Ketchikan intl arpt (ktn). Ktn & 6Z4 were located in tongass narrows withmtns NE & sw. Rprtd…Aug 12, 1987 · N58318 · 2 aircraft · DestroyedNTSB LAX87FA296Accident · No injuriesField investigationFinal reportCessna 152 · Palo Alto, CAA midair collision occurred abt 2.8 mi west of Palo Alto arpt (pao) as Cessna 152, N152SC, was on a left x-wnd dep fm rwy 30 & Mooney 20J, N5201Y was transitting the arpt traffic area (ata) fm se to NE & dscndg fm 2400' to 1500'. N152SC was on twr freq.…Aug 8, 1987 · N152SC · 2 aircraft · Minor damageNTSB LAX87FA290Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Palmdale, CAA Dehavilland DHC-6, N931MA, operating as transworld express flt 7591 (twe 7591) & a Cessna 172N, N737EV, collided abt 10 miles west/southwest of Palmdale, CA at abt 5500 ft MSL. Twe 7591 was descending on a 355 deg mag heading; N737EV was level and was…Aug 4, 1987 · N931MA · 2 aircraft · Substantial damageNTSB CHI87LA167Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Springfield, MITwo hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…Jul 12, 1987 · N1505F · 2 aircraft · Substantial damageNTSB LAX87LA224Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAWhile on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing…May 30, 1987 · N88314 · 2 aircraft · Substantial damageNTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…May 24, 1987 · N5711A · 2 aircraft · DestroyedNTSB LAX87FA213Accident · 4 fatalField investigationFinal reportCessna P206 · Tehachapi, CAAn USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government…May 22, 1987 · N2520X · 2 aircraft · DestroyedNTSB MIA87FA153Accident · No injuriesField investigationFinal reportCessna 152 · Lantana, FLThe plt stated that he was at 60 KTS. With full flaps & just about to flare when somthing forced the nose down. He then pulled back on the controls, hit the ground, veered off the left side of the runway & collided with a C152 that was holding for takeoff,…May 2, 1987 · N152LG · 2 aircraft · Minor damageNTSB DCA87MA029Accident · 4 fatalClass 1 · MajorFinal reportCessna 340A · Orlando, FLThe two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt…May 1, 1987 · N8716K · 2 aircraft · DestroyedNTSB ATL87FA130Accident · 2 fatalField investigationFinal reportCessna 182R · Kennesaw, GAN5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with…Apr 29, 1987 · N5511N · 2 aircraft · DestroyedNTSB DEN87FA091Accident · 1 fatalField investigationFinal reportGrumman G-164A · Lamar, COThe aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and…Apr 8, 1987 · N8369 · 2 aircraft · DestroyedNTSB DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…Mar 31, 1987 · N75584 · 2 aircraft · DestroyedNTSB BFO87LA028Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Dover, DEThe rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of…Mar 29, 1987 · N5216Y · 2 aircraft · Substantial damageNTSB NYC87FA098Accident · No injuriesField investigationFinal reportCessna 402 · Montgomery, NYBoth acft were operating under visual flight rules in the vicinity of active airports. The Cessna 402 was in a cruise descent. The decathlon was in level flight. Neither pilot in the 402 recalls seeing the decathlon, which was struck on the rt wing. The…Feb 26, 1987 · N36139 · 2 aircraft · Minor damageNTSB NYC87FA061Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Westerly, RIThe Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just…Jan 20, 1987 · N3293W · 2 aircraft · Minor damageNTSB DCA87MA020Accident · 6 fatalClass 1 · MajorFinal reportPiper PA-31-350 · Independence, MOThe two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt…Jan 20, 1987 · N60SE · 2 aircraft · DestroyedNTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…Jan 15, 1987 · N163SW · 2 aircraft · Destroyed