NTSB investigations, 1999
116 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
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\") = 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\" = 230)
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" = 230) 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 SEA00FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Hermiston, ORThe pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.NTSB ATL00FA017Accident · 1 fatalField investigationFinal reportCessna 551 · Cordele, GAThe pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.NTSB MIA00FA056Accident · 1 fatalField investigationFinal reportBeech E-90 · Beaufort, SCThe pilot-in-commands failure to maintain the appropriate altitude (minimum descent altitude) during an area surveillance radar (ASR) approach, resulting in an in-flight collision with swampy terrain. Contributing to the accident was the co-pilot's failure to…NTSB DEN00LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-31T1 · Santa Fe, NMThe pilot initiating lift off at an airspeed insufficient to maintain flight and retracting the landing gear prematurely resulting in a stall mush. A factor was the pilot incorrectly setting the elevator trim.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB CHI00FA040Accident · 6 fatalField investigationFinal reportCessna 525 · Branson, MOthe pilot descended below the minimum altitude for the segment of the GPS approach. Factors relating to the accident were low ceilings, rain, and pilot fatigue.NTSB MIA00FA043Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pelham, ALThe student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB CHI00LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenfield, INThe student pilot not maintaining aircraft control. A contributing factor was the student's aural perception.NTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.NTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.NTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.NTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.NTSB CHI00FA020Accident · 2 fatalField investigationFinal reportBell 206B · Cottage Grove, MNUndetermined.NTSB SEA00FA012Accident · 4 fatalField investigationFinal reportCessna U206F · Challis, IDAircraft control was not maintained. The pilot's improper decision to abort the landing and flight into a box canyon were factors.NTSB MIA00FA017Accident · 4 fatalField investigationFinal reportCessna T310R · Atlantic Ocean (Atlantic Ocean)the pilot's failure to maintain control of the airplane, which resulted in impact with rough water. A factor in this accident was a dark night, which resulted in no visual cues.NTSB ATL00LA003Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-MARINER · West Boca Raton, FLThe flight instructor's delayed response in taking remedial action during a practice autorotation. Factors were his inadequate planned approach and his improper use of powerplant controls.NTSB DEN00FA009Accident · 1 fatalField investigationFinal reportCessna 172R · Aspen, COthe pilot's improper decision to fly directly up the center of the valley and not circle climb to gain sufficient terrain clearance altitude. A factor was inadequate route performance planning by the pilot.NTSB CHI00LA014Accident · 1 fatalLimited investigationFinal reportHowlett KR-2 · Denison, IAthe pilot not maintaining altitude/clearance from rising terrain and the intentional low altitude flight. Factors were the known turbulence, rising terrain, and the inadequate in-flight decision to fly at low altitudes.NTSB LAX00FA014Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVThe failure of the pilot-in-command to maintain separation from terrain while operating under visual flight rules. Contributing factors were the improper issuance of a suggested heading by air traffic control personnel, inadequate flight progress monitoring…NTSB LAX00LA005Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Tonopah, NVThe pilot's failure to monitor his altitude and maintain an adequate terrain clearance during the approach. The dark night lighting conditions and the visual illusion created by the lack of ground reference lights were factors in the accident.NTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.NTSB CHI99FA356Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clinton, IAthe pilot's continued flight into known adverse weather conditions and not maintaining altitude/clearance. Factors were the low clouds, rain, and dark night conditions.NTSB DCA99MA088Accident · 10 fatalMajor investigationFinal reportPiper PA-31-350 · Volcano, HIthe pilot's decision to continue visual flight into instrument meteorological conditions (IMC) in an area of cloud-covered mountainous terrain. Contributing to the accident were the pilot's failure to properly navigate and his disregard for standard operating…NTSB ANC99LA154Accident · No injuriesLimited investigationFinal reportCessna 180 · Pilot Point, AKThe pilot's misjudgment of the touchdown point. A factor in the accident was the uneven terrain.NTSB NYC99LA237Accident · No injuriesLimited investigationFinal reportPratt Dominator · Auburn, METhe pilot's improper decision to execute a 0 airspeed pedal turn at 100 feet agl.NTSB NYC99LA242Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Brookfield, OHThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.NTSB LAX99LA319Accident · No injuriesLimited investigationFinal reportBell OH58A · Salinas, CAThe pilot's failure to maintain an adequate clearance from all ground obstacles during a low altitude aerial application flight.NTSB LAX99FA316Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · June Lake, CAThe pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.NTSB ANC99LA141Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.NTSB ANC99LA140Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.NTSB ANC99LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe pilot's inadequate preflight planning. Factors associated with this accident were the pilot's failure to use the takeoff performance charts, the short runway and uphill takeoff, and a sudden windshift.NTSB ANC99LA150Accident · No injuriesLimited investigationFinal reportCessna 182 · Northway, AKThe improper maneuver to avoid obstructions by the pilot. Factors associated with this accident were the ruts in the approach end of the airstrip, and tall brush alongside the airstrip.NTSB ANC99FA130Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Bettles, AKThe pilot's continued flight into known adverse weather conditions. Factors in the accident were low ceilings and snow.NTSB ANC99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's failure to avoid obstructions during takeoff. A factor associated with this accident was the high brush along the river bank.NTSB LAX99LA292Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pohnpei (Pacific Ocean)An in-flight collision with the water for undetermined reasons.NTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.NTSB DEN99LA155Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-4 (AT-6) · Mack, COThe pilot misjudging his distance and altitude from the runway. A factor was the tall crops.NTSB DEN99LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Salida, COAn inadvertent stall during an aborted landing. A factor was the pilot's selection of the wrong runway for landing.NTSB ANC99LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's selection of an unsuitable takeoff area, which resulted in the airplane colliding with vegetation, knocking the gascolator off the airplane, and fuel starvation of the engine.NTSB SEA99FA144Accident · 1 fatalField investigationFinal reportBeech F33A · White Swan, WAInadequate preflight planning/preparation and low airspeed. A dirt embankment, soft runway, and an excessive takeoff weight were factors.NTSB MIA99LA227Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Perry, SCan in-flight collision with the ground due to inadequate liftoff airspeed, and the pilot's improper use of flaps, which resulted in too low of an altitude to sustain flight.NTSB ANC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation.NTSB ANC99FA108Accident · 4 fatalField investigationFinal reportCessna A185F · Juneau, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were mountainous/hilly terrain, low ceilings, the pilot's improper in-flight decision making, and the pilot's impairment from over-the-counter…NTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.NTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…NTSB MIA99LA212Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Moore Haven, FLThe pilot exceeding the gross takeoff weight which reduced the climb capability and subsequent in-flight collision with terrain. Contributing to the accident was the high temperature and the pilot's failure to use aircraft performance data for the weather…NTSB DEN99LA130Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Centennial, WYThe pilot's failure to consult the airplane performance charts and allowing the airplane to exceed its climb performance. Factors were high density altitude conditions and a downdraft.NTSB DEN99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Limon, COThe pilot's selection of the wrong runway for takeoff. Factors were a direct tailwind and high density altitude that deteriorated the airplane's climb capability, and unsuitable terrain on which to make a forced landing.NTSB CHI99LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 401B · Mccanna, NDthe inadvertent stall by the pilot.