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 ANC04LA010Accident · No injuriesLimited investigationFinal reportdeHAVILLAND DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his failure to maintain adequate altitude/clearance, which resulted in a collision with terrain during the final landing approach. A factor contributing to the accident was the presence of a…NTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.NTSB FTW04FA024Accident · Serious injuriesField investigationFinal reportCessna 550 · Mineral Wells, TXThe pilot-in-command's failure to maintain control of the airplane while executing a simulated engine failure on final approach. A factor was the windshear.NTSB FTW04FA022Accident · 1 fatalField investigationFinal reportCessna 210M · Tolar, TXThe pilot's improper pre-flight planning and loss of engine power for undetermined reasons. A factor was the fog.NTSB LAX04LA041Accident · 2 fatalLimited investigationFinal reportDaughters T18C · Needles, CAthe pilot's continuation of a visual flight rules (VFR) flight into an area of adverse weather, which resulted in an encounter with moderate to severe turbulence and in-flight breakup of the airplane.NTSB NYC04LA024Accident · 1 fatalLimited investigationFinal reportCessna 150H · Bruceton Mills, WVThe pilot's physical impairment due to alcohol and his improper decision to attempt flight with a low cloud ceiling, low visibility, after consuming alcohol. A related factor in the accident was the low cloud ceiling.NTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.NTSB DEN04LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Denver, COthe in-flight encounter with heavy to moderate turbulence.NTSB LAX04FA031Accident · 5 fatalField investigationFinal reportCessna 421B · Kelso, CAThe pilot's continued VFR flight into instrument conditions between cloud layers and with reduced visibility due to smoke that resulted in an in-flight loss of control from spatial disorientation, and the structural overload of the airframe during the…NTSB LAX04LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Murrieta, CAThe pilot's inadequate evaluation of the weather which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Fog and rising terrain were contributing factors.NTSB FTW04FA007Accident · 3 fatalField investigationFinal reportBell 206L-3 · W. Cameron 509The pilot's loss of control following an inadvertent encounter with adverse weather conditions. Contributing factors were the prevailing thunderstorms, the low ceilings, and the miscommunication between the pilot and the company's communication center in…NTSB FTW04LA004Accident · 2 fatalLimited investigationFinal reportColliander RV-8 · Van, TXThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors were the low ceilings, rain, and fog.NTSB LAX04FA002Accident · 2 fatalField investigationFinal reportLockheed P2V · East Highlands, CAthe pilot's inadequate in-flight planning/decision and continued flight into instrument meteorological conditions that resulted in controlled flight into mountainous terrain.NTSB DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…NTSB CHI03LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chanute, KSThe pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…NTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.NTSB LAX03LA297Accident · No injuriesLimited investigationFinal reportEurocopter France AS 350 BA · Hilo, HIthe pilot's inadvertent encounter with instrument meteorological conditions and his failure to maintain aircraft control. Contributing factors were fog, rough/uneven terrain, and spatial disorientation.NTSB LAX03LA276Accident · No injuriesLimited investigationFinal reportMooney M20K · Novato, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions during the dark early morning takeoff, which resulted in spatial disorientation and lead to a collision with trees off the departure end of the runway.NTSB ANC03FA106Accident · 3 fatalField investigationFinal reportCessna T206H · Chickaloon, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with mountainous terrain while maneuvering. Factors contributing to the accident were weather conditions consisting of clouds/mist and low ceilings, and the…NTSB LAX03LA271Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Watsonville, CAthe non-instrument rated pilot's intentional continuance of VFR flight into instrument meteorological conditions and failure to maintain clearance with terrain.NTSB ATL03LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hendersonville, NCThe pilot's inadequate evaluation of the weather. The downdraft was a contributing factor.NTSB FTW03LA209Accident · No injuriesLimited investigationFinal reportPilatus PC-6/C-H2 · Vigo Park, TXThe loss of propeller pitch control for undetermined reasons.NTSB LAX03FA282Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Encinitas, CAThe student pilot's spatial disorientation and inadvertent descent into the ocean while maneuvering to avoid inclement weather. Also causal was the flight instructor's inadequate supervision due to his improper approval of his student's preflight preparation…NTSB CHI03LA267Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Hammond, MNThe pilot exceeded the design limits of the wings when he pulled out of an inadvertent spiral after he lost control of the airplane while operating in IMC conditions. Additional factors included the pilot's flight from VMC to IMC conditions, the turbulence in…NTSB NYC03LA177Accident · Serious injuriesLimited investigationFinal reportBoeing 737-800 · Wooster, OHAn inadvertent encounter with turbulence during descent.NTSB NYC03CA179Accident · No injuriesData collectionFinal reportCessna 172RG · Glens Falls, NYThe pilot's failure to maintain control during the flare/touchdown, which resulted in a hard landing. Factors in this accident were wind gusts and the pilot's improper decision to land during thunderstorm activity.NTSB DEN03LA142Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-81 · Greeley, COthe inflight encounter with severe turbulence.NTSB FTW03LA195Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A340-300 · Walnut Ridge, ARThe flight crew's inadequate evaluation of the weather and their decision to continue the along the route of flight resulting in an encouter with severe turbulence. Contributing factors were the captain's instructions to continue food servicing in the cabin,…NTSB DEN03LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Crowheart, WYThe pilot's inadequate preflight planning (attempting to exceed aircraft's published certificated performance), the pilot not obtaining sufficient altitude to clear the terrain (not possible), and the pilot's inadequate in flight planning/decision making.…NTSB CHI03FA246Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Clarkfield, MNThe pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.NTSB MIA03LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Charlotte, NCThe pilot-in-command's failure to sufficiently deviate to avoid known weather, and his failure to activate the seatbelt sign to ensure flight attendants and passengers were seated, which resulted in a passenger receiving serious injuries when the flight…NTSB IAD03FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Galion, OHThe pilot's improper in-flight decision making and flight into known adverse weather conditions while maneuvering to land. Also causal was the pilot's failure to regard the pre-flight weather briefing. Factors were the thunderstorm, rain, wind gusts and hail.NTSB CHI03LA242Accident · 1 fatalLimited investigationFinal reportTeratorn · Elbow Lake, MNThe pilot's intentional flight into known fog and failure to maintain aircraft control during cruise flight. A factor was the fog, and the low altitude flight.NTSB LAX03FA241Accident · 5 fatalField investigationFinal reportBell 206B · Waialeale,Kauai, HIThe pilot's failure to maintain adequate terrain clearance/altitude while descending over mountainous terrain, and his continued flight into adverse weather. Factors contributing to the accident were clouds and a low ceiling.NTSB NYC03CA169Accident · Serious injuriesData collectionFinal reportBoeing 757-251 · Wadsworth, OHAn in-flight encounter with turbulence.NTSB CHI03LA237Accident · Serious injuriesLimited investigationFinal reportBoeing B777-222 · Chicago, ILThe turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.NTSB DEN03LA128Accident · 1 fatalLimited investigationFinal reportGrob G103 Twin Astir · Morgan, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's inadequate in-flight planning/decision to fly low over a mountain ridge. Contributing factors included the wind shear, altitude/clearance, and the…NTSB DEN03LA126Accident · Serious injuriesLimited investigationFinal reportNational Ballooning 858 · Louisville, COThe pilot's inability to control the balloon. Contributing factors include the high winds, the attempted remedial action by the pilot, the building, fence, and transmission wires.NTSB ANC03LA071Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Kotzebue, AKThe airplane encountered unforecast turbulence, which resulted in serious injury to the pilot.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 CHI03LA185Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Elk Mound, WIThe pilot's failure to maintain clearance from the terrain. Factors contributing to the accident were the whirlwind, the turbulence, and the helicopter's low altitude.NTSB CHI03FA179Accident · 1 fatalField investigationFinal reportEurocopter EC120B · Boonville, MOThe pilot's inadequate weather evaluation which resulted in his inadvertent flight into instrument meteorological conditions. An additional cause was the pilot's failure to maintain clearance from the terrain. The dark night, thunderstorms, rain and lack of…NTSB ANC03FA061Accident · 2 fatalField investigationFinal reportCessna 172 · Skagway, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Factors associated with the accident were low ceilings, rain, and fog.NTSB DEN03LA110Accident · No injuriesLimited investigationFinal reportAlexander Schleicher · Paragonah, UTThe pilot's encounter with unsuitable terrain during a precautionary landing. Contributing factors were the strong winds and the approaching vehicle.NTSB ATL03LA112Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW28 · Batesburg, SCThe loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.NTSB MIA03LA127Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Taylor, FLThe in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.NTSB ATL03FA125Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Dover, TNThe pilot continued VFR flight into adverse weather conditions including instrument meteorological conditions and turbulence in thunderstorms, which resulted in a loss of control in flight and subsequent collision with terrain.NTSB ANC03LA060Accident · No injuriesLimited investigationFinal reportLongren Centaur L-13 · Chickaloon, AKThe loss of engine power during the takeoff initial climb for an undetermined reason, which resulted in an in-flight collision with water.NTSB DEN03LA152Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Santa Fe, NMthe inadvertent encounter with turbulence associated with thunderstorms. A contributing factor was the icing conditions.NTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…