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 NYC82FA116Accident · 1 fatalField investigationFinal reportCessna 152 · Elma, NYThe pilot was performing a flight exam for a private pilot certificate. An approach was made to a field bordered by high tension lines. During the approach the aircraft collided with wires and descended nose first to the ground.NTSB FTW82FRG35Accident · Minor injuriesFinal reportPiper PA-18A · San Marcos, TXThe pilot was on a flight to spray his own farm. While maneuvering during aerial application, the left wing tip struck a telephone guy wire and then the plane crashed. The pilot had been spraying his own farm over the previous 10 yrs with the same telephone…NTSB ATL82DKQ14Accident · Serious injuriesFinal reportCessna A188B · Boyle, MSThe pilot reported that he had begun a swath run with a fresh load of fertilizer when the aircraft struck a wire. He stated that this was the top wire of an extremely high set. The wires ran diagonally across the southeast corner of the rice field that he was…NTSB FTW82DA210Accident · No injuriesFinal reportBell 206B-III · West Cameron #4As the pilot approached helideck rig 498 the rig went into the automatic shut-in mode. This procedure depressurizes the oil rig and is accompanied by loud bells and vibration as the systems shut-in. The pilot stated this distracted him and the tail rotor…NTSB MKC82DA093Accident · Minor injuriesFinal reportGrumman G-164A · Red Cloud, NEThe aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…NTSB MKC82DA092Accident · No injuriesFinal reportCessna 188B · Thornton, IAWhile spraying a corn field, the pilot crossed under a powerline at the north end of the field. While passing beneath the lines, his left wing tip struck the bottom wire. The pilot reported that he lost aileron control and landed in a corn field with no…NTSB FTW82DA207Accident · No injuriesFinal reportCessna 152 · Clarksville, ARThe pilot reported that after landing at ozark, AR, no fuel was available. Therefore, he proceeded to obtain fuel at Clarksville, AR, a distance of about 15 miles. After takeoff, he encountered moderate turbulence, leveled at about 600 ft, and reduced power…NTSB SEA82DYE07Accident · 1 fatalFinal reportStarduster TOO SA300 · Sequim Bay, WAWhile flying over a lake at low altitude, the left wing of the aircraft struck wires on a moored sailboat about 50 ft above the water level. Three witnesses report that just prior to the collision, the pilot dipped or wagged his wings and waved at them. After…NTSB NYC82DA113Accident · No injuriesFinal reportCessna 150H · Cross Keys, NJAccording to the pilot, the aircraft touched down during landing, about halfway down the runway, then bounced several times. He elected to go around, applied full power, and moved the flap handle to the up position. The flaps were fully extended and did not…NTSB CHI82DA195Accident · Minor injuriesFinal reportGrumman AA1B · Chesterland, OHThe aircraft collided with trees during low flight maneuvering. The aircraft then collided with terrain and was destroyed. The pilot and passenger received minor injuries.NTSB ATL82FID09Accident · Minor injuriesFinal reportMignet HM293 · Radford, VADuring flight, the pilot began flying over a river in his homebuilt HM293 "flea." He reported that he had started a right turn and was looking for a bridge when the left wing tip struck wires. The wires were part of a railway signal line that crossed the…NTSB LAX82DA199Accident · No injuriesFinal reportCessna 210 · Roosevelt, AZThe pilot reported that during the landing he elected to initiate a go-around but failed to clear a fence. According to the pilot the temperature was 90 degrees fahrenheit with a density altitude of 5,100 ft.NTSB FTW82DA197Accident · No injuriesFinal reportConsolidated Aeronautics LA-4-200 · Canyon Lake, TXAfter taxiing around the shoreline, taking-off, and landing again, the pilot was unable to takeoff a second time because his left pontoon was submerging. He proceeded to drain the water out at a public boat dock and attempted to make a downwind takeoff due to…NTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…NTSB ATL82FA144Accident · 3 fatalField investigationFinal reportBell 206B · Oakwood, VAThe plt was flying railroad officials to inspect rail lines that had been covered by mud slides caused by recent heavy rains. A witness heard the helicopter coming up the valley & then heard two popping sounds. He saw the helicopter falling to the ground near…NTSB LAX82DA194Accident · Minor injuriesFinal reportGrumman G-164A · Woodland, CAThe aircraft collided with wires and crashed during a crop dusting operation. The aircraft hit wires during a turn at the end of a swath run.NTSB ATL82DA143Accident · No injuriesFinal reportCessna 172P · Jonesboro, GAThe pilot stated that after applying brakes on landing roll the aircraft began to hydroplane on water that was on the runway. He elected to raise the flaps and apply full power in a attempt to go-around but was unable to clear trees off the end of the runway.NTSB MIA82DA123Accident · No injuriesFinal reportLake LA-4 · Winter Garden, FLThe pilot reported that during takeoff from a 2500 ft Lake, the aircraft would not gain sufficient altitude. The plane collided with trees at the FAR end of the Lake and fell to the ground. The wind was calm and the temperature was about 85 degrees.NTSB FTW82FPG12Accident · 1 fatalFinal reportGrumman G-164 · Ethel, ARThe acft collided with power lines during the start of a swath run.NTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…NTSB SEA82DA074Accident · No injuriesFinal reportCessna 172G · Lester, WAThe pilot elected to takeoff from an airport that was officially closed to aircraft operations by the FAA because of winter flood damage to the runway. The aircraft cleared two large fir trees about 500 ft from the end of the runway but struck trees about 400…NTSB FTW82DRD12Accident · Serious injuriesFinal reportGrumman 164 · Reeves, LAThe aircraft was returning to base after an aerial application of liquid chemical. He stated that there was an odor of chemical and he looked down to check the hopper. When he looked up he was descending into the trees.NTSB LAX82DA186Accident · No injuriesFinal reportBell 47G2 · Santa Maria, CAThe helicopter contacted the platform with a landing skid and rolled over during an attempted takeoff. As the helicopterlifted off of a truck mounted platform a skid became fouled by the truck and a dynamic roll-over occurred.NTSB LAX82DA185Accident · 2 fatalFinal reportRockwell 112TC · Fort Apache, AZThe aircraft was observed to fly between two parked campers in a left wing low attitude before hitting a pine tree. The aircraft then went into an inverted position before contacting the ground about 300 yards from the campers. Investigation revealed that the…NTSB CHI82DA178Accident · No injuriesFinal reportBalloon Works FIREFLY-7 · Wyoming, MIThe pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.NTSB CHI82FA174Accident · 1 fatalField investigationFinal reportCessna A188 · Blue Earth, MNThe flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…NTSB CHI82DA169Accident · Serious injuriesFinal reportSchweizer SGU 2 22E · Belden, OHDuring dual flight in a glider practicing stalls the pilot recovered at a low altitude and collided with wires.NTSB CHI82DA167Accident · No injuriesFinal reportPiper PA-22-150 · Harrison, MIDuring takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.NTSB FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…NTSB SEA82DA069Accident · No injuriesFinal reportPiper PA 28-181 · Port Angeles, WAAbout 10 minutes after takeoff, the pilot realized that he was south of course. After beginning a shallow turn back to course, he realized that he was in close proximity to mountainous terrain. He made an abrupt 40 degree left bank to get away from the…NTSB NYC82DA089Accident · No injuriesFinal reportBell 47g-3b (Soloy Conversion) · New Hope, PAWhile making a cleanup swath around the bottom of a hill, the helicopter collided with wires. The pilot reported that he did not see the wires while holding his head in such a manner as to reduce the effect of sun-glare. After hitting the wires, the pilot…NTSB LAX82FA164Accident · 4 fatalField investigationFinal reportCessna 172 · Upper Lake, CAWitnesses observed the acft rolling right & left during the final approach. The acft drifted to the right & power was applied prior to the collision with the trees. Nw winds in excess of 25K prevailed. A CFI witness stated that it appeared the plt was not…NTSB LAX82FA163Accident · Serious injuriesField investigationFinal reportThunder Balloons LTD. · Fountain Valley, CAThe pilot stated the balloon was inflated and established weigh-off procedures were conducted. At the end of the weight-off procedure, as the balloon was being walked by the ground handlers, an increase in wind velocity caused the basket to be pulled free…NTSB CHI82DA156Accident · No injuriesFinal reportPiper PA-28-180 · Yale, MIThe pilot elected to make a go-around due to a wind shift. During the attempted go-around the aircraft collided with trees about 700 feet off the end of the runway and crashed in a corn field.NTSB CHI82DA154Accident · Minor injuriesFinal reportCessna 182 · Ottawa, ILThe aircraft collided with a truck off the approach end of the runway during a low, no flap approach. According to the pilot a caution sign for vehicles using the road had been removed by vandals and he did not see the truck because of his low approach. The…NTSB FTW82FRD10Accident · 1 fatalFinal reportCessna 207 · Franklinton, LAThe passenger stated that after sharp turns at low altitude over a farm house they did a roll & were too low to recover prior to striking trees. The acft came to rest inverted in a 4-5 ft deep farm pond. The autopsy report shows the plt's death by asphyxia…NTSB ATL82DA125Accident · No injuriesFinal reportPiper PA-38-112 · Jonesboro, TNAfter utilizing the southwest runway for takeoff and landing the pilot noted that the limp windsock had shifted to indicate use of the northeast runway. The next takeoff was therefore made to the northeast, with an uphill gradient to the runway. After a…NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…NTSB FTW82FRA20Accident · Serious injuriesFinal reportRockwell Intl S-2R · Alvin, TXThe pilot's father reported that he and his son were en route in separate aircraft to apply fertilizer to a rice field. He noticed his son dive from 500 ft to about 100 ft where the aircraft struck the top ground wires of a transmission line. The plane…NTSB FTW82FRJ11Accident · Serious injuriesFinal reportCessna 170B · Plain Dealing, LAThe aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while…NTSB FTW82FQD11Accident · 2 fatalFinal reportPiper PA-28-140 · Mescalero, NMTwo witnesses observed the aircraft flying eastbound at low altitude along a highway, then begin a climbing turn over sharply rising terrain. After completing about 90 degrees of turn, the aircraft struck the tops of trees about 30 ft AGL. About 12 paces…NTSB NYC82DHD11Accident · Minor injuriesFinal reportBell 47G · New Egypt, NJThe pilot stated that he was about to finish spraying the field and had only two passes remaining when the accident occurred. Passes were made to the north and south with the wind from the west at 5 to 10 knots. After completing a pass to the south, he pulled…NTSB FTW82DA174Accident · No injuriesFinal reportBoeing E75 · Erick, OKThe pilot was pulling up from the swath run and collided with wires. The aircraft nosed over during the forced landing.NTSB CHI82DA147Accident · Serious injuriesFinal reportMong Sport MS-1 · Pendleton, INWhen the pilot arrived at anderson, Indiana, he was unable to find the ace airport. He saw huntzinger airport, a private strip, and decided to land to find out exactly where ace airport was located. During an approach to the sod runway, the aircraft collided…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 ATL82DA119Accident · No injuriesFinal reportCessna A188 · Columbus, MSThe pilot had landed in a farmer's field to reload his sprayer tank. Before takeoff, he noticed some cows had strayed onto the strip. He directed his loadcrew assistant to take his truck and clear the cows from the strip. After the cows were cleared, the…NTSB ATL82DA117Accident · Minor injuriesFinal reportCessna 152 · White Sulphur S, WVThe pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the…NTSB ANC82DA038Accident · Minor injuriesFinal reportCessna 207 · New Stuyahok, AKThe pilot utilized a soft field technique and commenced his takeoff from the runway threshold. During takeoff run he observed the runway end markers and elected to put down full flaps. The aircraft became airborne just before colliding with the end marker and…NTSB FTW82FA155Accident · 1 fatalField investigationFinal reportCessna 411A · Houston, TXThe acft was the second acft of a flight of two. The lead acft had received radio clearance for takeoff. The lead acft was to proceed to a visual checkpoint northwest of the arpt & wait for this acft to join up. Witnesses observed the acft depart rwy 17 &…NTSB FTW82FRA19Accident · 1 fatalFinal reportBoeing A75 · Chapell Hill, TXDuring a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.