NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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\" = 230) 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" = 230) 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 DEN84LA105Accident · No injuriesLimited investigationFinal reportCallair A · Tremonton, UTThe acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the…NTSB NYC84MA102Accident · 3 fatalMajor investigationFinal reportPiper PA-31 · Cumberland, MDApprox 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy…NTSB FTW84LA154Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Intracstl City, LAThe helicopter collided with marsh terrain while spotting dead alligators. The plt does not remember events of the accident. The helicopter operator stated the helicopter appeared to have impacted at a low airspeed at a normal RPM. The emergemcy floats were…NTSB MKC84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Point Lookout, MOThe plt angled in on the final approach at low alt. And the right landing gear hit a snowbank. The collision pulled the acft into the snow and it nosed over.NTSB NYC84FA092Accident · Minor injuriesField investigationFinal reportCessna 425 · Dryden, NYThe plt stated that he was utilizing the autopilot and flt director to execute the ILS appch to rwy 32. The autopilot was tracking the localizer while the pilot controlled the rate of descent along the glideslope with pitch command wheel on the autopilot,…NTSB LAX84LA190Accident · No injuriesLimited investigationFinal reportMooney M20C · Scottsdale, AZThe plt reported that he failed to extend the landing gear prior to touchdown. Subsequently, the acft was damaged during a wheels up landing.NTSB FTW84LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-25-150 · Altus, OKThe acft crashed in a wheat field that was being spray, then was destoyed by a post crash fire. According to the operator, the plt was at the end of a swath run when he glanced into the cockpit to visually check how much chemical was remaining in the hopper.…NTSB ATL84FA099Accident · 1 fatalField investigationFinal reportPiper PA-30-160 · Massies Mill, VAWhile en route, the plt was progressing northbound when he contacted the Washington fss at 2134 EST for updated wx info. At that time, he described his position as north of lynchburg, VA. The fss briefer noted that his voice was normal, his manner was calm &…NTSB DEN84LA088Accident · No injuriesLimited investigationFinal reportMooney M20C · Angel Fire, NMThe plt reported that during takeoff, the acft slowed as it hit patches of slush. He lifted off at the end of the rwy & retracted the gear while in ground effect. The acft would not maintain flying speed & settled in snow. It then went thru a fence beyond the…NTSB ATL84LA094Accident · No injuriesLimited investigationFinal reportBeech F33A · Marion, SCThe plt stated he was involved in a discussion with the company president, who was on board, during the landing apch and he failed to use the checklist. The acft was landed gear up. It was later determined the gear up warning horn was inop.NTSB DEN84LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-4S · Three Forks, MTThe plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was…NTSB MIA84LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Naranjito, PRThe acft collided with hilly terrain during a low pass. The plt was preparing to land at a nearby private airstrip.NTSB DEN84FA081Accident · 1 fatalField investigationFinal reportEnstrom F-28C · Chester, MTAccording to a company employee, the plt made a radio call from a remote mountain site where the plt was doing some workon a transmitter tower & stated that he was taking off, & if the employee did not hear from him in an hour to come look for him. The…NTSB DEN84FA076Accident · 2 fatalField investigationFinal reportBeech A36 · Columbus, NMThe plt took off at night in the company of plts flying 2 other acft, a Cessna 150 & a Piper PA-22. N719K, a Beech A36 bonanza, was flying ahead of the other 2 acft. The plt of 1 of the other acft stated that the bonanza plt would usually fly at a slower…NTSB MIA84FA067Accident · 1 fatalField investigationFinal reportBell 206B · Stuart, FLWitnesses observed the helicopter flying at 100 to 150 ft above the water & about 100 yds offshore. They observed & heard nothing unusual, except they said the helicopter began descending until it impacted the water. The rear doors had been removed for the…NTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…NTSB MIA84IA062Incident · No injuriesIncident investigationFinal reportBeech D18S · Jacksonville, FLThe acft landed gear up at the Jacksonville, airport. Exam of the gear ext system revealed no malfunctions or failures.NTSB MIA84FA056Accident · 2 fatalField investigationFinal reportCessna T207A · Zolfo Springs, FLThe acft collided with trees and the ground during takeoff in IMC weather. The visibility was zero due to ground fog. There were no known witnesses to the accident but there was evidence of a collision with a 60 ft high tree at the end of the 3000 ft rwy. It…NTSB ANC84LA029Accident · No injuriesLimited investigationFinal reportCessna 172RG · Big Lake, AKThe dual student and instructor were practicing emergency procedures. During the turn onto final approach the left main landing gear and left wing struck a snowbank. Flying club procedures state that no emergency practice procedure will be conducted below 500…NTSB DEN84FA065Accident · 1 fatalField investigationFinal reportCessna 320C · Provo, UTThe acft had been cleared for an ILS rwy 13 apch. A witness, located just north of the rwy, saw an acft pass overhead & stated that the acft was not an a correct apch. The acft then began heading west as if to circle for a 2nd apch. The witness also estimated…NTSB LAX84LA217Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Hana, HIThe acft disappeared from radar about 8 mi north of Hana, HI, while on an over-water flt. When it did not return from the flt, a search was intiated, but the acft was not found. Only the nose wheel strut (which washed ashore) and a life vest (found by…NTSB LAX84FA130Accident · 1 fatalField investigationFinal reportBell 47J-2 · Kahuku, HIAbout 3 min after takeoff, the helicopter was observed descending in a 'gliding fashion' until water impact. A witness reported that it appeared to be flying straight & did not appear to be in trouble. The witness reported that she could hear the eng & it…NTSB CHI84FA073Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Traverse City, MIPrior to the flt, the plt made a phone call to a relative who lived near the southeast side of long lake & said he would 'pass over in about 10 min.' After he took off, the acft was observed in a low pass over the southeast corner of the lake. The acft then…NTSB MIA84FA053Accident · 3 fatalField investigationFinal reportCessna 210M · West Palm Beach, FLAt 1926 the plt was cleared for the LOC bc arch for rwy 27R. At 1927 the acft acknowledged a clearance to land. 10 secs later the radar target disappeared. The plt was rescued at 2050 from the waters of the atlantic ocean about 1 mioff the Beach at West Palm…NTSB MKC84LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manhattan, KSThe plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear…NTSB NYC84LA055Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Dummerston, VTThe plt initiated a practice autorotation from about 600 ft AGL. Airspeed was about 55 KTS with low m/r RPM due to low gross weight. A moderate flare was initiated in an effort to increase rotor RPM, reducing the airspeed to 40 KTS. However, the application…NTSB NYC84FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Buffalo, NYThe acft collided with lake erie during ILS approach to rwy 05 at Buffalo, NY. The acft had been descended to 3000 ft and the plt reported turning inbound from dunkirk VOR to the ILS. He was cleared for the approach and told to report the outer marker to…NTSB LAX84LA104Accident · Serious injuriesLimited investigationFinal reportBell 47H-1 · Paradise, CAAccording to witnesses, the helicopter lifted off near the north end of rwy 17 while on an eastenly heading. After lift-off, it turned right, as if to proceed down the rwy. After rising to about 5 ft AGL, it settled & contacted the rwy, rose again, then…NTSB CHI84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Brainerd, MNAfter making a vor/dme apch, the plt circled to land on rwy 23 in wx conditions of light snow & fog. The terrain & rwy were covered with snow. The plt tried to contact Brainerd UNICOM to have the rwy lights turned up, but he received no response. He could…NTSB LAX84FA101Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Tucson, AZThe acft crashed during a local multi-engine instructional flight. There were no known witnesses to the accident. Examination of the wreckage failed to reveal any pre-impact malfunction of the aircraft or engine.NTSB ANC84LA022Accident · No injuriesLimited investigationFinal reportCessna C-185A · Quinhagak, AKThe acft struck a snowbank during an attemped go-around. According to the plt there were no mechanical problems that contributed to the accident. The plt did not submit an accident report and attempts to reach him by telephone have been unsuccessful. The…NTSB CHI84LA057Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Owosso, MIThe acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2…NTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…NTSB LAX84FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, CAThe acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly…NTSB FTW84LA089Accident · 1 fatalLimited investigationFinal reportCessna 150G · Clinton, OKThree witnesses observed the acft flying low before it went out of sight behind trees. Two of them reported that the plt made 3 low fly-bys with the eng sounding normal, then they heard the acft impact in a field on the 3rd pass. An exam of the crash site…NTSB CHI84FA053Accident · 3 fatalField investigationFinal reportCessna T210M · White Lk Twnshp, MIAt about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the…NTSB FTW84FA082Accident · 1 fatalField investigationFinal reportCessna 310K · Hodgen, OKThe plt had purchased the acft at rexburg, id on the day of the accident. Reportedly, the previous owner had flown with the plt, before the plt departed rexburg, and said he had flown the acft very well. The previous owner stated that the DME was not…NTSB MIA84FA038Accident · 1 fatalField investigationFinal reportCessna 172RG · Cross City, FLWhile in the vicinity of Cross City the plt requested VFR flt following from jacksonville ARTCC. While he was in radio &radar contact, the controller suddenly lost radar contact with the flt. Radar indicated that the acft made a rapid descent from the cruise…NTSB NYC84FA042Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Bennington, VTThe acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is…NTSB MKC84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAAfter takeoff for an FAA part 135 check ride, the aircrew were unable to get a positive up indication for the landing gear. The gear was recycled & then the left main gear would not get a down & locked indication. Repeated attempts to extend the left main…NTSB LAX84LA079Accident · 1 fatalLimited investigationFinal reportCessna 180 · Las Vegas, NVWhile on a x-country flt, the acft collided with the crest of a 10,000 ft mountain. Witnesses stated that the plt had circled in the area prior to the accident. The accident reportedly occurred at dusk, but witnesses said the area to the north of the site was…NTSB ATL84AA053Accident · 6 fatalFinal reportBeech A36 · Armuchee, GAThe acft collided with trees and higher terrain which was adjacent to the VOR approach path. The weather was described by witnesses as stormy with heavy rains and high winds. Some of the occupants of the accident acft were airsick according to the plts radio…NTSB SEA84FA023Accident · Serious injuriesField investigationFinal reportCessna 304A · Ephrata, WAThe acft collided with a hilltop during a missed approach in IMC weather. The acft was on an IFR flt plan. The plt stated visual contact was EST at about 2000 ft MSL but ground features were masked in snow. When the plt did not see the airport at the proper…NTSB LAX84LA069Accident · No injuriesLimited investigationFinal reportCessna TU206E · Red Rock, AZThe acft taxied into a ditch after landing on a road at night. After the acft came to rest it was apparently intentionally burned. Sob & injuries are presumed. The landing site was marked by the placement of white cloths along the edges of the road. The acft…NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…NTSB FTW84MA069Accident · 4 fatalMajor investigationFinal reportCessna 210N · El Paso, TXN4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The…NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…NTSB LAX84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Peach Springs, AZReportedly, the wind was variable & gusty when the acft took off from the hualapai arpt, Peach Springs, AZ. The plt reported that after rotating for takeoff, the acft moved laterally to the left, and as he was correcting for the movement, the left main gear…NTSB DEN84LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Colorado Spgs, COThe Piper PA-18, N3594P, was being used to tow a burkhart grob flugzeugbau G103 twin astir, N4246L. At 0950 MST, the wind was reported from 310 deg at 9 KTS. Since the terrain sloped downhill to the south, rwy 17R (covered with hard packed snow) was being…NTSB ATL84FA044Accident · 1 fatalField investigationFinal reportPiper PA-31-300 · Charlotte, NCThe acft was first radar identified about 18 mi north of the arpt & was given radar vectors for a right downwind & base to rwy 36R. While on a downwind heading 150 deg, the plt was assigned a heading of 270 deg & was queried if the arpt wasin sight. The plt…