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 NYC83LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Little Ferry, NYStudent pilot step-taxiing from landing collided with a submerged object in the river and damaged the float. The river was at low tide.NTSB CHI83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Boonville, INOn takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over.NTSB NYC83IA013Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Augusta, METhe student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…NTSB LAX83LA017Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Valley, AZPilot could not get aircraft started so he got out and pulled prop. Engine started and with no one aboard the aircraft taxiied into two parked aircraft.NTSB ATL83LA015Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · N. Myrtle Beach, SCThe pilot set the parking brake after starting the aircraft and diverted his attention to the checklist. When he looked up the aircraft was moving. The pilot attempted to stop the aircraft by both pushing the toe brakes and pulling the parking brake. The…NTSB CHI83LA021Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Indianapolis, INThe left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.NTSB FTW83LA013Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Houston, TXThe pilot had taxied onto taxiway lima and had stopped short of runway 13R/31L to hold for landing traffic. At about the same time, an airport employee was proceeding down the runway from northwest to southeast to check the runway lights. The ground…NTSB SEA83LA005Accident · No injuriesLimited investigationFinal reportBeech C35 · Seattle, WAWhile hand propping to start, the engine went to full power. The pilot gained access to the controls as the aircraft began to move against the locked brakes. However, he was unable to stop the plane before it hit a Beech 58P, N3664G. The pilot reported that…NTSB LAX83LVD02Accident · No injuriesFinal reportCessna 172 · Gualala, CACessna 172, N29150, & Piper PA-28, N8465Y, were both departing from a pvt, unctld arpt at the same time, but from opposite drctns on the same rwy. Th rwy was crowned in the center which prevented line-of-sight to acft on opposite ends. Each plt stated that he…NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB LAX83LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Peoria, AZWhile taxiing to the ramp the aircraft's left wing struck a chain link fence causing substantial damage to the aircraft.NTSB LAX83LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Palm Springs, CAWhile taxiing for takeoff the aircraft's left wing struck the nose of a Cessna 337, N547SE, which spun to the left and damaged a Piper PA-28, N8163E. The pilot stated that the Cessna 337 was 3 1/2 feet beyond alignment with other aircraft and extended into…NTSB MKC82DA177Accident · No injuriesFinal reportPiper PA32RT-300 · Excelsior Sprin, MOPilot did not attain enough airspeed and aborted takeoff too late to stop before going off end of runway into bushes, damaging landing gear.NTSB CHI82DA369Accident · No injuriesFinal reportPiper PA-25-180 · Baldwin, WIThe pilot attempted to takeoff from a 1200 ft alfalfa field with a load of seed but was unable to obtain flying speed. By the time he realized the situation, there was not enough room to stop. He reported that he released the back pressure until he was near…NTSB ATL82DA286Accident · No injuriesFinal reportPiper PA-32RT-300T · Athens, GAThe pilot initiated an intersection takeoff with 1400 ft of runway remaining. After starting the takeoff, he elected to abort; however, the aircraft continued off the end of the runway and collided with obstacles. The performance charts showed that a 3000 lb…NTSB ANC82DAG58Accident · No injuriesFinal reportThurston TSC-1A · Homer, AKDuring a water takeoff, the aircraft impacted a large wave unexpectedly. Witnesses stated that the aircraft was thrown to a height of approximately 12 feet. The pilot stated that the airspeed was about 40 to 45 knot's at the time of impact with the wave. He…NTSB ANC82DAA16Accident · No injuriesFinal reportPiper 18 · Kotzebue, AKThe pilot attempted a takeoff from a rough dirt strip approximately 1000 feet in length. The wind was blowing from the east and the takeoff was to the southwest due to the downhill slope of the runway. The aircraft lifted off at an unknown airspeed…NTSB FTW82DA378Accident · No injuriesFinal reportCessna 180K · New Iberia, LAThe plt encountered detreiorating visibility due to fog & haze & decided to make a precautionary landing on the intracoastal waterway. The plt stated he was blinded by the reflected light when he turned on his landing light & did not see the pilings which…NTSB NYC82DA231Accident · No injuriesFinal reportPiper PA-38-112 · Pomona, NJWhile taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.NTSB CHI82DA346Accident · No injuriesFinal reportPiper PA-23-250 · Holland, MIPilot taxiing to takeoff collided with fuel pumps.NTSB MKC82DA172Accident · No injuriesFinal reportErcoupe 415C · Andover, KSPilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred.NTSB FTW82DA368Accident · No injuriesFinal reportBellanca 8GCBC · Katy, TXN1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to…NTSB SEA82DA154Accident · Minor injuriesFinal reportCessna R172K · Brownsmead, ORThe pilot reported that about 30 minutes after takeoff, the engine sputtered and quit. The aircraft was damaged from a landing on rough terrain. During an investigation, only about two pints of fuel were found in the aircraft.NTSB SEA82DYK12Accident · No injuriesFinal reportCessna 210 · Rosenburg, ORThe pilot attempted to hand start the aircraft due to a weak battery. The pilot told passenger to hold the brakes and assumed the passenger knew how, because of his many hours of flight time (as a passenger). When the engine started the aircraft began to move…NTSB SEA82DA150Accident · No injuriesFinal reportPiper PA-28-161 · Auburn, WAN1338J experienced a brake line failure and taxied into Piper PA-28, N8316A, that was parked in the warm-up area. There were no injuries.NTSB CHI82DA291Accident · No injuriesFinal reportCessna 172M · Strongsville, OHThe aircraft was on a local flight from an uncontrolled airport. The wind was from 320 deg at 11 KTS. During arrival, the pilot elected to make a straight-in landing on runway 36. At about the same time, a Cessna 172, N20374, was landing from a normal pattern…NTSB FTW82DA339Accident · Minor injuriesFinal reportNorth American AT-6A · Abilene, TXThe pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.NTSB FTW82DA337Accident · No injuriesFinal reportCessna 177RG · Afton, TXWhile en route, the piiot encountered severe weather and landed on a paved road. He stated that after about 2 hrs, the weather improved and he decided to taxi to an area where he could takeoff. While taxiing, the left wing struck a tree which pulled the…NTSB ATL82DA240Accident · Minor injuriesFinal reportCessna 180 · Grand Bay, ALReportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he…NTSB NYC82DA196Accident · No injuriesFinal reportPiper PA-28-161 · Wilkes Barre, PAThe student pilot stated that as he began to taxi, he proceeded about 35 ft and then the aircraft suddenly veered to the left as if the wheel had locked. He applied right rudder, then right brake. However, the aircraft struck a building and an automobile.NTSB NYC82DA192Accident · No injuriesFinal reportde Havilland DH-114 · Sidney, NYWhile taxiing on the ramp the plt experienced a brake failure & the acft collided with several parked acft. The brake system is air operated & a small threaded rod with a small locking screw disconnected from the brake valve.NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…NTSB DEN82DA157Accident · No injuriesFinal reportCessna 172 · Grafton, NDThe pilot stated that when he began to taxi he noticed a Cessna 172 with its engine running in front of a hangar, about 500 feet ahead and to his left. Continuing his taxi, the pilot's attention was diverted by an aircraft on the right. When he looked forward…NTSB FTW82DA307Accident · No injuriesFinal reportCessna 182M · Calumet, OKWhen the pilot landed on a 2000 ft private strip, the left wing of the aircraft struck a tree that was located beside the landing area. After impact the aircraft traveled approximately 100 ft before coming to rest. Both wings, propeller, cabin section and…NTSB ATL82IA218Incident · No injuriesIncident investigationFinal reportCessna 152 · Hampton, GADuring taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…NTSB ANC82DA069Accident · No injuriesFinal reportAeronca Champ 7EC · Lake Clark, AKDuring takeoff the aircraft contacted willow trees which swerved the aircraft farther into brush. The pilot aborted the takeoff and braked to a stop. Engine fire started which consumed the aircraft.NTSB NYC82DA164Accident · Minor injuriesFinal reportCessna 172N · Jamaica, NYAn airport operations agent, in a port authority automobile monitored ground control conversation with the pilot and offered to assist N9426E in locating the active runway. When approaching the lost aircraft's position the vehicle driver experienced sun glare…NTSB MKC82DA132Accident · No injuriesFinal reportCessna 150 · Davenport, IAUnauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is…NTSB ATL82DA213Accident · No injuriesFinal reportSchweizer SGS-2-33A · Little River, SCDuring the landing roll, the left wing of the glider struck the left wing of another glider of the same make and model. The other glider, N1211S was being readed for a flight and was positioned with its left wing overlapping the runway. The pilot of N1211S…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB ATL82DA206Accident · No injuriesFinal reportPitts S2S · Somerville, TNShortly after touchdown during a formation landing, the wingman's aircraft struck an engine stand that had been placed over a hole in the runway. The hole was located about 900 ft from the approach end and was about 2 ft long, 1 ft wide, and 1 ft deep. It was…NTSB ATL82DA205Accident · No injuriesFinal reportBeech J35 · Birmingham, ALThe pilot reported that he had received an instrument clearance before starting the engine and noted that the battery was weak. He reported that he decided to pull the propeller through and turned the ignition switch toward the off position. As the propeller…NTSB CHI82DA257Accident · No injuriesFinal reportBeech 36 · Ypsilanti, MIAfter the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,…NTSB ANC82DA061Accident · No injuriesFinal reportCessna 180 · Soldotna, AKAfter landing at a private airstrip the pilot taxied into a parked truck. The left wing of the aircraft was substantially damaged.NTSB LAX82DA252Accident · No injuriesFinal reportPiper PA28-201T · Aguila, AZThe plt stated he overflew the rwy to check the windsock which indicated a landing on rwy 17. During the apch he encountered severe turbulence, gusty & variable winds. Noticing that the windsock indicated a severe x-wind the plt executed a go-around &…NTSB LAX82DA248Accident · No injuriesFinal reportBeech 77 · Healdsburg, CAWhile taxiing past parked planes on the right, the student was distracted by a plane being towed out of a hangar on the left. The propeller of the BE-77 heavily damaged 8 ft of the right wing of a parked PA-28, N8118S.NTSB FTW82DA269Accident · No injuriesFinal reportPiper J3L-65S · New Orleans, LAAfter landing the float plane on a bayou, the pilot started to taxi past an anchored barge on the waterway. The barge was used to support a shrimp net framework. While passing the barge, the right wing of the aircraft struck the framework and was damaged.NTSB DEN82DA129Accident · No injuriesFinal reportPiper PA-32-260 · Broadus, MTDuring a landing the aircraft collided with bales of hay along the left side of the runway, collapsing the left landing gear. Later his instructor informed him he had developed a habit of landing on the left side of the runway.NTSB FTW82DRJ19Accident · No injuriesFinal reportBoeing B-75 · Lufkin, TXN733BD was holding for the active runway when N59257 taxied into the tail of the aircraft. N733BD received substantial damage and N59257 received minor damage.NTSB DEN82FTE19Accident · Serious injuriesFinal reportCessna 182 · Loma, COThe pilot while attempting to straighten the aircraft and go around collided with small trees and nosed over. The pilot stated that probably the indecision of trying to stop or abort the landing slowed the aircraft during the attempted go around.