NTSB investigations
4,605 cases where the first occurrence was “In flight 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\" = 220) 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" = 220) 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 LAX86LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lower Lake, CAThe airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…NTSB FTW86LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Afton, OKThe pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness.NTSB MIA86LA240Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Dublin, MSWhile buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground.NTSB CHI86LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clintonville, WIFollowing at least three successful practice low approaches to a farm field, the student pilot climbed over a small wooded area and did a 180 degree turn to perform an approach to another field. He flew down to within 20 feet of the ground, then applied full…NTSB CHI86LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Milford, MIThe pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft…NTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.NTSB DEN86FA231Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Redcliff, COA husband & wife rprtd that the acft flew near their house at a very low alt, then climbed in the direction of the sun to clear over a bridge. Moments later, the acft collided with power lines that were suspended between 2 towers. The towers were located atop…NTSB ATL86FEK05Accident · Serious injuriesFinal reportPiper PA-25-235 · Melrose, OHThe acft collided with a traffic sign during an aerial application flt. The plt had made a low pass prior to the collision.NTSB SEA86LA204Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grangeville, IDThe helicopter plt was on an emergency medical service (ems/medivac) flt to transport survivors from an airplane accident. He landed at night on a ridge about 1/4 mi from the airplane crash site. At about 2400 MDT, the plt attempted to takeoff from the…NTSB ATL86FA217Accident · Minor injuriesField investigationFinal reportPiper PA-28-161 · Douglasville, GAThe plt loaded three adults plus herself into the warrior ii and attempted to take off from a grass strip which had a dip and a hill of about 6 feet near the departure end. The acft traveled about 150 ft past the end of the runway before impacting on the side…NTSB DEN86LA229Accident · No injuriesLimited investigationFinal reportRaven Aero Star S-66A · Fort Collins, COThe plt rprtd he began venting the balloon in preparation for a landing in a field. The balloon encountered a wind shift & started drifting toward powerlines. The plt said there was not enough time to add heat to avoid the powerlines, so he held the vent open…NTSB LAX86FA314Accident · 1 fatalField investigationFinal reportCessna 421C · Callahan, CAAfter dropping company executives off at medford, the pilot was to return to santa rosa empty. Witnesses along the 25 NM valley which ends at the accident site reported that the aircraft buzzed their locations at AGL altitudes variously described as '10 feet'…NTSB MKC86LA168Accident · No injuriesLimited investigationFinal reportCessna 188B · Edison, NEThe PIC had made 5 or 6 passes to the corn field he was spraying. During this pass, the PIC stated he struck a pwr line that ran diagonally across the fld. The PIC stated he did not observe this particular strand during the other passes on the fld. Pwr lines…NTSB NYC86LA193Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Lancaster, PAThe Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…NTSB SEA86LA186Accident · No injuriesLimited investigationFinal reportCessna 210 · Hillsboro, ORThe pilot reported that he struck a post on take-off and broke off the main landing gear wheel. The pilot proceeded to Hillsboro, Oregon where an emergency landing was made on a paved runway with the landing gear still extended. The stub caught in the runway…NTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…NTSB FTW86LQG17Accident · No injuriesFinal reportMcculloch J-2 · Stanton, TXPilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available.NTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…NTSB MKC86LA159Accident · No injuriesLimited investigationFinal reportCessna T188C · Davenport, IAThe ag pilot was spraying a field when he impacted powerlines which removed the upper one-third of the vertical stab and rudder. On landing he groundlooped and collapsed the right main gear.NTSB CHI86FA179Accident · 2 fatalField investigationFinal reportStinson 108-3 · Shiocton, WIWitnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…NTSB CHI86FEM12Accident · No injuriesFinal reportRobinson R-22HP · Grayling, MIThe helicopter, during cruise flight, was flying low in an attempt to remain clear of clouds when it struck a power line and was forced to make an emergency landing. The helicopter received substantial damaged when it struck the power line and reportedly…NTSB SEA86LA178Accident · 1 fatalLimited investigationFinal reportAyres S-2R · Kuna, IDAcft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…NTSB LAX86FUJ04Accident · No injuriesFinal reportGrumman G-164-3 · Casa Grande, AZThe acft collided with telephone wires on the third apch to a field for an aerial application run. The acft then descended to collision with the terrain. The plt reported having noticed the power lines during the previous spray runs.NTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…NTSB ANC86LA106Accident · No injuriesLimited investigationFinal reportCessna 207 · Ekuk, AKThe pilot stated that during the approach to landing, the aircraft struck a tree stump short of the approach end of the runway.NTSB LAX86FA288Accident · 6 fatalField investigationFinal reportCessna T210N · Bullhead City, AZThe private pilot, who had accumulated approximately 450 hours of flight experience and his 5 passengers, arrived at the destination airport during darkness. This was the pilot's first landing at the uncontrolled airport and he was not familiar with the…NTSB FTW86LA128Accident · No injuriesLimited investigationFinal reportCessna U-206G · Decker'S Island, TXDuring take-off the pilot did not compensate for a strong crosswind and allowed the aircraft to drift sideways where the main gear collided with a fallen tree separating it from the aircraft and causing the aircraft to veer and collide with the ground.NTSB NYC86FNC05Accident · Minor injuriesFinal reportBell 47G-5 · Walthamer, MEWhile on a spray run the pilot of the Bell 47 was blinded by the sun as he was turning. The aircraft struck power lines, control was lost and the helicopter crashed.NTSB DEN86LA199Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Hobbs, NMThe plt was participating in a soaring competion meet. While on the return portion of the flt, the plt encountered an area of insufficient lift & was unable to reach the arpt. During an off arpt landing, the left wing of the glider struck a mesquite bush &…NTSB BFO86LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Clifton, VAAccording to the pilot, he and his wife had departed mount olive, NC on the morning of the accident enroute to romeo, MI. After refueling at danville, VA they departed but ran into weather near beckly and diverted to the east. Unable to locate greenbrier…NTSB ATL86LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Augusta, GADuring takeoff from an emergency landing zone, the aircraft collided with power lines and made a precautionary landing on the median between the highway. The helicopter was operating as an emergency medical services helicopter and the pilot was responding to…NTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.NTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…NTSB CHI86LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt initiated the takeoff, however, the CFI took over control of the acft when it became apparent that the acft was not climbing. The CFI was unable to salvage the takeoff and the acft struck and settled into trees at the departure end of the rwy.NTSB ATL86FEG01Accident · No injuriesFinal reportBeech C-45H · Tremont City, OHThe acft collided with a utility pole during an exhibition fly-by. The acft continued to fly to its home arpt where it made an uneventful landing. The rt wing was damaged on the outboard end to include 2 ft of the aileron. The pole struck was 30 ft high and…NTSB DEN86LA183Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bynum, MTAfter the first landing on a gravel road for reloading liquid insecticide the pilot attempted to take off for an aerial application flight. During the take off ground roll the pilot observed that the left door was not properly closed. He momentarily reduced…NTSB CHI86LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Int'L Falls, MNAcft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported.NTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…NTSB NYC86LA168Accident · No injuriesLimited investigationFinal reportBell 206B III · Moultonboro, NHThe Bell jet ranger had just dropped off an external load and was returning downhill when the pilot reported hearing a growling noise in the aft portion of the aircraft. He autorotated to landing as control was lost. When the wreckage was examined after it…NTSB MIA86LA193Accident · Minor injuriesLimited investigationFinal reportCulver V · Deland, FLThe plt stated that on his landing apch he reduced the power too soon, the acft stalled and collided with trees and crashed 150 feet short of the runway.NTSB SEA86LA154Accident · 1 fatalLimited investigationFinal reportCessna A188B · Boise, IDThe purpose of the flight was to spray thirty gallons of rinse water to clear the spray tanks of chemical. While maneuvering the acft struck power lines and then struck the ground. The acft slid for about 20 feet and then nosed over inverted.NTSB MKC86LA134Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Wellman, IAThe PIC stated that during the last 3rd of his procedure turnaround the acft descended to just below the powerlines at the edge of the field he was spraying. The acft struck the powerlines with the main landing gear which nosed the acft over. Full power was…NTSB FTW86LRD20Accident · Serious injuriesFinal reportPiper PA-25-235 · Marksville, LAThe pilot delayed in his pullup from a spray swath run until there was insufficient time and distance to clear the line of trees at the end of the field. Airspeed decreased rapidly during the pullup. Tree impact occurred and the pilot was unable to recover…NTSB LAX86FA260Accident · 2 fatalField investigationFinal reportCessna 152 · Marysville, CAAt 0203 PDT, there was an electrical power outage when a Cessna 152, N4873H, collided with a power line that crossed the feather river near Marysville, CA. The acdnt occurred as a student plt was flying over the river at low alt with a passenger aboard at…NTSB ATL86FA178Accident · 2 fatalField investigationFinal reportCessna 120 · Marlton, NJAbout 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver…NTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.NTSB MKC86FCJ02Accident · 1 fatalFinal reportCessna A188B · Bridgeport, NEDuring an agricultural spray run, the aircraft collided with a utility pole, leaving part of the spary boom wrapped around the pole, and pieces of flap, wing, and fuel bladder nearby. The aircraft then impacted the ground about 1000 ft from the pole & was…NTSB ANC86FA081Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Lakecreek River, AKAccording to a witness on the ground, the pilot-in-command landed from west to east and after unloading the supplies decided to takeoff in the same direction. The pilot taxied down to the end of the runway and upon turning around the witness stated the tail…NTSB LAX86FUG03Accident · 1 fatalFinal reportBensen-Jansen B-8M · Adelanto, CAThe acft collided with power lines crossing the airstrip at midfield and crashed on the rwy. A witness stated that the plt had been briefed on the pwr lines prior to the flt.NTSB ANC86FA080Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Settlers Bay, AKThe instructor (CFI) gave the front seat plt a simulated forced lndg while the airplane was aligned with rwy 20 & the wind. The front seat plt elected to fly a traffic pattern to rwy 2. As the front seat plt maneuvered to line up with rwy 2, much alt was lost…