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 LAX99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lytle Creek, CAthe pilot's inadvertent visual flight into instrument meteorological conditions resulting in impact with high terrain.NTSB ANC99LA036Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Girdwood, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.NTSB NYC99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Richmond, VAThe pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.NTSB NYC99LA069Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Atlantic City, NJUnanticipated in-flight turbulence.NTSB DEN99LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COThe pilot's failure to maintain directional control and inadvertently allowing the airplane to ground loop. Factors were gusty crosswind conditions, pertinent crosswind information not made available by the manufacturer, and FAA's inadequate certification and…NTSB NYC99LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Wolfeboro, NHThe pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.NTSB MIA99LA096Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stuart, FLThe inadequate touchdown resulting in a hard landing on the nose landing gear and subsequent structural damage.NTSB DEN99LA044Accident · No injuriesLimited investigationFinal reportParsons Kitfox II · Colorado Spgs, COThe airplane's encounter with a dust devil during landing.NTSB DEN99LA043Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Leadville, COThe pilot's in-flight decision to turn into rising terrain, and his decision to fly into and out of the airport in a heavy weight condition after the local flight instructor/FAA accident prevention counselor recommended that he should not. Factors were the…NTSB ANC99TA029Accident · Minor injuriesFinal reportBell 206L-1 · Barrow, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and the snow-covered terrain.NTSB LAX99FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Coalinga, CAthe pilot's inadvertant visual flight into instrument meteorological conditions.NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB IAD99LA030Accident · Minor injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Kutztown, PAwas the in-flight encounter with thermal sink over unsuitable terrain for landing.NTSB ATL99LA049Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Raleigh, NCThe flight encountered clear air turbulence while descending through 17,000 feet mean sea level (MSL).NTSB DEN99LA037Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Climax, COThe flight's encounter with turbulence.NTSB FTW99LA076Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Sabine Pass, TXThe pilot's inadvertent flight into instrument meteorological conditions and subsequent spatial disorientation. Factors were the dark night conditions, the fog, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB LAX99FA102Accident · 1 fatalField investigationFinal reportNorth American T-28B · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.NTSB SEA99IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 747-238B · Pacific Ocean (Pacific Ocean)An encounter with Clear Air Turbulence at Flight Level 330.NTSB LAX99FA077Accident · 4 fatalField investigationFinal reportBeech F35 · Chino, CAThe pilot's intentional flight into known instrument meteorological conditions in hilly terrain and his failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's inadequate evaluation of the weather conditions, dark night…NTSB CHI99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Charles, ILA loss of engine power due to fuel exhaustion. Also causal was the pilot's inadequate preflight/planning preparation which led to inadvertent flight into instrument meteorological conditions and him becoming lost/disoriented. Contributing to the accident were…NTSB ANC99LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's continued flight into adverse weather conditions. Factors associated with the accident were freezing rain, an accumulation of ice on the wings and ailerons, and diminished directional control.NTSB ANC99LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's attempted flight into adverse weather. Factors associated with the accident were the pilot's inadequate evaluation of the weather conditions, icing conditions, and an inadvertent stall.NTSB DEN99FA029Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · West Jordan, UTThe pilot's poor judgement by intentionally flying into instrument meteorological conditions without proper certification. Factors were the resulting spatial disorientation, the pilot's failure to maintain control of the aircraft, the in-flight wing…NTSB DEN99LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rollinsville, COThe pilot's inadequate decision to continue flight into deteriorating weather conditions, that included a downdraft which resulted in a loss of control, and collision with terrain. Contributing factors were the pilot's lack of familiarity with the terrain,…NTSB NYC99FA041Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Randolph, NHThe pilot's continued VFR flight into instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the aircraft which resulted in an in-flight separation.…NTSB SEA99LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Bellingham, WAInadequate preflight planning/preparation, and the pilot's failure to maintain altitude. VFR flight into IMC conditions and cloudy weather conditions were factors.NTSB DEN99LA026Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Granby, COThe in-flight encounter with clear air turbulence during descent.NTSB LAX99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Sacramento, CAThe failure of the second and third flight attendants to comply with instructions to remain seated in anticipation of turbulence.NTSB FTW99FA044Accident · 1 fatalField investigationFinal reportBeech 58 · Newcastle, OKthe pilot's loss of control due to his inadvertent encounter with severe turbulence and wind shear during an instrument approach. Factors contributing to the accident were the severe turbulence and the wind shear.NTSB ANC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Point Lay, AKFailure of the pilot to maintain a proper glidepath. Factors associated with this accident were the airport not having a VASI system installed, and the lack of visual perception for the pilot.NTSB FTW99FA038Accident · 1 fatalField investigationFinal reportBlanton RAF 2000 · The Colony, TXThe pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.NTSB FTW99FA033Accident · 2 fatalField investigationFinal reportCessna 172N · Bacliff, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.NTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.NTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB ATL99LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lima, SCThe flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.NTSB ATL99FA136Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Robbinsville, NC"This case was changed from ATL05FA014." The pilot's improper in-flight decision to continue VFR flight into IMC, which resulted in an in-flight encounter with weather and controlled flight into terrain. Factors were the pilot's inadequate preflight planning…NTSB MIA99LA015Accident · No injuriesLimited investigationFinal reportPeters Strojnik S2A · Pensacola, FLThe aircraft's uncontrolled climb after encountering a wind gust or thermal during landing flare without engine power resulting in the pilot having to force the aircraft onto the runway making a hard landing prior to the end of the runway.NTSB DEN99FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Buffalo, WYThe non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.NTSB FTW99LA012Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Eagle Pass, TXA downdraft, which exceeded the aircraft's climb performance. A factor was the thunderstorms in the vicinity of the airport.NTSB IAD99FA005Accident · 1 fatalField investigationFinal reportCessna R172K · Bowie, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.NTSB DEN99LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Jackson Hole, WYThe pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.NTSB FTW99FA004Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Newellton, LAThe pilot's failure to maintain aircraft control during an inadvertent entry into adverse weather conditions. A related factor was the fog.NTSB ANC99LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Russian Mission, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are rising terrain, and a downdraft.NTSB ANC98LA165Accident · Serious injuriesLimited investigationFinal reportMaule ML-7 · Wasilla, AKThe pilot's inadequate compensation for the wind conditions, resulting in an inadvertent stall. Contributing factors were the gusty and turbulent weather conditions.NTSB ANC98FA168Accident · 1 fatalField investigationFinal reportCessna TU-206G · Ketchikan, AKThe pilot's continued VFR flight into instrument meteorological conditions. Contributing factors were low ceilings and mountainous/hilly terrain.NTSB NYC98LA193Accident · Serious injuriesLimited investigationFinal reportBoeing DHC-8-102 · Islip, NYClear air turbulence.NTSB LAX98FA306Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Hawthorne, NVThe pilot's disregard of the weather briefing information and his decision to attempt flight into forecast adverse weather conditions, which led to an encounter with icing conditions beyond the performance capability of the aircraft. The pilot's disregard for…NTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.NTSB LAX98FA296Accident · 2 fatalField investigationFinal reportCessna 310K · Saugus, CAthe pilot's in-flight loss of control which led to a subsequent structural airframe failure as the pilot exceeded the design stress limits of the airplane during an attempted recovery.NTSB ANC98FA152Accident · 1 fatalField investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, mountainous/hilly terrain features, rain, and fog.