NTSB investigations
435 cases where the first occurrence was “Midair collision”.
Cases, newest first
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 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 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 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…NTSB 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,…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…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,…NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…NTSB LAX86MA050Accident · 1 fatalMajor investigationFinal reportBell 206L-1 · San Pedro, CATwo Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,…NTSB DCA86AA004Accident · 6 fatalFinal reportDassault Falcon 50 · Fairview, NJDassalt falcon 50 (D50), N784B, was on vor/dme-a apch at dusk to circle/lnd at teterboro (teb), as Piper PA-28, N1977H, was transiting arpt traffic area (ata) fm west to east at 1500' in VFR (no flt pln). PA-28 plt was clrd thru ata by teb twr (staying blo…NTSB LAX86LA034Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Chandler, AZDuring a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short…NTSB LAX86LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Angwin, CANear the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &…NTSB LAX86FA025Accident · No injuriesField investigationFinal reportCessna 182P · Sacramento, CAAs the Cessna 182P pilot flew through a control zone without establishing communications at an altitude of 3,500 ft, a Piper PA28 was beginning its approach for landing. The Piper's pilot was practicing instrument flight using a hood and a safety pilot. The…NTSB FTW86MA001Accident · 5 fatalMajor investigationFinal reportCessna 441 · Dallas, TXA student plt in a Cessna 152, N5522L, had deptd redbird arpt at Dallas. He was practicing solo maneuvers in a privatelydesignated practice area that overlapped the extended inbnd course to rwys 31L & r at love field. At the same time, a Cessna 441, N400BG,…NTSB ATL85MA282Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Auburn, ALDrg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion…NTSB MIA85FA253Accident · No injuriesField investigationFinal reportCessna 152 · Panama City, FLThe plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and…NTSB MIA85FA247Accident · No injuriesField investigationFinal reportCessna 150 · Pensacola, FLThe commercial plt & CFI departed from gulfport, ms on a night VFR x-country flt to gulf shores. Al. The flt landed at foley, al after the plt mistook foley for gulfshores 10 mi south. The flt departed again & was advised by ATC to fly a heading of 170 deg…