NTSB investigations, TX
49 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 3 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
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\" = 430)
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" = 430) 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 DFW06CA064Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawaokecie PZL-104 Wilga 80 · Comstock, TXThe pilot's inadequate preflight planning and preparation leading to him becoming lost. Contributing factors were the unfavorable winds and the lack of suitable terrain for a precautionary landing.NTSB DFW06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-225 · San Antonio, TXThe captain's improper decision to maneuver a transport category airplane in a confined and unapproved area with engine thrust, which resulted in ground damage and personal injury to an individual.NTSB DFW05LA047Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Austin, TXThe failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.NTSB FTW04CA205Accident · No injuriesData collectionFinal reportCessna 172N · Cleveland, TXThe student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.NTSB FTW04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172N · La Grange, TXThe pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.NTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.NTSB FTW02LA255Accident · No injuriesLimited investigationFinal reportCessna 182P · Kirbyville, TXThe pilot's physical impairment due to a previous head injury which resulted in his becoming disoriented. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW02LA088Accident · No injuriesLimited investigationFinal reportFokker F-28 MK-100 · Dallas, TXThe ground crew inadvertent application of deicing fluid in the auxiliary power unit resulting in an overspeed and turbine wheel burst. A contributing factor was the gusty wind.NTSB FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.NTSB FTW01LA086Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain rotor rpm, which resuted in the main rotor contacting the tail during landing.NTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.NTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.NTSB FTW99LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Panhandle, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.NTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.NTSB FTW99LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Tomball, TXThe pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.NTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.NTSB FTW98IA196Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-51 · Brownsville, TXThe flightcrew experienced physical impairment resulting from an accumulation in the cockpit of carbon dioxide fumes produced by dry ice, a hazardous material, carried in the main cargo compartment.NTSB FTW97IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Corpus Christi, TXThe flightcrew's inadequate in-flight planning and decision, and their failure to refer to the navaids needed for the instrument approach procedure. A factor was the lack of a minimum safe altitude warning from approach control.NTSB FTW96FA143Accident · 1 fatalField investigationFinal reportCessna 150 · Muleshoe, TXimproper planning/decision by the student pilot, and his failure to take adequate remedial action after becoming lost and encountering a low fuel situation, which subsequently resulted in fuel exhaustion, loss of engine power, and a forced landing at night.…NTSB FTW96LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Decatur, TXthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.NTSB FTW95IA148Incident · 1 fatalIncident investigationFinal reportDouglas DC-9-32 · Abilene, TXIncapacitation of the first officer due to a heart attack.NTSB FTW95LA103Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · Dallas, TXThe flight attendants' lack of supervision of deplaning passengers. A factor was lack of supervision by accident victims mother.NTSB FTW94LA056Accident · No injuriesLimited investigationFinal reportBeech 35 · Crystal Beach, TXWas a total loss of engine power for undetermined reasons. Factors were a passenger door inadvertently opening in flight due to inadequate preflight by the pilot, unsuitable terrain for the forced landing, and carburetor icing conditions.NTSB FTW93IA064Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-82 · Dfw Airport, TXThe inaccurate safety advisory provided by the tower operator. A factor was the emergency evacuationNTSB FTW93IA048Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120RT · Houston, TXThe assigned mechanic's failure to reinstall the attachment screws and the quality inspector's inadequate inspection of the completed work. A factor was the complacency of the maintenance personnel.NTSB FTW93LA001Accident · No injuriesLimited investigationFinal reportBeech D18S · Brookston, TXSmoke trailing from the left engine for an undetermined reason(s). Factors contributing to the accident were unsuitable terrain conditions.NTSB FTW91LA161Accident · Serious injuriesLimited investigationFinal reportBarnes AX 7 · Baytown, TXThe crewmembers improper posture during landing which led to a serious injury.NTSB FTW91LA110Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Addison, TXEntry door opening in flight, inadequate emergency procedures published by the manufacturer, and poor emergency training by the student's instructor. Factors were inadequate design/installation of the door locking mechanism, deteriorated airplane performance,…NTSB FTW91LA048Accident · 1 fatalLimited investigationFinal reportBell 206B II · High Island, TXFor occurrence #1 - inadequate supervision by the operator in launching a hazardous mission without an adequate sling/harness, the pilot's poor judgement in accepting and continuing the mission into low light conditions, and the crewmember's inadvertent…NTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.NTSB FTW89LA086Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Lampasas, TXThe pilot's failure to follow proper procedures and directives for the attempted operation. A factor was the undetermined status of the magnetos.NTSB FTW89DPA01Accident · Minor injuriesFinal reportShannon J-BIRD · Mckinney, TXThe plt rprtd he was making a high speed taxi test of his gyroplane after installation of a different eng & prop. He said the gyroplane enctrd a bump on the rwy which caused it to become airborne at about 35 mph (takeoff speed was 45 mph). He added power to…NTSB FTW88DRG11Accident · No injuriesFinal reportEnstrom F28A · Port Isabel, TXThe pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…NTSB FTW88LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10 · Dfw Airport, TXUnexpected opening of the IL door, which caught the passenger between it and the bulkhead as the door moved inward and upward. A secondary cause was the failure of the flight attendants to follow company procedures requiring them to guard all entry doors…NTSB FTW86LA132Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Dfw Airport, TXThe aircraft was in smooth air and in straight and level flight. The 'fasten seat belt' sign was illuminated. A male passenger went to the forward lavatory and fell, injuring his head and back. The floor was dry and there was no loose or torn carpet ot other…NTSB LAX86MA268Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Galveston, TXThe plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground…NTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…NTSB FTW85IA341Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Abilene, TXAa DC-10 enroute el paso, TX. To dfw arprt TX. Had fire warning #3 eng. Crew performed emerg. Proc. But lite remained on. Crew made emergency landing dyess afb Abilene, TX. Pax emer evac left side of a/c. aft slide L4 deflated during evac 1 pax received minor…NTSB FTW85LA046Accident · No injuriesLimited investigationFinal reportReed Bandit 1 · Amarillo, TXThe homebuilt acft, N52957, was observed to land hard, collapse the landing gear & slide into N3376V holding short of the rwy at an intersecting taxiway.NTSB FTW84LA327Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe pilot stated that after takeoff he did 3 touch and go landing then started a series of stalls. After entry into a cross-control spin to the left, he found that he could not apply enough right pedal to recover. Examination of the aircraft revealed that the…NTSB FTW84LA254Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Amarillo, TXDuring a pre-flt breifing, the wind was reported to be from 280 deg at 6 to 12 KTS. At launch time, the plt estimated the wind was blowing at 7 KTS. He took off at 0720 CDT without difficulty & climbed to about 1000 ft AGL. Aprx 1 hr after taking off, the plt…NTSB FTW84LA099Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Imperial, TXThe plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by…NTSB FTW83LA350Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kemah, TXThe plt had landed in a restaurant parking lot. When he was informed that a local ordinance had been passed prohibiting helicopter operations from restaurant parking lots & that the police had been called, he prepared to takeoff. As the plt was preparing to…NTSB FTW83LA049Accident · No injuriesLimited investigationFinal reportCessna 150H · Addison, TXPilot hand propped engine with aircraft cockpit unattended. Aircraft started taxiing and collided with another unattended aircraft parked on the ramp.NTSB FTW83LA033Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Austin, TXThe pilot penetrated the top of a cumulus cloud while climbing from 18000 to 20000 feet. A sharp jolt was felt and turbulence continued for 3-4 seconds. A stewardess fell and broke her ankle.NTSB FTW82DA264Accident · No injuriesFinal reportGlassflugel 604 · Refugio, TXThe pilot accidently released the tow line at about 50 feet AGL when his parachute caught on the tow release handle. In attempting to turn to the runway, he dragged a wing. The glider fuselage broke aft of the cockpit.NTSB FTW82DA183Accident · No injuriesFinal reportChampion 7EC · Southlake, TXDuring takeoff, the private pilot sitting in the front seat, thought the cowling was loose. The pilot informed the owner and commercial pilot in the rear seat who took control and decided to return to the airport. The pilot landed short of the runway and the…NTSB FTW82DA163Accident · No injuriesFinal reportCessna TU-206A · Rachal, TXThe aircraft wreckage was found by a rancher on may 1, 1982. The date of accident and circumstances could not be determined. The accident reporting forms sent to the registered owner were returned undelivered. Dea found 340 lb. Of marijuana on board the…