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 FTW84LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Slidell, LAThe acft collided with submerged objects during takeoff. The takeoff was aborted and the acft ran up on the bayou bank where it collided with trees.NTSB NYC84LA020Accident · No injuriesLimited investigationFinal reportCessna 340 · Washington, PAThe pilot said that when about 8 miles out he called UNICOM to report in and receive advisories. He was told that horseshad been chased off the runway earlier and to use caution. During the approach he came in high and touched down about 700 feet down the…NTSB LAX84IA040Incident · No injuriesIncident investigationFinal reportBoeing 767 · San Francisco, CADuring pushback the right wingtip of the Boeing 767 struck the rudder of a Douglas DC-9 parked at the adjacent gate. The B-767 was being pushed back by two mechanics, one on thetug & one under the left wing.NTSB FTW84LA041Accident · No injuriesLimited investigationFinal reportCessna 180K · Patterson, LAAfter landing, the plt was step taxiing the float plane around a slight curve in the canal. As the acft went around the curve, the sun was in the plt's eyes & he did not see a piling until it was directly ahead. He took evasive action, but the left wing…NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB LAX84LA033Accident · 1 fatalLimited investigationFinal reportCessna 401 · San Diego, CAAfter touchdown during a night landing, the plt was lowering the nosewheel to the rwy when he saw a mexican national crossing the rwy. The plt swerved to the left in an attempt to avoid a collision; however, the right wing struck the person which resulted in…NTSB LAX84IA036Incident · No injuriesIncident investigationFinal reportBeech 200 · San Francisco, CADuring taxi after landing the right wingtip hit a steel awning support.NTSB ATL84IA029Incident · No injuriesIncident investigationFinal reportCessna 150M · Mobile, ALThe acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot.NTSB ANC84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKDuring a night landing. The non-rated plt accidently selected the taxiway, and subsequently, the acft collided with a parked airplane. The acft was equipped with ski gear only & it had no landing light installed. Also, the arpt was not lighted & had no snow…NTSB FTW84LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Spring, TXThe plt stated that while he was taxiing to takeoff, he misjudged his clearance from a 6 ft x 6 inch concrete block. The left brake housing hit the block which resulted in damage to the wing spar. He did not examine the acft until after the flt & was unaware…NTSB LAX84LA009Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Fresno, CAA flt of 5 North American SNJ-2 acft were on a flt from long beach to Fresno, CA. By prior arrangement, the lead plt in N61563 was to handle the radio communication with ATC facilities. During arrival at Fresno, the local controller inquired whether the group…NTSB CHI84LA013Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Delaware, OHThe plt of American AA-1A, N9237L, departed the traffic pattern, while turning base, because of traffic taxing on the rwy. He re-enter the pattern on downwind & continued, but did not see a Piper PA-38, N2333B, that entered the pattern. The PA-38 pilot also…NTSB CHI84LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ypsilanti, MIThe acft was struck by a truck as it taxied on the ramp after landing. The fire department reported the truck left a 25 ft skid mark as it came out from an area of parked acft and struck N47519.NTSB MKC83LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOWhile taxiing off temporary rwy 22 the plt prematurely taxied into the taxiway leading to the air cargo ramp. In an effort to reach the general aviation ramp he turned onto a vehicle access road & the left wing struck a vehicular traffic warning sign.NTSB LAX83FA454Accident · Serious injuriesField investigationFinal reportCessna 150 · Mariposa, CAThe plt of a Cessna 150, N3382V, noted that the wind was calm, so he elected to enter traffic for rwy 8 to practice landings. He said he used the UNICOM freq to announce entering traffic from a 45 deg entry as well as advising of his position in the pattern.…NTSB FTW83LA434Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Cresson, TXDuring arrival, the plt elected to land on an unlighted arpt. After landing & while slowing, the acft drifted to the left side of the rwy. Subsequently, the acft went over a concrete curb & the left main gear failed.NTSB CHI83LA429Accident · No injuriesLimited investigationFinal reportCessna 150M · Anderson, INCessna 150, N45257, collided with Cessna 182, N2462G, at ace airpark. N45257 was in the process of landing and N2462G was in the takeoff phase of operation. Neither plt used the airport UNICOM. Both plts rept slightly different wx conditions.NTSB ANC83LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Big Lake, AKThe acft collided with bushes at the departure end of the rwy. The pilot told the investigator that he attempted to takeoff from the grass strip but aborted at the last moment. He said he was unable to stop the acft before striking bushes at the departure end.NTSB FTW83LA433Accident · No injuriesLimited investigationFinal reportCessna 182 · Monahans, TXN3447R collided with a hanger after the plt hand propped the unoccupied and unchocked acft. The plt stated that the acft's battery was too weak to turn it past the compression stroke. The plt got out to pull the prop through top dead center and it started.…NTSB CHI83LA400Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Blair, WIThe acft collided with a fence during an aborted takeoff. The student was on a solo training flt when the accident occurred. This was the first takeoff of the flt. The field was soft and the pilot decided to abort the takeoff during the ground roll. He was…NTSB MIA83IA217Incident · Minor injuriesIncident investigationFinal reportSemco SEM 182 · Palm Beach, FLWhile being ground handled after landing a balloon contacted high tension high voltage wires.NTSB LAX83LA404Accident · No injuriesLimited investigationFinal reportCessna P21O · Goldfield, NVThe acft collided with a cattle guard during an attempted takeoff from a road. The plt elected the road rather than the airstrip which was made of gravel and was wet and muddy. He stated that there was about 4000 ft of flat straight road available and he set…NTSB MKC83LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · S. Sioux City, NEThe plt reported that during a touch-and-go landing on rwy 14 with a southerly wind at 8 KTS, he touched down about 1/4 of the way down the rwy with 20 deg of flaps. The temp was 93 deg & the density altitude was aprx 3800 ft. the plt did not raise the flaps…NTSB FTW83LA380Accident · No injuriesLimited investigationFinal reportMooney M-20C · Midland, TXThe acft collided with a fence post during taxi for takeoff. The acft was allowed to drift right of the center of the taxiway. The collision veered the acft to the right and damaged the wing. The accident occurred at dusk.NTSB ATL83LA323Accident · No injuriesLimited investigationFinal reportBellanca 8-KCAB-150 · Kennesaw, GABoth aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that…NTSB MKC83LA185Accident · No injuriesLimited investigationFinal reportDe Havilland DHG-6-300 · Kansas City, MOAs the aircraft was being parked, the outer portion of the right wing contacted the awning on a building.NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…NTSB CHI83LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Charlotte, MIDuring the takeoff portion of a night touch-and-go, the acft collided with a deer that ran into the acft.NTSB ANC83LA132Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Tyonek, AKAccording to the pilot, during takeoff at rotation the floats struck a sandbar. He lost control of the aircraft and it nosed over in the water.NTSB ATL83LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cornelia, GAThe left main gear reportedly jumped a partially obscured curb during a turn around at the end of the rwy after landing. The curb had been installed for erosion control for water runoff. The left wing and landing gear of the acft were damaged.NTSB LAX83FA349Accident · Minor injuriesField investigationFinal reportBeech C-45G · Kahalui, HIA Beech C-45G, N888M, call sign lani 8 and a Beech E185, N162SP, call sign lani 9 were part of a flt of 5 acft, with call signs of lani 6 thru 10, that where being used on an inter-island tour. The 1st act, lani 6, was cleared for takeoff & departed…NTSB NYC83IA182Incident · No injuriesIncident investigationFinal reportCessna 172XP · Mechanicville, NYAfter starting the engine and taxiing forward the pilot stated he pushed the trottle by mistake and the acft moved rapidy forward and struck a parked acft.NTSB MKC83IA159Incident · No injuriesIncident investigationFinal reportBoeing 727-231A · St. Louis, MODuring taxi, while being guided by a ground marshallers the tail of the acft hit the tail of another acft.NTSB LAX83LUQ05Accident · No injuriesFinal reportPiper PA-38-112 · Rosamond, CAA Piper PA-38, N9905T, and a Bellanca 8GCBC, N8667V, collided at the intersection of rwys 22 & 25, while the acft were landing. The Piper PA-38 was on a dual instructional flt while the Bellanca was being used to tow gliders. The aircrew in the PA-38 saw the…NTSB NYC83LA174Accident · No injuriesLimited investigationFinal reportCessna 150M · Atlantic City, NJAfter preflight and while the student plt was waiting for the CFI to board the acft he started the eng. The acft began to roll forward. The student, being unfamiliar with acft, could not stop the acft prior to colliding with the parked Cessna 182Q.NTSB FTW83FA324Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Azle, TXDuring a landing in light wind conditions, the balloon touched down beside a power line. After touchdown, the balloon envelope collapsed over the power line which carried 7200 volts. The voltage traveled to the basket/gondola which overturned on the grass…NTSB FTW83LA322Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMThe tow plane collided with a van on the rwy during takeoff. The van had been parked there on purpose by the arpt owner to close the rwy. He stated that he had notified the FAA of the closing but no NOTAM had been issued on 7/7/83. A NOTAM was issued for…NTSB ANC83FA113Accident · Minor injuriesField investigationFinal reportCessna 207A · Dillingham, AKThe acft collided with a beached unoccupied 18 ft skiff during a takeoff attempt from a soft beach. This acft is a 7 place model. At the time of the accident there were 12 occupants on board. The acft was not overweight because several occupants were children…NTSB MIA83LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Near Tampa, FLThe plt reported that before the flt, he had taken 2 sominex tablets, but had insomnia & could not sleep, even though he was very tired. He stated that after takeoff, he thought he was heading southeast, but later, he found out that he was going northeast.…NTSB MKC83LA141Accident · No injuriesLimited investigationFinal reportPiper PA-36 · St. Paul, NEThe plt stated that when he was unable to get takeoff speed he dumped his load, then hit a fence & fence posts. The acftwas estimated to be within the CG & gross weight limits. Two inspections of the eng revealed no malfunctions.NTSB LAX83IA316Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Los Angeles, CADuring taxi into the terminal the acft left wing hit a parked tow truck boom. The tow truck was not authorized to be parked in the clear zone due to its height.NTSB CHI83LA286Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dayton, OHThe acft collided with equipment when landing on a closed rwy at night. The plt of N4929V called Dayton approach regarding landing at Dayton general but did not receive info that the fld was closed. Another acft called ATC at about this time, without…NTSB FTW83FA303Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Houston, TXThe Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The…NTSB SEA83LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rome, ORThe acft struck a rock during landing and damaged the landing gear. The pilot was on a fishing trip and landed initiallyon a gravel bar. He decided to move the acft to a longer plateau because of increasing density altitude. Upon landing inthis open field the…NTSB DEN83LA157Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Vernon, COThe acft collided with a mailbox during takeoff from a gravel road.NTSB MIA83LA169Accident · No injuriesLimited investigationFinal reportLake LA2-200 · Lake Seminole, FLThe right float hit a submerged object during landing at about 40 mph. The right float broke off but was dragged by a fuel line still attached to it. The pilot taxied to shore with the right wing dragging in the water. The float was destroyed and the wing…NTSB CHI83IA300Incident · No injuriesIncident investigationFinal reportBeech H-35 · Graceville, MNOn landing roll on slick grass with a crosswind the acft slid to the right and the right wing tip struck a tree.NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB CHI83IA269Incident · No injuriesIncident investigationFinal reportBoeing B-747 · Chicago, ILThe united airlines B747 was standing in the run up area adjacent to the runway. A flying tigers B747 was passing to his left. The crew of the parked B747 opened their overhead escape hatch and indicated to the taxiing B747 with a thumbs up sign that there…