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 FTW83LA412Accident · No injuriesLimited investigationFinal reportCessna 421C · Port Lavaca, TXThe acft collided with a fence and bushes during takeoff. The rwy was shell and turf construction 2300 ft long. The plt figured the takeoff distance from a chart using dry hard surfaced level rwy. The acceleration seemed slow according to a witness and the…NTSB ATL83LA352Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Tyler, ALThe plt reported that while he was spray a field, he was flying under 2 transmission lines. He reported that as he began spraying the field, there was a thunderstorm aprx 2 to 3 mi away & the air became 'rough.' As the acft was crossing under the 2nd wire on…NTSB ATL83FU006Accident · 1 fatalFinal reportCondor II · Slate Hill, VADuring a local flt, the ultralight vehicle was observed approaching a residence in a shallow descent & with little eng noise. A witness stated that just prior to hitting a tall tree, the eng sound increased, the nose pitched up & the empennage struck tree…NTSB SEA83LA191Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1 · Eatonville, WAThe acft collided with a tree during a go-around. The pilot was able to continue flt to another arpt and complete a landing. During the attempted landing at the accident arpt the pilot stated she 'did not touch down when I expected'. During the go-around the…NTSB CHI83LA408Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Little York, INThe plt stated that he circled & looked for wires & obstructions prior to spraying. During a run he flew over a first set of wires but struck a second set of wires which were not marked & the poles were difficult to see because they were in trees. From the…NTSB SEA83LA188Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Quincy, WAThe acft collided with a car on the rwy during an aborted landing at a private airstrip. The pilot saw the auto as he turned base but believed the driver would cross and clear the rwy. Instead the driver went down the rwy in the directionof landing. When the…NTSB ATL83FKG11Accident · 1 fatalFinal reportCessna A188A · Jesup, GAThe plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered…NTSB SEA83FA187Accident · 3 fatalField investigationFinal reportCessna 182C · Near Elk River, IDThe acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.…NTSB LAX83FU014Accident · 1 fatalFinal reportDavis Homebuilt · Byron, CAGround witnesses reported that the ultralight departed the private airstrip to the east. After departure the plt negotiated a 90 deg lt turn, followed by a 270 deg rt turn. After the 90/270 deg turn was completed, the plt negotiated a rt traffic pattern but…NTSB FTW83LA423Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Opelousas, LAAfter aborting 3 tkofs from a short grass strip the plt decided the grass was too long. Aft mowing the grass and an additional area to extend the length of the strip the plt took off alone to see if the length was suitable for takof. The plt then lndd and…NTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.NTSB MKC83LA203Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Junction City, KSDuring arrival, the plt noticed an isolated thunderstorm just to the west of the arpt. While on the approach, he noticed the wind sock indicating a southeast wind with little velocity. The plt stated that when he was on a short final approach, the wind…NTSB DEN83LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-25B-235 · Montrose, SDThe pilot stated that he was spraying a field that was divided in half by a 60 foot high powerline. As he made a turn to enter the south side of the field, parallel to the powerlines, flying east into the sun, he struck the unseen guy cables out in the field.…NTSB CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.NTSB NYC83LA225Accident · No injuriesLimited investigationFinal reportCessna 182C · New Salem, MAThe acft collided with high tension wires while flying at about 100 ft AGL. The plt landed in the water and all 4 occupants evacuated safely. The ditching was controlled but the acft nosed over after impact. The passengers said they had no trouble until they…NTSB FTW83LA396Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Addis, LAThe acft made a forced landing in a plowed field after colliding with a low hanging transmission wire over a field beingsprayed. The plt applied full power after the collision but a damaged and locked up elevator caused excursions of climbing, stalling and…NTSB ATL83FA339Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Lexington, GAThe plt was on a cable patrol/aerial observation mission. While patrolling, he missed a turn in the cable route & turn to relocate it. After relocating the route, he looked back to observe a portion that he had missed & saw a logging operation. The plt turned…NTSB FTW83LA392Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · San Antonio, TXBoth occupants were confederate air force personnel. The plt-in-command (PIC) reminded the other occupant of wires in the area where the were flying on base leg. The other occupant replied, 'yes, I see them & think we will be above them.' He then replied,…NTSB CHI83LA392Accident · Minor injuriesLimited investigationFinal reportAyres S2R-R1820 · Essexville, MIWhile on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under…NTSB ATL83FA337Accident · Minor injuriesField investigationFinal reportCessna 414A · Marion, NCDuring the takeoff run, at 85 KTS, the acft hit a bump & the plt stated his forward vision was obstructed by water on the windshield. He instinctively pulled back on the controls & become airborne. He lost sight of the right side set of rwy lights & was…NTSB DEN83LA194Accident · No injuriesLimited investigationFinal reportPiper PA-12 · St. Xavier, MTThe acft collided with a fence during an attempted go-around in a field which was estimated to be 500 ft long. The wind was calm and the density alt was calculated to be 4900 ft. after landing and rolling 300 ft the plt decided he would not be able to stop.…NTSB CHI83LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Canton, MNThe acft collided with a tree about 20-30 ft AGL in IMC weather after calling rochester approach at 1244 CDT to say that he was lost and in a thunderstorm. The plt was not instrument rated. Radio contact was lost at 1247 CDT. The flt originated in alton, IL…NTSB ATL83LA338Accident · No injuriesLimited investigationFinal reportCessna 172 · Falls Of Rough, KYThe acft collided with a power line during a G0-around. Investigation revealed the acft had rolled about 3/4 of the way down the 2700 ft rwy before a go-around was started. The collision occurred 850 ft beyond the departure end of the rwy 30 ft AGL and 400 ft…NTSB NYC83FFA02Accident · Serious injuriesFinal reportCessna 150M · So. Fallsburgh, NYThe acft was observed performing low level steep turns, climbs & dives over a hotel. The acft collided with the tops of trees, nosed over & crashed. The student plt resides at, & is employed by, the hotel.NTSB LAX83LA384Accident · Serious injuriesLimited investigationFinal reportCessna 150K · N. Palm Springs, CAThe plt reported he originally intended to fly aprx 19 mi to the Palm Springs arpt to perform night landings to acquire night currency. However, due to a radio malfunction, he was unable to communicate with the control tower. Therefore, he decided to return…NTSB FTW83LA375Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lyons, TXWhile on the return portion of a round-robin x-country flt, the plt lost thermal lift & elected to land in a pasture. He gradually descended over the pasture & prepared to land. When the glider was about 30 ft AGL, the right wing tip struck the top of a tree,…NTSB CHI83LER03Accident · Serious injuriesFinal reportBoeing A75N1 · Sabin, MNAcft collided with power lines.NTSB MKC83FA189Accident · Serious injuriesField investigationFinal reportPiper PA-25-260 · Whittemore, IAThe plt reported he was making a trim swath in a low area toward rising terrain when he approached an unexpected 'high line' wire. The wire was positioned diagonally across the field. He reported that while avoiding the wire, he was unable to clear nearby…NTSB FTW83LA378Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Grove, OKThe acft was high & fast on final apch & touched down about 1/3 of the way down the rwy. The nosewheel touched down 1st & the acft began to porpoise. The plt applied power to stop the porpoise, then elected to go around. In order to avoid trees near the end…NTSB CHI83FA381Accident · 2 fatalField investigationFinal reportBeech G18S · Evart, MIThe acft collided with a utility pole and a large tree during a forced landing after a power loss on takeoff. Witnesses heard the acft backfiring and the ground run was excessively long. Immediately after takeoff the acft went through the tops of pine trees.…NTSB CHI83LU007Accident · Serious injuriesFinal reportBerwin Waspair Tomcat Tour · Oconomowoc, WIThe ultralight collided with a tree during a go-around. The acft encountered an updraft during the landing attempt and the pilot decided to go-around. The acft was not able to gain alt fast enough to clear a tree at the end of the field. The pilot was in…NTSB MKC83FA184Accident · Serious injuriesField investigationFinal reportCessna 172M · Minden, NEA student plt in left seat made the takeoff using 10 deg flaps. At about 50 ft AGL passing over the departure end of therwy, the PIC noticed the acft was sinking & took the controls. The acft impacted trees as the PIC was avoiding power lines. The flaps were…NTSB FTW83LA372Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMDuring a pre-solo flt, the flt instructor (CFI) asked the student to make a simulated forced landing apch to a road. The student made the apch, but while he was making a go-around maneuver, the acft's right wing tip collided with a tree on a rise in the…NTSB SEA83LA170Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315B · Montpelier, IDThe plt & 3 passengers were on a flt to find drilling supplies that had been dropped off of a truck on the previous day. The plt reported that he was hovering down an abandoned road at about 5 to 10 mph & 15 to 20 ft AGL when the helicopter collided with…NTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…NTSB FTW83FA361Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201T · Seminole, TXPrior to the flt, the plt & passengers were observed drinking beer in a lounge. They told witnesses that they were going to the arpt to eat & were later seen at a restaurant on the arpt. After that, they decided to fly. The takeoff time & purpose of the flt…NTSB FTW83FA364Accident · No injuriesField investigationFinal reportBalloon Works Firefly AX-7 · Fort Worth, TXThe intended landing area was a parking lot. Adjacent to the lot was a one-story building on top of which a tv antenna about 20 ft above the roof top. In an effort to clear the antenna during the descent to the parking lot, the pltwas not aware of a set of…NTSB CHI83LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Baroda, MIThe acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing…NTSB NYC83FNC09Accident · Serious injuriesFinal reportCessna 172 · Enosburg Falls, VTThe plt reported that when he was on final to land on a dark night, the acft had electrical failure & he had no lights. He reported that this occurred when he had started his flare & that was all he could remember until after he had regained consciousness…NTSB ATL83LA310Accident · No injuriesLimited investigationFinal reportCessna T188C · Semmes, ALThe acft collided with a power line during an aerial application maneuver. There were 2 set of wires crossing the area, a low set and a high set. The pilot suddenly came upon the low set and climbed over them but collided with the high set. The vertical…NTSB SEA83LA163Accident · No injuriesLimited investigationFinal reportCessna 172M · Friday Harbor, WADuring arrival, the plt elected to land on an uphill rwy with a tail wind. She stated that she was high on final & side slipped until reaching the correct altitude while using the VASI lights for a reference. As she approached the rwy, the wind blew the acft…NTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.NTSB CHI83LA338Accident · No injuriesLimited investigationFinal reportKane Bush BY Mustang 2 · Winona, MNThe plt initiated a takeoff on a 2000 ft grass strip. He stated that the takeoff was normal until it became apparent that the acft would not climb out of ground effect. Since the go/no go decision point had been passed, he attempted to climb straight ahead.…NTSB MIA83LA188Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Melrose, FLThe plt took off on rwy 11 (elev 150 ft MSL) with a density alt of 1500 ft. he reported the wind was calm, but aprx 14 mi west at gainsville, FL, the 2052 EDT wind was from 250 deg at 9 KTS. During takeoff, the acft climbed aprx 75 ft, then settled into trees…NTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…NTSB DEN83LA177Accident · No injuriesLimited investigationFinal reportBell 206B · Melrose, MTThe helicopter tail rotor contacted a forest service sign post during landing. The pilot was aware of the post when landing but landed near it for convenience in refueling. The landing was on a slope and the nose of the acft started sliding on the slope. The…NTSB ANC83FA126Accident · 1 fatalField investigationFinal reportHelio H395 · Fairbanks, AKTakeoff was from a dirt driveway which had a usable length 0F 330 ft before it curved north. Before takeoff, the plt hadbent several small trees back away from the driveway & tied them down so they would not interfere with the takeoff. There are numerous…NTSB CHI83LA323Accident · No injuriesLimited investigationFinal reportCessna 150 · Wilmot, WIThe acft collided with a tree during a go-around. The pilot added full flaps as the rwy was approached. During the flare the acft ballooned and bounced. A go-around was started but the flaps were not raised. The acft did notachieve enough climb to clear the…NTSB FTW83LA338Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Garland, ARThe plt-in-comand (PIC) & the designated flt examiner (fe) were on a flt to give the PIC a commercial plt flt exam. During a simulated forced landing apch, the PIC spiraled the acft down to the proposed landing spot. The proper check list procedures were…NTSB CHI83LA321Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooklyn Park, MNThe plt reported that he was spraying the end rows of a field when the helicopter approached some wires. He stated that he saw the wires at the last second & tried to get under them. Reportedly, the helicopter crossed below a set of power lines, but struck a…