NTSB investigations, 1994
35 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\") = 1994
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") = 1994 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 ANC95LA031Accident · No injuriesLimited investigationFinal reportCessna 182M · New Stuyahok, AKA failure of the pilot to maintain directional control of the airplane during the landing roll. A factor in the accident was an icy runway surface.NTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.NTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.NTSB ANC95LA011Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot's selection of unsuitable terrain for landing. The pilot's disregard of a NOTAM that closed the runway and a slush covered runway area were factors in the accident.NTSB SEA95LA019Accident · No injuriesLimited investigationFinal reportBeech A23 · La Grande, ORThe pilot's failure to maintain directional control. Factors include the soft, wet airstrip, and a ditch near the side of the runway.NTSB CHI95LA056Accident · No injuriesLimited investigationFinal reportCessna 206G · Butler, MOthe pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.NTSB NYC95LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · Nunda, NYthe pilot-in-command's failure to assure that an adequate runway length was available.NTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.NTSB ANC95LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Kotzebue, AKA failure of the pilot to maintain adequate distance from the terrain (snow bank). Flat lighting and low contrast conditions were factors in the accident.NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB ATL94LA172Accident · No injuriesLimited investigationFinal reportBell 47D1 Wasp · Hazel Green, ALUndetermined.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.NTSB ANC94LA131Accident · No injuriesLimited investigationFinal reportCessna 180B · Fort Yukon, AKThe pilot's improper use of the flaps and flight controls, and a delay in aborting the takeoff. A factor in the accident was glassy water conditions.NTSB ANC94LA123Accident · No injuriesLimited investigationFinal reportHelio H295 · Artic Village, AKThe pilot selected unsuitable terrain for landing. A factor was the hidden obstruction (hole).NTSB ANC94LA107Accident · No injuriesLimited investigationFinal reportHelio H-700 · Tok, AKThe partial failure of the airplane's normal brake system.NTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.NTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.NTSB ANC94LA083Accident · No injuriesLimited investigationFinal reportCessna 206 · Noatak, AKThe pilot's selection of unsuitable landing area. A factor was a 'cut bank' in the landing area.NTSB ANC94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ft Richardson, AKThe pilot's selection of unsuitable terrain for landing. A factor which contributed to the accident was the pilot's impairmentNTSB LAX94LA275Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Las Vegas, NVThe failure of the pilot to obtain the proper takeoff speed. Factors are the high density altitude and the crosswind.NTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.NTSB ANC94LA063Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot's selection of an unsuitable landing area.NTSB NYC94LA079Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Hempstead, NYThe inadvertent collision with a hidden obstruction after swerving to avoid birds during a water takeoff.NTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.NTSB FTW94LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Hempstead, TXThe pilot's improper selection of the strip between the two runways. Factors were the pilot not being familiar with the airstrip and the soft, wet terrain.NTSB MIA94LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Stuart, FLPoor in-flight planning/decision by the pilot-in-command. Contributing to the accident was wind information disregarded by the pilot-in-command.NTSB ANC94LA042Accident · Minor injuriesLimited investigationFinal reportBell 206B · Wrangell, AKThe pilot-in-command's failure to assure that he had the proper clearance from obstructions prior to landing on the platform. A factor in the accident was the high obstruction (tree strump).NTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.NTSB ANC94LA040Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka Lodge, AKThe pilot-in-command's selection of unsuitable terrain for a landing.NTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.NTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.NTSB BFO94LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHFailure of the pilot to maintain directional control during takeoff leading to a collision with a snow bank which resulted in the airplane nosing over.NTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.