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 MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…NTSB FTW96LA187Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Carlsbad, NMThe pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the sudden windshift and/or windshear.NTSB CHI96IA145Incident · Minor injuriesIncident investigationFinal reportBoeing 727-222A · Chicago, ILa passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.NTSB FTW96LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Columbus, TXthe pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…NTSB MIA96LA123Accident · Serious injuriesLimited investigationFinal reportVernon L. Cox COX-HAWK · Mebane, NCThe pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…NTSB CHI96FA139Accident · 1 fatalField investigationFinal reportCessna 150F · Mackinac Island, MIthe student pilot iniating VFR flight into instrument meteorological conditions which led to a loss of aircraft control. A factor was the fog.NTSB ANC96LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKfailure of the pilot to maintain sufficient altitude/clearance above terrain, after becoming spatially disoriented, while maneuvering after takeoff. Factors relating to the accident were: fog, snow, partial obscuration, 'flat' conditions of light, and the…NTSB NYC96FA085Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Granville, OHthe pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…NTSB MIA96LA119Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Portland, TNDelay by the pilot-in-command to perform a go-around after the airplane bounced three times during the landing attempt. Contributing to the accident was the failure of the pilot to obtain a preflight weather briefing and his poor in-flight planning decision…NTSB IAD96LA063Accident · 2 fatalLimited investigationFinal reportGlasair GL20 · Rocky Mount, VAthe pilot's continued flight into adverse weather conditions which led to airframe ice and a loss of control. Related factors were: the failure of the FSS briefer to advise the pilot of a valid AIRMET regarding icing conditions, the icing conditions, and…NTSB FTW96LA171Accident · 1 fatalLimited investigationFinal reportCessna U206G · Venice, LAthe pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.NTSB IAD96LA058Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlantic Ocean (Atlantic Ocean)the in-flight encounter with unforecast, unexpected turbulence.NTSB CHI96FA120Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lincoln, KSthe pilot became spatially disoriented and failed to maintain control of the airplane. The factors involved were the pilot encountered VFR flight into IMC, pressure induced by conditions/events, low ceilings, and the dark light conditions.NTSB MIA96LA106Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Defuniak Spring, FLThe pilot's inadvertent flight into instrument meteorological conditions, and inadvertent descent, due to spatial disorientation, which resulted in a collision with trees. Factors relating to the accident were: the adverse weather conditions and the pilot's…NTSB LAX96LA144Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Hollister, CAthe pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.NTSB FTW96LA157Accident · Serious injuriesLimited investigationFinal reportBoeing B-757-222 · Taos, NMan encounter with unforecasted clear air turbulence.NTSB MIA96LA101Accident · No injuriesLimited investigationFinal reportSummerfeldt Thorp T-18 · Hampton, SCThe pilot's improper planning/decision and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: the pilot's failure to use a preflight briefing service, the adverse weather conditions, and soft terrain in the…NTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.NTSB SEA96LA068Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Point Of Rocks, WYthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control due to spatial disorientation. Factors relating to the accident were: the low ceiling and snow.NTSB NYC96LA071Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Philadelphia, PAthe pilot's improper planning/decision, and his resultant flight into known icing conditions, which resulted in ice accumulation, loss of engine power, a forced landing, and subsequent collision with a residence and a vehicle. A factor relating to the…NTSB ATL96LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Livingston, TNFailure of the pilot to see-and-avoid obstructions (electrical lines), while on final approach to land after encountering icing conditions and diverting to a new destination (alternate airport).NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.NTSB ANC96LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Nome, AKthe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.NTSB LAX96FA121Accident · 3 fatalField investigationFinal reportCessna 172D · Julian, CAthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.NTSB IAD96IA048Incident · Minor injuriesIncident investigationFinal reportBoeing 767-2B7 · Pittsburgh, PAthe in-flight encounter with unforecast turbulence.NTSB CHI96FA094Accident · 2 fatalField investigationFinal reportCessna 182 · Odell, ILVFR flight by the pilot into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, probably due to spatial disorientation of the pilot. Factors relating to the accident were: darkness, reduced visibility due to the weather…NTSB FTW96FA113Accident · 1 fatalField investigationFinal reportCessna 150 · Galveston, TXthe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his failure to sufficient altitude. Factors relating to the accident were: darkness, foggy weather conditions, the pilot's lack of instrument experience, his lack of recent…NTSB SEA96LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Heber City, UTthe pilot's attempted VFR flight into IMC, and his failure to maintain adequate altitude and clearance from terrain during the landing flare. Factors contributing to the accident were the snowbank, fog, and the pilot's complacent attitude.NTSB FTW96LA107Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Bernal, NMthe pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…NTSB FTW96FA100Accident · 4 fatalField investigationFinal reportBeech 58 · Atkins, ARContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…NTSB MIA96LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Smithville, TNThe pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…NTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…NTSB MIA96FA064Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)the turbulence and failure of the passengers to have their seat belts fastened. A factor relating to this accident was: the failure of the aircraft operator to advise the flight crew of forecast active intensifying thunderstorm conditions in the area of the…NTSB SEA96MA043Accident · 8 fatalMajor investigationFinal reportMitsubishi MU-2B-36 · Malad City, IDcontinued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…NTSB IAD96LA109Accident · 1 fatalLimited investigationFinal reportMooney M20F · Cape Charles, VAThe pilot's improper in-flight planning/decision making by continuing flight into known adverse weather conditions. Related factors were the dark night and the winter storm (snow and fog).NTSB SEA96FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Lehi, UTcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: darkness, low ceiling, and snow.NTSB LAX96LA090Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Honolulu, HIthe flight attendant's decision to leave her seat in an area of forecast and known moderate turbulence. The turbulence was a related factor.NTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB MIA96FA048Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Memphis, TNthe pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.NTSB MIA96LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryceville, FLThe pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.NTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…NTSB MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.NTSB FTW96FA071Accident · 2 fatalField investigationFinal reportCessna 150M · S Padre Island, TXVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the surface of the water. Factors relating to the accident were: the adverse weather conditions (low ceiling and…NTSB CHI96FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Steuben, WIfailure of the pilot to select alternate air. Darkness and snowy weather conditions were related factors.NTSB CHI96FA049Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Parker, KSthe pilot's impairment of judgment and performance due to a drug (cocaine); his improper in-flight decision to continue flight over an overcast condition and then to descend into instrument meteorological conditions (IMC); his failure to maintain control of…NTSB ANC96LA022Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Delta Junction, AKThe pilot's inadequate preflight preparation/planning, and his improper in flight decision making. Factors associated with the accident are the gusty crosswinds and associated turbulence.NTSB NYC96LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerset, PAthe pilot's improper planning/decision and use of unsuitable terrain for a precautionary landing, which resulted in a collision with an embankment and subsequent nose over of the airplane. Factors relating to the accident were: the adverse weather conditions,…NTSB NYC96FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Rush Township, PAthe pilot's continued flight into adverse weather conditions which resulted in becoming lost and disorientated and subsequent impact with rising terrain. Factors in this accident were fog and a dark night.NTSB CHI96LA039Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Stevens Point, WIflying into known icing conditions and descending below the minimum descent altitude.NTSB SEA96LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 737-522 · Portland, ORAn unexpected encounter with unforecast moderate high level windshear and turbulence as the flight attendant was performing his duties during descent.