NTSB investigations, KY
26 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1985 | 3 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 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\" = 'KY' 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" = 'KY' 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 DEN08CA001Accident · Serious injuriesData collectionFinal reportDegelia Rotor Flight Dynamic · Ashland, KYthe pilot's failure to maintain aircraft control during the landing flare resulting in a hard landing. Contributing factors were the crosswind and the pilot's failure to recover from a bounced landing.NTSB NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.NTSB IAD05LA028Accident · 2 fatalLimited investigationFinal reportCessna 172 · Knottsville, KYthe pilot's loss of control in flight due to spatial disorientation. Also causal to the accident was the pilot's inadequate preflight planning which resulted in his inadvertent flight into night instrument meteorological conditions.NTSB NYC04FA092Accident · 6 fatalField investigationFinal reportPiper PA-32R-301 · Harlan, KYThe pilot's improper decision to continue VFR flight into IMC conditions and his failure to maintain terrain clearance, which resulted in controlled flight into terrain. Factors were night, snow and a low ceiling.NTSB NYC03FA148Accident · 2 fatalField investigationFinal reportBeech F-35 · Middlesboro, KYThe pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.NTSB NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.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 BFO90LA072Accident · 1 fatalLimited investigationFinal reportCessna A152 · Hyden, KYThe pilot intentionally continuing VFR flight into instrument meteorological conditions which resulted in spatial disorientation and loss of aircraft control. Factors contributing to the accident were the thunderstorms and the pilot's lack of instrument…NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.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 ATL89FA149Accident · 1 fatalField investigationFinal reportBeech S35 · Russellville, KYImproper planning/decision by the pilot, his continued flight into an area of known adverse weather, and his failure to maintain control of the aircraft. Contibuting factors were: the dark night, the adverse weather conditions, and the pilot's overconfidence…NTSB ATL89FA131Accident · 2 fatalField investigationFinal reportMooney M20F · Lynch, KYContinued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience.NTSB ATL89LA068Accident · Serious injuriesLimited investigationFinal reportBeech B-90 · Paducah, KYPilot failed to maintain proper altitude while maneuvering to land. Probable contributing factors were inoperative weather radar, thunderstorms, lightning, an undetermined electrical problem, dark night, the pilot's improperly planned approach and visual…NTSB ATL88LA228Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Burkesville, KYThe plt reported that the airplane encountered heavy rain and extreme turbulence while flying over a black cloud at 8,500 ft. he stated that it was as if an 'invisible tornado had reached out' and grabbed the airplane; excessive climb & descent rates were…NTSB ATL88FA136Accident · 7 fatalField investigationFinal reportPiper PA-32R-301T · Middlesboro, KYThe plt received preflt wx briefing that stated VFR flt was not recommended due to low pressure system affecting proposed flt path. Wx forecast included tornadoes, hail, thunderstorms to 42,000', moderate rime icing, moderate turbulence, wind gusts to 70 KTS,…NTSB ATL88FA104Accident · 2 fatalField investigationFinal reportBeech A36 · Bow, KYThe pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…NTSB MIA88LA090Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-82 · Hickman, KYThe capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…NTSB ATL86LLQ01Accident · Minor injuriesFinal reportCessna 172 · London, KYThe acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast…NTSB ATL85LA259Accident · No injuriesLimited investigationFinal reportHughes 269C · Elizabethtown, KYAfter takeoff from off airport landing zone, the acft encountered heavy raninshowers and the plt attempted to return to the landing zone. Visibility was such that the plt was unable to see the ground and the tailrotor contacted a lake adjacent to the landing…NTSB ATL85FA085Accident · 3 fatalField investigationFinal reportBeech B-50 · Edgewood, KYDuring a VFR flt from london, KY, to detroit, MI, the acft crashed into a single family home while attempting a landing at cvg arpt. The plt reported a right eng pwr loss, from suspected impact ice. The alternate air source did not change the acft…NTSB ATL84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waverly, KYAbout 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…NTSB ATL83LA325Accident · No injuriesLimited investigationFinal reportPiccard AX-6 · Louisvile, KYThe plt received a wx briefing at 0600 EDT & noted nothing significant that would be a hazard to flt. He proceeded to long run park, aprx 20 mi east of louisville, KY, to launch the ballon. There was a 654 foot tower in the vicinity, but the plt believed the…NTSB ATL83FA128Accident · 3 fatalField investigationFinal reportCessna 310 · Hopkinsville, KYThe plt obtained a wx briefing & filed a flt plan from lexington to paducah,KY with a 15 min en route stop at bowling green, KY. While inbound to bowling green, he reported that the cloud base was at aprx 6000 ft & that there was lightning to the west. After…NTSB ATL83LLQ01Accident · Serious injuriesFinal reportBeech 35 · Hazard, KYThe pilot reported that the airport was located in a valley, and due to the terrain, it was necessary to takeoff on runway 17 with a quartering left tail wind. He reported that a mountain was located close to the runway centerline (to the right) as well as…NTSB ATL82DA258Accident · Minor injuriesFinal reportHughes 269C · Louisville, KYThe pilot received a weather briefing before taking off on an aerial traffic patrol for a local radio station. He was issued a special VFR clearance to follow a pre-established route. However, after departing, he encountered thunderstorm activity. He returned…NTSB ATL82DA234Accident · No injuriesFinal reportGrumman American AA-5A · Providence, KYDense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not…