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 LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…NTSB SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.NTSB MIA87FA086Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, MSThe acft struck an embankment about 5 feet below the crest & just short of the rwy while attempting to land at dusk & in reduced lighting conditions. The acft exploded & bounced out of the impact crater & came to rest about on the extended rwy centerline. An…NTSB LAX87DVG02Accident · No injuriesFinal reportPiper PA-25-235 · Williams, CADuring an aerial application flt, the plt was paralleling a canal when the right wing became entangled in weeds and contacted the canal. The acft began a right turn when the acft slowed and the left main landing gear contacted the terrain. The acft nosed…NTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.NTSB NYC87FA138Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Lanesville, NYThe plt and his family dptd 2/8/87 on a ski trip to VT. The flt did not arrive. The acft was fnd on a mtn plateau on 5/2/87. Wx conditions rptdly deteriorated and darkness was apching at the estimated time of the acdt, shortly after sunset. The acft impacted…NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…NTSB ANC87LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear, AKThe pilot of the ski equipped airplane stated he taxied too fast after landing and damaged the airplane after the right ski toed into a large snow drift on rough surface ice.NTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…NTSB ANC87IA032Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Barter Island, AKThe pilot flew into rising terrain during a night VFR flight. After shutting down the right engine and achieving only partial propeller feather he elected to make a gear up landing. The plt was flying at 500 ft AGL when he wandered from over water to on-shore…NTSB LAX87DJA04Accident · 1 fatalFinal reportGlaser-Dirks DG-400 · Dillingham, HIThe aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical…NTSB CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…NTSB DEN87FA061Accident · 4 fatalField investigationFinal reportCessna T210L · Nucla, COThe acft was on an IFR flt to an arpt without an instrument approach procedure. ATC cleared the flt to descend to 12,000 ft, the IFR mea for the area, at 30 NM NE of the arpt. At approx 3 min prior to the mishap, the plt was issued a cruise clearance at…NTSB LAX87LA091Accident · Minor injuriesLimited investigationFinal reportCessna C-152 · Bakersfield, CAA Cessna 152 collided with a dirt bank located approximately 140 ft to the left of the rwy edge while on a night apch. The rwy safety area at the aprt extends 60 ft from the rwy centerline. The PIC indicated that he was unable to activate the low intensity…NTSB LAX87FA116Accident · 1 fatalField investigationFinal reportBeech 35 · Monrovia, CAAfter receiving his preflight wx briefing at 0715 hrs, the plt tookoff at 1436 hrs on a x-country flight. There is no evidence that the pilot requested or received a current wx briefing prior to the accident. After the acft was provided flight following…NTSB MKC87FA036Accident · 1 fatalField investigationFinal reportCessna 152 · Berryman, MOThe acft flew into trees and terrain in normal cruise flt. There were no problems found with the acft during post acc invest. The autopsy and toxicology revealed no evidence that could be considered as casual. Wx was not considered to be a problem. The flt…NTSB DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.NTSB LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…NTSB MIA87LA059Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Key West, FLShortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,…NTSB DEN87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Nathrop, COThe canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial…NTSB LAX87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Chico, CADuring an ILS apch to rwy 13L, the plt thinking he was at the missed apch point collided with the terrain 200 yrds west of the arpt. The route of flt was determined to be in a north westerly direction. Exam of the navigational instruments revealed that the…NTSB CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…NTSB CHI87FA050Accident · 1 fatalField investigationFinal reportCessna 182P · Durand, ILStudent pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there…NTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.NTSB SEA87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Murtaugh, IDDuring the transition from a DME arc to the ILS final apch course, the plt allowed the acft to prematurely descend into the ground. The reason for the descent could not be determined. However, no pre-impact mechanical malfunction with the acft was found nor…NTSB ANC87LA018Accident · No injuriesLimited investigationFinal reportCessna U206G · Uganik Pass, AKThe pilot stated that he encountered a complete white-out condition; he started a turn to the left and struck the top of the ridge at the 1780 foot level.NTSB DEN87FA023Accident · 5 fatalField investigationFinal reportBeech A36TC · Steamboat Sprgs, COPlt and four paxs were returning home from a ski vacation. A witness at the arpt observed a normal takeoff and saw the acft turn towards an area of high terrain located approximately 1.5 miles from the Steamboat arpt. The witness observed N36TS continue on a…NTSB LAX87FA055Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Eloy, AZIn cavu weather conditions, the acft crashed into open, level desert terrain at a 30 deg, nose low and near wings level attitude. No pre-impact mechanical malfunctions were found with the aircraft. There were no witnesses to the accident.NTSB NYC87FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glen Mawr, PADrg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.…NTSB SEA87FA027Accident · 1 fatalField investigationFinal reportCessna U206F · Moose Creek, IDAfter departure and during the initial cruise climb the plt and pax heard a metallic clicking described as sounding like a 'valve tap' in an automobile and coming from the eng area. The plt executed an immediate course reversal back to the airstrip while…NTSB CHI87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Minneapolis, MNThe pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.NTSB MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…NTSB MIA87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homestead, FLThe plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway…NTSB FTW87LA012Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Clarendon, TXThe plt was attempting a takeoff with a 12 kt quartering tailwind when the accident occurred. Immediately following rotation and gear retraction, the acft settled and impacted the terrain.NTSB LAX87FA028Accident · Serious injuriesField investigationFinal reportFairchild Swearingen SA-226TC · Santa Barbara, CAOn a dark night, in cavu weather, the captain directed the first officer (who was flying) to disarm the landing gear warning horn system by pulling its circuit breaker. The f/o complied & did not challenge the captain. On final approach the f/o failed to…NTSB DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…NTSB FTW87LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pollok, TXThe dual student was receiving emergency landing training. Power was reduced while on approach which resulted in a loss of airspeed and a high sink rate. Corrective action was initiated too late and the aircraft touched down a few feet short. The landing gear…NTSB BFO87FA004Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Mount Pleasant, MDThe acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which…NTSB CHI87FA009Accident · 1 fatalField investigationFinal reportCessna 441 · West Chicago, ILThe plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very…NTSB ANC87LA006Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Nightmute, AKAccording to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to…NTSB MKC87LA009Accident · No injuriesLimited investigationFinal reportCessna 501 · Little Rock, ARThe PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further…NTSB LAX87MA018Accident · 2 fatalMajor investigationFinal reportCessna 172N · Altadena, CAWhile rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…NTSB MIA87LA008Accident · No injuriesLimited investigationFinal reportCessna 210 · Kissimmee, FLThe plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in…NTSB SEA87LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Perrydale, ORThe acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.NTSB ANC87LA002Accident · No injuriesLimited investigationFinal reportTeal TSC-1A2 · Lewis River, AKThe plt stated that he landed the amphibious acft on the Lewis River with the gear in the extended position. Shortly after touchdown, the acft nosed over on its top. FAA records showed the plt had a total flying time of aprx 710 hrs.NTSB MIA87FA004Accident · No injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Jacksonville, FLReportedly, during an ILS approach to land, the pilot did not use the company approved checklist and landed with the gear retracted.NTSB LAX87LA012Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dolan Springs, AZThe pilot stated that he was climbing the helicopter up a dry wash and planned to cross a 3000 foot high ridge at about 10 feet above the terrain. As he approached the ridge the helicopter yawed to the right about 70 degrees and the acft main rotor lost RPM.…NTSB MKC87FA002Accident · 2 fatalField investigationFinal reportCessna 150 · Fort Scott, KSThe purpose of the flt was to observe and photograph the effects of a flood which had inundated a part of the city of Fort Scott. The acft was observed flying low and slow over the city. Witnesses said the acft was flying from west to east and made a turn…NTSB BFO86FA050Accident · 1 fatalField investigationFinal reportMooney M20F · Leesburg, VADrg arrival, the plt was clrd for a VOR rwy 35 apch. Also, he was advised that there were problems with the rwy lights &that other plts had made missed apchs that evening due to dim arpt lighting. He was then clrd to UNICOM freq & told to cancel his IFR clnc…