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 LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.NTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.NTSB NYC02LA172Accident · No injuriesLimited investigationFinal reportCessna 500 · Sandusky, OHA collision with a deer during a night takeoff.NTSB IAD02LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Williamsport, PAThe student pilot's failure to maintain adequate clearance from a building while taxiing.NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB SEA02LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Quincy, WAThe pilot's failure to maintain the proper descent rate during the descent for landing. A proper glide path was not attained, inadequate remedial action, and a fence were factors.NTSB SEA02LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Cascade, IDThe pilot's failure to maintain directional control during the takeoff ground run. Wind gusts and a tree were a factor.NTSB NYC02LA146Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Charleston, WVThe vehicle driver's failure to maintain clearance of the airplane.NTSB ANC02LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's selection of an unsuitable area for taxiing, which resulted in running the airplane's float aground. Factors contributing to the accident were the hidden obstructions underwater, and the excessive taxi speed.NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.NTSB CHI02LA173Accident · No injuriesLimited investigationFinal reportBeech BE90 · Roseau, MNAn inadvertent collision with a deer during the landing roll.NTSB CHI02LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Minneapolis, MNThe pilot did not maintain clearance from the vehicle while taxiing. A factor was the fuel truck.NTSB NYC02LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe student pilot's failure to maintain adequate clearance while maneuvering to avoid obstructions.NTSB CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB FTW02LA166Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Nageezi, NMthe pilot's failure to select a suitable landing site, which resulted in a collision with a fence.NTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.NTSB CHI02LA128Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe ground personnel handled the aircraft improperly during pushback from the gate by failing to maintain clearance with the other parked aircraft. The light rain and the parked airplane that was contacted were factors.NTSB ANC02LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe pilots improper starting procedure. Factors associated with the accident are the continued operation of the airplane with a known mechanical deficiency, and failure to use wheel chocks and/or tie-down rope/straps to restrain the airplane during the engine…NTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.NTSB NYC02LA096Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHIngestion of birds into both engines.NTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB NYC02LA081Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Louisa, VAThe airplane's inadvertent collision with a deer while landing at night. A factor in the accident was the night condition.NTSB LAX02LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodyear, AZThe student pilot's misjudgment of clearance and his failure to adhere to the flight school's policy/procedures for taxiing around obstructions.NTSB CHI02LA115Accident · No injuriesLimited investigationFinal reportCessna 551 · Lake in Hills, ILThe deer on the runway.NTSB FTW02LA094Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the tug driver to stop at the stop sign resulting in a collision with a taxiing airplane. A contributing factor was the dark night light conditions.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.NTSB SEA02LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Longmont, COThe pilot's failure to maintain directional control of the aircraft during landing. Factors were a contaminated runway, which was icy and covered with snow, and a snow bank.NTSB SEA02LA049Accident · No injuriesLimited investigationFinal reportBoeing 757-200 · Seattle, WAThe failure of the deicing truck driver to insure that the deicing basket boom remained clear of the aircraft structure as he backed away from the position he had been in while performing deicing procedures.NTSB LAX02LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Peoria, AZFailure of the cyclist to coordinate and communicate that he was on the active runway. A contributing factor was the sun glare encountered by the pilot on final approach.NTSB CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.NTSB SEA02LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-24-180 · Scappoose, ORThe pilot's failure to tie down the aircraft prior to hand propping the engine. Factors were a fence, trees, and the pilot's inadequate preflight planning/preparation.NTSB NYC02LA057Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Point Pleasant, WVAn inadvertent collision with a deer while landing at dusk. A factor in the accident was the dusk light condition.NTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.NTSB IAD02LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Doylestown, PApilot's failure to maintain clearance between the airplane and a parked fuel truck while taxing.NTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…NTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB NYC02LA047Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-227-AT · Covington, KYthe tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.NTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.NTSB SEA02LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAThe student pilot misjudged the distance from a fence during taxi. The flight instructors inadequate supervision and the fence were factors.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB MIA02LA024Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with vehicles.NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.NTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.NTSB MIA02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway, impacting with a windsock, and nosing over in soft terrain.NTSB DEN02LA006Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Casper, WYThe pilot's failure to maintain clearance from another parked airplane while taxiing. Contributing factors were the night light conditions, and the pilot's fatigue from a long day.NTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.