NTSB investigations
435 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
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.\"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 NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.NTSB MIA08LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Farmingdale, NYThe failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.NTSB SEA07FA264Accident · 1 fatalField investigationFinal reportDeluca-Owl OR-71 · Reno, NVThe failure of the pilots of both aircraft to maintain an adequate visual lookout and clearance from one another during a low altitude aerial race.NTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.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 CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna T210R · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB LAX07LA079Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Palos Verdes, CAthe failure of both pilots to maintain adequate visual lookout and clearance from each other while maneuvering in close proximity.NTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.NTSB DEN07IA021Incident · No injuriesIncident investigationFinal reportBeech P35 · Los Alamos, NMthe failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.NTSB LAX06FA277Accident · Minor injuriesField investigationFinal reportRaytheon Hawker 800XP · Smith, NVThe failure of the glider pilot to utilize his transponder and the high closure rate of the two aircraft, which limited each pilot's opportunity to see and avoid the other aircraft.NTSB CHI06LA157Accident · 1 fatalLimited investigationFinal reportGood RV-6A · Peru, ILFailure of the pilot of the second airplane in the formation to maintain clearance with the lead airplane during the overhead recovery maneuver prior to landing.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB ANC06FA048Accident · 5 fatalField investigationFinal reportCessna 170B · Chugiak, AKThe inadequate visual lookout by the pilots of both airplanes during cruise flight, which resulted in their failure to see-and-avoid each other, and a subsequent midair collision.NTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…NTSB CHI06FA077Accident · 3 fatalField investigationFinal reportShort Brothers SD-360-300 · Watertown, WIThe other airplane's flight crew failure to maintain clearance while maneuvering during formation flight. Contributing to the accident was the decision of both flight crews to fly in formation.NTSB LAX06LA065Accident · No injuriesLimited investigationFinal reportBeech F33A · La Verne, CAthe failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.NTSB LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.NTSB MIA06FA022Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Homestead, FLThe failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…NTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.NTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.NTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…NTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.NTSB MIA05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bradfordville, FLThe failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.NTSB CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…NTSB DEN05IA025Incident · No injuriesIncident investigationFinal reportBlair-American USA · Fort Collins, COthe Blair-American and the Cessna pilot's inadequate visual lookout, and student pilot's failure to give right-of-way to a landing aircraft, which resulted in a runway incursion and subsequent collision. Contributing factors include the student instructor's…NTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.NTSB LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.NTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.NTSB NYC04FA185Accident · 2 fatalField investigationFinal reportCessna A150L · Kinnelon, NJBoth pilots inadequate visual lookout, which resulted in a midair collision.NTSB FTW04LA151Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Weldon, ARThe other pilot's failure to maintain an adequate visual lookout during approach to landing, which resulted in a midair collision between the two airplanes.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB FTW04LA123Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-40 · Georgetown, TXThe failure of both pilot's to maintain an adequate visual lookout, which resulted in a midair collision between the two airplanes.NTSB CHI04LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · New Munster, WIVisual lookout not maintained by the pilots of both airplanes.NTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.NTSB MIA04FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Clearwater, FLThe failure of both pilots to maintain adequate visual lookout while entering the traffic pattern (downwind leg) at an uncontrolled airport resulting in a midair collision. inadvertent stall, and in-flight collision with terrain.NTSB LAX04FA095Accident · 1 fatalField investigationFinal reportCessna 180K · Tehachapi, CAThe pilot's inadequate visual lookout during climb, and the pilot of the other airplane's inadequate visual lookout during cruise.NTSB ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…NTSB LAX04FA037Accident · 2 fatalField investigationFinal reportRobinson R22 Beta II · Torrance, CAthe failure of the pilot of the R22 to comply with an ATC clearance.NTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.NTSB CHI03FA284Accident · 3 fatalField investigationFinal reportCessna 172S · Lake Elmo, MNBoth pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.NTSB MIA03LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · West Palm Beach, FLThe poor judgment by the pilot-in-command of the airplane for his initiation of takeoff after the helicopter pilot had announced intention to perform a 180-degree autorotation to the runway, and the failure of both pilots to maintain visual lookout resulting…NTSB DEN03LA130Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Snowmass Villag, COthe failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.NTSB MIA03FA124Accident · 5 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FL**This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…NTSB LAX03LA129Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Herald, CAthe inadequate visual lookout for other aircraft by both pilots that resulted in a midair collision.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.