NTSB investigations
1,695 cases where the first occurrence was “On ground/water collision with object”.
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\" = 310) 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" = 310) 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 ANC04LA100Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cordova, AKThe pilot's failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a runway marker sign. A factor contributing to the accident was sunglare in the pilot's eyes.NTSB IAD04LA043Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1-A2 · Elkton, KYThe pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.NTSB SEA04CA170Accident · No injuriesData collectionFinal reportCessna 180J · Pittsburg, ORThe pilot's failure to maintain clearance from an object (pole) during an aborted landing. The pilot's delayed decision to abort the landing and a pole were factors.NTSB LAX04CA296Accident · No injuriesData collectionFinal reportPilatus PC-12/45 · Show Low, AZthe collision with an elk during the landing roll. The dark night lighting conditions was a factor.NTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.NTSB DEN04CA111Accident · Minor injuriesData collectionFinal reportBell 206 L-1 · Escalante, UTthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the high winds, the gusts, and the refueling truck.NTSB SEA04LA129Accident · No injuriesLimited investigationFinal reportLogston Starduster SA100DL · Arlington, WAThe pilot's failure to maintain clearance during taxi from another aircraft standing on the runway resulting in a collision. The aircraft standing on the runway was a factor.NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.NTSB ATL04TA142Accident · No injuriesFinal reportBell UH-1H · Childs, FLThe vehicle driver's inadequate visual lookout and his failure to maintain clearance. A factor was the lack of company standards and operation procedures.NTSB ATL04LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston Salem, NCThe pilot's failure to maintain clearance from the fence post, while taxing which resulted in a collision.NTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.NTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.NTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB ATL04LA110Accident · No injuriesLimited investigationFinal reportCessna 150K · Monticello, GAThe pilot's failure to maintain clearance from trees during taxi from landing.NTSB LAX04CA196Accident · No injuriesData collectionFinal reportCessna 172N · Lincoln, CAthe pilot's failure to maintain obstacle clearance.NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.NTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.NTSB NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.NTSB FTW04LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe pilot's delay in aborting the landing. A contributing factor included the entrance of a crawfish boat onto the airstrip.NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB DEN04IA050Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Denver, COthe failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.NTSB CHI04LA077Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Romulus, MIThe visual lookout not maintained and the procedures not followed by the Push Tug Operator during the pushback. Factors were the parked airplane, the dark night, and the inadequate surveillance of the pushback by airline management.NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.NTSB CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.NTSB FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.NTSB ATL04LA053Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Miami, FLThe tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.NTSB LAX04CA065Accident · No injuriesData collectionFinal reportBeech 58P · San Diego, CAthe pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.NTSB CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.NTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.NTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.NTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.NTSB LAX04LA007Accident · No injuriesLimited investigationFinal reportBoeing 777-22B · San Francisco, CAthe failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…NTSB NYC04CA003Accident · No injuriesData collectionFinal reportBoeing 737 · Boston, MAThe collision of a ground support vehicle with a parked aircraft, due to the faulty gearshift lever on the ground support vehicle.NTSB NYC03LA208Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Flushing, NYThe inadequate visual lookout by the driver of a ground vehicle, and by ground support personnel, which resulted in a subsequent collision between the airplane and ground vehicle. A factor related to the accident was the failure of the pilot-in-command and…NTSB LAX03LA295Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Phoenix, AZthe ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.NTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.NTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB CHI03LA276Accident · No injuriesLimited investigationFinal reportBeech 1900D · Muskegon, MIThe airplane colliding with a deer during the landing roll.NTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.NTSB ATL03LA124Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the ground crew to follow powerback procedures and directives.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB SEA03CA162Accident · No injuriesData collectionFinal reportCessna R172K · Idaho Falls, IDThe pilot's failure to see and avoid a parked aircraft while taxiing.NTSB NYC03LA145Accident · No injuriesLimited investigationFinal reportMooney M20J · De Lancey, NYThe pilot's delayed decision to perform an aborted takeoff, which did not allow for sufficient room to stop. A factor was the grass runway.NTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.