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 SEA85LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Pacatello, IDAfter landing the plt was instructed by the tower to expedite off the rwy and taxiway due to a jet following close behind. During taxi from the taxiway to the ramp, the plt was paying particular attention to his right wing tip to avoid parked acft. The acft…NTSB FTW85LA291Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Patterson, LAThe acft was substantially damaged when it was rammed by a speed boat after it had landed on a canal and was water taxiing to its tie down area. The boat came out of a crossing canal at high speed and struck the amphib in the area of the left float. The boat…NTSB DEN85LA178Accident · No injuriesLimited investigationFinal reportCessna R172K · Leadville, CODuring the landing roll on rwy 34, a deer ran in front of the acft. The deer was struck and killed by the right wing strut.NTSB MKC85LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cedar Rapids, IAWhile taxiing to takeoff, the plt was proceeding between 2 rows of hangars. He stated that he was having a problem with the acft transceiver & was adjusting it for taxi instructions. At about that time, the right wing tip of the acft struck the tail rotor of…NTSB MKC85LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hays, KSThe plt started the eng & was preparing to taxi from the parking area when he reached back to retrieve a flashlight from his flt case. At that time, the acft began slowly rolling forward. When the plt returned his attention to the front, he applied brakes.…NTSB CHI85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Kankakee, ILThe aircraft while clearing the runway, shot wide of the taxiway taxiing onto the grass and into a culvert which was difficult to see resulting in substantial damage to the aircraft.NTSB DCA85AA026Accident · 1 fatalFinal reportBeech E18S · Birmingham, ALAt 2045 the military flt, dixie 06, contacted Birmingham apch & obtained clearance for a low apch followed by a full-stop lndg on rwy 05. At 2053, dixie 06 reported a 4 mile final for a low apch to the local controller. At 2054:19, the local controller…NTSB SEA85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Long Valley, NVThe plt chose to land on a country road due to low fuel. After refueling the plt attempted to depart the rough road. During the takeoff roll the acft veered left and struck a wire fence.NTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…NTSB MKC85FCQ03Accident · 1 fatalFinal reportCessna 172RG · Wichita, KSThe acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter…NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…NTSB LAX85LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Phoenix, AZThe plt had just purchased the acft & this was the first time he had taxied it from the left seat. This plt taxied from the parking ramp up a slight grade an across a taxiway. He reported that when he 'looked up', he observed that the acft was heading toward…NTSB FTW85LA222Accident · No injuriesLimited investigationFinal reportBeech M-23 · Willow City, TXDuring the return leg of a x-country flt to California, the plt became lost and elected to make a precautionary landing. The acft wing contacted a sign post during the landing.NTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…NTSB MIA85LA167Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Winter Haven, FLA Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…NTSB FTW85LA213Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Balmorhea, TXThe acft was involved in illegal activity when it was intentionally landed in an open pasture. During the landing, the acft veered left and struck a 30 inch high concrete culvert. The gear collapsed on contact with the culvert. Unknown personnel subsequently…NTSB ATL85FKG05Accident · No injuriesFinal reportPiper PA-31 · Atlanta, GAOn may 2, 1985, at 0714 EDT, a Piper PA-31, N902BH, regisered to paul m. furnee, was struck by a ground vehicle while taxiing for take off at hartsfield international airport, Atlanta, Georgia on an airtaxi cargo flight. Instrument meteorological conditions…NTSB LAX85LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Hemet, CAThis was the first flight after a cockpit check-out in the Schweizer sgc 1-36. The pilot released from the tow plane when he realized that the spoilers were deployed and landed short of the runway. The pilot reported that the spoiler handle in this model…NTSB FTW85LA205Accident · No injuriesLimited investigationFinal reportCessna A185F · Gibson, LAThe amphibian acft was substantially damaged when it collided with a tree while landing on an oil field service canal. The plt stated that he landed long and fast and as a result he was unable to negotiate the second half of an 's' turn in the canal. The left…NTSB LAX85LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA32-301T · Show Low, AZAfter giving the pilot airport advisories,via UNICOM, the refueler drove the refueling truck across the runway in front of the aircraft during its takeoff roll. The pilot unable to stop before impact, attempted to takeoff before reaching the tanker. The…NTSB LAX85LA219Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Prescott, AZThe acft departed rwy 21. The reported surface winds were 190 degs at 12 KTS gusting to 29 KTS. The acft was climbing at 200 fpm until reaching 800 ft AGL. The plt reported that he considered the climb rate as being too slow and elected to negotiate a…NTSB LAX85LA195Accident · No injuriesLimited investigationFinal reportCessna 210A · Quartzsite, AZThe owner of the airstrip reported that he observed the acft touchdown with its left wheel 2 to 3 ft left of the improved portion of the rwy. Thereafter the acft rolled aprx parallel to the rwy until its left wing hit the top of a 10 ft tree beside the rwy.…NTSB LAX85FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Anza, CAAfter making two previous takeoffs and one landing in an overloaded airplane the pilot landed about 1000 feet down a 3200 foot runway. When the aircraft failed to decelerate quickly enough and the pilot attempted a go-around toward rising terrain. The…NTSB MIA85FA122Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Winter Haven, FLWhile taxiing back to the seaplane ramp after landing the acft struck a small fishing boat causing fatal injuries to the boats sole occupant. The acft was being taxied at high speed on the step and s turns where being made to clear the area due to the plt not…NTSB LAX85LA176Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Paso Robles, CAThe plt pulled the prop through by hand after attempts to start the acft failed. The unoccupied acft started and traveled aprx 200 ft before contacting the left wing of another acft. Inspection revealed the 'p' lead on the left magneto was not grounded. The…NTSB ATL85LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Decatur, ALDuring eng start the acft accelerated into two parked acft causing substantial damage. The plt stated that the toe brakes were ineffective. Post crash investigation failed to disclose a preexisting failure or malfunction which may haverendered the brakes inop.NTSB MIA85LA117Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Titusville, FLA group of T-6 type acft were taking off in sections of two acft each. Each section of two were making a formation takeoff with a 5 to 6 second interval between sections. N58740 was in the left position of the 2nd section; N9801C was in the left position of…NTSB DEN85LA092Accident · No injuriesLimited investigationFinal reportCessna 180 · Arroyo Seco, NMThe acft collided with trees off the end of the 1000 ft long grass airstrip during an aborted takeoff attempt. Calculations show it would have taken aprx 1171 ft for the plt to successfully perform the aborted takeoff.NTSB ATL85LA108Accident · No injuriesLimited investigationFinal reportCessna 172H · Bessemer, ALThe plt was taxiing to the rwy on a narrow taxiway when the left wing struck a t hangar support post.NTSB ATL85FA109Accident · Serious injuriesField investigationFinal reportMooney M20J · Chattanooga, TNThe plt was attempting to disengage the starter pinion gear by rocking the prop up & down by hand. The eng inadvertently started & the acft rolled across the ramp at a high rate of speed & collided with two automobiles & a chain link fence before coming to…NTSB LAX85LA153Accident · No injuriesLimited investigationFinal reportBarnes FF-8-24 · Scottsdale, AZOn landing the balloon touched down short of the desired landing area. The pilot heated slightly in order to proceed to smooth field. A strong gust picked up the balloon and took it into power lines which arced and the balloon caught fire. The pilot stated…NTSB DEN85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lapoint, UTThe acft collided with a snowbank while taking off from a road near Lapoint, Utah. The acft was being used to count elk on an indian reservation. The plt landed to relieve himself. On the subsequent takeoff the acft hit a chuckhole in the road which caused it…NTSB SEA85LA064Accident · No injuriesLimited investigationFinal reportLyoyd Thompson Pober Pixie · Nampa, IDLeft main gear contacted runway-taxiway intersection lights during a landing roll. Acft then nosed over. Rwy width is 75 ft.NTSB SEA85LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Boise, IDWhile taxiing on the ramp after landing, the right wing of the acft struck a jet blast fence. The plt stated two linemen were guiding the acft at the time.NTSB MKC85LA052Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ottawa, KSRight main gear struck an object during takeoff ground run. Plt aborted the takeoff. Acft veered to the right and impacted a snowbank which paralled the side of the rwy. The arpt operator reported that there was snow knocked onto the rwy 5O to 100 ft prior to…NTSB LAX85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sahuarita, AZAcft veered to the right during landing roll on an abandoned airstrip. Right wing contacted a tree aprx 1 ft inboard on right wing tip deforming the main spar. Trees lined both sides of the airstrip.NTSB CHI85LA089Accident · No injuriesLimited investigationFinal reportBeech 58P · Grand Rapids, MIAt 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…NTSB MIA85LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · St.Petersburg, FLThe acft collided with a parked acft while taxiing in from landing. The plt complained after the accident that the parked acft were too close to the taxiway. The tailwheel equipped acft had been engaged in banner towing operations prior to the taxi accident.NTSB MIA85LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Wesley Chapel, FLThe student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy.NTSB ATL85LA076Accident · No injuriesLimited investigationFinal reportBeech C90 · Winston Salem, NCDuring takeoff roll, at rotation, acft contacted a large dog which was on the rwy. Plt had good visibility except for light condition. Acdt occurred at night. Arpt perimeter is fenced but there are many gates, some of which remain open at night. Many dogs…NTSB LAX85LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · California City, CAThe plt elected to land in a clear, flat, open, desert area which was used by campers to ride motorcycles and off-road vehicles. On the date that the plt landed there, numerous campsites & off-road vehicles were in the area. Nearly 2 hrs after the landing, he…NTSB MIA85LA063Accident · No injuriesLimited investigationFinal reportBeech 58P · Deland, FLN41Q was taxiing to the ramp after landing. As N41Q taxied behind N3707N, who was starting the rt engine, propwash caused plt of N41Q to lose directional control of the acft. Prop of N41Q contacted the left elevator of N3707N.NTSB CHI85LA081Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wisconsin Rapid, WIThe plt stated that during takeoff into winds form 290 deg at 10 KTS gusting to 15 KTS, the acft began to slide to the left on the icy rwy. When the acft hit a snow bank along the rwy, the nose gear collapsed.NTSB CHI85LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Staunton, ILWhile taxiing for takeoff at a private airstrip, the acft contacted a parked truck. The plt attributed the collision to his lack of alertness.NTSB MIA85LA054Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Daytona Beach, FLPlt stated that he was unfamiliar with the arpt and requested assistance to taxi to the ramp. The pilot was told to take the first left turn to ramp, he turned onto an access road to the fire station and collided with a sign that stated 'no taxiway.'NTSB LAX85LA062Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Salinas, CADuring walk-around preflight, plt was checking the prop for nicks and decided to 'turn the prop through' by hand to 'loosen the oil and coat cylinder walls,' assuming the power plant controls to be off and secure. The engine started at full power and the…NTSB CHI85LA068Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Lafayette, INWhile turning the prop by hand to lubricate the engine it unintentionally started and ran at aprx 1700 RPM. The acft was not chocked or tied down and the parking brake was not set. The acft traveled across the ramp and collided with an empty t-hangar. After…NTSB LAX85LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Ukiah, CAOn initial takeoff roll, plt allowed acft to drift left while attention was focused on the airspeed indicator. When drift was noted, plt cut power and applied brakes but acft collided with VASI lights.NTSB ANC85LA025Accident · No injuriesLimited investigationFinal reportPiper PA-185-135 · Kodiak, AKThe wheel equipped acft broke through the ice during a takeoff from a frozen lake. The increased drag slowed the acft and the plt was able to clear some trees but after bouncing along for 300-400 ft the acft hit a tree and ground looped. The acft wreckage was…