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 LAX06CA224Accident · No injuriesData collectionFinal reportMooney M20M · Searchlight, NVthe pilot's encounter with rocks and debris on the runway during landing.NTSB DFW06CA162Accident · No injuriesData collectionFinal reportCessna 182L · Coupland, TXThe pilot's disorientation. Contributing factors were the prevailing night light condition and the inoperative landing light.NTSB ANC06LA076Accident · No injuriesLimited investigationFinal reportCessna 185 · Dillingham, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in the airplane's tailwheel snagging a rope during the takeoff run, and subsequent in-flight collision with terrain. A factor contributing to the accident was a rope that was positioned…NTSB CHI06LA278Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Lawrenceville, ILThe visual separation from the glider attempted by the tow pilot and traffic advisories from the glider not received by the tow pilot. The airport sign/marker was a contributing factor.NTSB CHI06LA161Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · New York, NYThe foreign object damage to the horizontal stabilizer during taxi as a result of improper airport maintenance by contract maintenance personnel. The aluminum plate was a factor.NTSB DEN06CA082Accident · No injuriesData collectionFinal reportCessna 182R · Albuquerque, NMthe pilot's failure to maintain directional control of the airplane after landing.NTSB SEA06CA136Accident · No injuriesData collectionFinal reportCessna 206G · Stanley, IDThe pilot's failure to maintain directional control during an aborted takeoff. Factors include a tailwind gust, and a large rock near the side of the runway.NTSB SEA06TA118Accident · No injuriesFinal reportCessna 206H · Aurora, ORThe failure of both the pilot of the aircraft traveling on a taxi lane and the operator of the automobile driving on a taxi lane to maintain an adequate visual lookout and their failure to see and avoid one another.NTSB SEA06CA095Accident · No injuriesData collectionFinal reportHelmer Avid Magnum · Big Timber, MTThe pilot's failure to maintain directional control after he diverted his attention to close the aircraft's door during the takeoff roll. Factors include a fence and fence post along the side of the runway.NTSB DEN06CA078Accident · No injuriesData collectionFinal reportAviat A-1A · Englewood, COthe pilot's failure to maintain aircraft control while taxiing from landing, resulting in a collision with a refuse dumpster. A contributing factor was his physical impairment by alcohol.NTSB ANC06CA053Accident · No injuriesData collectionFinal reportCessna 207 · Akiachak, AKThe failure of the driver of an all terrain vehicle to maintain adequate visual lookout while maneuvering on the ramp, which resulted in a collision with the parked accident airplane's elevator.NTSB NYC06LA114Accident · Minor injuriesLimited investigationFinal reportEmbraer EMB-145-LR · Boston, MAThe tug driver's inadequate visual lookout, which resulted in a collision with a parked airplane. A factor was the fog.NTSB CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB LAX06LA154Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2D24 · Las Vegas, NVThe failure of ground service personnel to properly set the parking brake on the lead baggage cart.NTSB LAX06CA157Accident · No injuriesData collectionFinal reportCessna 172S · Big Bear, CAthe pilot's failure to maintain wing clearance from a pole during taxi.NTSB SEA06CA098Accident · No injuriesData collectionFinal reportCessna 172N · Billings, MTThe pilot's failure to maintain clearance from a sign while taxiing to parking.NTSB NYC06CA103Accident · No injuriesData collectionFinal reportMaule M-5-210C · Linville, VAThe pilot's improper decision to depart with a tailwind.NTSB DEN06IA068Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Denver, COThe ground crew's failure to retract the adjacent jetway and to verify the airplane's clearance with the jetway as it taxied.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB SEA06CA073Accident · No injuriesData collectionFinal reportCessna 170B · Havre, MTThe pilot's improper starting procedures in attempting to hand-prop the airplane's engine. Contributing factors were the discharged battery, the failure of the right parking brake and the hangar which the aircraft collided with.NTSB MIA06CA102Accident · No injuriesData collectionFinal reportPiper 38-112 · Apopka, FLThe pilot's failure to maintain clearance from an object while taxiing which resulted in the airplane impacting the object and incurring damage.NTSB SEA06CA066Accident · No injuriesData collectionFinal reportCessna 182D · Sandpoint, IDThe pilot's failure to maintain clearance from an object (snow blowing equipment) while taxiing. The snow blowing equipment, and the pilot's failure to adequately maneuver the aircraft around snow berms were factors.NTSB LAX06CA139Accident · No injuriesData collectionFinal reportBeech G35 · Flagstaff, AZthe pilot's failure to maintain an adequate clearance with obstructions while taxiing.NTSB NYC06LA074Accident · No injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe deice vehicle driver's failure to maintain clearance from a standing airplane, which resulted in a collision between the deice vehicle and left elevator of the airplane.NTSB LAX06CA122Accident · No injuriesData collectionFinal reportCessna 172P · Sedona, AZThe pilot's failure to maintain an adequate clearance from obstructions and diverted attention while taxiing.NTSB MIA06CA129Accident · No injuriesData collectionFinal reportTharp S Richard Challenger II · Apopka, FLThe pilot's inadequate selection of a landing area which resulted in one of the seaplane's floats impacting a submerged stump.NTSB NYC06LA066Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Henderson, WVThe pilot's improper decision to attempt the off-airport takeoff; and his improper decision to continue the takeoff after striking a pole during the takeoff roll.NTSB LAX06CA083Accident · No injuriesData collectionFinal reportPiper J5 · Carefree, AZthe pilot's selection of unsuitable terrain for the precautionary landing and failure to avoid obstacles during the landing roll.NTSB DEN06IA034Incident · No injuriesIncident investigationFinal reportBoeing B777-200B · Denver, COthe truck driver's failure to maintain clearance from the airplane and the boom operator's failure to adequately clear the boom from the airplane. Contributing to the accident was the low visibility due to snow and mist.NTSB ANC06LA016Accident · No injuriesLimited investigationFinal reportCessna S-550 · Anchorage, AKA failure of the driver of a snowplow vehicle to maintain adequate visual lookout while maneuvering on an airport hangar ramp, which resulted in a collision with the accident airplane as it was being marshaled into parking.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB ANC06CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground collision with trees during the landing roll. Factors associated with the accident were the icy and snow-covered terrain.NTSB NYC06LA042Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Dunkirk, NYThe Piper Malibu pilot's failure to use the correct radio frequency for traffic advisories, and his selection of the wrong, inactive runway, which resulted in an on-ground collision with another airplane while landing.NTSB ATL06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-2S2F · Memphis, TNThe improper towing of the airplane by the tug operator which resulted in the shearing of the towbar shear pin and subsequent collision of the airplane and tug.NTSB LAX06CA057Accident · No injuriesData collectionFinal reportGrafton Rand KR-1 · El Cajon, CAThe pilot's attempt to turn off the runway at an excessive taxi speed.NTSB LAX06CA062Accident · No injuriesData collectionFinal reportRyan Navion · Los Angeles, CAthe pilot's failure to maintain adequate clearance from a parked vehicle.NTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.NTSB DEN06IA020Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Denver, COthe pilot's failure to maintain clearance from the taxiway light. Factors contributing to the incident were the crew's inadequate visual lookout and the taxiway light.NTSB CHI06LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-10 · Chicago, ILThe failure of the flight crew to see and avoid the crew stairs and the failure of unknown persons to properly secure the stairs after use. Factors associated with the accident were the dark light conditions and the gusty winds.NTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.NTSB DEN06IA019Incident · No injuriesIncident investigationFinal reportBeech 1900D · Telluride, COThe tug driver's failure to maintain adequate clearance from the airplane resulting in the baggage cart striking the airplane's stabilon. A factor contributing to the incident was the tug driver's failure to consider the extra height of the cart in relation…NTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.NTSB DFW06CA016Accident · No injuriesData collectionFinal reportCessna 210L · Baker, LAThe pilot's failure to maintain clearance during takeoff roll.NTSB ANC06CA008Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable taxi area, which resulted in an encounter with a hidden obstruction, and an on-ground collision with trees while taxiing to takeoff. Factors associated with the accident were trees and a hidden obstruction.NTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.NTSB NYC06LA011Accident · No injuriesLimited investigationFinal reportBeech 1900D · Ogdensburg, NYA collision with a coyote during the takeoff roll, which resulted in a nosegear collapse and subsequent impact with the runway. A factor was the nighttime condition.NTSB LAX06LA009Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the other flight crew to maintain an adequate clearance from obstructions while taxiing.NTSB DEN06IA008Incident · No injuriesIncident investigationFinal reportAirbus Industries A319-111 · Denver, COthe de-ice vehicle operator's failure to follow post de-icing procedures, resulting in a collision. Contributing factors were the fog, snow, and the de-icing vehicle.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB DFW05CA233Accident · No injuriesData collectionFinal reportIsrael Aircraft Industries 1124 · New Braunfels, TXThe airplane's collision with a coyote during the landing roll. A contributing factor was the prevailing night conditions.