NTSB investigations
139 cases where the first occurrence was “Collision between aircraft (other than midair)”.
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\" = 271) 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" = 271) 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 FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.NTSB ATL97LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLfailure of the pilot of N7617F to comply with an ATC instruction to hold short of a taxiway, and failure of the pilots in both airplanes to see-and-avoid each other's airplane.NTSB LAX97LA200Accident · No injuriesLimited investigationFinal reportMoravan Z242L · Jean, NVThe pilot of the Beech E35, N7354, inadequate preflight planning/preparation and lack of familiarity with the aircraft which led to his attempt to taxi from a seat without brake controls.NTSB FTW97IA161Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe first officer's failure to maintain clearance while taxiing around a standing airplane.NTSB FTW97LA148Accident · No injuriesLimited investigationFinal reportStinson L5 · Lancaster, TXFailure of the pilot of the Stinson L5, N57789, to see and avoid the RV-6, N139TX.NTSB DCA97MA009Accident · 14 fatalClass 1 · MajorFinal reportBeech 1900C · Quincy, ILthe failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…NTSB ATL97LA004Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Angier, NCThe Aeronca 65's pilots selection of the wrong taxi route, and his inadequate visual lookout during back taxi.NTSB SEA97LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albany, ORfailure of the SA-750 pilot to see-and-avoid the Cessna 172, which had landed ahead of him on the same runway. The inherent visual restrictions of the SA-750 (a tandem two-place biplane) was a related factor.NTSB NYC97LA003Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Mansfield, MAfailure of the T-6 pilot to maintain clearance from the Cessna 152, as he turned off the runway after landing. A factor relating to the accident was: the T-6 pilot's restricted view of the Cessna 152 (lack of visual detection), due to a blind spot beyond the…NTSB SEA96LA215Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, WAinadequate visual lookout by the pilot of the Piper J3, and failure of the flight instructor in the Bellance to ensure that clearance was maintained from the other moving aircraft. Factors relating to the accident were: the inherent visual restrictions…NTSB CHI96LA339Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Highland, ILfailure of the Piper PA-25 tow pilot to see-and-avoid the Blanik L-23 glider. A factor relating to the accident was: neither aircraft was equipped with a communication radio.NTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.NTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.NTSB FTW96LA287Accident · No injuriesLimited investigationFinal reportCessna 421B · Stillwater, OKthe failure of the pilots of the Cessna 421B, N450SU, and the Cessna 152, N94532, to maintain visual lookout. Factors were: the inadequate radio communications maintained by both pilots, and the failure of the student pilot of the Cessna 152 to take evasive…NTSB LAX96LA222Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · San Francisco, CAinadequate visual lookout by the United Airlines tug driver during the pushback operation. Contributing factors were: the driver's reduced ability to observe the American B-767 due to the nighttime condition, and United Airlines management's failure to ensure…NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.NTSB ATL96LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Nashville, TNthe failure of the pilot of the Piper PA-28, N26046, to visually clear the intended taxi course.NTSB CHI96LA118Accident · No injuriesLimited investigationFinal reportCessna 310R · Marshfield, WIthe failure of the pilot of the PA-32R, N1030Q, to obtain identification of the Cessna 310R, N1835E, visually, and his inadequate visual outlook. A factor was the failure of both pilots to hear communications from each other.NTSB ANC96LA026Accident · No injuriesLimited investigationFinal reportBoeing 757-232 · Fairbanks, AKinadequate visual lookout by the flightcrew of the Delta Boeing 757, N622DL, and their failure to follow procedures and directives by not closely following the ramp marshals' signals.NTSB MIA96FA068Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Miami, FLThe local and ground controllers' failure to adequately coordinate the movement of the two airplanes, the tower cab supervisor's failure to provide adequate supervision to the controllers, the MD-11 flightcrew's misinterpretation of the local controller's…NTSB LAX96LA092Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Kailua Kona, HIThe failure of the Waco pilot to see and avoid the opposite direction Cessna 172 while both aircraft were taxiing in a non-movement area of the airport. Factors in the accident were: the congested nature of the taxi lane, which limited the Waco pilot's…NTSB CHI95LA318Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Belvidere, ILinadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.NTSB FTW95LA352Accident · No injuriesLimited investigationFinal reportCessna 172E · Alpine, TXThe failure of the pilots of both airplanes to see and avoid each other. A factor was the Cessna's inoperative radio.NTSB CHI95LA252Accident · No injuriesLimited investigationFinal reportStevens Acro II · Oshkosh, WIthe failure of the pilot of the Acro II, N40LF, to maintain clearance from the Cessna 172, N5542R.NTSB FTW95FA319Accident · No injuriesField investigationFinal reportBoeing 737-3A4 · Dallas, TXFailure of the flightcrews of the Boeing 737, N675AA, and the Cessna 401, N31DB, to see and avoid each other. Factors were: the failure of 737 flightcrew to respond to the traffic advisory given by the ground controller identifying potentially conflicting…NTSB LAX95LA239Accident · No injuriesLimited investigationFinal reportCessna 182A · Paso Robles, CAFailure of the great lakes pilot to see-and-avoid the Cessna 182. The sun glare was a related factor.NTSB LAX95LA194Accident · Serious injuriesLimited investigationFinal reportAero Commander 500S · Santa Barbara, CAthe inadequate visual lookout by both pilots and their failures to maintain adequate separation from each other while taxiing in a non-movement area.NTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.NTSB NYC95IA114Incident · No injuriesIncident investigationFinal reportBoeing 767-383ER · Newark, NJthe pilot of the B-767, LNRCK, misjudged clearance between his airplane and the B-737, N13624, resulting in an on-ground collision.NTSB SEA95LA076Accident · No injuriesLimited investigationFinal reportCessna 402B · Boise, IDFailure of both pilots to perform adequate visual lookout during taxi, and the ground controller's failure to identify the position of the Piper PA-34 before issuing taxi instructions. Factors relating to the accident were: decreased visibility due to…NTSB MIA95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Venice, FLFailure of the globe GC-1B (swift) pilot to see the Piper PA-23 in time to avoid a collision, and the Piper PA-23 pilot's delay in initiating remedial action to avoid the collision.NTSB MIA95LA086Accident · No injuriesLimited investigationFinal reportLockheed L-1011-385 · San Juan, PRThe tug operator of another airplane commencing pushback procedures without clearance to do so from the dispatching agent, resulting in an on-ground collision between both airplanes.NTSB MIA95LA040Accident · No injuriesLimited investigationFinal reportCessna 208B · Memphis, TNThe inability of the pilot of Cessna 208, N927FE to see Douglas DC3, N24320, as he taxied to takeoff due to inoperative tail navigation lights and beacon lights on the DC3 and due to glare on the wet taxiway.NTSB CHI95MA044Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 · Bridgeton, MOThe Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…NTSB BFO95LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Syracuse, NYThe failure of the pilot of the AG-5B, N1190L, to see and avoid the PA-28R, N38869. The dark night was a factor.NTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.NTSB CHI94LA178Accident · 1 fatalLimited investigationFinal reportCessna 150L · Richmond, INInadequate visual lookout by the pilots of both airplanes.NTSB LAX94LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R22-B · Stockton, CAA failure of the pilot-in-command of a landing helicopter to maintain sufficient clearance from a second helicopter.NTSB LAX94LA122Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the other aircraft's left brake system due to a worn master cylinder, and the failure of the other pilot to taxi at a speed and spacing interval which would allow for successful remedial action.