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 FTW82DA247Accident · No injuriesFinal reportCessna 172 · Houston, TXAfter the student pilot returned from a cross-country. He taxied into the parking area, but noticed there were no parking spaces available. While making a 180 deg turn, the right wing struck a fence post. After hitting the post, the plane turned and the…NTSB CHI82DER20Accident · No injuriesFinal reportCessna 188B · Hallock, MNDuring landing roll to investigate a stalled truck, the aircraft collided with the truck which backed into the aircraft's roll out path. After the collision, the aircraft ran into a ditch.NTSB LAX82DA212Accident · No injuriesFinal reportCessna 185 · Anza, CAThe student, a rated pilot, and his instructor landed on an unimproved private strip which was at an elevation of about 4750 ft MSL. After landing, the pilots walked through the airstrip and discussed the condition of the strip. There was tall grass on the…NTSB MIA82FKT10Accident · Minor injuriesFinal reportCessna 172RG · Labelle, FLThe pilot and two passengers planned to depart on a flight to spot hogs for hunters. The aircraft was loaded with about 50 gallons of fuel and was near its maximum gross weight. Before takeoff, the pilot noted the wind. He reported that it was light and…NTSB CHI82DA188Accident · No injuriesFinal reportPiper PA-34 · Springfield, ILAfter landing the pilot attempted to taxi the aircraft back to the ramp area in heavy rain and reduced visibility. The aircraft taxied off the left side of the runway and struck two runway lights.NTSB LAX82DA180Accident · No injuriesFinal reportCessna 172 · Bakersfield, CAThe student pilot had been cleared to land at meadows field but landed five miles to the south-southeast at Bakersfield airpark. Upon taxiing back to takeoff the left wing collided with a backhoe which was working alongside the runway installing a lighting…NTSB ANC82DAG25Accident · No injuriesFinal reportCessna 180C · Latouche Island, AKA takeoff was initiated from a dry gravel strip in calm wind conditions. The pilot reported that just prior to lift-off, the main landing gear rolled over a 2 x 12 inch board that flipped up and struck the right elevator. Reportedly, a part of the elevator…NTSB MKC82IA079Incident · No injuriesIncident investigationFinal reportCessna 402B · St. Louis, MOWhile taxiing in close to deplane his passengers, the commuter pilot pulled in behind a parked northwest orient 727. As he approached the rear of the 727, the pilot turned the Cessna 402B to the right so that the passenger door would be facing the gate. As…NTSB NYC82FNA13Accident · No injuriesFinal reportBeech E33 · Bedford, MAThe pilot was unable to start the aircraft with the electric starter when the battery had insufficient power to crank the engine. The pilot stated that he shut off the battery and alternator switches, turned off the magneto switch, and removed the keys. He…NTSB NYC82DHA09Accident · No injuriesFinal reportBryan HP-18 · Hazelton, PAThe pilot departed blairstown, PA on a round robin, triangular course to bethel and dallas, PA and return to blairstown. He stated that while he was proceeding from bethel to dallas he encountered heavy sinking conditions in addition to a head wind.…NTSB FTW82FQA18Accident · 1 fatalFinal reportBlanik L-13 · Los Lunas, NMDuring landing the left wing struck a bystander who wandered onto the edge of the asphalt overrun taking photographs of the landing. There is a caution sign posted on the north access road of the runway.NTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…NTSB NYC82FGT14Accident · No injuriesFinal reportChristian Eagle II · Lancaster, PAAfter taking off from runway 31, the pilot proceeded to an area where he performed inverted flight in an attempt to find a dime that may have been dropped in the cockpit. During his departure and arrival, he and a tower controller discussed and joked about…NTSB FTW82DA154Accident · No injuriesFinal reportPiper PA-44-180 · Albuquerque, NMThe purpose of the flight was for the pilot-in-command to take his multi-engine airplane check ride. During the takeoff sequence, the examiner reduced power on one engine. The pilot decided there was insufficient runway remaining and aborted the takeoff. The…NTSB NYC82FHJ04Accident · Minor injuriesFinal reportBell 206L · New York, NYThe accident involved two Bell 206L helicopters that were parked beside one another, but headed in opposite directions. When the pilot of N49575 arrived, the other helicopter, N16696, was operating with the rotors at about 60% RPM (flight idle) while…NTSB FTW82FPD10Accident · No injuriesFinal reportPiper J3C-65 · Grand Prairie, TXWhile the pilot was taxiing to the engine run-up area, his right wing struck the propeller of a Piper PA-24 (N7545P) that was positioned at the edge of the taxiway. The pilot believed that if he had been making sharper s-turns while taxiing, he would have…NTSB MIA82DA100Accident · No injuriesFinal reportPiper PA-28-140 · Lake Wales, FLDuring takeoff, three/fourths of the way down the runway, the pilot decided to abort because of a slow buildup of airspeed on the wet grass. The aircraft overran the runway colliding with a fence and a tree.NTSB MIA82DA104Accident · No injuriesFinal reportLuscombe 8A · Panama City, FLThe pilot elected to make a precautionary landing on a highway median due to low fuel and weather conditions. During the landing roll the aircraft collided with marker posts and nosed over.NTSB CHI82DA126Accident · No injuriesFinal reportRaven RX-6 · Sellersburg, INDuring a landing approach, the pilot was aware of powerlines to the left of his course. Just prior to touchdown, he became aware of a branch off of the powerlines that crossed in front of the balloon's path. He ripped out the top inflation panel; however,…NTSB ATL82FLG11Accident · No injuriesFinal reportPiper PA-34-200J · Columbia, SCAfter landing at night, the pilot was cleared to a parking area. A lineman with wands responded to assist. While attempting to follow the signals from the lineman, the pilot taxied into another aircraft.NTSB LAX82FVD15Accident · No injuriesFinal reportRutan Varieze · Concord, CAThe pilot stated that during landing the aircraft was in a nose high attitude, thus obstructing his view of the runway. By the time he got the nose down enough to see over it, the aircraft was drifting off the right side of the runway. He applied left braking…NTSB FTW82DA120Accident · No injuriesFinal reportCessna 210A · Rock Springs, TXThe pilot became disoriented during a cross country flight. He decided to make a precautionary landing in a clearing. During the landing roll the left wing collided with a tree.NTSB FTW82DA118Accident · No injuriesFinal reportAir Tractor AT-400 · Edna, TXThe aircraft landed on an unlighted strip at dusk and collided with a truck. Landing lights on the aircraft were unusable because of a generator failure.NTSB MKC82DA054Accident · No injuriesFinal reportCessna 340A · Lincoln, NEThe pilot tookoff from runway 17L at 1705 CST. After takeoff, he encountered a vibration. He decided to land and was cleared for runway 14. Reportedly, the vibration increased at 130 knots. The pilot reduced the power to decrease his speed and remain under…NTSB MKC82DA052Accident · No injuriesFinal reportCessna 182RG · Gurley, NEDuring takeoff from a wheatfield the left gear hit a rut and the pilot lost control. The takeoff was aborted and the aircraft traveled across a road and through a fence.NTSB MIA82DA098Accident · No injuriesFinal reportCessna 172 · Ormond Beach, FLAfter landing the aircraft, one of six on a night cross-country flight, the pilot taxied back to the approach end of the runway for takeoff. N129ER was parked at the approach end awaiting takeoff sequence so the pilot of N23ER stopped about 30 yards behind it…NTSB MIA82DA103Accident · No injuriesFinal reportPiper PA-31-350 · Miami, FLThe pilot was taxiing to gate H-2 to pick up a charter passenger when the aircraft and a vehicle collided. The pilot reported that about five seconds before impact, he saw the vehicle approaching from his ten o'clock position. He applied the brakes, but the…NTSB LAX82DA118Accident · No injuriesFinal reportCessna 172 · Dilkon, AZThe pilot elected to land on a paved road and during the landing roll collided with a road sign.NTSB NYC82DA066Accident · No injuriesFinal reportBeech A23-24 · Lock Haven, PAWhile taxiing for takeoff the left wing of the aircraft collided with the nose of a parked Piper twin. The pilot stated that during his instrument scan he noticed that the alternator failed to show a charge and that this may have distracted his attention as…NTSB NYC82IA058Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Bayport, NYThe pilot taxied into the parking area and stopped in a position that was facing Cessna 172, N7909G. The pilot of N40627, while sitting in the aft seat, reached forward and accidently caught his coat sleeve on the throttle. The throttle was pushed forward.…NTSB MKC82DA044Accident · No injuriesFinal reportHelio H-295 · Ozark, MOThe driver of the automobile parked on the east end of the east/west runway to watch aircraft taking off and landing on the north/south runway. After landing on the south end of the n/s runway, the pilot taxied to his right around a group of hangars and onto…NTSB FTW82DA092Accident · No injuriesFinal reportColonial C-1 · Grand Prairie, TXDuring a landing on mountain creek lake, the aircraft struck a submerged object in the water. The plane was taxied to a boat ramp. An inspection revealed that the hull was dented, a nose gear door was bent, and two bolts on the left wing sponson had failed.NTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…NTSB LAX82DA097Accident · No injuriesFinal reportCessna 150 · Half Moon Bay, CAThe pilot of Taylorcraft, N94906, was making mild s-turns as he proceeded down a taxiway. As he was making an s-turn back to the right, he saw a Cessna 150, N5678E, at the right edge of the taxiway on a converging course. He turned left to avoid a collision,…NTSB MIA82DA081Accident · No injuriesFinal reportCessna 152 · Brooksville, FLWhile taxiing for takeoff on a road used for aircraft and vehicles the aircraft collided with a parked garbage truck.NTSB LAX82DA112Accident · No injuriesFinal reportPiper PA-28-161 · Glendale, AZWhile taxiing for takeoff, the right wing of the aircraft collided with a sign that was located beside the taxiway.NTSB LAX82DA090Accident · No injuriesFinal reportSchweizer SGS1-260 · Phoenix, AZDuring the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther.NTSB LAX82DA089Accident · Minor injuriesFinal reportBarnes Balloon AX7 · Napa, CAThe pilot attempted to land short of powerlines after aborting an ascent to safely clear them because of what he reported as unstable air. The gondola bounced and slid into the wires. The pilot stated that electric current passed through the load lines and a…NTSB FTW82DA066Accident · No injuriesFinal reportCessna A185F · Near Patterson, LAAfter landing the pilot began to step taxi on an unfamiliar canal to a drilling rig location. While negotiating a turn in the canal, the left wing struck a tree limb. The aircraft veered to the left and the right wing dropped and hit the water.NTSB MKC82DA037Accident · No injuriesFinal reportCessna 150 · Grain Valley, MOThe pilot was attempting to taxi his aircraft back to its tiedown space through 6 to 8 inches of snow. While maintaining clearance on an aircraft on his right the left wing tip struck the tail of a Cessna 140.NTSB SEA82DA028Accident · No injuriesFinal reportBoeing A75N1 · Medford, ORAfter landing the pilot of Taylorcraft, N9507B, was cleared to proceed to his parking area. At 1054:50, ground control advised him of stearman, N56270, approaching from the opposite direction. The Taylorcraft pilot adjusted his taxi path to the right of the…NTSB LAX82DA065Accident · No injuriesFinal reportCessna 180 · San Jose, CABellanca N71681 was awaiting clearance for takeoff when Cessna N3343D taxied into the turning propeller during a positioning maneuver.NTSB LAX82IA062Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201T · Truckee, CADuring the landing roll the aircraft veered sharply to the left and struck a snowbank, collapsing the nose and left main landing gear. Inspection of the runway revealed the presence of several large ice chunks adhering to the runway surface.NTSB LAX82DVG15Accident · No injuriesFinal reportAeronca 7AC · Redding, CAWhen the pilot hand propped the aircraft to start the engine, it began rolling and struck Cessna 206, N732TQ.NTSB MIA82FKA05Accident · 1 fatalFinal reportCessna 206 · Saint CroixAircraft landed during darkness before control tower had opened. While taxiing to ramp, aircraft was struck by an ambulance as aircraft was crossing parallel taxiway. Aircraft immediately burst into flames, and ambulance continued to travel through the…