NTSB investigations
1,048 cases where the first occurrence was “On ground/water encounter 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\" = 320) 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" = 320) 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 CHI82DA307Accident · No injuriesFinal reportPiper PA-28-151 · Kankakee, ILSometime after 2300 on August 14, 1982, the aircraft was taken without authorization from the greater Kankakee airport. The aircraft was discovered in a nearby field some 750 feet from the runway. Markings on runway 04 indicated that approximately 150 feet…NTSB FTW82DA321Accident · No injuriesFinal reportCessna 152 · Iredell, TXThe student pilot originally took off at temple, TX and proceeded to mcgregor, TX to practice touch-and-go landings. After departing mcgregor to return to temple, he became lost. After about two hours, he landed in a pasture and received directions to temple.…NTSB CHI82DA297Accident · No injuriesFinal reportLake LA-4-200 · Standard Rock, MIAfter landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage.NTSB CHI82DA289Accident · No injuriesFinal reportCessna 150 · Caledonia, MNThe pilot stated that the wind was from about 135 deg at 10 KTS. He stated he made a mistake and landed on runway 31 instead of 13. Reportedly, his touchdown was too FAR down the runway for a safe landing. He initiated a go-around but the stall warning horn…NTSB MKC82DA134Accident · No injuriesFinal reportCessna R172K · Hansell, IAThe pilot reported that during the takeoff roll, he was blinded by the sun and allowed the aircraft to drift into tall corn beside the runway. Subsequently, the aircraft nosed over.NTSB LAX82DA281Accident · No injuriesFinal reportBeech 95-B55 · Henderson, NVPilot raised landing gear instead of flaps on a touch and go landing. Pilot owns a C-411 and a BE-B55. Switches are reversed on these aircraft.NTSB FTW82DA311Accident · No injuriesFinal reportPiper PA-34-200T · Eagle Pass, TXThe pilot stated that he overflew the ranch strip and looked it over before landing. He stated that he touched down on the first 200 ft of the 2200 ft, asphalt runway, but each time the brakes were applied, the wheels would lock and skid due to loose gravel…NTSB LAX82DA278Accident · No injuriesFinal reportBeech F35 · Upland, CAPilot pulled up landing gear after landing instead of flaps.NTSB FTW82DA293Accident · No injuriesFinal reportCessna A188B · Texline, TXThe pilot started to takeoff with a 145 gal spray load. Reportedly, the main gear dug into the surface of a plowed field during the takeoff roll and collapsed.NTSB MKC82DA126Accident · No injuriesFinal reportPiper PA-28-181 · Lawrence, KSThe student pilot was on his third solo cross country flight. A NOTAM was in effect showing part of runway 19 at Lawrence municipal was closed. The pilot said he saw the markings but was distracted by a crosswind. He landed on the closed portion of the runway…NTSB DEN82DA137Accident · No injuriesFinal reportPiper PA-28R · Near Almosa, COThe pilot stated that during flight, his oil temperature began to rise and he elected to land on an abandoned air strip. During the landing, the aircraft encountered rough, uneven terrain, and subsequently, the landing gear and right wing were damaged. An…NTSB CHI82DA248Accident · No injuriesFinal reportCessna 182C · Deer River, MNThe pilot reported that when he was briefed by the flight service station, he was told the ceilings were low, but VFR conditions were expected by 1000 CDT. The pilot departed at 0850 CDT in weather conditions that he estimated to be 1000 ft overcast with 8 mi…NTSB ATL82DA200Accident · No injuriesFinal reportErcoupe 415-C · Richmond, KYPilot hand propped aircraft which broke tail tie-down rope and taxiied unattended into a runway light and a ditch about 175 feet from starting point.NTSB LAX82FUM07Accident · No injuriesFinal reportPiper PA-36-285 · Imperial, CAThe pilot was unable to maintain airspeed and altitude after taking off from a wet and muddy runway. He closed the throttle and landed in a cotton field, but was unable to stop the aircraft before hitting a ditch. Reportedly, the previous (first) takeoff…NTSB ANC82DA050Accident · 1 fatalFinal reportCessna 185F · Near Chinitna B, AKThe aircraft was chartered to salvage gear from a burned hovercraft that was beached about one mile south of Chinitna bay. The pilot reported that the two passengers got the gear ready to load while he held the plane off the beach by hand, trying to keep the…NTSB FTW82FQA20Accident · No injuriesFinal reportCessna T210M · Belen, NMA person called abq fss at 2310Z on 6/7/82 & asked for a wx briefing in the area of deming/silver city, NM to abq. He said he was a pilot & the acft was N761YA. On 6/11/82, the burned out remains of the acft were found in open desert terrain. Tracks appearing…NTSB SEA82DA079Accident · No injuriesFinal reportCessna 177 · Waldport, ORThe pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area.NTSB SEA82DA075Accident · No injuriesFinal reportBellanca 7ECA · Roche Harbor, WAThe aircraft drifted off the runway during landing and collided with a ditch. The right main landing gear collapsed.NTSB FTW82DA187Accident · No injuriesFinal reportGrumman G-164A · Pine Bluff, ARDuring landing the right main landing gear dropped into a ditch alongside the runway and the aircraft nosed over.NTSB FTW82DA175Accident · No injuriesFinal reportPiper PA-32RT-300 · Pineville, LADuring taxi to the runway for takeoff, the right main gear dropped into an unmarked hole on the right edge of the taxiway resulting in substantial damage to the aircraft.NTSB CHI82DA143Accident · No injuriesFinal reportBenson BM8 · Batavia, OHThe pilot, on a local flight, was making an approach under visual meteorological conditions to runway 22. While on short final the pilot observed an aircraft taxi into takeoff position for runway 04. This is an uncontrolled airport. The pilot stated that as…NTSB CHI82DA133Accident · No injuriesFinal reportCessna 182 · Brazil, INThe pilot elected to land on the grass adjacent to a paved runway. While on landing roll the landing gear contacted the edge of a paved taxiway that ran perpendicular to the runway. The aircraft nosed over and came to rest inverted.NTSB ANC82DAG18Accident · Minor injuriesFinal reportCessna 170 · Big Lake, AKDuring a local flight, the pilot elected to land at the Big Lake airport. Before landing, he noted that weather was moving in from the northwest. Also, he noted that the wind sock was limp, but favored a landing to the west. He landed, and before taking off…NTSB MKC82DA061Accident · No injuriesFinal reportCessna 152 · Grain Valley, MODuring landing roll the aircraft went off the runway and ended up in a ditch.NTSB CHI82DA128Accident · Serious injuriesFinal reportPiper PA-32 · Brookfield, OHWitnesses observed the aircraft performing turns and rolls at an altitude of approximately 300 feet AGL. A decrease and subsequently an increase in engine power was heard. The aircraft was observed crashing into trees. Investigation revealed that the pilot…NTSB DEN82DA058Accident · No injuriesFinal reportMooney M20F · Crosby, NDThe pilot reported that the runway had a 6 to 7 ft snowbank on the left side of the runway and a 2 to 3 ft snowbank on the right side. Also, water was on the runway intermittently along the entire length. After landing, the plane started hydroplaning. As the…NTSB CHI82DA119Accident · No injuriesFinal reportPiper PA-22-160 · Nova, OHThe aircraft encountered a four inch snowdrift during takeoff roll from a sod strip. It nosed over and came to rest inverted.NTSB CHI82IA117Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Youngstown, OHAfter aborting one approach and holding for several minutes, the flight was cleared for the ILS approach runway 32 at 0947 EST. While the flight was holding, the crew had several conversations with approach control and the company representative regarding…NTSB LAX82DUJ34Accident · No injuriesFinal reportCessna 180K · Meadview, AZThe flight had originated at north las vegas, NV. According to the pilot, he landed at an unprepared strip when his engine did not sound right, but it checked out on the ground. While at the unprepared strip, the right tire blew out when it struck a rock.…NTSB NYC82FGT11Accident · Serious injuriesFinal reportPiper PA-44-180 · Mcsherrystown, PAThe pilot reported that when he arrived at night, there were snow showers at the airport. While turning final, he turnedhis landing lights on. However, he reported that he could see better with the landing lights off, so he turned them off. After touching…NTSB LAX82DA120Accident · No injuriesFinal reportPiper PA-28-201T · Auberry, CADuring landing, the pilot rolled to the left side of the runway to avoid possible potholes. After steering to the left side, the left main gear encountered a small berm and the aircraft veered further left. The nosewheel hit the berm and the nose gear…NTSB ANC82DAG17Accident · No injuriesFinal reportCessna 185 · Paxson, AKAfter landing on a snow covered, frozen lake, the pilot began to taxi to the desired parking spot. While taxiing, the aircraft encountered an area of smooth ice under the snow and began to slide sideways. The right ski dropped through an overflow area on the…NTSB SEA82DA036Accident · No injuriesFinal reportPiper PA-32-301T · Hailey, IDAfter an engine run-up with the parking brake set, the first attempt to takeoff was aborted when the plane failed to accelerate satisfactorily. The brakes operated satisfactorily during the abort and a second run-up revealed no unusual engine indications.…NTSB CHI82DA071Accident · No injuriesFinal reportCessna 414 · Bryan, OHThe pilot reported landing in almost total whiteout conditions. The landing was made at the first light of day, there was a little light ice on the windshield, and there was snow and ice on the runway. The pilot was unaware that only a 50 ft wide strip was…NTSB MIA82DA056Accident · No injuriesFinal reportCessna 210A · Florida City, FLThe aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug…NTSB LAX82DA083Accident · No injuriesFinal reportMooney M-20C · Sacramento, CAThe student pilot obtained permission for and attempted an ILS approach. After demonstrating an inability to follow the ILS the pilot was cleared for a special VFR approach. The aircraft landed with the gear retracted.NTSB MIA82DA055Accident · No injuriesFinal reportCessna P206B · Pembroke Pines, FLThe wreckage was found abandoned off the side of a narrow road on 2/19/82. Only the pilot's seat was installed. Traces of narcotics were found on board. The aircraft's registered owner as shown in the FAA records contained a fictitious address. The injury…NTSB FTW82DA057Accident · No injuriesFinal reportCessna 172 · Navajo Dam, NMThe pilot landed at an unattended airport on what he thought to be approximately 2 inches of snow. It turned out to be 8 inches and the aircraft turned over on landing.NTSB ANC82DA018Accident · No injuriesFinal reportCessna 185 · Fort Yukon, AKThe pilot had landed the wheel/ski equipped aircraft at a field site to pick-up a passenger. While taxiing in snow, estimated to be 14 to 15 inches deep, the right ski hit something in the snow and the plane nosed over.NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…NTSB LAX82FVA11Accident · 1 fatalFinal reportCessna TR182 · Oakdale, CAThe aircraft was observed to porpoise several times during the takeoff roll, become airborne with the landing gear immediately retracting, then nose down with the propeller striking, the runway. The pilot continued the takeoff and the aircraft climbed to…NTSB MKC82DA025Accident · No injuriesFinal reportCessna 172N · Lee'S Summit, MOPower was added to initiate taxiing. When the aircraft did not turn enough to the left additional power was applied and the aircraft struck a snowbank.NTSB MKC82DA021Accident · No injuriesFinal reportCessna 152 · Essex, MOThe student departed on a solo, cross-country flight. A comfort stop was made at an enroute airport during the first leg of the flight. The flight was then continued to the first pre-planned destination. After taking off on the second leg, the student became…NTSB ANC82DA015Accident · No injuriesFinal reportde Havilland DHC-2-MK3 · Near Nuiqsut, AKEarlier in the day, the pilot received information about the landing area. He understood that the landing area would be cleared or prepared and be defined by flare pots. He believed he would be landing on a frozen river. During arrival after dark, he flew…NTSB ATL82DKJ09Accident · No injuriesFinal reportCessna 310L · Auburn, ALThe pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…NTSB FTW82DA038Accident · No injuriesFinal reportPiper PA-34 · Tomball, TXAfter being cleared by the tower to taxi onto the runway from an unlighted taxiway the right main landing gear fell into a hole. Construction work was being done in the area and no warning lights had been erected. The pilot stated that the tower personnel had…NTSB DEN82DTI09Accident · No injuriesFinal reportAir Tractor AT-301 · Greenough, MTDuring takeoff the aircraft struck a snow berm. The aircraft received substantial damage to both wings and prop. The aircraft had been landed on a county road about a week earlier due to deteriorating weather.