NTSB investigations
133 cases where the first occurrence was “Forced landing”.
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\" = 180) 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" = 180) 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 ANC92LA094Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Oshetna River, AKThe tailwind and the pilot not understanding the effects. Factors relating to the accident were the attempted precautionary landing and the high vegetation in the forced landing area.NTSB SEA92LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Spangle, WAAltitude was not attained. A factor to the accident was: load jettison was not possible.NTSB LAX91LA414Accident · No injuriesLimited investigationFinal reportLet L-13 · Adelanto, CAImproper planning/decision by the pilot. Loss of thermal lift was a related factor.NTSB DEN91LA134Accident · Serious injuriesLimited investigationFinal reportAbernathy LONG-EZ · Raton, NMPhysical impairment of the pilot. Factors were: rough terrain.NTSB SEA91LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ellensburg, WAThe pilot's failure to maintain terrain clearance. Contributing to the accident was the pilot's overconfidence in the aircraft's ability, and flight in a box canyon where remedial action was not possible.NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…NTSB CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.NTSB DEN91FA111Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Colorado Spring, COThe pilot exceeded weight and balance limitations. Factors were: high density altitude and unsuitable terrain.NTSB LAX91LA346Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 126E · Sutcliffe, NVThe pilot's inadvertent stall of the glider.NTSB SEA91LA192Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, WAA delayed go-around, and airspeed not being maintained. Factors include the pilot's overconfidence in the aircraft's ability, the pilot's lack of total experience in this type of operation, misjudged clearance, and the use of improper procedure.NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB DEN91FA083Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus C · Durango, COThe absence of thermal lift, the pilot's apprehension, and his lack of familiarity with the geographic area.NTSB DEN91FA072Accident · Serious injuriesField investigationFinal reportBeech C23 · Boulder, COInadvertent stall/mush due to the passengers's delay in relinquishing aircraft control, and inadequate supervision of the flight by the pilot in command. Factors were: mixture not leaned, and a high density altitude takeoff with a slight quartering tailwind.NTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.NTSB ATL91LA053Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Grantham, NCThe pilot's improper planning/decision, and his attempt to fly the aircraft while it was loaded over its maximum allowable gross weight.NTSB LAX90LA168Accident · No injuriesLimited investigationFinal reportRobinson R22 · Irvine, CAThe cfi's failure to maintain rotor RPM during the practice autorotation.NTSB LAX89LA234Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hollister, CAFlight instructor's failure to take corrective action in sufficient time to prevent the airplane from striking the ground.NTSB NYC89LA151Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415C · Canaan, CTAn off airport landing in unsuitable terrain due to a power loss, caused by loose parts in the fuel pump.NTSB LAX89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fresno, CAThe pilot's inflight decision to abort the takeoff and land in a field. Contributing to the accident was the fence post that the aircraft collided with during the landing roll.NTSB MKC88LA181Accident · No injuriesLimited investigationFinal reportBeech 77 · Friendship, ARThe CFI rprtd he was demonstrating an emergency landing to a pvt rated plt & confusion (about who was flying the acft) resulted in a commitment to land. The landing was made on a gravel road. During the roll-out, the acft veered into a ditch & was damaged.NTSB LAX88LA182Accident · No injuriesLimited investigationFinal reportSlingsby T59D Kestrel 19 · Middletown, CANTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…NTSB MIA88LA036Accident · No injuriesLimited investigationFinal reportRaven S-66A · Naples, FLAfter liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then…NTSB ATL88LA018Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Whitwell, TNThe glider plt made an off-arpt ldg after realizing that he didn't have enough altitude to return to his departure point. During ldg rollout on uneven terrain, one of the wingtips contacted the terrain and the glider ground-looped.NTSB DEN87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Steamboat Sprin, CON7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He…NTSB FTW87DRG06Accident · Minor injuriesFinal reportWilliam M. Burge Tern · Refugio, TXOn August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…NTSB FTW87LA186Accident · No injuriesLimited investigationFinal reportLet L-13 · Hempstead, TXAcft landed short of threshold following a low release shortly after t/o. release was low due to tow plane's being unable to climb above 200' AGL due to the glider's spoilers being deployed inadvertently during the t/o. the plt stated that he executed a 270…NTSB ATL87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Goldsboro, NCStudent PIC rpted he followed wrong railroad track to return from the practice area to the airport. Viz was about 6 miles in hazy conditions. Prior to exhausting fuel or daylight he elected to land in a field. Field was soft terrain and acft nosed over.NTSB MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…NTSB NYC87LA136Accident · No injuriesLimited investigationFinal reportBeech BE-18 · York, PAWhile the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire…NTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…NTSB FTW87FA090Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Uvalde, TXOn 04-02-87, a Piper PA-38-112, N5540E, owned and operated by southwest Texas junior college, impacted the terrain near Uvalde, TX. The flight was conducted for training purposes. Visual meteorological conditions prevailed at the time of the accident. The…NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…NTSB LAX87LA043Accident · No injuriesLimited investigationFinal reportCessna A150M · Corona, CADuring a local flight, the pilot was practicing a simulated engine out procedure toward an open field on rolling terrain. He stated that he misjudged the rising terrain and got too low and slow to initiate a go-around. Subsequently, he was forced to land.…NTSB SEA86LA242Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pomeroy, WAThe pilot was flying over unfamiliar terrain at a low altitude in order to spot elk. The pilot encountered steep rising terrain which his aircraft was unable to out climb. Density altitude at the time of the accident computes to be approximately 7,500 feet.…NTSB MKC86LA155Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe aerial application airplane was departing from a short strip on a hot day. The pilot said the airplane would not climb and he was forced to put it down in a flooded rice field where it nosed forward to the inverted position. The pilot stated he should…NTSB CHI86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Shiocton, WICFI delayed corrective action during a practice forced landing by a student. Aircraft touched down with insufficient runway remaining to stop safely. During the subsequent go-around attempt the aircraft rolled into a plowed field and nosed over.NTSB ATL86LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Parkton, NCWhile practicing a simulated forced landing the aircraft stalled and crashed into the trees. The pilot related that the aircraft lost power. Post crash examination of the wreckage failed to disclose any pre-existing mechanical failure or malfunction which…NTSB LAX86LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Banning, CAThe glider plt lost lift as he flew farther into the mountains with lack of thermal and ridge effect. A landing was attempted which resulted in an overrun into a ravine.NTSB LAX86LA203Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Palmdale, CAThe helicopter landed hard in the desert while on a VFR personal flt. The plt indicated that he just departed a mountian area for refueling. He also indicated he was disoriented and the compass was inoperable. He decided to land and check the fuel quantity.…NTSB LAX86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Benson, AZA Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see…NTSB ANC86LA017Accident · No injuriesLimited investigationFinal reportCessna C-177RG · Big Lake, AKWhile performing slow flight maneuvers, the student applied power with no response. Various combinations of controls produced no further response from the engine. The instructor and student completed a forced landing in a furrowed clearing at night.NTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…NTSB LAX86LA026Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Flagstaff, AZThe plt reported that while sight-seeing in the vicinity of the grand canyon, he became disoriented and lost. The fuel in the left tank was exhausted and the right fuel tank contained minimum fuel. The pilot negotiated a precautionary landing on the hard…NTSB CHI86LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Troy, MIThe pilot reported a partial loss of power on takeoff. Altitude could not be maintained. During an attempt to return to the airport, the aircraft descended and landed on railroad tracks. The engine was test run at all power settings without discrepancies.NTSB BFO85LA078Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · New Castle, VAAccording to the plt, after experiencing a loss of lift, he flew over the open field, observed electrical wires, and continued to fly parallel with the wires. As he turned westward to land in the field, the plt lost sight of the power lines in the sunset.…NTSB ANC85LA151Accident · No injuriesLimited investigationFinal reportCessna C-207 · Mountain Villag, AKThe pilot-in-command was aware of the weather he was operating in and intended to fly through a locally well known pass. He misidentified the pass and found himself in a narrow valley. There was insufficient width to effect a 180 degree turn and the rising…NTSB DEN85LA185Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20B · Grand Lake, COOn returning from a 300-kilometer cross-country flight, in a glider the pilot noticed the absence of thermal activity and was forced to land in an open field. The pilot said he landed with a 2-5 knot tailwind and his approach and touchdown speed was too fast.…NTSB NYC85LA151Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103-II Aero · Erwinna, PAThe glider contacted tall hay in a fld and ground looped during an off arpt forced landing. The plt stated the glider was released downwind from the arpt at an alt of aprx 3000 ft AGL. A sink rate of 1000 fpm developed preventing the plt from returning to…NTSB FTW85FA254Accident · No injuriesField investigationFinal reportRobinson R-22 · Dallas, TXThe student plt allowed the main rotor blades to drop to a slow speed well below the green arc. The student plt and the instructor plt attempted to do a power recovery from the aborted autorotation maneuver but the eng could not accelerate the main rotor…