NTSB investigations, TX
220 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 20 |
|---|---|
| 1983 | 19 |
| 1984 | 21 |
| 1985 | 13 |
| 1986 | 13 |
| 1987 | 14 |
| 1988 | 5 |
| 1989 | 13 |
| 1990 | 9 |
| 1991 | 7 |
| 1992 | 7 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 8 |
| 1996 | 7 |
| 1997 | 1 |
| 1998 | 8 |
| 1999 | 4 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 8 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND 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 DFW07LA102Accident · 1 fatalLimited investigationFinal reportWalker Zenith Zodiac 601 XL · Canadian, TXThe pilot's improper pre-flight planning and decision to depart into deteriorating weather conditions, which resulted in a loss of control and subsequent in-flight break up.NTSB DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.NTSB DFW06CA161Accident · No injuriesData collectionFinal reportLindstrand Balloons 105A · Frisco, TXThe pilot's failure to maintain the proper glidepath while landing. Contributing factors were the prevailing high winds and the downdraft encountered on final approach.NTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.NTSB DFW06LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 777-233ER · DFW Int'l Apt, TXThe in-flight encounter with turbulence in clouds resulting in a flight attendant being injured.NTSB DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.NTSB DFW05CA211Accident · No injuriesData collectionFinal reportSchleicher ASW-27b · Encinal, TXThe pilot's misjudgment of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB DFW05CA096Accident · No injuriesData collectionFinal reportGlaser-Dirks DG 600 · Kent, TXThe pilot's misjudgement of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB DFW05FA052Accident · 1 fatalField investigationFinal reportCessna 150M · Coleman, TXThe pilot's inadequate in-flight planning/decision by his VFR flight into IMC which resulted in his failure to maintain aircraft control. Contributing factors were fog and the pilot's inadequate preflight preparation.NTSB DFW05CA004Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-26E · El Paso, TXThe pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB FTW05CA001Accident · Minor injuriesData collectionFinal reportAerostar S-60A · Austin, TXThe pilot's excessive descent rate during the execution of a high wind landing, resulting in a hard landing. A factor was the high wind.NTSB FTW04FA208Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burnet, TXThe pilot's continued flight into known adverse weather, VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. A contributing factor was the cloudy weather.NTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.NTSB FTW04FA097Accident · 4 fatalField investigationFinal reportBell 407 · Pyote, TXThe pilot's inadvertent encounter with adverse weather, which resulted in the pilot failing to maintain terrain clearance. Contributing factors were the dark night conditions, the pilot's inadequate preflight preparation and planning, and the pressure to…NTSB FTW04LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Sugar Land, TXThe pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW04FA079Accident · 1 fatalField investigationFinal reportCessna 210N · Valley Spring, TXThe pilot's continued flight into known adverse weather and failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation.NTSB FTW04FA052Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe failure of flight/navigation instruments while in instrument meteorological conditions (in-cloud flight and low ceilings) resulting in spatial disorientation. A contributing factors was the prevaling instrument meteorological conditions (low ceiling and…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 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 FTW03LA209Accident · No injuriesLimited investigationFinal reportPilatus PC-6/C-H2 · Vigo Park, TXThe loss of propeller pitch control for undetermined reasons.NTSB LAX03LA193Accident · Serious injuriesLimited investigationFinal reportBoeing MD-82 · Fort Worth, TXThe encounter with severe turbulence during descent, prior to the cabin crew taking their seats, which resulted in serious injury to two flight attendants.NTSB FTW03LA121Accident · Serious injuriesLimited investigationFinal reportBoeing 737-924 · Palestine, TXThe airplane's encounter with unforecasted clear air turbulence during cruise flight.NTSB FTW03LA112Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-B3 · Clyde, TXthe pilot's delayed remedial action and his continued flight into known adverse weather conditions. A contributing factor was the excessive descent rate which resulted in a hard landing.NTSB FTW03FA089Accident · Serious injuriesField investigationFinal reportCessna 208B · San Angelo, TXThe flight crew's failure to cycle the deice boots prior to conducting a simulated forced landing and their failure to maintain adequate airspeed during the maneuver, which resulted in an inadvertent stall and subsequent loss of control. A contributing factor…NTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.NTSB FTW02CA206Accident · Serious injuriesData collectionFinal reportAero Commander Callair A-9B · El Paso, TXthe loss of control due to the encounter with the dust devil.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…NTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.NTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.NTSB FTW02FA005Accident · 1 fatalField investigationFinal reportCessna 150G · Sargent, TXthe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall. Contributing factors were the pilot's flight into known adverse weather, his self-induced pressure to complete the flight and the thunderstorm.NTSB FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…NTSB FTW01FA069Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Borger, TXthe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain obstacle clearance. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing and the dark night conditions.NTSB FTW01LA041Accident · No injuriesLimited investigationFinal reportBeech BE-60 · Addison, TXThe pilot's misjudged flare of the airplane resulting from restricted forward visibility. Factors were the pilot's continued flight into known adverse weather conditions, the icing conditions, and the iced windshield.NTSB FTW01FA021Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Houston, TXthe pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.NTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.NTSB FTW00LA225Accident · Minor injuriesLimited investigationFinal reportBrown/Morrison Rans S-12 · Bonham, TXThe pilot's failure to maintain control of the airplane while maneuvering to return to the airport. Factors were the gusty wind conditions and the pilot's lack of experience.NTSB FTW00LA220Accident · No injuriesLimited investigationFinal reportAero Tek Zuni · Uvalde, TXThe pilot's inadvertent flight into adverse weather conditions which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate 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 FTW99LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Fabens, TXThe pilot's inadvertent flight into adverse weather conditions. A factor was the windshear weather conditions.NTSB FTW99LA166Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Pleasanton, TXThe pilot's inadvertent flight into adverse weather, which resulted in a loss of aircraft control. A factor was the whirl wind weather condition.NTSB FTW99FA121Accident · 1 fatalField investigationFinal reportCessna 182G · Blanco, TXThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain. Factors were, the low cloud and drizzle weather conditions, and the dark night light conditions.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 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 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.