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 NYC00LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Renick, WVThe pilot's improper weather evaluation, and subsequent improper decision to fly into forecast and known icing conditions that exceeded the capability of the airplane to maintain flight. A factor was the icing conditions.NTSB MIA00LA119Accident · Minor injuriesLimited investigationFinal reportBair Helicopters Searey · Kill Devil Hill, NCThe inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.NTSB LAX00LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Corona, CAThe pilot's inadequate weather evaluation, and his improper remedial actions that led to a precautionary landing and subsequent attempted takeoff from unsuitable terrain.NTSB DEN00LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Hanksville, UTThe pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…NTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.NTSB IAD00LA025Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Blairstown, NJthe encountering of wind conditions in flight that inhibited the pilot from maintaining altitude.NTSB DEN00FA053Accident · 1 fatalField investigationFinal reportCessna 182E · El Prado, NMThe pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…NTSB CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.NTSB LAX00LA098Accident · Serious injuriesLimited investigationFinal reportFokker FK-28-4000 · Red Bluff, CAthe failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.NTSB LAX00FA099Accident · 2 fatalField investigationFinal reportCessna 182L · Coulterville, CAThe pilot's attempted flight into known adverse weather after receiving hazardous weather advisories, which resulted in inadvertent flight into instrument meteorological conditions while attempting to maintain VFR conditions on top. The subsequent…NTSB MIA00FA090Accident · 1 fatalField investigationFinal reportBeech 35-P35 · Dayton, TNthe non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.NTSB ANC00LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-T3 · Wales, AKThe pilot's inadequate evaluation of the weather conditions, and his inadvertent flight into adverse weather conditions. Factors in the accident were terrain induced turbulence and a tailwind.NTSB LAX00FA090Accident · 1 fatalField investigationFinal reportCessna 150J · Redwood City, CAThe pilot's inadequate weather evaluation and continued visual flight into instrument meteorological conditions. Factors were the pilot's improper remedial action and his self-induced pressure.NTSB ANC00FA024Accident · 6 fatalField investigationFinal reportCessna U206G · Iliamna, AKThe pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.NTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB FTW00LA084Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Dallas, TXThe diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.NTSB DEN00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Tooele, UTThe pilot's failure to correct the descent, and his failure to maintain a visual lookout. Factors were the pilot's improper weather evaluation, his lack of recent experience in type of operation, his inadvertent encounter with instrument meteorological…NTSB LAX00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Las Vegas, NVEncounter with Clear Air Turbulence. Poor communication between the captain and flight attendants as to the urgency for the flight attendants to take their seats was a contributing factor.NTSB LAX00GA073Accident · 2 fatalFinal reportArrow OH-58A · Crows Landing, CAThe failure of the pilot to maintain altitude and clearance from terrain during a turn to reverse direction after encountering instrument meteorological conditions. A factor in the accident was the pilot's failure to obtain a full weather briefing before…NTSB DEN00LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntsville, UTThe snow shower, and the lack of suitable terrain for the precautionary landing.NTSB ATL00FA019Accident · 2 fatalField investigationFinal reportBellanca BL-17-30A · Monteagle, TNThe pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB DEN00LA031Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · San Luis, COThe pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.NTSB ATL00LA018Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Adjuntas, PRThe pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.NTSB MIA00FA058Accident · 2 fatalField investigationFinal reportAero Commander 500 · Georgetown, SCThe noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…NTSB ANC00FA018Accident · 6 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.NTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.NTSB MIA00LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Defuniak Spgs, FLWas the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.NTSB ANC00LA013Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Palmer, AKThe pilot's intentional takeoff into known adverse weather. Factors associated with this accident are crosswinds, gusts, and downdrafts.NTSB DEN00FA135Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Lake City, COthe pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…NTSB FTW00LA026Accident · No injuriesLimited investigationFinal reportWaco KNF · Midway, ARThe inability of the pilot to maintain control of the airplane as a result of a downdraft.NTSB ANC00LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Russian Mission, AKThe pilot's continued flight into adverse weather, and an inadvertent stall. Factors in the accident were adverse weather consisting of icing conditions, and airframe icing.NTSB ANC00LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…NTSB ANC00LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Seward, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were a crosswind, and a downdraft.NTSB LAX00FA017Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAthe pilot's continued VFR flight into IMC. Contributing factors were the pilot's self induced pressure to depart the airport before the weather worsened and the airport closed, and the mountain obscurement and foggy weather conditions, and the night light…NTSB LAX00LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waialua, HIThe pilot's delay in recognizing the onset of a wind direction change resulting in the downward flow of wind on the leeward side of the mountain (strong sink rate).NTSB DEN00LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · La Junta, COThe pilot-in-command's failure to maintain a proper altitude during final approach to landing, and his misjudgment of altitude clearances. Factors were the sudden windshift, downdraft and turbulent weather conditions, the dark night, and the pilot's lack of…NTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.NTSB ANC99LA149Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a windshear, and a short runway area.NTSB ANC99LA147Accident · No injuriesLimited investigationFinal reportCessna 185F · Pilot Point, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the pilot's inadequate evaluation of the weather conditions, a downdraft, and swampy terrain.NTSB SEA99LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Eatonville, WAInadequate inflight planning/preparation and terrain clearance not maintained. Mountainous terrain, cloudy conditions and delayed remedial action are factorsNTSB LAX99LA323Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Beatty, NVthe failure of the injured passengers to remain seated with their seat belts fastened as directed by the captain.NTSB ANC99FA139Accident · Serious injuriesField investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's continued flight into instrument meteorological conditions (IMC), and inadequate altitude/clearance. Factors associated with the accident were flat light and whiteout conditions, snow, and snow-covered terrain. An additional factor was the FAA's…NTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.NTSB DEN99LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Peyton, COThe pilot's loss of control resulting in inadvertent stall/mush during initial climb following takeoff. Factors were the unfavorable, sudden windshift conditions, the high density altitude, and the manufacturer's failure to provide adequate density altitude…NTSB LAX99LA288Accident · Minor injuriesLimited investigationFinal reportWirth Avid Flyer · Schellville, CAThe pilot's encounter with wind shear and a downdraft which precipitated his loss of airplane control.NTSB SEA99FA150Accident · 4 fatalField investigationFinal reportCessna 182E · Ryegate, MTThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from mountainous terrain. Factors include low ceilings and inadequate in-flight planning.NTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB LAX99LA285Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe pilot's encounter with a sudden and violent dust devil, which caused the student pilot to lose control of the aircraft during the landing flare/touchdown.NTSB ANC99LA123Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Wasilla, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a downdraft.