# Fatal NTSB investigations: On ground/water encounter with terrain/water NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. ## Latest cases - [NTSB ATL07LA110](https://openairdocs.org/ntsb/ATL07LA110.md): Cessna T206H · Lovell, ME · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 2007 · N206MW · Substantial damage > The pilot's failure to retract the amphibious floatplane's landing gear during a water landing. - [NTSB CHI06FA193](https://openairdocs.org/ntsb/CHI06FA193.md): Cessna 560 · Cresco, IA · Accident · 2 fatal · Field investigation · Final report · Jul 19, 2006 · N636SE · Substantial damage > The flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen… - [NTSB NYC03FA162](https://openairdocs.org/ntsb/NYC03FA162.md): Start & Flug H101 · Rock Hill, NY · Accident · 1 fatal · Field investigation · Final report · Jul 19, 2003 · N999JB · Substantial damage > The pilot's selection of an unsuitable area for landing. - [NTSB CHI00FA027](https://openairdocs.org/ntsb/CHI00FA027.md): Beech 200 · Chicago, IL · Accident · 3 fatal · Field investigation · Final report · Nov 12, 1999 · N869 · Destroyed > On ground collision with the lake for undetermined reasons. - [NTSB DEN99FA086](https://openairdocs.org/ntsb/DEN99FA086.md): PZL-Mielec M-18B · Altus, OK · Accident · 1 fatal · Field investigation · Final report · May 25, 1999 · N8199W · Substantial damage > The pilot's disregard of takeoff performance data and his failure to jettison the load. Contributing factors were high density altitude, exceeding the aircraft's maximum allowable gross weight, and the berm. - [NTSB SEA98FA170](https://openairdocs.org/ntsb/SEA98FA170.md): Cessna 172L · Anacortes, WA · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1998 · N1069M · Substantial damage > Terrain clearance was not maintained. A low ceiling and the pilot's inadequate in-flight planning/decision were factors. - [NTSB NYC93FA079](https://openairdocs.org/ntsb/NYC93FA079.md): Aerotek Pitts S-2B · North Benton, OH · Accident · 2 fatal · Field investigation · Final report · Apr 10, 1993 · N5306N · Destroyed > The pilot's failure to maintain adequate aircraft control due to alcohol impairment. - [NTSB LAX92LA006](https://openairdocs.org/ntsb/LAX92LA006.md): Bentley Mongoose A · Boulder City, NV · Accident · 2 fatal · Limited investigation · Final report · Oct 5, 1991 · N7143K · Destroyed > The pilot's selection of an inadequate takeoff area which was too short for the prevailing conditions. - [NTSB SEA90FA149](https://openairdocs.org/ntsb/SEA90FA149.md): Piper PA-22-150 · Leavenworth, WA · Accident · 1 fatal · Field investigation · Final report · Jul 30, 1990 · N9978D · Destroyed > The pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could… - [NTSB MIA89FA237](https://openairdocs.org/ntsb/MIA89FA237.md): Eagle DW-1-220 · Oklawaha, FL · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1989 · N8802M · Destroyed > The loss of control on the ground during the landing roll for undetermined reasons. - [NTSB NYC87FA006](https://openairdocs.org/ntsb/NYC87FA006.md): Piper PA-28-140 · Holyoke, MA · Accident · 3 fatal · Field investigation · Final report · Oct 3, 1986 · N38688 · Destroyed > The aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument… - [NTSB MIA86FA095](https://openairdocs.org/ntsb/MIA86FA095.md): Piper PA-31-350 · Florida City, FL · Accident · 1 fatal · Field investigation · Final report · Mar 14, 1986 · N49984 · Destroyed > The acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the… - [NTSB DEN84FA294](https://openairdocs.org/ntsb/DEN84FA294.md): Cessna A185F · Fort Peck, MT · Accident · 1 fatal · Field investigation · Final report · Sep 20, 1984 · CGZWQ · Substantial damage > Plt attempted to takeoff from a calm part of reservoir. The wave heights were estimated to be 4 to 6 feet. The arft struck several waves during the takeoff run. The rt wing tip dragged in the water causing the acft to nose over. The acft came to rest… - [NTSB DCA83AA013](https://openairdocs.org/ntsb/DCA83AA013.md): Convair 580-11-A · Brainerd, MN · Accident · 1 fatal · Final report · Jan 10, 1983 · N8444H · Substantial damage > During arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right… - [NTSB ANC82DA050](https://openairdocs.org/ntsb/ANC82DA050.md): Cessna 185F · Near Chinitna B, AK · Accident · 1 fatal · Final report · Jun 19, 1982 · N4212Q · Destroyed > The 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 LAX82FVA11](https://openairdocs.org/ntsb/LAX82FVA11.md): Cessna TR182 · Oakdale, CA · Accident · 1 fatal · Final report · Jan 30, 1982 · N5173R · Substantial damage > The 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… ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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."highestInjuryLevel" = 'Fatal' AND 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 ``` This list as a web page: https://openairdocs.org/ntsb?fatal=1&occurrence=320 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.