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 NYC86LA012Accident · No injuriesLimited investigationFinal reportBell 206B · Colts Neck, NJThe plt entered an autorotation at an alt of 1000 ft MSL at a speed of 100 mph. The plt stated, at 75 ft AGL he started to decelerate and the acft was leveled at 8 ft AGL. Cushioning pitch was used to hold the acft off the ground for a zero ground run on…NTSB MKC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gardner, KSThe pilot stated that he was landing on runway 8 with a right crosswind and had the right wing down for wind correction. The right wheel impacted a lip on the approach end of the runway, 6 inches below the level of the runway. The right gear collapsed, the…NTSB CHI86FEX03Accident · No injuriesFinal reportBell H13G · Mccordsville, INThe helicopter rolled over after the main rotor blades contacted the terrain during an attempt to land from a hover. The plt had a student plt airplane certificate at the time of the accident.NTSB MKC86FA011Accident · 1 fatalField investigationFinal reportBeech V35B · Sullivan, MOThe acft was observed going from level flt to straight up before stalling, turning over and spiraling straight down, at full throttle, toward the ground. Impact marks indicated a near vertical descent with initial impact on the nose of acft. Impact was in a…NTSB DEN86LA010Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Albuquerque, NMDuring landing, while the basket of a Raven balloon was being pulled by the wind driven envelope, it struck a fence and a mobile home trailer. Of the four passengers aboard, one received minor injuries and one received serious injuries. The pilot stated that…NTSB NYC86FA006Accident · 1 fatalField investigationFinal reportde Havilland DHC-6 · Homer City, PAThe acft was observed flying at low altitude along about a 5 mile distance. Some witnesses described the acft altitude as just above treetops. Witness heard engine sounds and saw lights on the acft. The acft flight was on a southeast direction before it…NTSB LAX86LA011Accident · No injuriesLimited investigationFinal reportBeech B19 · Ruth, CAThe 117 hr pvt plt completed a 50 min flt at dusk & prepared for ldg on rwy 31. The plt had never landed on that rwy before & stated that he was unaware of the remarks contained in the arpt/facility directory indicating that the threshold for rwy 31 had been…NTSB MKC86FA002Accident · 2 fatalField investigationFinal reportRockwell 112A · Gravois Mills, MOThe acft was observed on final with the gear down, flying along a ridge that was beside a lake. Witnesses stated that it was below the elevation of the arpt that was on top of the hill. Two witnesses also stated that the eng was running but not at full pwr.…NTSB SEA85LA231Accident · 1 fatalLimited investigationFinal reportMitchell U2 · Prineville, ORPlt was on second flt in newly completed, registered ultralight. Craft had not been issued a certificate of airworthiness. After takeoff, acft was observed to circle airport, then descend out of sight behind trees. Investigation showed steeep, nosedown…NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…NTSB NYC85LA253Accident · No injuriesLimited investigationFinal reportCessna C-170A · Marathon, NYDuring an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…NTSB ATL85FA283Accident · 1 fatalField investigationFinal reportBeech D18S · Huntington, WVThe acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…NTSB DCA85AA037Accident · 14 fatalFinal reportBeech B99 · Grottoes, VAAcft arr fm the NE, crossed ovr the arpt in IMC conds & contd twd the sw to the initial apch fix (iaf) for an ILS rwy 4 apch. The iaf was ovr the outer marker (om), 4.2 mi sw of the arpt. As the acft deptd the iaf, it contd outbnd twd the sw on an imprecise…NTSB SEA85LA224Accident · 3 fatalLimited investigationFinal reportCessna 172PII · Brinnon, WAAcft collided with vertical rock face in mountainous terrain 32 mins after takeoff on night VFR instrument instruction flt, 31 mi west of point of departure. Radar trk shows acft proceeded nw for 14 mins, reversed course for 4 mins, then headed due west into…NTSB LAX85LA405Accident · 2 fatalLimited investigationFinal reportPiper J3 C-65 · Grand Canyon, AZAfter departing pierce ferry, AZ the plt and his passenger flew east, up the Colorado river, at a low level towards kanab point. The plt's notes and charts show that the flt was to turn north for aprx 40 NM, with a refueling stop at kanab, UT. The bright…NTSB NYC85IA238Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYThe acft was making a visual app to rwy 31R at Jamaica NY waen the bottom of the aft 60 ft of the fuselage made ground contact. The left outflow valve was scraped and the rear drain mast was separated. Part of the apr access door and several stringers &…NTSB ANC85LA178Accident · No injuriesLimited investigationFinal reportCessna 180 · Tutna Lake, AKThe plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to…NTSB SEA85LA213Accident · Minor injuriesLimited investigationFinal reportTodd KR-II · Boise, IDThe acft settled back onto the rwy shortly after takeoff pushing both main gear up through the wings. The plt did not have any previous experience in this type acft.NTSB MKC85FA213Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hoskins, NEThis accident occurred on a telephone cable patrl flt. The acft would normally fly along the route of the buried cable at 200 to 300 ft AGL. When construction activity was sighted the plt would first record the sighting on a portable tape recorder and then…NTSB MKC85LA223Accident · No injuriesLimited investigationFinal reportBeech 58 · Greenfield, MOThe plt reports that he extended the landing gear and wing flaps at the same time and the landing gear circuit breaker tripped. The plt was not aware that the gear had not extended and the acft landed with the gear retracted.NTSB LAX85LA386Accident · No injuriesLimited investigationFinal reportPeterson J-4 · Tucson, AZThe student pilot stated that he observed a tow airplane and a glider on the runway as he turned onto the final aproach to land. He said that he continued his approach and when the tow aircraft and glider failed to take off he attempted to turn off the…NTSB ANC85LA171Accident · 1 fatalLimited investigationFinal reportCessna 182B · English Bay, AKA witness stated that he saw the acft crash in the cook inlet while it was in a steep descent. Neither the acft nor the plt were recovered; however, some small objects from the acft were retrieved. The plt was presumed to have been fatally injured.NTSB FTW85LRA04Accident · Minor injuriesFinal reportRockwell S2R-600 · Rosharon, TXThe plt reported the acft contacted the ground after the left boom caught weeds during a spray run.NTSB FTW85LA338Accident · No injuriesLimited investigationFinal reportCessna 150J · Crystal Beach, TXThe plt reportedly was delivering the acft to Crystal Beach, TX, from its home base at orange county airport, TX. The pilot reportedly call the owner and told him he had bent the acft upon landing at Crystal Beach. He was told by the owner to wait at the acft…NTSB SEA85FA203Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Bridge, IDAt 1445 MDT, the 60 yr old plt departed on a routine, VFR, repositioning flt which he had frequently flown before. After takeoff, he leveled the acft at 9500 ft on a direct course toward the destination. While en route at about 1515, the acft began a shallow…NTSB SEA85LA202Accident · No injuriesLimited investigationFinal reportCessna 182R · Reno, NVThe student pilot had only 1.9 hours of flt time in the Cessna 182R and a ttl PIC time of 6.6 hrs. After practicing turns around a point at 800 ft AGL a climb was initiated. The acft was unable to clear the rising terrain due to a density alt of aprx 8200 ft.…NTSB ATL85FA256Accident · 5 fatalField investigationFinal reportPiper PA-31T · Flat Rock, NCAcft hit northwest side of ridge in level attitude,cruise speed,heading southeast. Conditions were dark night and the cloud ceiling was about 40 feet above the ridge. Pilot received wx brief before take off and en route which reported a ceiling of 10,000 feet…NTSB DEN85FA227Accident · Serious injuriesField investigationFinal reportPiper PA-31B-310 · Vernal, UTThe plt cancelled his IFR plan and began descent from 13000 ft in preparation for landing at Vernal, UT. The acft impacted ground in wings level attitude under power. Plt was seriously burned by post-crash ground fire. Investigation revealed no evidence of…NTSB DEN85FA225Accident · Serious injuriesField investigationFinal reportCessna 182J · Torrington, WYThe plt had a limitation on her certificate that prohibited flight at night. The flt was conducted at night and while enroute the plt diverted to the Torrington arpt. The rwy is equipped with plt activated lgts. A witness stated that the acft circled several…NTSB NYC85FNA03Accident · Serious injuriesFinal reportPiper PA-28-151 · Newburyport, MAThe pilot attempted a landing at night with an inoperative landing light and no runway lights. After circling the airport 3 or 4 times he attempted a landing. The aircraft received substantial damage and the pilot received serious injuries. The passenger…NTSB ANC85FA154Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK.1 · Tutna Lake, AKThe acft crashed on the side of a mountain at an elev of 2200 ft aprx 3 miles from its intended destination, a remote lake. Purpose of the flt was to discharge caribou hunters into an area where caribou were spotted early that day. The acft was destroyed by…NTSB DEN85LTG09Accident · No injuriesFinal reportPiper PA-30/A · Bowman, NDThe acft was landed gear up. The plt was aware of the condition at one point in the traffic pattern. A check by retarding the throttle(s) on final produced no warning horn so the plt assumed that the gear was down. After the gear up landing, the circuit…NTSB MIA85LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jacksonville, FLPilot stated that while enroute he experienced an electrical system failure. During approach to the airport he could not get the landing gear to extend and he made a gear up landing. As the aircraft was raised after the accident the landing gear extended and…NTSB LAX85LA345Accident · No injuriesLimited investigationFinal reportAerospatiale SF3130 · Buckeye, AZDuring a hover in a confined area the plt misinterpeted his passg signal to move to a diferent location as a signal that the tail rotor was in danger. The plt used abrupt control movements that resulted in the toe of a skid hooking into a wire fence. The…NTSB ANC85LA188Accident · 2 fatalLimited investigationFinal reportMaule M-5-235C · Mccarthy, AKThe pilot departed a sand bar near the bernard glacier on 8/8/85, and never returned to pick up the passenger he had dropped off earlier. On 8/12/91 the wreckage was found by hunters at 61-11N 141-42W at the 1,000-FT level in mountainous terrain. The wreckage…NTSB ANC85FA146Accident · 2 fatalField investigationFinal reportPiper PA-30 · Kodiak, AKDuring a wx briefing at 0719 adt, the plt was advised that VFR flt was not recommended. Later, at 0827. He called the fss to update his wx & filed an IFR clearance. At 0938, the acft departed anchorage. During arrival at Kodiak, the acft was cleared for an…NTSB LAX85LA338Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAOn aug 4, 1985 an Aeronca 7AC collided with the ground while buzzing over a sand bar near Santa Paula, CA. VMC existed at the time. The ac sustained substantial damage and the pvt plt received minor injuries. He reported no mechanical problems with the ac…NTSB LAX85FUM01Accident · 2 fatalFinal reportAerotek Pitts S-2A · Ramona, CAOn July 28, 1985 at approximately 1820 hours, a pitts S-2A, N56PS, owned and operated by william l. travis, crashed on a hillside on the 192 deg radial, 12.8 nautical miles from the julian VOR. The flight was for the purpose of aerobatics. The aircraft was…NTSB ANC85LA134Accident · No injuriesLimited investigationFinal reportCessna 206 · Kustatan River, AKThe plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over…NTSB CHI85FA301Accident · 1 fatalField investigationFinal reportBell 47G2A1 · Brook, INThe helicopter contacted the terrain in a flat attitude and rolled over during an autorotative landing. A witness stated an autorotation was entered at 800 ft AGL during which the plt made a 360 deg descending turn. An application of pwr was heard at an alt…NTSB CHI85LA298Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pepin, WIThe aircraft traveled three quarters down a 2300 foot sod runway and the pilot attempted to takeoff with 55 KIAS. The aircraft mushed into trees off the end of the runway when the pilot couldn't obtain flying speed. The pilot reported full engine RPM was…NTSB ANC85LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Mccarthy, AKThe pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree…NTSB SEA85LA164Accident · No injuriesLimited investigationFinal reportCessna 172 · Idaho City, IDShortly after takeoff the pilot was unable to outclimb rising terrain. A tree was struck with the left wing tip. And shortly afterwards the aircraft mushed into trees. Density altitude at the time of takeoff computed to be about 6000 feet. The aircraft was…NTSB CHI85FA284Accident · 1 fatalField investigationFinal reportEipper MX Super · Almont, MIWitnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had…NTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…NTSB LAX85FA314Accident · 1 fatalField investigationFinal reportMooney M20J · Antioch, CAThe acft crashed into a reservoir shortly after departing the Antioch arpt. There were no eye witnesses to the crash. However, an ear witness stated that he heard the acft skipping along the water like the sound of a hydro-plane. He did not hear the eng, but…NTSB DEN85LTG03Accident · No injuriesFinal reportPiper PA-25-235 · Kramer, NDThe acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt.NTSB ATL85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAAccording to the pilot, he forgot to extend the landing gear. He stated most of his flight time had been in fixed gear aircraft. On this flight he had been told by his instructor to work on smoothing his radio technique on the second landing of the flight he…NTSB ANC85LA121Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Summit Lake, AKHelicopter struck glassy water lake during a low alt turn. Plt/flt instructor said he became disoriented during the turn, after he looked inside the helicopter briefly to check the rotor RPM. Accident occured during a bright night.NTSB DEN85LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182-R · Telluride, COThe plt said that he maneuvered the near max gwt acft in close proximity to a ski slope and 'I didn't leave myself an exit.' The plt then applied full power in an attempt to outclimb the rising terrain but impacted a knoll. Density altitude was computed to be…