Major NTSB investigations
24 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2007 | 1 |
Where
Open the mapLatest 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 (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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 (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 LAX07MA231Accident · 4 fatalClass 1 · MajorFinal reportEurocopter AS350-B2 · Phoenix, AZBoth pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…NTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.NTSB DCA00MA080Accident · 11 fatalMajor investigationFinal reportPiper PA-31 Navajo · Burlington Twp., NJthe failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.NTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.NTSB DCA92MA049Accident · 6 fatalClass 1 · MajorFinal reportMitsubishi MU-2B-60 · Greenwood, INThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the pilots of the MU-2 and the PA-32 from recognizing a collision hazard and taking actions to avoid the midair collision.…NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…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 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 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 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 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 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 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 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 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 FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…NTSB DCA84AA034Accident · 17 fatalClass 1Final reportBeech C-99 · San Luis Obispo, CAAt about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…NTSB ATL83MA084Accident · 7 fatalClass 1 · MajorFinal reportBeech D55 · Cherry Point, NCThe two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area…NTSB DCA83AA006Accident · 3 fatalFinal reportCessna 182Q · Livingston, NJAero commander 560E, N3827C (27C), was returning from blairstown where it had been flown for minor maint. The plt was on an IFR flt plan, cleared by new york TRACON to proceed at 2000 ft MSL on a radar vector of 170 deg for an ILS apch to the teterboro arpt.…