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 DEN90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDFailure of the CFI to utilize carburetor heat prior to the induction icing and power loss. Contributing to the accident was the cfi's continued VFR flight into known and forecast instrument meteorological conditions.NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…NTSB DEN90FA027Accident · Serious injuriesField investigationFinal reportPiper PA-46P-350 · Des Moines, IALoss of engine power for undetermined reason(s). The light conditions (dusk) and trees in in the emergency landing area were considered to be contributing factors.NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…NTSB DEN90LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Steamboat Spgs, COContinued VFR flight by the pilot into instrument meteorological conditions (IMC) and his delay in diverting or reversing course. The terrain, weather conditions, wing ice, and trees were considered to be contributing factors.NTSB NYC90LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Johnstown, PAFailure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…NTSB FTW90IA030Incident · No injuriesIncident investigationFinal reportSaab-Fairchild 340A · Beaumont, TXThe pilot failed to maintain adjusted vref and proper descent rates during the approach. The pilot delayed decision to execute a go-around and the copilot failed to monitor the poorly flown approach. Contributing to the accident was the rain and wind shear…NTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.NTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.NTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.NTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…NTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB DCA90MA005Accident · 20 fatalClass 1 · MajorFinal reportDe Havilland DHC-6-300 · Halawa,Molokai, HIThe airplane's controlled flight into terrain as a result of the decision of the captain to continue flight under visual flight rules at night into instrument meteorological conditions (IMC), which obscured rising mountainous terrain. Contributing to the…NTSB FTW90FA018Accident · 2 fatalField investigationFinal reportCessna TR182 · Crane, TXThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his loss of aircraft control, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument…NTSB LAX90FA016Accident · 3 fatalField investigationFinal reportCessna 177 · So Lake Tahoe, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions.NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.NTSB SEA90LA008Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Salmon, IDFailure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.NTSB ATL90LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Kernersville, NCImproper fuel consumption calculations by the pilot, which resulted in fuel exhaustion from lack of fuel. Adverse weather conditions were related to the accident.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 NYC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Palmyra, NYThe pilot failed to maintain airspeed during a tight closed pattern turn to final. Contributing factor(s) was: the pilot initiating flight into known adverse weather conditions, which included fog and reduced visibility.NTSB SEA90FA005Accident · 1 fatalField investigationFinal reportHughes 369D · Bothell, WAThe pilot failed to determine weather conditions before the flight, his attempt to fly VFR in IMC, and his failure to maintain obstacle clearance altitude. Factors in the accident were the low ceiling, rain and fog weather conditions.NTSB DEN90FA002Accident · 1 fatalField investigationFinal reportCessna 182A · Nixon, NVContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Inadequate preflight preflight planning/preparation by the pilot, and the…NTSB SEA90FA002Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Cougar, WAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.NTSB ATL90LA002Accident · No injuriesLimited investigationFinal reportBeech V35B · Colquitt, GAThe pilot's failure to obtain current enroute weather information for his destination resulting in his flying VMC into IMC conditions which resulted in his collision with powerlines while making a precautionary landing on a road.NTSB SEA89FA182Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Bridal Veil, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the adverse weather conditions, the pilot's lack of instrument experience,…NTSB MKC89FA202Accident · No injuriesField investigationFinal reportFokker F27 · Bemidji, MNThe pilot's failure to maintain a proper descent rate and compensate for the downdraft encountered while on short final approach.NTSB ANC89LA178Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Shotgun Hills, AKThe pilot's failure to adequately evaluate the existing weather conditions and to maintain control of the aircraft. Contributing to the accident was the pilot's overconfidence in both personal ability and the ability of the aircraft along with the downdraft…NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB FTW89FA172Accident · 1 fatalField investigationFinal reportCessna 210D · Covington, LAThe pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.NTSB ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB CHI89LA193Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Medina, OHThe pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…NTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.NTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.NTSB NYC89LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Montague, NJImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.NTSB LAX89FA319Accident · 2 fatalField investigationFinal reportCessna 310K · Ojai, CAThe pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…NTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.NTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.NTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB LAX89LA313Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mammoth Lakes, CAThe pilot's improper compensation for the existing wind condition and his failure to maintain airspeed. Factors that related to the accident were: the gusty & cross-winds and high density altitude.NTSB DEN89FA218Accident · 2 fatalField investigationFinal reportCessna 310I · Hesperia, CAThe non-instrument rated pilot continued VFR flight into instrument meteorological conditions (IMC) and misjudged his altitude above the terrain. Contributing factors were: the pilot's lack of instrument experience, pressure induced by his wife (the…NTSB MIA89LA251Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yulee, FLImproper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.NTSB LAX89FA304Accident · 2 fatalField investigationFinal reportRockwell 112B · La Grange, CAContinued VFR flight into instrument meteorlogical conditions (IMC) by the pilot, which resulted in spatial disorientation and loss of aircraft control. Related factors were: flight into known adverse weather by the pilot, the adverse weather conditions, and…NTSB SEA89LA173Accident · 1 fatalLimited investigationFinal reportMiller Special JM-2 · Reno, NVStructural failure when design stress limits were exceeded after encountering hazardous meteorological conditions.NTSB DEN89LA224Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Monument Valley, UTThe pilot's failure to adequately compensate for windshear.NTSB NYC89LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sanbornton, NHVFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.NTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.NTSB NYC89FA204Accident · 1 fatalField investigationFinal reportCessna U206F · West Point, NYContinued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…