NTSB investigations, OK
43 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 3 |
| 1998 | 2 |
| 2000 | 1 |
| 2002 | 2 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' 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 DFW07LA164Accident · Serious injuriesLimited investigationFinal reportBoeing B737-800 · McAlester, OKAn in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.NTSB FTW03LA056Accident · No injuriesLimited investigationFinal reportCessna 172M · Vici, OKThe pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing.NTSB FTW03LA011Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Vinson, OKThe pilot's inadvertent flight into adverse weather conditions during cruise resulting in his failure to maintain control of the helicopter, and his failure to maintain rotor rpm. Contributing factors relating to the accident included the frontal activity…NTSB FTW00LA221Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kingfisher, OKThe pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.NTSB FTW99FA044Accident · 1 fatalField investigationFinal reportBeech 58 · Newcastle, OKthe pilot's loss of control due to his inadvertent encounter with severe turbulence and wind shear during an instrument approach. Factors contributing to the accident were the severe turbulence and the wind shear.NTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB FTW95FA114Accident · 2 fatalField investigationFinal reportRockwell 690A · Guthrie, OKThe pilot's failure to maintain adequate airspeed due to airframe ice, which resulted in a loss of control. Factors contributing to the accident were the pilot's continued flight into adverse weather, his failure to obtain weather information either before or…NTSB FTW95FA071Accident · 3 fatalField investigationFinal reportCessna 182G · Muskogee, OKFailure of the pilot to maintain control of the airplane due to spatial disorientation after inadvertently flying into adverse weather. Factors related to the accident were: darkness, the low ceiling, the pilot's inadequate evaluation of the weather, and his…NTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.NTSB FTW93FA128Accident · 2 fatalField investigationFinal reportCessna 172M · Hobart, OKInadvertent stall. Factors were the instructor pilot's spatial disorientation, his lack of total instrument time, the weather, and the dark night conditions.NTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.NTSB FTW91DPJ03Accident · 2 fatalFinal reportGrimm Cavalier SA102.5 · Mcalester, OKThe pilot's attempted flight into IMC and his subsequent loss of control due to spatial disorientation.NTSB FTW90FA093Accident · 1 fatalField investigationFinal reportMooney M-20J · Inola, OKThe pilot's decision to conduct the flight into known adverse weather and his inability to maintain control of the airplane due to spatial disorientation. Factors were the dark night conditions and thunderstorms.NTSB FTW90FA062Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Coalgate, OKFlight into known adverse weather conditions by the non-instrument rated pilot, and his subsequent spatial disorientation, which resulted in a loss of aircraft control. Factors related to the accident were: inoperative instrument panel lights, dark night,…NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.NTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB FTW88DPJ08Accident · Minor injuriesFinal reportCessna 152 · Heavener, OKDuring a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR…NTSB FTW88FA046Accident · Serious injuriesField investigationFinal reportBeech B36TC · Woodward, OKBefore tkof, the plt was briefed on flt precautions for IFR & snow; however, he was not adzd of icing conds in clouds & precip above the freezing lvl to 18,000' as cautioned in the current area forecast. While climbing after tkof, he enctrd clouds & 'some…NTSB MIA87FA248Accident · No injuriesField investigationFinal reportBoeing 727 · Tulsa, OKThe crew of the Boeing 727 aircraft on a domestic passenger flight initiated an approach to a runway with a known crosswind and tailwind component. On final approach the tower controllers re-stated the wind and issued a windshear warning. On short final at…NTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…NTSB FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…NTSB DEN86FA150Accident · 2 fatalField investigationFinal reportBeech A36TC · Marietta, OKThe plt obtained a wx briefing and was advised of scattered thunderstorm activity along his route of flt. The plt then filed an IFR flt plan from wiley post airport, Oklahoma city, OK, to houston intercontinental airport, TX. The plt and his wife took off at…NTSB FTW86FA092Accident · 2 fatalField investigationFinal reportCessna 210M · Calumet, OKAcft on a night xc flt in marginal VFR to IMC conditions impacted in an 80 deg nose down attitude in a left spiral. Immediately prior to the accident the non-instrument rated pvt plt had indicated that he was IMC and was going to attempt to climb out of it.…NTSB FTW86LA048Accident · No injuriesLimited investigationFinal reportBeech H35 · Talihina, OKAcft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power…NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB FTW85FA343Accident · 1 fatalField investigationFinal reportMooney M20J · Bethel, OKDespite a wx brief discouraging VFR flt the non-instrument rated plt departed at about 1330 CST. His stated dest was ft. worth, TX which is due north. After takeoff in VMC the acft flew NE toward an unknown dest. A wx study indicated conditions along the…NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…NTSB FTW84LA250Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Arnett, OKAccording to the plt, the wx for his route of flt was forcast to remain VFR. En route, ceilings at 4000 to 5000 ft MSL were encountered in the vicinity of hobart, OK. As the flt continued the wx deteriorated. In order to maintain VFR conditions, the…NTSB FTW84FA242Accident · 1 fatalField investigationFinal reportBeech BE35G · Wewoka, OKThe plt was not current in IMC operations nor was the acft certified for instrument lft. After obtaining a wx briefing which forecast a chance of thunderstorms along his route, the plt departed on a x-country. En route the plt contacted Oklahoma city efas and…NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.NTSB FTW84LA092Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Washington, OKAbout 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…NTSB FTW84LA018Accident · No injuriesLimited investigationFinal reportCessna 182M · Aline, OKBefore departing norman, OK, the plt obtained a wx briefing from the Oklahoma city fss. During that briefing, he was advised that VFR flt was not recommended. He then took off for dodge city, KS without filling a flt plan. However, en route, he encountered wx…NTSB FTW83LA390Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Buffalo, OKThe acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…NTSB FTW83FA170Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKDuring the early morning hours, the acft crashed at the edge of a wheat field on relatively level terrain. The main wreckage then crossed a road & came to rest in another field. There were no known witnesses. A passing farmer discovered the wreckage at about…NTSB FTW83LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Nash, OKPilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.NTSB FTW83FPM04Accident · 2 fatalFinal reportPiper PA23-250 · 8 Miles Se Bris, OKThe acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog.NTSB FTW82FA223Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Hartshorne, OKWhile on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,…NTSB FTW82FPJ14Accident · 1 fatalFinal reportCessna 172N · Hulen, OKThe pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that…