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 SEA05CA186Accident · No injuriesData collectionFinal reportPiper PA-22 (20) · McCall, IDThe pilot's failure to maintain airspeed during takeoff. A wire fence was a factor in the accident.NTSB IAD05CA124Accident · No injuriesData collectionFinal reportCessna 421C · Readington, NJAn encounter with animals during the landing - flare/touchdown.NTSB CHI05LA238Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe flightcrew's failure to maintain clearance from a fence while taxiing.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.NTSB ANC05CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Aleknagik, AKThe pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…NTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…NTSB ANC05CA102Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Karluk, AKA collision with a deer on the runway during the landing roll, which resulted in substantial damage to the tail of the airplane.NTSB DEN05LA118Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Englewood, COthe pilot not maintaining clearance from the portable helipad during taxi after landing resulting in the airplane colliding with it. Factors contributing to the accident were the pilot's selection of a taxi route through a non-movement area, his inability to…NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB CHI05LA179Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Chicago, ILThe pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…NTSB ANC05CA089Accident · No injuriesData collectionFinal reportCessna 207A · Excursion Inlet, AKThe pilot's failure to maintain clearance from a building during taxi from landing, which resulted in structural damage to the left wing when it struck the building.NTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.NTSB LAX05LA218Accident · No injuriesLimited investigationFinal reportBoeing 727-230 · San Diego, CAthe inadvertent throttle movement by one of the flight crew and the captain's inadequate supervision during the engine start sequence.NTSB DEN05IA092Incident · No injuriesIncident investigationFinal reportBeech 1900D · Grand Junction, COthe flight crew's diverted attention while the number 2 engine was operating and failure to maintain aircraft control which resulted in an inadvertent taxi of the airplane into an airport security fence.NTSB CHI05LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Allegan, MIThe inadequate aircraft control by the PA-28-180 pilot while the airplane was stopped.NTSB DEN05IA098Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Salt Lake City, UTthe left wing walker's failure to maintain an adequate visual lookout. Contributing factors were his inadequate initial training, and the failure of other ground personnel to follow company procedures/directives.NTSB DEN05IA084Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-202 · Denver, COThe improper procedures conducted by the ground personnel and the flight crew's failure to coordinate procedures with the ground personnel during push back operation which resulted in the collision between the ground support vehicle and the airplane. A…NTSB LAX05CA182Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oxnard, CAthe pilot's failure to maintain an adequate clearance from the building. The pilot's diverted attention was a factor.NTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.NTSB DEN05IA076Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Denver, COthe improper use of procedure used by the ground personnel resulting in the right wing of the aircraft colliding with the left wing of another aircraft. A factor in this incident was the failure to maintain clearance by the flight crew of the other aircraft.NTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…NTSB DFW05LA117Accident · No injuriesLimited investigationFinal reportRockwell International NA-265-80 · Brownwood, TXThe loss of engine power due to damage to the first stage compressor by a foreign object (bird).NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB ANC05CA069Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from a sign while taxiing from landing, which resulted in an on ground collision with the sign.NTSB DEN05IA071Incident · No injuriesIncident investigationFinal reportBoeing 737-282 · Denver, COthe improper operation of the loading bridge which resulted in the loading bridge impacting the airplane. Contributing factors were the failure of the ground personnel to marshal the airplane on the assigned aircraft stop line, lack of supervision and…NTSB MIA05LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Miami, FL"This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.NTSB NYC05LA061Accident · No injuriesLimited investigationFinal reportBoeing 737-72T · Newark, NJThe Boeing flightcrew's misjudged clearance of the parked Gulfstream during taxi, which resulted in a ground collision.NTSB DFW05CA076Accident · No injuriesData collectionFinal reportCessna 172 · Marshall, TXThe pilot's improper engine starting procedure resulting in a loss of control.NTSB NYC05LA043Accident · No injuriesLimited investigationFinal reportBoeing 737-247 · Covington, KYThe catering truck driver's failure to maintain clearance of the parked airplane by his inadvertent depressing the accelerator. A factor in this accident was the catering truck driver's diverted attention.NTSB NYC05LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Providence, RIThe vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.NTSB NYC05LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Philadelphia, PAThe failure of the ground controller to coordinate the runway crossing of a maintenance tug, with the local controller, which resulted in a ground collision with an MU-2 airplane during it's takeoff roll.NTSB IAD05CA019Accident · No injuriesData collectionFinal reportEmbraer EMB-135BJ · Cleveland, OHThe pilot in command's improper decision to continue taxi without a ground marshaller, and her misjudged clearance from a parked airplane, which resulted in a ground collision during taxi. Factors which contributed to the accident were fatigue, night…NTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB IAD05CA014Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.NTSB CHI05CA031Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Sikeston, MOThe pilot not maintaining his visual lookout and not maintaining clearance from the pole during his taxi to park from a landing. A factor was the pole he impacted.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB NYC05LA013Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAThe flightcrew's misjudged clearance from a parked airport vehicle while taxiing. A factor was the vehicle operator's improper decision to park within a taxiway safety area.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.NTSB NYC05CA007Accident · No injuriesData collectionFinal reportBeech A23 · New Market, VAA collision with a deer during the takeoff roll. A factor in the accident was the night.NTSB CHI05CA007Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Port Austin, MIThe pilot's excessive airspeed during landing resulting in the airplane exiting the end of the wet turf runway. Factors were the wind gusts, the wet grass, the reported airplane braking not being possible on the wet grass, and the impacted fence.NTSB ANC04CA114Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Willow, AKThe pilot's selection of an unsuitable landing area, which resulted in an on-ground collision with trees during the landing roll. A factor associated with the accident were trees.NTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.NTSB LAX04CA317Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Monterey, CAthe pilot's failure to maintain proper alignment with the taxiway and adequate obstacle clearance. A factor was the bright morning sunglare.NTSB ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.