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 NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.NTSB LAX92LA285Accident · No injuriesLimited investigationFinal reportSchweizer 1-36 · Hemet, CAThe pilot's inadvertent selection of unsuitable terrain for the precautionary landing. A factor in the accident was his failure to obtain a preflight weather briefing.NTSB MIA92LA122Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Boynton Beach, FLPremature extension of the spoilers by the pilot during approach to land. Contributing to the accident was his lack of total experience in the type of aircraft and in-flight encounter with a downdraft.NTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.NTSB MIA92LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Scottsmoor, FLEncounter with clear air turbulence during cruise flight.NTSB MIA92LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe pilot's inadequate compensation for wind conditions during the landing flare, in gusty winds.NTSB LAX92LA192Accident · No injuriesLimited investigationFinal reportLaister Nugget · Bishop, CAThe pilot-in-command's improperly planned no-flap landing approach; failure to follow the checklist; and inadvertent gear retraction. Factors contributing to the accident were the buckling of the wing skin, cracking of the fuselage and the inoperative flaps.NTSB LAX92LA190Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mammoth Lakes, CAThe pilot-in-command's inaccurate weather evaluation, his improper setting of the mixture control, and his failure to maintain proper climb airspeed. Factors related to the accident were: high density altitude, unfavorable wind with mountain wave activity and…NTSB ATL92FA091Accident · 1 fatalField investigationFinal reportCessna 310R · Gatlinburg, TNThe pilot's continued VFR flight into IMC, and his failure to attain a proper altitude over high, mountainous terrain. Factors were the high terrain, and the fog, clouds, and obscuration at the accident site.NTSB ATL92FA090Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Burnsville, NCThe pilot's failure to adequately evaluate the weather information and his continued visual flight into instrument conditions, which resulted in a collision with high terrain. A factor was the dark night.NTSB LAX92MA184Accident · 9 fatalClass 1 · MajorFinal reportBeech E18S · Mount Haleakala, HIThe captain's decision to continue visual flight into instrument meteorological conditions that obscured rising mountainous terrain and his failure to properly use available navigational information to remain clear of the island of maui. Contributing to the…NTSB MIA92FA112Accident · 1 fatalField investigationFinal reportNavion NAV-A · Monteverde, FLThe pilot's inadvertent flight into IMC conditions and subsequent loss of control of the airplane in flight.NTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB MIA92LA109Accident · Serious injuriesLimited investigationFinal reportStoltzfus Stileto MK II · Cross City, FLThe pilot-in-command's continued flight into adverse weather conditions resulting in a loss of control during a precautionary landing due to a loss of visual references. The weather was a factor.NTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.NTSB LAX92LA165Accident · No injuriesLimited investigationFinal reportRobinson R22B · Palm Springs, CAThe pilot's failure to maintain a proper cruise altitude upon entering a mountain pass area, and his failure to maintain control of the helicopter. Factors which contributed to the pilot's loss of control were related to his encountering turbulence and…NTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.NTSB ANC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kotzebue, AKPilot factor in that the proper glidepath and altitude was not maintained. Factors to the accident were: inattentiveness and snow.NTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.NTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…NTSB BFO92FA048Accident · 2 fatalField investigationFinal reportMooney M20M · Youngs Bottom, WVThe pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.NTSB ANC92LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Golovin, AKProper altitude was not maintained. Factors to the accident were: inadvertent VFR flight into IMC, fog, snow, and night.NTSB NYC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Medina, OHThe pilot's failure to maintain control of the airplane during landing. Contributing to the accident were strong winds.NTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.NTSB CHI92FA095Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Burlington, ILThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions in cruise flight. Related factors are the pilot's inadequate weather evaluation, the low ceiling and reduced visibility (fog).NTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.NTSB FTW92LA070Accident · No injuriesLimited investigationFinal reportBell 206L-3 · South Pelto #1The pilot's inability to control the helicopter due to spatial disorientation. Factors were the fog and the pilot's failure to receive a weather briefing prior to the flight.NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB SEA92FA046Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · West Glacier, MTThe inflight encounter with IMC weather by the non-instrument rated pilot. Factors relating to the accident were the weather conditions, the mountainous/hilly terrain, and lack of instrument qualification by the pilot.NTSB SEA92FA045Accident · 2 fatalField investigationFinal reportBell 206B · Wellington, UTThe pilot's continued flight into adverse weather conditions and an excessive rate of descent. Factors contributing to the accident were fog, rain, low ceilings, night conditions, snow covered terrain and pilot disorientation.NTSB MIA92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Smyrna Bch, FLImproper weather evaluation by the pilot in command resulting in the in flight encounter with fog during the downdwind leg shortly after takeoff to remain in the traffic pattern.NTSB SEA92LA044Accident · 2 fatalLimited investigationFinal reportLockheed P2V-7 · Dixon, WYThe pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…NTSB ANC92LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tununak, AKMisjudged wind information. Factors to the accident were: turbulence, crosswind and flight into known adverse weather.NTSB MIA92LA073Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Alpha · Juno Beach, FLImproper collective and cyclic control inputs and poor in-flight planning decision by the pilot-in-command.NTSB SEA92FA105Accident · 1 fatalField investigationFinal reportCessna 182R · Garrison, MTPoor inflight planning/decision. Factors to the accident were: icing conditions, dark night, flight into known adverse weather and an inadequate weather evaluation.NTSB MIA92FA067Accident · 2 fatalField investigationFinal reportCessna 402-C · Clewiston, FLPilot-in-command's improper inflight decision to attempt to descend and remain in VFR conditions in an area of thunderstorms and heavy rain. Contributing to the accident was the pilot-in-command's loss of control in flight.NTSB FTW92LA058Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Austin, TXThe pilot's failure to maintain proper altitude. Factors were the pilot descending below the minimum descent altitude and not performing the briefed missed approach procedure along with the dark night, fog, drizzle, and low ceiling.NTSB SEA92LA039Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Hansville, WAThe inadequate preflight preparation and improper inflight decision by the student pilot who was not qualified to conduct the flight. A factor relating to the accident was the adverse weather conditions.NTSB LAX92LA093Accident · 5 fatalLimited investigationFinal reportCessna 310Q · Honolulu, HIThe pilot's continuation of VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. Factors which contributed to the accident were: the adverse weather conditions and the pilot's failure to obtain…NTSB ATL92FA039Accident · 5 fatalField investigationFinal reportCessna 421C · Atlantic Ocean (Atlantic Ocean)The pilot's inadequate weather evaluation, and his continued flight into known adverse weather conditions. Factors were: the improper weather briefing by a flight service station specialist, and level iii thunderstorms.NTSB SEA92LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Hood River, ORPoor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.NTSB ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB ANC92FA022Accident · 1 fatalField investigationFinal reportCessna 207 · Mcgrath, AKThe pilot in command's improper inflight planning/decision and his attempt to fly VFR through IMC conditions. Factors contributing to the accident were the snow, whiteout conditions, and darkness.NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…NTSB NYC92FA047Accident · 1 fatalField investigationFinal reportPiper PA-23-235 · Fall River, MAThe pilot did not follow IFR proceedures and was manuvering at too low an altitude to remain clear of the terrain. Factors in the accident were; fatigue, fog and no visual ground clues.NTSB FTW92FA045Accident · 4 fatalField investigationFinal reportBeech C23 · Dewitt, ARThe pilot's attempt to land in IMC conditions and her subsequent loss of control during climb out due to spatial disorientation. A factor was the pilot's disregard of the pre-flight weather briefing.NTSB MIA92LA044Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Valdosta, GAThe pilot-in-command's improper in-flight decision to continue flight into deteriorating weather conditions. Contributing to the accident was the pilot's overconfidence in his personal ability to fly in instrument conditions.NTSB MIA92IA046Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · St. ThomasPilot-in-command's delayed remedial action to correct for a gust of wind during the landing flare.