NTSB investigations, 1990
154 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\") = 1990
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") = 1990 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 ATL91FA031Accident · 1 fatalField investigationFinal reportCessna 182E · Saluda, NCThe continued visual flight rules flight into instrument meteorological conditions. Contributing factor were fog, rain, and low ceiling.NTSB BFO91LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Boston, VAThe student pilot's delay in taking appropriate action while encountering adverse weather conditions. Factors which contributed to the accident were: the weather conditions that were worse than forecast, and the unsuitable terrain.NTSB MIA91GA050Accident · Minor injuriesFinal reportBell 206 B3 · St. Marks, FLThe pilot in command's failure to maintain safe altitude while descending over a coastline, at night, in visual meteorological conditions. Contributing to the accident was the pilot in command's failure to obtain a full weather briefing prior to departure…NTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.NTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.NTSB NYC91FA046Accident · 4 fatalField investigationFinal reportAerostar S-60A · Columbus, OHImproper planning/decision by the pilot. The unfavorable wind and temperature inversion were related factors.NTSB FTW91LA022Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Boerne, TXThe pilot's inability to climb over obstacles due to encountering a downdraft which exceeded the climb capability of the airplane. Factors in the accident were the gusty wind conditions and the downdraft.NTSB NYC91FA042Accident · 2 fatalField investigationFinal reportBeech A24R · Owls Head, NYThe pilot's continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness, adverse weather conditions, and mountainous terrain.NTSB MIA91LA036Accident · No injuriesLimited investigationFinal reportCessna 550 · Sebring, FLThe pilot's delayed go-around after encountering a fog bank on short final. The fog and the dark night were factors.NTSB LAX91LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Livermore, CAInadvertent flight by the pilot into instrument meteorological conditions (IMC), and her failure to maintain adequate altitude and/or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB LAX91FA045Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Show Low, AZThe pilot's improper in-flight planning/decision, which resulted in loss of engine power, due to induction system icing. Factors related to the accident were: the adverse weather condition and lack of a suitable area for a forced landing.NTSB LAX91FA044Accident · 1 fatalField investigationFinal reportCessna T210-F · Fontana, CAThe pilot-in-command's decision to continue flight into known adverse weather conditions during the hours of darkness in mountainous terrain.NTSB NYC91LA036Accident · 3 fatalLimited investigationFinal reportPiper PA-28-140 · Cheswold, DEA loss of control in flight, by a non-instrument rated pilot in instrument meteorological conditions. Factors related to the accident were: his decision to fly after he received weather briefings which inlcuded 'VFR flight not recommended'.NTSB SEA91FA020Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Albion, IDThe pilot-in-command's failure to maintain control of the airplane in instrument meteorological conditions. Factors which contributed to the accident were the pilot's apprehension of flying in the forecasted weather, and the adverse weather conditions…NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB FTW91FA012Accident · 5 fatalField investigationFinal reportPiper 601P · Nacogdoches, TXFailure of the pilot to follow IFR procedures and maintain the proper altitude. Factors related to the accident were: the adverse weather conditions, dark night, low fuel state of the aircraft, and trees at the accident site.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…NTSB NYC91FA025Accident · 2 fatalField investigationFinal reportBeech A36 · Bradford, PAThe pilot's failure to maintain adequate terrain clearance while maneuvering to land during an instrument approach. Factors related to the accident were: the pilot's failure to obtain a weather briefing prior to departure, his delayed decision to make an…NTSB CHI91LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Latham, KSFailure of the pilot to maintain a proper altitude.NTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB LAX91LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe failure of the flight instructor to ensure that an adequate airspeed was maintained during the final approach for the existing wind conditions; to adequately supervise the conduct of the flight; and to arrest the rate of descent prior to touch down.NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.NTSB SEA91LA004Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Hamilton, MTThe pilot's inadequate compensation for wind conditions.NTSB FTW91LA005Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's decision to enter an area of forecast thrunderstorms. The factor was the severe downdraft encountered.NTSB DEN91LA007Accident · Minor injuriesLimited investigationFinal reportBalloon Works AX9 · Cedar Crest, NMPilot's delayed precautionary landing and the subseuqent fuel exhaustion. A factor was the encounter with high winds in flight.NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB CHI91LA002Accident · No injuriesLimited investigationFinal reportGulfstream American 690B · Willow Springs, MOThe airplanes encounter with a static discharge, turbulence and a downdraft in the clouds which were associated with severe meteorological conditions.NTSB DEN91LA001Accident · No injuriesLimited investigationFinal reportRaven S-60A · Harrison, ARThe student pilot's improper inflight planning and inaccurate evaluation of the surface weather. A factor was the unfavorable wind.NTSB ANC90LA189Accident · 1 fatalLimited investigationFinal reportMaule M-4-210C · 60 E Of Bethel, AKContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance above mountainous terrain. Factors related to the accident were: darkness, adverse terrain and weather conditions, the…NTSB FTW90LA187Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Greers Ferry, ARThe pilot's decision to penetrate adverse weather and the resultant spatial disorientation. Factors were the weather conditions and the pilot's lack of instrument training/experience.NTSB LAX90LA340Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Vacaville, CAThe Balloon's encounter with a sudden increase in wind speed accompained by a strong down draft beyond the compensation capability of the Balloon.NTSB ATL90LA182Accident · Serious injuriesLimited investigationFinal reportHelio HST-550A · Mobile, ALThe pilot's intentional attempted takeoff with a known tailwind component. Factors relating to the accident were the tailwind, trees and utility lines on the departure end of the takeoff area.NTSB NYC90FA225Accident · 4 fatalField investigationFinal reportPiper PA-30 · Berlin, VTThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and…NTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.NTSB ATL90LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Midfield, ALThe pilot's inadequate assessment of deteriorating weather conditions and his resultant flight into areas of low clouds. The safety board believes that the pilot's overall lack of experience was a factor in the accident.NTSB LAX90FA331Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Flagstaff, AZVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude during the approach to land. Factors related to the accident were: darkness, the adverse weather conditions, and failure of…NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB LAX90LA326Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Mount Wilson, CAThe pilot's inadvertent flight into IMC. Contributing factors related to the pilot's failure to request in-flight weather avoidance assistance and his misjudged evaluation of the en route weather.NTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.NTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.NTSB NYC90FA220Accident · 2 fatalField investigationFinal reportCessna 152 · Plain City, OHPoor judgement of the pilot due to consumption of alcohol, flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: darkness,…NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB LAX90LA325Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Hemet, CAImproper compensation for wind conditions.NTSB DEN90LA181Accident · No injuriesLimited investigationFinal reportCessna T210N · Durango, COThe loss of control of the airplane when the pilot encountered turbulence on short final to land.NTSB ANC90FA164Accident · 5 fatalField investigationFinal reportCessna P206C · Talkeetna, AKThe pilot-in-command's continued VFR flight into instrument meteorological conditions, and failure to maintain adequate altitude for terrain clearance. Factors to the accident were the adverse weather conditions, mountainous terrain, and the dark night.NTSB BFO90FA073Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Richland, VAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain proper clearance from high terrain. Darkness and the adverse weather conditions were related factors.