NTSB investigations, 1989
187 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 244 |
|---|---|
| 1983 | 255 |
| 1984 | 241 |
| 1985 | 209 |
| 1986 | 207 |
| 1987 | 176 |
| 1988 | 158 |
| 1989 | 187 |
| 1990 | 154 |
| 1991 | 143 |
| 1992 | 121 |
| 1993 | 98 |
| 1994 | 74 |
| 1995 | 114 |
| 1996 | 110 |
| 1997 | 94 |
| 1998 | 110 |
| 1999 | 101 |
| 2000 | 99 |
| 2001 | 75 |
| 2002 | 85 |
| 2003 | 122 |
| 2004 | 115 |
| 2005 | 100 |
| 2006 | 87 |
| 2007 | 88 |
Where
Latest 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\" = 240)
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" = 240) 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 MKC90LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Norfolk, NEInproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…NTSB DEN90LA037Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tularosa, NMThe pilot's VFR flight into instrument meteorological conditions (IMC), and his failure to see and avoid the road sign during the precautionary landing. The adverse weather was a realted factor.NTSB CHI90FA056Accident · No injuriesField investigationFinal reportCessna 340 · Merrill, WIFailure of the pilot to maintain proper alignment with the runway during his landing roll and an inflight encounter with icing conditions.NTSB CHI90FA055Accident · 3 fatalField investigationFinal reportBeech A24R · Merrill, WIFlight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…NTSB CHI90LA054Accident · No injuriesLimited investigationFinal reportBeech V35B · North Canton, OHContinued flight by the pilot into known adverse weather conditions, and his delay in diverting to an alternate airport, which resulted in accumulation of airframe icing. Factors related to the accident were: the adverse weather and runway/terrain conditions.NTSB NYC90FA041Accident · 3 fatalField investigationFinal reportCessna 172N · Washington Twp, NJThe failure of the pilot to properly pre-flight plan and execute the VFR flight. Factor's related to the accident were: the pilot's inexperience; no visual cues (lights) due to dark night conditions; the pilot's disregard of the weather briefing.NTSB ANC90FA020Accident · No injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKInadvertent encounter with volcanic ash cloud, which resulted in damage from foreign material (foreign object) and subsequent compressor stalling of all engines. A factor related to the accident was: the lack of available information about the ash cloud to…NTSB SEA90FA028Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Rainier, WAContinued flight by the pilot into known adverse weather conditions, and his failure to maintain sufficient altitude/clearance from wooded mountainous terrain. Factors related to the accident were: darkness and the weather/terrain conditions.NTSB LAX90LA048Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Chandler, AZImproper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.NTSB DEN90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDFailure of the CFI to utilize carburetor heat prior to the induction icing and power loss. Contributing to the accident was the cfi's continued VFR flight into known and forecast instrument meteorological conditions.NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…NTSB DEN90FA027Accident · Serious injuriesField investigationFinal reportPiper PA-46P-350 · Des Moines, IALoss of engine power for undetermined reason(s). The light conditions (dusk) and trees in in the emergency landing area were considered to be contributing factors.NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…NTSB DEN90LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Steamboat Spgs, COContinued VFR flight by the pilot into instrument meteorological conditions (IMC) and his delay in diverting or reversing course. The terrain, weather conditions, wing ice, and trees were considered to be contributing factors.NTSB NYC90LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Johnstown, PAFailure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…NTSB FTW90IA030Incident · No injuriesIncident investigationFinal reportSaab-Fairchild 340A · Beaumont, TXThe pilot failed to maintain adjusted vref and proper descent rates during the approach. The pilot delayed decision to execute a go-around and the copilot failed to monitor the poorly flown approach. Contributing to the accident was the rain and wind shear…NTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.NTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.NTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.NTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…NTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB DCA90MA005Accident · 20 fatalClass 1 · MajorFinal reportDe Havilland DHC-6-300 · Halawa,Molokai, HIThe airplane's controlled flight into terrain as a result of the decision of the captain to continue flight under visual flight rules at night into instrument meteorological conditions (IMC), which obscured rising mountainous terrain. Contributing to the…NTSB FTW90FA018Accident · 2 fatalField investigationFinal reportCessna TR182 · Crane, TXThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his loss of aircraft control, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument…NTSB LAX90FA016Accident · 3 fatalField investigationFinal reportCessna 177 · So Lake Tahoe, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions.NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.NTSB SEA90LA008Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Salmon, IDFailure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.NTSB ATL90LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Kernersville, NCImproper fuel consumption calculations by the pilot, which resulted in fuel exhaustion from lack of fuel. Adverse weather conditions were related to the accident.NTSB ATL90FA008Accident · 2 fatalField investigationFinal reportCessna 172N · Eddyville, KYThe pilot continuing VFR flight into adverse weather conditions. Contributing factor(s) was: low ceiling and rain.NTSB NYC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Palmyra, NYThe pilot failed to maintain airspeed during a tight closed pattern turn to final. Contributing factor(s) was: the pilot initiating flight into known adverse weather conditions, which included fog and reduced visibility.NTSB SEA90FA005Accident · 1 fatalField investigationFinal reportHughes 369D · Bothell, WAThe pilot failed to determine weather conditions before the flight, his attempt to fly VFR in IMC, and his failure to maintain obstacle clearance altitude. Factors in the accident were the low ceiling, rain and fog weather conditions.NTSB DEN90FA002Accident · 1 fatalField investigationFinal reportCessna 182A · Nixon, NVContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Inadequate preflight preflight planning/preparation by the pilot, and the…NTSB SEA90FA002Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Cougar, WAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.NTSB ATL90LA002Accident · No injuriesLimited investigationFinal reportBeech V35B · Colquitt, GAThe pilot's failure to obtain current enroute weather information for his destination resulting in his flying VMC into IMC conditions which resulted in his collision with powerlines while making a precautionary landing on a road.NTSB SEA89FA182Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Bridal Veil, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the adverse weather conditions, the pilot's lack of instrument experience,…NTSB MKC89FA202Accident · No injuriesField investigationFinal reportFokker F27 · Bemidji, MNThe pilot's failure to maintain a proper descent rate and compensate for the downdraft encountered while on short final approach.NTSB ANC89LA178Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Shotgun Hills, AKThe pilot's failure to adequately evaluate the existing weather conditions and to maintain control of the aircraft. Contributing to the accident was the pilot's overconfidence in both personal ability and the ability of the aircraft along with the downdraft…NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB FTW89FA172Accident · 1 fatalField investigationFinal reportCessna 210D · Covington, LAThe pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.NTSB ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB CHI89LA193Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Medina, OHThe pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…NTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.NTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.NTSB NYC89LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Montague, NJImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.NTSB LAX89FA319Accident · 2 fatalField investigationFinal reportCessna 310K · Ojai, CAThe pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…NTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.NTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.