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 IAD99FA041Accident · 3 fatalField investigationFinal reportCessna 305A · Hilltown, PAThe inadequate lookout of both pilots, and the pilot of the other aircraft.NTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 172N · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.NTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.NTSB MIA99FA126Accident · Minor injuriesField investigationFinal reportBeech E-55 · Lakeland, FLFailure of the pilot of the other aircraft to maintain a visual lookout and visual separation while on approach for landing. This resulted in a midair collision with another airplane and subsequent in-flight collision with the runway.NTSB MIA99LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe inadequate visual lookout of the pilot of the Cessna airplane and of the pilot of the glider resulting in the midair collision.NTSB LAX99FA036Accident · 2 fatalField investigationFinal reportCessna 172P · Scottsdale, AZthe failure of the solo student pilot in the other aircraft to acquire and maintain separation from this aircraft, which was departing the airport traffic pattern and had been issued as traffic by the local controller. Also causal was the failure of the pilot…NTSB LAX99FA027Accident · 3 fatalField investigationFinal reportCessna 150L · Yerington, NVthe failure of the pilot to see and avoid the aircraft ahead, which was already established in the traffic pattern. The failure of both pilots announce their intentions on the Common Traffic Advisory Frequency was a factor in this accident.NTSB FTW99FA001Accident · 1 fatalField investigationFinal reportBell 407 · Vermilion 331the failure of both pilots to see and avoid each other's aircraft during cruise flight. Factors were the failure of both pilots to use a known safety advisory recommendation and the failure of both operators to implement the recommendation as a company…NTSB ATL98GA127Accident · 1 fatalFinal reportGovernment Aircraft Fact N22S · Caribbean SeaThe failure of the pilot-in-command of the other aircraft (N6305U) to maintain physical clearance from N6302W. Contributing factors were the inadequate visual lookout of all four pilots involved.NTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 310R · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.NTSB LAX98LA253Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Lincoln, CAThe pilot of the other aircraft's inadequate visual lookoutNTSB SEA98LA138Accident · 2 fatalLimited investigationFinal reportRockwell S-2R · Burley, IDA failure of both pilots to see and avoid each other's aircraft due to inadequate visual lookout.NTSB ANC98FA061Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-B2 · Juneau, AKThe failure of both command pilots to maintain an adequate lookout to see and avoid each other's aircraft. Factors associated with the accident were the pilot's failure to follow published advisory procedures to monitor/issue position reports on the…NTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…NTSB MIA98FA135Accident · 2 fatalField investigationFinal reportBoeing A-75N1 · Kissimmee, FLFailure of the number 2 pilot to maintain visual contact and/or proper position/clearance from other aircraft.NTSB ATL98FA060Accident · 5 fatalField investigationFinal reportCessna 525 · Marietta, GAThe failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…NTSB LAX98FA118Accident · 3 fatalField investigationFinal reportCessna 310H · Corona, CAThe failure of both pilots to maintain an adequate visual lookout and to see and avoid the other airplane.NTSB CHI98FA096Accident · 2 fatalField investigationFinal reportWasielak Sonerai II L · Malta, ILThe pilot's failed to maintain adequate clearance from the other aircraft.NTSB LAX98FA086Accident · 1 fatalField investigationFinal reportBeech J35 · Morgan Hill, CAThe pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors.NTSB FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.NTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…NTSB FTW98LA022Accident · No injuriesLimited investigationFinal reportCessna 150G · Tyler, TXThe failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.NTSB MIA98FA007Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Robbins, NCfailure of the pilots in both aircraft to see-and-avoid each other's airplane (inadequate visual lookout), and failure of the Beech pilot to operate his airplane at a correct Visual Flight Rules (VFR) cruising altitude for his route of flight.NTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.NTSB CHI97FA218Accident · 7 fatalField investigationFinal reportCessna 172P · Chicago, ILthe pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.NTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.NTSB MIA97FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Asheboro, NCfailure of the pilots in both airplanes to see and/or avoid a collision with each other.NTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…NTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…NTSB ANC97FA051Accident · 2 fatalField investigationFinal reportCessna 185 · Tatitlek, AKThe command pilots of both airplanes inadequate visual outlook which led to their failure to see and avoid each other's airplane. A factor associated with the accident was sunglare.NTSB SEA97LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Arlington, WAThe failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…NTSB ANC97FA037Accident · 2 fatalField investigationFinal reportShort Brothers SC7 · Nunapitchuk, AKinadequate visual look-out by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplanes.NTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.NTSB LAX97FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · San Diego, CAThe failure of the pilot-in-command of the Piper PA-28, N943R, to maintain an adequate visual lookout to see and avoid the Cessna 150, N63137. A factor in the accident was the failure of the air traffic controller to issue a traffic advisory to the pilot…NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.NTSB MIA97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 21OK · Tampa, FLThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the improper planning/decision of the pilot of the Cessna 210 to depart the traffic pattern on the downwind leg rather than on the upwind leg as…NTSB FTW97LA018Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Oil City, LAthe failure of the pilots of both aircraft to maintain an adequate visual lookout. Factors were: different traffic pattern altitudes flown by the two pilots, and the sunglare encountered by the pilot of the ultralight.NTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.NTSB ANC96LA111Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas MD369D · Healy, AKThe inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.NTSB FTW96FA279Accident · 2 fatalField investigationFinal reportPrevatt RV-6 · Boulder, COPoor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…NTSB ANC96LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot of the Cessna 180, N5020E, disregard of an air traffic control clearance/instruction to hold short. A factor in the accident was the failure of both pilots to maintain an adequate visual lookout for other aircraft.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB FTW96FA208Accident · 1 fatalField investigationFinal reportJerrell RV-4 · Englewood, COfailure of the pilot of the RV-4, N44AZ, to comply with an ATC clearance by landing on the wrong runway, and the failure of the pilot of the SU-29, N55SU, to maintain an adequate visual lookout. Factors in the accident were: the failure of the air traffic…NTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…NTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.NTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.NTSB MIA96FA096Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · Flagler Beach, FLinadequate visual lookout by the pilots in both airplanes, which resulted in their failure to see-and-avoid conflicting traffic.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.