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 DEN83LA137Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Saco, MTThe acft collided with telephone lines during an aerial application run. The pilot's son reported that the acft was pulling up at the end of a spray run when the wires were hit. Most of the wires in this area are underground however thewires at the end of…NTSB ANC83LA091Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Deadhorse, AKThe helicopter collided with a pole and landed hard during air taxi to position the acft. The pilot had just off loaded passengers and was alone in the helicopter. A witness said the pilot hovered too close to the pole and both rotor bladesmade contact. The…NTSB CHI83LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Roseau, MNDuring an aerial application flt, the acft collided with power lines during a pull-up from a swath run. The plt reported no preimpact malfunctions.NTSB ATL83LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingston, TNThe plt checked the wx conditions before operating on the 1020 ft grass strip. He landed on the strip at 0935 EDT, took off again about 10 min later, then returned & landed again. Aprx 1 hr & 5 min after his 1st takeoff, he started another departure with 20…NTSB CHI83LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Lake, MNThe acft collided with a railroad sign during approach to a private airstrip. The weather was VMC but there was a cross-wind of about 15 KTS and a low sun creating sunglare. The acft drifted to the south side of the rwy due to wind and collided with the sign.…NTSB LAX83FA260Accident · 2 fatalField investigationFinal reportPiper PA-32 300C · Buckeye, AZThe acft collided with a utility pole about 36 ft AGL less than a mile north of a private dirt airstrip. The acft had departed scottsdale municipal arpt at about 0045. The accident occurred at about 0200 aproximately 4 miles west of Buckeye,AZ. A witness…NTSB NYC83FA128Accident · No injuriesField investigationFinal reportCessna 172RG · Plattsburgh, NYDuring an IFR arrival, aprx 1 mi from the outer marker (om), the plt asked for a descent from 3300 ft MSL & was cleared for the localizer, rwy 1 apch. The published min alt at the om was 2100 ft. the plt reported at the om, and 11 seconds later, the…NTSB SEA83LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Portland, ORWhile landing at night on rwy 34, the plt noticed that he was over half way down the rwy and still floating. He elected to go around but the acft collided with trees on the departure end & crashed. The plt reported that several of the threshold and rwy lights…NTSB NYC83FA126Accident · 4 fatalField investigationFinal reportBeech B36TC · Farmingdale, NYThe acft collided with a powerline static wire during an instrument landing approach. The private plt was instrument rated and had received a weather briefing and filed an IFR flt plan. He commented to the briefer that 'it doesn't sound too good' and that he…NTSB LAX83FU006Accident · 1 fatalFinal reportEipper Weight Shift · Bakersfield, CAReportedly, the plt was lining up on final apch to land when the ultralight vehicle collided with a power line at aprx 30 ft AGL. According to the county coroner, the plt died from accidental electrocution on 5/31/83.NTSB FTW83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Bon Wier, TXThe acft collided with a fence during takeoff from an unimproved field. The plt and his wife had departed houston TX theday before for a 'local' flt. Due to mechanical difficulties a landing was made at Bon Wier. According to the plt, although relatives live…NTSB FTW83LA260Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Farmington, NMAccording to the plt, a unauthorized ground crew relieved the plt's crew & would not follow his instructions. After the ground crew moved the Balloon into a position that was upwind from a light pole, they released it & it ascending. The plt stated that he…NTSB DEN83FTM04Accident · Minor injuriesFinal reportPiper PA-25-235 · Delta, UTThe acft collided with two power lines on a clean up swath run. The acft rolled inverted and struck the ground. The field being sprayed was bordered on the north by highly visible wires. The wires that ran along the east side were not so visible. There was…NTSB ATL83LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Tallassee, ALAs the student jumper was getting out of the aircraft and onto the step in preparation for a parachute jump the pack tray prematurely opened and the canopy blossomed under the tail pulling the jumper into the horizontal stabilizer causing a cut on his left…NTSB ATL83LA209Accident · Serious injuriesLimited investigationFinal reportBarnes AX-6B · Decatur, ALThe balloon was launched from a field with power lines along the east side after another balloon was launched. The first balloon was aprx 50 ft from the power line when it was launched. When it tookoff, it traveled to the north northwest & remained well clear…NTSB MIA83LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Jay, FLThe acft collided with a tree while maneuvering in an aerial application operation. The pilot stated that while completing a run,turbulence was encountered which he believes was related to a 20 acre field being burned nearby. The acft descended about 25 feet…NTSB LAX83LA249Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164C · Live Oak, CAThe plt was on a flight to seed a rice field with 2 sets of power lines located near its west edge. The plt had seeded the field many times before, & reportedly, was familiar with the area. During the 1st swath run, which was from east to west, the acft…NTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…NTSB MKC83FA114Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Troy, KSThe acft collided with a powerline while the pilot was locating a field to spray at a later date. The pilot saw telephone lines and flew over them but hit the powerlines which were 20 feet higher. The skids caught the wires and the helicopter nosed down,…NTSB LAX83FA246Accident · 2 fatalField investigationFinal reportHerpst Varieze · Portola, CAThe home built acft collided with trees & crashed on rising terrain while the plt & passenger were on a sight-seeing flt. The accident occurred at an elevation of 7000 ft, the density altitude was estimated to be aprx 10000 ft. the wreckage was scattered aprx…NTSB ANC83LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Big Lake, AKThe acft collided with trees and stalled into the ground during a go-around. The plt stated that the acft was using up a lot of rwy during the landing so he initiated a go-around. He added full power but was unable to gain enough altitude to clear the trees.…NTSB SEA83FA103Accident · 1 fatalField investigationFinal reportCessna U206 · South Prairie, WAWitnesses observed the touchdown about 1,800 ft down the 2,600 ft strip. After bouncing twice, & about 2,000 ft down therwy, power was applied for a go-around. During the climbout the acft turned left toward higher trees. The flaps were described as being in…NTSB SEA83LA106Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cle Elum, WAThe acft collided with a power line while flying low over a river. Reportedly the student pilot was buzzing some rafterson the yakima river when the acft collided with a power line about 25 feet AGL. The powerline was downed by the impact and the acft right…NTSB ATL83LA193Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe acft collided with a powerline while on an ILS approach. The weather was VMC but scattered clouds and a dark night necessitated the instrument approach. The pilot stated that he became distracted while re-setting his directional gyro and descended below…NTSB ATL83FA194Accident · 2 fatalField investigationFinal reportBeech A23 · Dublin, VAThe acft collided with wires and crashed during a training mission. According to one of the cfi's other students the area in which the crash occurred was regularly used by the CFI for airwork. This airwork was normally performed at ABOUT800 ft AGL. On this…NTSB ANC83LA077Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKAccording to the plt, he was taking off downslope & downwind on bumpy muskeg/tundra with full flaps. At aprx 40 to 45 mph, the acft lifted off before reaching the edge of a deep ravine. He began a shallow left turn, then the left wing struck a tree which spun…NTSB FTW83LA244Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Taft, LAThe acft flew into guy wires of a weather tower after a spray run.NTSB NYC83LNC02Accident · Serious injuriesFinal reportAeronca 7AC · Johnson Pond, METhe acft lifted off from the surface of Johnson Pond and was climbing over trees when the plt made a sharp turn and the acft struck a tree. The acft then impacted the ground and was destroyed by impact and fire.NTSB LAX83LA231Accident · No injuriesLimited investigationFinal reportCessna 150M · Bakersfield, CAThe acft collided with a powerline while on final approach and nosed over in a open field one half mile short of the runway. The pilot had flown into this arpt the morning of the accident as a pax. She decided to do some takeoffs and landings, local pilots…NTSB SEA83LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Inchelium, WAThe intended landing area was a dirt road aprx 1500 ft long. After making a low pass to check the area, the plt made an approach over trees to land, but was too high, so he went around. On the 3rd pass, he applied full flaps. The plt stated that the acft was…NTSB LAX83LA213Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Healdsburg, CABefore starting his dusting operation, the plt had observed the grape vineyard & made plans to begin on the following day. He reported observing the power lines that were suspended across the vineyard. However, he did not notice the anchor wire that was…NTSB FTW83LA218Accident · No injuriesLimited investigationFinal reportBell 206B · Thorndale, TXThe acft approached the field to be surveyed and collided with a wire at about 30 ft AGL. According to the plt during the actual survey the acft is hovered at low alt. When the plt saw the wire ahead the reported airspeed was about 20 ktsthe collective was…NTSB FTW83LA217Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quanah, TXThe helicopter was being used to search for cattle. As the plt was looking down through some bushes for cattle, the m/r blade hit a powerline wire about 25 ft AGL.NTSB NYC83FA106Accident · 2 fatalField investigationFinal reportBell 47G-2 · Waymart, PAThis was an introductory instructional flt. Witnesses observed the helicopter flying straight & level prior to the accident. The helicopter had impacted a 60-FT tree at about the 40-FT level. No preimpact failure/falfunction of either the airframe or engine…NTSB FTW83LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Morrilton, ARThe acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he…NTSB DEN83LA101Accident · No injuriesLimited investigationFinal reportPiper J3C65 · Kalispell, MTWhile making an approach to a field on a ranch, the acft hit a power line on short final and crashed upright in the field. The pilot said he did not see the wire across the north approach to the field.NTSB ATL83LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Clinton, MDWitnesses observed that the acft took off from rwy 31, began a left turn, then descend into the trees. One witness, a lineboy, stated that he heard the engine running until the acft contacted the trees. The plt received a head injury and was unable to recall…NTSB DEN83LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Martinsdale, MTReportedly, the instructor plt was on a personal/business flt with a student plt as a passenger. A landing was made on a road that had been used by crop duster plts. The plt had been informed about the presence of power lines. He saw some power lines & had…NTSB LAX83LA180Accident · No injuriesLimited investigationFinal reportHughes 269A · Lindsay, CAThe plt was rounding up cattle for a bbq. One of the steer in the herd charged the helicopter & struck its skid. The main rotor deflected & severed the tail boom. The plt lost control of the acft which impacted the ground & rolled over.NTSB ATL83FA163Accident · 4 fatalField investigationFinal reportBeech V35B · Frisco, NCThe destination arpt was unlighted & was closed from 30 min after sunset until 30 min before sunrise. Prior to the flt, the plt made arrangements for someone to take his car to the destination arpt & park it with the headlights turned on at the apch end of…NTSB LAX83LA466Accident · No injuriesLimited investigationFinal reportCessna 188B · Modesto, CAThe acft collided with a fence during takeoff and pulled the tailwheel out of the empennage. The plt said the dump valvefailed to work or 'struck' so he could not jettison the load. He felt the need to 'dump' when the acft hit a 'softspot' in the gravel and…NTSB CHI83FA166Accident · 1 fatalField investigationFinal reportPiper PA24-260 · Middleton, WIDuring arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling…NTSB ATL83FIJ02Accident · Serious injuriesFinal reportCessna 182P · Bluefield, WVThe plt reported that he began an ILS approach to the mercer county arpt. He stated that he planned to descend to 3200 ft MSL, then execute a missed approach & return to abington, VA. The arpt elevation was 2857 ft MSL. He stated that he remembered glancing…NTSB DEN83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hulett, WYThe acft struck a deer while landing into the sun at a private ranch strip. The animal was seen just before touchdown but not in time to avoid hitting it.NTSB ATL83FA161Accident · 1 fatalField investigationFinal reportCessna 177RG · Mobile, ALThe plt had not flown actively for aprx 1 yr. However, shortly before the accident, he had told friends that he had missed flying & was going to resume this activity. He received a checkout in the Cessna 177RG on 12/12/82 in anticipation of flying again. This…NTSB NYC83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · West Chester, PAThe plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…NTSB MKC83LA089Accident · No injuriesLimited investigationFinal reportVarga 2150A · Moline, KSThe aircraft collided with power lines on final approach but a landing was accomplished on the runway. The pilot stated that he had made 2 prior landings on the same runway and did not see the wires. During this approach he saw the wires and tried to fly…NTSB FTW83LA182Accident · No injuriesLimited investigationFinal reportRotec Rally 3B · Edmond, OKThe plt of the registered, 2 place, ultralight acft reported that the winds were variable & he was intending to land into the wind. However, he further stated that he believed the wind had switched to a tail wind before the landing. After landing, he realized…NTSB LAX83FA185Accident · 6 fatalField investigationFinal reportPiper PA32-300 · Weaverville, CAThe acft was being flown to a uni-directional arpt with an instructor plt (CFI) in the right front seat & a student plt/prospective buyer in the left front seat. The rwy elevation was 2230 ft MSL at the south end & 2350 ft at the north end. North of the rwy,…NTSB ATL83LA156Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Liberty, NCThe acft collided with trees during takeoff climb and crashed to the ground in a nose low attitude. The 4 occupants received only minor injuries. This was the beginning of a 10 minute night flight in dark overcast conditions. The pilot lowered the acft nose…