NTSB investigations
3,567 cases where the first occurrence was “In flight encounter with weather”.
Cases, newest first
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.\"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."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 BFO88FA009Accident · 1 fatalField investigationFinal reportCessna 182D · South Hill, VAThe plt was on the third leg of a trip between tampa, FL and sussex, NJ. The previous two stops were made because of adverse wx conditions. Before this flight he was advised by fss that VFR flight was not recommended. He filed a VFR flight plan but did not…NTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…NTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…NTSB FTW88FA032Accident · 3 fatalField investigationFinal reportBeech H35 · Port Mansfield, TXThe plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd…NTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…NTSB SEA88FA021Accident · 1 fatalField investigationFinal reportCessna 210E · Port Townsend, WAThe aircraft flew into the side of maynard mountain, the point of a coastal land mass, while on a night VFR flight in IMC wx conditions. Radar data showed the aircraft on a straight course at cruise airspeed.NTSB MIA88FA042Accident · 2 fatalField investigationFinal reportCessna 152 · Okeelanta, FLThe acft crashed into a wildlife management area in a steep nose down attitude with about 20 degs flaps extended. The stated purpose of the flt was to spot deer & a suitable area in which to hunt. Torsional damage to the airframe suggested that the acft was…NTSB MKC88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mena, AROn the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had…NTSB SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…NTSB NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…NTSB FTW88FA028Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lancaster, TXThe pilot received a weather report indicating that IFR conditions prevailed. After takeoff the airplane traveled approximately 1/2 mile before it crashed. Pilot was not instrument rated and had very little total time. He did have three hours of night time…NTSB SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…NTSB MIA88FA032Accident · Serious injuriesField investigationFinal reportAirbus Industrie A310 · Atlantic Ocean (Atlantic Ocean)The capt said he expected some wx drg the 1st 2 hrs of flt. After lvlg at FL 330, the acft was in clear wx, but lgt turbc contd for a time. After the turbc had stopped & there were no wx rtrns on the radar, the seat belt sign was turned off, although the capt…NTSB MIA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · West Palm Beach, FLThe plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…NTSB ATL88LA034Accident · Serious injuriesLimited investigationFinal reportBoeing 737-232 · Raleigh, NCThe acft encountered moderate to severe turbulence during the nighttime flt, when it passed through clouds momentarily at FL225. A flt attendant sustained a broken ankle. The captain rptd that radar gave no indication of any wx ahead prior to the encounter.…NTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…NTSB DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…NTSB MIA88LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Orlando, FLThe acft made a hard ldg during heavy rain & after being advised of wind shear. The crew stated that at one point, the acft was thrown into a 60 deg bank with airspeed fluctuations plus or minus 20 KTS about 400 to 600 ft AGL. The plt stated that at 100 to…NTSB FTW88FA023Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Fulton, TXAcft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…NTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…NTSB SEA88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Snoqualamie Pss, WAThe pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…NTSB FTW88LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Brownsville, TXDuring initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and…NTSB LAX88FA020Accident · 1 fatalField investigationFinal reportCessna 208A · Fairfield, CAPilot's encounter with severe turbulence which precipitated a loss of aircraft control.NTSB FTW88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Caney, TXAcft took off in marginal VFR conditions on a pipeline patrol flt. En route, the plt encountered deteriorating wx conditions and experienced a rough running eng, due to what he suspected was carb ice. His attempts to remedy the roughness were unsuccessful and…NTSB FTW88FA009Accident · 2 fatalField investigationFinal reportCessna 172RG · Llano, TXThe pilot departed lubbock, Texas in VFR conditions. As the flight progressed the ceiling and visibility deteriorated and the pilot encountered instrument meteorological conditions. No evidence was found to indicate that the pilot obtained a weather briefing…NTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…NTSB DEN88FA014Accident · 1 fatalField investigationFinal reportCessna 340A · Bailey, COThe aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…NTSB LAX88LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Carpenteria, CAThe pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses…NTSB NYC88LA010Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Henryville, PAOn takeoff from a private airport, the flight encountered downdrafts and the left wing dropped. As the pilot attempted to level the wings, he realized that the aircraft was no longer climbing but descending at a rapid rate. The aircraft crashed on rising…NTSB FTW88FA006Accident · 3 fatalField investigationFinal reportCessna 172RG · Refugio, TXThe plt continued VFR flt into wx that was IMC. The acft impacted the terrain in an extremely nose low attitude. There was no record of the pilot receiving any pre-flt or in flight weather briefings or forecasts for this flight. A witness reported normal…NTSB ATL88FA010Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, SCThe plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted…NTSB LAX88FA014Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Mount Baldy, CABfr tkof, the plt filed a VFR flt plan & rcvd a wx briefing which included an AIRMET. The AIRMET contained precautionaryinfo abt instrument conds (IMC), icing & mtn obscuration in calif. When the plt opened his flt plan with the fss, he wasagain briefed on…NTSB FTW88DQG01Accident · No injuriesFinal reportBoeing A75N1 · Fort Stockton, TXThe pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an…NTSB LAX88LA011Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Luis Obispo, CAThe non-instrument rated pilot became disoriented when he inadvertently flew into a layer of fog while making an enroute descent for landing at his destination. The aircraft collided with trees while the pilot was attempting to execute a climbing course…NTSB MIA88FA001Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Everglades City, FLThe non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about…NTSB NYC87FA264Accident · Serious injuriesField investigationFinal reportLockheed L-1011 · Bermuda, BermudaEncounter with undetectable clear air turbulence.NTSB DEN87LA243Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Las Cruces, NMA CFI and a private plt were ferrying a newly purchased helicopter to their home airport. During a fuel stop, while on a visual approach, the helicopter encountered windshear. The density altitude was 8000 feet, and the helicopter was at or near max gross wt.…NTSB NYC87FA260Accident · Serious injuriesField investigationFinal reportBoeing 737 · Philadelphia, PAThe acft was in a holding pattern at 11,000' in an area of thunderstorms & turbulence. Although the seat belt sign was on, two passengers (pax) went to the aft lavatory. As one of the pax was waiting & the other was exiting the lavatory, the acft encountered…NTSB NYC87FA257Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Pittsburgh, PAWhile descending out of flt lvl 270 for lndg, usair flight 10 encountered light to moderate turbulence. Prior to this this encounter, the capt advised all passengers and cabin crew to remain seated and to engage their seatbelts. A similar announcement was…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 ATL87LA259Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Concord, NCWhile on climbout, the stu plt switched radios to the dest UNICOM freq. Unable to contact anyone on that freq, the departure arpt freq was reselected. No contact was established on this freq so the stu plt attempted to rtrn to the arpt. The haze was very…NTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.NTSB FTW87FA214Accident · 4 fatalField investigationFinal reportBeech 58P · Austin, TXThe plt rcvd a full wx briefing at 0540 CDT & a wx update at 0737 when he filed an IFR flt plan. The flt was without incident with a final cruise alt of 16,000' until 1055:43, when the plt reqd a 'left turn for deviation.' About 3 min later, the ctlr noticed…NTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…NTSB BFO87FA062Accident · 2 fatalField investigationFinal reportCessna 172P · Cabin, WVThe plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to…NTSB DEN87FA230Accident · 1 fatalField investigationFinal reportCessna 170B · Cedar City, UTWhile on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon.NTSB ANC87LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong…NTSB MIA87FA239Accident · 1 fatalField investigationFinal reportCessna 421 · Coral Springs, FLThe acft had been abandoned in the Bahamas for aprx 7 months. A plt, with no known flt time in a Cessna 421, flew it to ft lauderdale. Except to avoid clds, he made the flt at a low alt & airspeed. When asked why, he said he was trying to save the engs. The…NTSB LAX87LA321Accident · No injuriesLimited investigationFinal reportCessna 152C · Upland, CAThe dual instruction flight completed 2 full stop landings on runway 06 at the cable airport. On the next takeoff the flight encountered a downdraft after turning on the crosswind leg. The instructor pilot took the controls and turned to the downwind leg but…NTSB ATL87FA257Accident · 2 fatalField investigationFinal reportBeech V-35B · Hilton Head, SCPIC said he had wx brief. Noted tstms ovr atlantic & fog at arpt. Stated he would hold ovr ocean until arpt clr. Acft track on radar was into area of tstms ovr ocean followed by mode c altitude deviations and loss of radar contact. Acft recovered from ocean.…