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 LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.NTSB FTW96FA062Accident · 3 fatalField investigationFinal reportCessna 182G · Caddo Mills, TXThe failure of the pilot-in-command in each airplane to see-and-avoid conflicting traffic (inadequate visual lookout). The localized haze and smoke were related factors.NTSB MIA96LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Ocala, FLThe failure of the pilot-in-command (CFI) of the Cessna, N210PW, to see and avoid the Piper, N2114P.NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.NTSB ANC95LA127Accident · No injuriesLimited investigationFinal reportCessna 206 · Sterling, AKFailure of both pilot's to maintain adequate visual lookout. The low angle of the sun was a related factor.NTSB ANC95FA104Accident · 2 fatalField investigationFinal reportCessna 172A · Naknek, AKInadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.NTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.NTSB LAX95GA219Accident · 3 fatalFinal reportDouglas C-54G · Ramona, CAInadequate visual lookout by the Beech 58P pilot, and the operator's inadequate procedures concerning 360-degree overhead approaches.NTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.NTSB FTW95IA243Incident · No injuriesIncident investigationFinal reportCessna 150L · Levelland, TXThe failure of the pilot of the other aircraft to maintain clearance during a formation flight. A factor was the lack of experience in the type of operation.NTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.NTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…NTSB CHI95FA126Accident · 4 fatalField investigationFinal reportCessna 150M · Oshkosh, WIInadequate visual lookout by the pilot of the Beech V35B, resulting in his failure to see-and-avoid the Cessna 150, which was ahead and below him on final approach; and failure of the tower controller to provide adequate service (flight advisories and landing…NTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.NTSB LAX95LA114Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Pacifica, CAFailure of the Grumman pilot to maintain visual contact and clearance from the citabria, while overtaking that aircraft. Factors relating to the accident were: the hazy sky condition and the Grumman pilot's diverted attention to other traffic.NTSB LAX95LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Santa Paula, CAThe failure of both pilots to maintain an adequate visual lookout for other traffic in the pattern, and the other pilot's failure to effectively use the CTAF for position reports while in the pattern.NTSB LAX94FA383Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 520N · Mesa, AZFailure of the chase helicopter pilot to maintain clearance from the lead helicopter during a night approach to land. Possible factors relating to the accident were: darkness, and inadequate radio coordination between flight crews of the two helicopters.NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.NTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.NTSB NYC94FA119Accident · 1 fatalField investigationFinal reportCessna 172RG · Kiptopeka, VAInadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.NTSB LAX94FA243Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Banning, CAThe failure of both pilots to see and avoid each other. The haze was a factor.NTSB MIA94LA119Accident · No injuriesLimited investigationFinal reportGlobe 9C-1B · Okeechobee, FLBoth pilots misjudged their clearance from each other.NTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.NTSB FTW94FA102Accident · 4 fatalField investigationFinal reportTaylorcraft DCO-65 · San Antonio, TXThe failure of the pilot of the other aircraft to maintain adequate clearance during formation flight. A factor was the pilot's inadequate preflight planning and preparation regarding inflight formation procedures.NTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…NTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.NTSB FTW94FA060Accident · 5 fatalField investigationFinal reportPalmer Hawk BM-4 · Pearland, TXInadequate visual lookout by the pilot of the hawk BM-4, which resulted in his failure to see-and-avoid the Cessna 172. The BM-4 pilot's non-standard procedure for entering the traffic pattern was a related factor.NTSB MIA93LA199Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Deland, FLFailure of both pilots to maintain adequate visual lookout. Factors related to the accident were: the conflicting right traffic pattern procedures for landing that were briefed to the Boeing E75 pilot by the owner of the airstrip, and failure of both pilots…NTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.NTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.NTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.NTSB LAX93FA241Accident · 3 fatalField investigationFinal reportLancair 320 · Chino, CAInadequate visual lookout by the pilot of the Lancair 320, N69WD, that precluded him from recognizing a collision hazard and taking action to avoid a midair collision with the Cessna 152, N80203. In addition, the local controller failed to advise the pilot of…NTSB FTW93IA141Incident · No injuriesIncident investigationFinal reportCommander 114B · Oklahoma City, OKThe pilot of the pitts, N51ST, misunderstanding of the tower's instructions and clearance, and his failure to see and avoid the Commander 114B, N194A.NTSB ATL93FA082Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Statesboro, GAInadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…NTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…NTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.NTSB ATL93FA061Accident · 4 fatalField investigationFinal reportRobinson R22B · Atlanta, GAThe failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…NTSB LAX93FA055Accident · 5 fatalField investigationFinal reportCessna T210M · Thornton, CAThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the failure of the sacramento controller to advise the stockton controller of the impending unsafe situation, and the failure of the stockton controller…NTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.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 SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.NTSB LAX92FA367Accident · 1 fatalField investigationFinal reportCessna 182Q · Santa Paula, CAThe failure of both pilots to see and avoid each other. Contributing to the accident was the azimuth of the setting sun and the Cessna 182 pilots non standard flight pattern.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…