NTSB investigations, 1997
94 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\") = 1997
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") = 1997 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 FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…NTSB DCA98MA015Accident · 1 fatalMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)The pilot-in-command's inadvertent flight into adverse weather conditions, and the difficulty of obtaining adequate weather forecasts of over-ocean turbulence. Factors contributing to the accident include the presence of clear air turbulence, and the failure…NTSB LAX98LA059Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Safford, AZThe pilot's poor in-flight judgement and intentional flight into known adverse weather conditions. Related factors were, mountainous terrain, rain and fog.NTSB NYC98FA041Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Pittsville, MDthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…NTSB LAX98LA057Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Ventura, CASeat belt not used. A related factor was the unforecasted severe air turbulence.NTSB NYC98LA038Accident · No injuriesLimited investigationFinal reportCessna TR182 · Owenton, KYThe pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.NTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.NTSB LAX98FA052Accident · 2 fatalField investigationFinal reportCessna 172N · Lytle Creek, CAthe non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…NTSB MIA98FA040Accident · 3 fatalField investigationFinal reportCommander 114B · Cross City, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…NTSB IAD98FA012Accident · 2 fatalField investigationFinal reportCessna 182A · New Dover, OHThe pilot's attempted VFR flight into instrument conditions and the loss of aircraft ctontrol subsequent to the pilot's spatial disorientation. Contributing factors were low ceilings, snow and the pilot's failure to obtain a preflight weather briefing, as…NTSB ATL98LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Opa Locka, FLthe pilot's continued flight into adverse weather conditions, and failure to maintain clearance above the ground while attempting a VFR approach to an airport with low clouds. The low clouds (ceiling) and condition of light at dusk were related factors.NTSB MIA98LA033Accident · 1 fatalLimited investigationFinal reportMooney M20C · Sparta, TNThe pilot's inadequate preflight and inflight decision and his inadvertent VFR flight into instrument meteorological conditions. Contributing factors are self induced pressure, mountainous terrain, and low clouds.NTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…NTSB CHI98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Willmar, MNthe pilot's improper planning/decision, his continued flight into known adverse weather, and subsequent fuel exhaustion, which resulted in loss of engine power, and a forced landing. Factors related to the accident were: the adverse weather conditions, the…NTSB CHI98LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Ulysses, KSthe pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…NTSB ATL98FA007Accident · 1 fatalField investigationFinal reportChampion 7ECA · Hamilton, GAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Related factors were: darkness, adverse weather conditions, and the pilot's self induced pressure…NTSB CHI98FA031Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lynn, INthe pilot's failure to maintain control of the airplane which resulted in the inflight separation of the wings, vertical stabilizer/rudder, and the stabilator. Factors associated with the accident the pilot continued the flight into known adverse weather and…NTSB MIA98LA017Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-8-201 · Jacksonville, FLThe passengers failure to secure her seatbelt as directed by the flight crew (seatbelt sign illuminated) on initial takeoff climb resulting in her ejection from her seat during an encounter with turbulence.NTSB ANC98FA006Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot's intentional flight into adverse weather. Related factors were the low ceilings, mountainous terrain, and self induced pressure by the pilot to complete the flight and return for the evening.NTSB SEA98FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Leadore, IDthe pilot's inadvertent entry into instrument meteorological conditions, and his failure to maintain clearance from wooded terrain in the area where he was maneuvering. Factors relating to the accident include: darkness, low ceiling, and high/mountainous…NTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.NTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.NTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.NTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…NTSB MIA98LA002Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Cross City, FLThe in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.NTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.NTSB LAX97FA331Accident · 1 fatalField investigationFinal reportCessna 172K · Sandy Valley, NVthe pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…NTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…NTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.NTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.NTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.NTSB ANC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gulkana, AKThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.NTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…NTSB ANC97LA134Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.NTSB ANC97GA126Accident · 1 fatalFinal reportBell BH-206B · Dillingham, AKThe pilot's intentional VFR flight into instrument meteorological conditions (IMC). Factors associated with the accident are the pilot's failure to activate the cabin heating system, the lack of an operable windshield defogger, the pilot's overconfidence in…NTSB FTW97LA310Accident · No injuriesLimited investigationFinal reportWaco KNF · Wamsutter, WYThe pilot's failure to maintain directional control during the precautionary landing. A factor was a wind gust.NTSB ANC97FA121Accident · 3 fatalField investigationFinal reportCessna U206G · Halibut Cove, AKThe pilot's improper evaluation of the weather conditions which led the pilot to maneuver within the confines of the lake to avoid surrounding terrain and a subsequent inadvertent stall. Factors were the terrain-induced turbulence and gusts.NTSB ANC97LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKthe pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.NTSB FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB FTW97FA292Accident · 2 fatalField investigationFinal reportBeech F35 · Richards, MOThe pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.NTSB FTW97FA286Accident · 1 fatalField investigationFinal reportDurbin Glasair R · Chama, NMflight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the low ceiling, rain, fog, and high/mountainous terrain.NTSB NYC97LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)Failure of the aft flight attendant to secure her seat belt. Related factors were turbulence in clouds, and the flight attendant not receiving the crew briefing.NTSB ANC97LA109Accident · No injuriesLimited investigationFinal reportCessna 208 · Naknek, AKThe pilots decision to continue the landing into adverse weather conditions and failure to maintain runway alignmet. A factor was the rain shower which resulted in reduced forward visibility.NTSB ANC97LA108Accident · No injuriesLimited investigationFinal reportGoode Avid Flyer MK-IV · Nikiski, AKThe pilot's inadequate compensation for wind conditions. Factors were the sudden windshift, and the pilot's lack of seaplane certification.NTSB MIA97LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Eustis, FLan in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.NTSB FTW97IA261Incident · Minor injuriesIncident investigationFinal reportBoeing 757-223 · Dickinson, NDan encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.NTSB LAX97LA236Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Susanville, CAthe pilot's inadvertent encounter with unfavorable weather conditions during the landing, and his failure to maintain runway alignment. The sudden onset of crosswind gusts beyond the capability of the aircraft was a related factor.NTSB NYC97FA139Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Jones Beach, NYVFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…NTSB ANC97LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Cantwell, AKThe pilot's failure to maintain sufficient altitude to clear terrain. Factors were exceeding the airplane's maximum allowable gross weight, and downdrafts and turbulence associated with wind flowing across a mountain ridge.NTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.