NTSB investigations, 1989
40 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 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
Open the mapLatest cases
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 year(c.\"eventDate\") = 1989
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") = 1989 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 CHI90LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Middletown, OHThe inability to establish a sufficient climb after takeoff. Contributing to the accident was the pilot's lack of total experinece in this type of aircraft.NTSB BFO90FA012Accident · No injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Staunton, VAThe pilot's failure to properly align the airplane with the runway heading during the takeoff run. Factors related to the accident were: airport personnel's failure to assure that runway marking and edge lights were adequately cleared of snow, adverse…NTSB ANC90LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Chakachamna Lk, AKInadequate preflight preparation of the takeoff area by the pilot, and his attempt to take off on unsuitable terrain. The soft/snow covered terrain was considered to be a contributing factor.NTSB SEA90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Boulder City, NVThe pilot did not attain proper alignment with the runway. Contributing to the accident was the ditch and the pilot's diverted attention.NTSB ANC90LA008Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKPilot's failure to assure condition of runway prior to landing and failure to maintain runway alignment during landing.NTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.NTSB CHI90LA018Accident · No injuriesLimited investigationFinal reportBeech A36 · Lansing, ILPilot's poor judgement in electing to taxi across an unmarked area in dark night conditions, at an airport with known construction in progress and the airport management's failure to assure the initial repairs were sufficient to correct the holes made during…NTSB FTW90LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Addison, TXThe pilot's decision to continue the taxi during dark night conditions without taxiway lights, an operable landing light or, assistance from airport personnel.NTSB ANC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Montague Island, AKSelection of unsuitable terrain by the pilot. Contributing factors were: rough terrain, gusty winds, high vegetation, and trees.NTSB ANC89LA157Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igushik, AKThe pilot selected unsuitable terrain for a landing. Soft terrain was a contributing factor.NTSB ANC89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Trading Bay, AKSelection of unsuitable terrain (landing area) by the pilot. Contributing factors were: improper information provided by other personnel and a hidden obstruction (log) in tall vegetation (grass).NTSB ANC89LA154Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of unsuitable terrain for an off-airport operation. Factors related to the accident were: the adverse terrain conditions.NTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.NTSB ANC89LA149Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Fairbanks, AKThe pilot was taxiing too fast to negotiate a bend in the river. Trees & the river bank were contributing factors.NTSB NYC89LA191Accident · No injuriesLimited investigationFinal reportCessna 421C · Waterville, MEImproper planning/decision by the pilot, his failure to obtain NOTAMS, and failure of the approach controller to provide a safety advisory about the runway condition.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.NTSB ANC89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 206G · Iliamna, AKImproper planning/decision by the pilot & his failure to attain adequate speed to fly. The terrain (bank) was a contributing factor.NTSB SEA89LA138Accident · No injuriesLimited investigationFinal reportGrumman 164B · Hermiston, ORThe airport owners failure to mark a hidden hazard.NTSB ANC89LA125Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Golovin, AKThe pilot's poor judgement, his inadequate preflight planning/preparation, and his selection of the taxiway (wrong runway) for takeoff. Contributing factors were: the pilot's physical condition (fatigue), his self induced pressure, the weather conditions, and…NTSB LAX89DVA08Accident · No injuriesFinal reportSchweizer G-164B · Livingston, CAThe pilot's decision to attempt a takeoff on unsuitable terrain. A factor was the water on the airstrip.NTSB FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.NTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.NTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.NTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.NTSB DEN89LA133Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COFailure of the pilot to follow warnings provided by a NOTAM & flags on the taxiway. Factors related to the accident were: darkness and the ditch.NTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…NTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.NTSB ATL89LA138Accident · No injuriesLimited investigationFinal reportCessna 150 · New Bern, NCThe pilot's improper in-flight planning/decision and a delayed go-around. Turbulence, wet terrain, and a ditch were contributing factors.NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB MIA89LA116Accident · Minor injuriesLimited investigationFinal reportBeech B55 · Sarasota, FLUneven runway condition (sunken spot).NTSB ANC89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Beluga Mountain, AKPilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor.NTSB ANC89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kasigluk, AKThe pilot's inadequate visual lookout which resulted in the collision with a snowbank.NTSB ANC89LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Shell Lake, AKThe pilot's improper inflight decision in selecting unsuitable terrain on which to land. Contributing to the accident was the rough/uneven terrain and the snowbank.NTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.NTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.NTSB DEN89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Longmont, COFailure of the student pilot to maintain proper runway alignment during the landing roll. Factors related to the accident were: snow on the edges of the runway, the student's lack of total experience, and the snowbank.