NTSB investigations, 1993
34 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\") = 1993
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") = 1993 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 LAX94LA078Accident · No injuriesLimited investigationFinal reportBell 206B · Las Vegas, NVthe pilot's failure to properly position the helicopter away from the dolly edge during the initial touchdown.NTSB ANC94LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Juneau, AKThe pilot in command's selection of a sight unsuitable for landing. A factor in the accident was the ditch on the beach.NTSB ANC94LA022Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKFailure of the pilot to maintain proper alignment during the takeoff roll. Factors related to the accident were: darkness and the snow berm along the edge of the runway.NTSB ANC94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Chignik, AKThe pilot-in-commands selection of unsuitable terrain on which to perform a takeoff. A factor in the accident was the brush.NTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.NTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.NTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.NTSB BFO93LA185Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wauseon, OHThe pilot's failure to compensate for the crosswind which resulted in loss of directional control during the flare/touchdown. A factor in the accident was the crosswind component.NTSB ANC93LA184Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's improper planning/decision. The rough water in the takeoff area was a factor.NTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).NTSB BFO93LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Centre Hall, PAThe pilot misjudged his airspeed and altitude which resulted in the pilot's failure to attain the proper touchdown point resultng in the airplane exiting the runway and colliding with the berm. A related factor was the location of the berm.NTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.NTSB SEA93LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Enumclaw, WAThe pilot's delayed remedial action. Factors include a wet, downhill, grass runway during the abort.NTSB NYC93LA152Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAThe pilot's failure to maintain aircraft control which resulted in a nose over. A rough uneven runway, and the pilot's diverted attention are contributing factors.NTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.NTSB CHI93LA310Accident · No injuriesLimited investigationFinal reportCessna 177RG · Emporia, KSThe pilot's selection of unsuitable terrain.NTSB ANC93LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's failure to maintain directional control of the airpalne. A factor in the accident was the ditch along the side of the runway.NTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.NTSB ANC93LA122Accident · No injuriesLimited investigationFinal reportHelio H295 · Talkeetna, AKThe pilot in command's selection of unsuitable terrain. The rough/uneven terrain was a factor.NTSB ANC93LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilot's selection of unsuitable terrain. Factors related to the accident were: the submerged sand bar and the pilot's excessive taxispeed.NTSB SEA93LA141Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe pilot's failure to attain the proper touchdown point. Factors to the accident were: lack of familiarity with geographic area and the grass.NTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.NTSB SEA93LA128Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Havre, MTThe pilot in command misjudged his clearance from a ditch, and his use of improper remedial action.NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barNTSB LAX93LA219Accident · No injuriesLimited investigationFinal reportCessna 182Q · Concord, CAThe passenger/dual student's improper recovery from a bounced landing, and the pilot's inadequate supervision of the flight.NTSB ATL93LA091Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilmington, NCThe ground personnel's failure to ensure that the airplane was clear of obstructions which resulted in the right wing colliding with a utility pole. A factor was the pilot's inadequate visual lookoutNTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.NTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.NTSB NYC93FA079Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2B · North Benton, OHThe pilot's failure to maintain adequate aircraft control due to alcohol impairment.NTSB BFO93LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Corry, PAFailure of the pilot to maintain runway alignment during the landing roll. Factors related to the accident were: darkness, the pilot's lack of visual cues due to the runway lights being obscured by the plowed snow, and failure of airport personnel to issue a…NTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.NTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.NTSB BFO93LA028Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Pittsfield, METhe pilot's inadequate inflight decision to continue a landing without runway lights, and his delay in initiating a go-around. A related factor was the pilot's over confidence in his ability.NTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.