Skip to content

NTSB investigations, 1999

40 cases where the first occurrence was “On ground/water encounter with terrain/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, 1999 per year, 1982–2026: 1,048 cases
1982	68
1983	54
1984	45
1985	57
1986	34
1987	46
1988	30
1989	40
1990	37
1991	31
1992	27
1993	34
1994	35
1995	45
1996	38
1997	33
1998	46
1999	40
2000	33
2001	35
2002	44
2003	33
2004	44
2005	47
2006	33
2007	39

Where

Latest cases

Query with 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 year(c."eventDate") = 1999 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

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 year(c.\"eventDate\") = 1999
    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"

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 year(c."eventDate") = 1999
  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

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 ANC00LA020Accident · No injuriesLimited investigationFinal reportCessna 185 · Chenega Bay, AKThe pilot's selection of an unsuitable takeoff area during the incoming tide. Factors associated with the accident were the incoming tide wave, and the pressure induced by the delays encountered picking up the passengers.Dec 23, 1999 · N70021 · Substantial damage NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.Dec 12, 1999 · N260XX · Substantial damage NTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.Dec 8, 1999 · N7565G · Substantial damage NTSB CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.Dec 2, 1999 · N1756R · Substantial damage NTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.Nov 12, 1999 · N869 · Destroyed NTSB ANC00LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident was snow-covered terrain.Nov 7, 1999 · N8145D · Substantial damage NTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.Oct 16, 1999 · N783WW · Substantial damage NTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.Oct 9, 1999 · N35669 · Substantial damage NTSB ANC99LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's choice of unsuitable terrain for taxi, and inadequate compensation for high winds. Factors associated with this accident were the muddy ground, and the winds of 25 knots gusting to 40 knots.Sep 18, 1999 · N2294C · Substantial damage NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.Sep 17, 1999 · N84697 · Substantial damage NTSB ANC99LA144Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Heiden, AKThe pilot's selection of unsuitable terrain for landing.Sep 13, 1999 · N3017G · Substantial damage NTSB ANC99LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Nikolai, AKThe pilot's selection of an unsuitable takeoff and landing area. Factors associated with this accident were the unfavorable winds, and sunglare.Sep 6, 1999 · N1881X · Substantial damage NTSB FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.Sep 3, 1999 · N3865V · Substantial damage NTSB ANC99LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable takeoff area, and an inadvertent stall. Factors associated with the accident were large wave/swells, and low light conditions (dawn).Aug 25, 1999 · N930TG · Substantial damage NTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.Aug 23, 1999 · N2808F · Substantial damage NTSB ANC99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Seward, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft sand.Aug 17, 1999 · N8841Y · Substantial damage NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.Aug 15, 1999 · N4072C · Substantial damage NTSB ANC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation in the landing area.Aug 12, 1999 · N7174K · Substantial damage NTSB ANC99LA109Accident · No injuriesLimited investigationFinal reportCessna A188-B · Bettles, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft terrain.Aug 8, 1999 · N731UW · Substantial damage NTSB ANC99LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Sand Point, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a large rock.Aug 3, 1999 · N49JT · Substantial damage NTSB ANC99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Levelock, AKThe pilot's selection of an unsuitable landing site.Aug 1, 1999 · N693JB · Substantial damage NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.Jul 29, 1999 · N331TB · Substantial damage NTSB MIA99LA200Accident · No injuriesLimited investigationFinal reportBell OH-13H/M74A · Sparta, GAthe pilot's inadequate preflight which resulting in his failure to remove all the tie downs, and the subsequent impact with the ground.Jul 22, 1999 · N51857 · Destroyed NTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.Jul 17, 1999 · N849JA · Substantial damage NTSB NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.Jul 8, 1999 · N7164Q · Substantial damage NTSB ANC99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was high vegetation.Jun 19, 1999 · N4292H · Substantial damage NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.Jun 13, 1999 · N8235W · Substantial damage NTSB CHI99LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Traer, IAThe pilot's not maintaining proper runway alignment during the aborted takeoff, and the airport personnel not maintaining the runway. Factors were rough terrain and a dirt bank.Jun 8, 1999 · N4525R · Substantial damage NTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.Jun 6, 1999 · N3024U · Substantial damage NTSB ATL99LA100Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbia, SCThe pilot's failure to maintain directional control during a landing roll.May 31, 1999 · N39PC · Substantial damage NTSB DEN99FA086Accident · 1 fatalField investigationFinal reportPZL-Mielec M-18B · Altus, OKThe 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.May 25, 1999 · N8199W · Substantial damage NTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.May 21, 1999 · N9670P · Substantial damage NTSB ANC99LA051Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2B-21 · Kongiganak, AKThe deep, water filled hole in the runway.Apr 19, 1999 · N414JA · Substantial damage NTSB ANC99LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the soft, snow-covered terrain.Mar 28, 1999 · N3452D · Substantial damage NTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.Mar 14, 1999 · N30412 · Substantial damage NTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.Mar 13, 1999 · N700SP · Substantial damage NTSB ANC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing the wheel equipped airplane. A factor associated with the accident was the soft snow covering the frozen lake.Mar 7, 1999 · N4040M · Substantial damage NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.Feb 13, 1999 · N3753D · Substantial damage NTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.Jan 30, 1999 · N24562 · Substantial damage NTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…Jan 1, 1999 · N4022 · Substantial damage