NTSB investigations, 1986
29 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 30 |
|---|---|
| 1983 | 14 |
| 1984 | 26 |
| 1985 | 25 |
| 1986 | 29 |
| 1987 | 25 |
| 1988 | 18 |
| 1989 | 19 |
| 1990 | 23 |
| 1991 | 23 |
| 1992 | 12 |
| 1993 | 13 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 17 |
| 1997 | 15 |
| 1998 | 15 |
| 1999 | 17 |
| 2000 | 19 |
| 2001 | 7 |
| 2002 | 10 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 11 |
| 2006 | 8 |
| 2007 | 9 |
Where
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\") = 1986
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.
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") = 1986 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX87MA068Accident · No injuriesMajor investigationFinal reportPiper PA-28-181 · Long Beach, CAA Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS…NTSB NYC87FA049Accident · 1 fatalField investigationFinal reportCessna 172M · Kingston, NYCessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final…NTSB ATL87FA038Accident · 2 fatalField investigationFinal reportCessna 185D · Hammonton, NJThe mid-air collision occurred while the Cessna 185 was attempting a steep climbout during takeoff from rwy 21 and the Mooney was making a landing to the same runway. Another aircraft attemped to warn both aircraft over the UNICOM freq. Neither aircraft…NTSB LAX87FA057Accident · No injuriesField investigationFinal reportCessna 172N · Santa Paula, CAA Cessna 172 & a Dehavilland gipsy moth collided at 150 ft. AGL while on short final approach to the uncontrolled arpt. On base leg the plt flying the moth failed to observe & yield the right of way to the Cessna which was already established on the final…NTSB FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…NTSB LAX87FA040Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Corona, CAThe plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second…NTSB NYC87FA027Accident · Serious injuriesField investigationFinal reportPiper PA-31-325 · Mansfield, MAPiper 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 ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…NTSB CHI87FA004Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Charleston, ILN8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy…NTSB ATL87FA001Accident · 3 fatalField investigationFinal reportPiper J3-65C · Goldsboro, NCThe J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The…NTSB DCA86AA041Accident · 82 fatalClass 1Final reportMcDonnell Douglas DC-9-32 · Cerritos, CAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/07. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…NTSB CHI86MA212Accident · 1 fatalMajor investigationFinal reportPiper PA-31-T1 · Montgomery, NYAfter canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he…NTSB LAX86FA320Accident · No injuriesField investigationFinal reportBellanca 7GCBC · Van Nuys, CATwo plts, 1 flying Bellanca 7GCBC, N50443, the other flying champion 7KCAB, N443E, took their girl friends on a flt which included formation flying. The champion plt rprtd he flew formation with the Bellanca with aprx a 20' spread. Rprtdly, about half way…NTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…NTSB DCA86AA028Accident · 25 fatalFinal reportde Havilland DHC-6-300 · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…NTSB ANC86LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilots of each acft stated they thought that the left float and prop of the Taylorcraft had come in contact with the rt wing and rt landing gear of the Piper. The plts failed to see the other acft in time to avoid the collision. Both acft nosed over…NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…NTSB SEA86FA121Accident · 2 fatalField investigationFinal reportCessna 152 · Mead, WABoth acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for…NTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…NTSB NYC86FA114Accident · 1 fatalField investigationFinal reportGlaser-Dirks DIRK-DG-400 · Julian, PAThe plt of N686U reported he was established in weak thermal at an alt of aprx 2500 AGL when two other gliders were seen. One at aprx the same alt and one below his alt. He continued to state that the glider which was at his alt passed very close to but…NTSB LAX86LA189Accident · Serious injuriesLimited investigationFinal reportCessna 195A · San Rafael, CAThe two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…NTSB LAX86MA186Accident · No injuriesMajor investigationFinal reportLTV Aerospace Industries A7E · Warner Springs, CAA rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating…NTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…NTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…NTSB ATL86MA114Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Holliston, MAThe 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 SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…NTSB FTW86FA049Accident · Serious injuriesField investigationFinal reportSpencer Pitts S-1 · Mckinney, TXAs a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts…NTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…NTSB CHI86FA094Accident · 1 fatalField investigationFinal reportCessna 152 · Drayton Plaines, MIAfter a home built dragon fly gnd looped, other acft in the VFR traffic pattern were sent around, including a Cessna 152(C-152), N93604, flown by a student plt. Shortly after the dragon fly was clrd fm the rwy, Cessna 172 (C-172), N48003, entered the pattern,…