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 LAX88DVD01Accident · No injuriesFinal reportTexas Helicopter Wasp/M74L · Petaluma, CADuring an aerial application flight, while on the last pass, the aircraft struck a power line that became entangled in the rotor blades. The pilot was unable to maintain control of the aircraft and collided with the terrain. There were no reported mechanical…NTSB ATL88LA057Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Monroe, GAThe Beech D35 was landing at a private airstrip from which it had departed fifteen minutes earlier. The final approach was to the south, into the sun. On short final the pilot looked down to verify that the gear was down. He looked outside again just in time…NTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…NTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…NTSB ATL88FA046Accident · 1 fatalField investigationFinal reportCessna 152 · Oliver Springs, TNThe plt had deptd from a small airport nr kingston, TN mid afternoon and had landed at another about 30 nmi to the NE. He remained on the ground 30-45 min departing between 1530-1545. According to info gathered, the aircraft was observed to fly over the oak…NTSB SEA88FA023Accident · Serious injuriesField investigationFinal reportCessna 172M · Hillsboro, ORThe daily radio traffic reporting flight was cleared for an IFR departure from Hillsboro airport in IMC. The owner/ operator of the aircraft stated the company had a 'no ifr' policy. On takeoff witnesses observed the aircraft to be lower and slower than…NTSB MIA88FA044Accident · 1 fatalField investigationFinal reportCessna 172N · Palm Coast, FLThe student plt was flying the acft on a solo instructional flt in the north practice area & was assigned to practice landings, takeoffs, stalls & slow flt. Witnesses stated they observed the acft flying at a very low altitude just before it collided with a…NTSB ATL88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Hazel Green, ALThe airplane hit a tree and crashed about 300 yds short of the rwy while on final appch to land. The plt indicated that he became preoccupied with the airspeed indicator and allowed the airplane to descend below the proper glide path. The plt had less than 1…NTSB LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNTSB ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…NTSB MKC88FA019Accident · 2 fatalField investigationFinal reportPiper PA-32R · Fayetteville, ARThe airplane was cleared to land while on downwind. Tower saw lights and said airplane appeared to be flying around hill north of airport. Investigation revealed airplane had turned left and impacted trees below the top of the hill.NTSB NYC88LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Montoursville, PAAfter takeoff, the plt remained in the traffic pattern to practice takeoffs & landings. He made a touch-&-go, then rprtd on a right downwind for another landing. He acknowledged a clearance to continue, but moments later, an ELT signal began transmitting.…NTSB SEA88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Winnemucca, NVThe plt was attempting to land close to the approach end of the rwy. He made the approach with full flaps at 85 mph the rate of descent became excessive and before recovery was affected the acft collided with a fence near the rwy threshold. The acc site was…NTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…NTSB LAX88LA036Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Carmel Valley, CAThe plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after…NTSB CHI88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Hudson, MIThe student pilot was on his first solo flight. Before turning onto final approach to land, he noticed another aircraft ahead, already on final approach. The student decided to s-turn for spacing, but while maneuvering, altitude was lost. Subsequently, he saw…NTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…NTSB NYC88LA021Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21B · Montgomery, NYThe aircraft was on approach for landing on runway 26 at orange county airport. However the aircraft collided with a tree about 200 yards from the runway threshold just outside of the airport boundary.NTSB MIA88LA021Accident · No injuriesLimited investigationFinal reportParrish Dragonfly · Boca Raton, FLWhile on short final approach the flight encountered a wind gust which caused the left canard to drop. The landing gear on the left canard then struck the raised lip of the runway causing substantial damage. The aircraft came to rest on the runway.NTSB BFO88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Churchton, MDThe plt rprtd that after searching unsuccessfully for a wind sock & getting no reply on UNICOM freq, he made an apch to rwy 16. Later, he saw the wind sock about half way down the rwy near a building. Drg the apch, he noticed he was high & put the acft in a…NTSB MKC88LA014Accident · Serious injuriesLimited investigationFinal reportNational Balloon 752 · Ankeny, IADuring a promotional balloon flt, the plt stated that on an approach to lnd the basket drifted into a large hay bale. The basket tipped and the plts ankle was broken when caught between the basket and a propane tank.NTSB DEN88LA011Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aspen, COThe plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…NTSB LAX88FA016Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Buena Park, CAWhile depg on an IFR flt to VFR conds, the plt failed to provide the correct transponder code per ATC clnc. The local controller (ctlr) reminded him to set the correct code & the plt subsequently replied 'I'm having a problem right now . . . I've got to get…NTSB FTW88FA005Accident · Serious injuriesField investigationFinal reportCessna 175 · Crystal City, TXThe plt was attempting a night visual apch to his unlighted pvt strip when the acft struck trees, flew under a pwr line,struck additional trees & subsequently impacted the gnd. The acdnt occurred aprx 2.5 miles short of the threshold. Samples of the plt's…NTSB MKC88FA003Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Wakeeney, KSThe owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &…NTSB ANC88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip.NTSB MKC88LA001Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Wamego, KSDuring a night ldg the plt aligned the acft with the white tops of a fence that was parallel to the runway. Not all of the rwy lights were illuminated. Both wings and the lower fuselage were substantially damaged during the lndg on the fence.NTSB DEN88FA002Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · Fowler, CODuring a pleasure flight the pilot flew too low over the Arkansas river, collided with powerlines and crashed into the river. The pilot stated he could not see well due to the setting sun in his eyes. The pilot and his passenger received serious injuries and…NTSB FTW88LA001Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bulverde, TXOn the second approach after a go-around, the aircraft landed approximately halfway down the 2850 ft runway. In an attempt to go around the pilot applied power. The aircraft started to climb but collided with the top of a tree causing the tail of the aircraft…NTSB NYC87FA265Accident · 1 fatalField investigationFinal reportBeech D95A · Pittstown, NJPilot departed runway 26 at alexandria arpt toward trees in fog. Left wing hit trees. Acft landed hard collapsing landing gear. Acft hit a tree in area of pilot seat during lndg fatally injuring the plt.NTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…NTSB MIA87FA260Accident · 2 fatalField investigationFinal reportBeech B35 · Kissimmee, FLThe plt bgn taking off on a pvt 1800' grass strip which had trees nr the edges. Aprx 1575' fm the threshold, there was a parked acft nr the left side of the strip with its rgt wing protruding over the rwy area. While taking off with a rgt qtrg tail wind, the…NTSB DEN87LA245Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Bountiful, UTWhile on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir.NTSB ATL87FA262Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Demopolis, ALThe plt of an aircraft carrying an estimated 317 kilos of cocaine was attempting to land at an apt which did not have a published instrument approach procedure in IMC. Witnesses estimated that the visibility was no more than 1/2 mile in fog about 45 min after…NTSB FTW87DPJ09Accident · Serious injuriesFinal reportG&C Helicopters EL Tomcat MK5A · Marlow, OKPilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn.NTSB FTW87FA223Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenwood, LAThe pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously…NTSB CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…NTSB MKC87LA175Accident · No injuriesLimited investigationFinal reportCessna 180B · Atkinson, NEWitnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to…NTSB MKC87FA172Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Weiner, ARThe plt rprtd he was on a flt to chase birds from a rice field. Drg a low pass over the field, the main wheels dscndd into the rice crop, & after about 1000', the acft contacted the terrain & nosed over. The single place acft was equippedwith only one seat…NTSB ANC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot of the airplane was an Alaska state trooper performing his official duties and was flying an airplane owned and operated by the state of Alaska. He had landed on a remote ridge top to recover essential items of evidence for a pending case. Upon…NTSB ANC87LA158Accident · No injuriesLimited investigationFinal reportCessna 207 · Two Lakes, AKThe pilot stated the gravel airstrip was muddy and he lifted off at the end of the strip. The aircraft clipped a tree with the horizontal stabilizer and the airplane settled into the trees.NTSB ATL87DKG07Accident · Serious injuriesFinal reportGrumman G-164A · Alamo, GAThe acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.…NTSB NYC87LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Brookline, NHDuring an approach to land at night, the pilot saw deer on the runway that were facing his direction and moving to the right. He didn't see the deer until he had reached a point were a go-around would be unsafe for this runway. In an effort to avoid the deer,…NTSB FTW87DPJ08Accident · 1 fatalFinal reportAir Tractor 301A · Hollis, OKDuring an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or…NTSB SEA87LA186Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Quincy, WADuring an aerial application maneuver the pilot flew into two 23,000 volt powerlines. The helicopter's rotor blades struck the powerlines, the aircraft turned to the right and descended to the ground.NTSB NYC87FA251Accident · 2 fatalField investigationFinal reportCessna 152 · Boxborough, MAThe IFR flight from auburn-lewiston, Maine to the manchester, new hampshire VORTAC facility was without incident. Boston center cleared the flight for the vor/dme instrument approach procedure to runway 21 at the uncontrolled stow/minute man airport, stow,…NTSB LAX87FA332Accident · 3 fatalField investigationFinal reportBell 206B · Vallejo, CAWhile performing a routine aerial observation flight to inspect the integrity of the pacific gas & electric company's transmission lines, the helicopter crashed after colliding with an unmarked static wire. The line installation was on sloping terrain &…NTSB CHI87LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Perham, MNThe pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed.NTSB LAX87LA324Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lee Vining, CAWhile flying over mountainous terrain. The pilot inadvertently followed the wrong road & went into a box canyon area. He stated the visibility was about 5 miles & he did not see the upcoming rising elevation. Eventually, he got into a situation were the acft…NTSB DEN87LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-210 · Yuma, COThe plt said that during his final approach for landing he thought his airspeed was too high for touchdown and he attempted to go around. During the go around his acft struck an arpt sign and a bldg.