NTSB investigations, 2007, TX
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 397 |
| 1965 | 415 |
| 1966 | 429 |
| 1967 | 433 |
| 1968 | 360 |
| 1969 | 357 |
| 1970 | 330 |
| 1971 | 310 |
| 1972 | 260 |
| 1973 | 292 |
| 1974 | 318 |
| 1975 | 292 |
| 1976 | 312 |
| 1977 | 316 |
| 1978 | 276 |
| 1979 | 304 |
| 1980 | 293 |
| 1981 | 367 |
| 1982 | 295 |
| 1983 | 256 |
| 1984 | 255 |
| 1985 | 229 |
| 1986 | 185 |
| 1987 | 195 |
| 1988 | 153 |
| 1989 | 154 |
| 1990 | 143 |
| 1991 | 132 |
| 1992 | 130 |
| 1993 | 136 |
| 1994 | 119 |
| 1995 | 164 |
| 1996 | 141 |
| 1997 | 138 |
| 1998 | 141 |
| 1999 | 136 |
| 2000 | 140 |
| 2001 | 135 |
| 2002 | 119 |
| 2003 | 126 |
| 2004 | 137 |
| 2005 | 129 |
| 2006 | 108 |
| 2007 | 117 |
| 2008 | 125 |
| 2009 | 120 |
| 2010 | 127 |
| 2011 | 121 |
| 2012 | 126 |
| 2013 | 102 |
| 2014 | 120 |
| 2015 | 110 |
| 2016 | 126 |
| 2017 | 91 |
| 2018 | 119 |
| 2019 | 116 |
| 2020 | 116 |
| 2021 | 97 |
| 2022 | 118 |
| 2023 | 104 |
| 2024 | 101 |
| 2025 | 103 |
| 2026 | 91 |
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 year(c.\"eventDate\") = 2007
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2007 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB DFW08CA051Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot's failure to maintain aircraft control. A contributing factor was prevailing crosswind.NTSB DFW08CA049Accident · No injuriesData collectionFinal reportCessna 182 · Austin, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the gusting winds.NTSB DFW08CA048Accident · Minor injuriesData collectionFinal reportPortman RV-7A · ELmendorf, TXThe failure of the nose landing gear. A contributing factor was the mound/uneven runway surface.NTSB DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB DFW08CA041Accident · No injuriesData collectionFinal reportCessna 172P · Bridgeport, TXThe pilot's failure to maintain direction control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…NTSB ENG08IA002Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Greenville, TXA total loss of engine power due to the No. 2 engine experiencing a release of its fan spinner through the fan cowl as a result of an unidentified object striking the spinner, separating it from the fan disk and causing the spinner to be ingested into the fan…NTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.NTSB DFW08LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Sugar Land, TXThe collapsed of the nose landing gear due to shimmy as the result of the improper installation of the nose landing gear upper torque arm pin by the flight crew during the preflight inspection of the aircraft.NTSB DFW08LA029Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Midland, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the prevailing tailwind and an airport sign.NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB DFW08CA023Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arcola, TXThe loss of control as result of the pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the gusty crosswind.NTSB DFW08CA022Accident · No injuriesData collectionFinal reportAeronca 7AC · Fort Worth, TXThe pilot's failure to maintain direction control. A contributing factor was the tailwind.NTSB DFW08LA035Accident · No injuriesLimited investigationFinal reportAyres S2-R · Lenora, TXThe loss of engine power due to separation of the "P3" line from the engine's fuel control.NTSB DFW08LA020Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Catarina, TXThe loss of control due to the pilot's failure to maintain clearance with trees while hovering . A contributing factor was the low altitude.NTSB DFW08CA033Accident · No injuriesData collectionFinal reportCessna 172R · Lufkin, TXThe pilot's improper recovery from a bounced landing.NTSB DFW08CA016Accident · No injuriesData collectionFinal reportWard RC 350 HP · Magnolia, TXThe in-flight fire and loss of engine power as a result of a ruptured fuel line for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Houston, TXThe pilot's failure to properly position the fuel tank selector before takeoff. Contributing to the accident were the non suitable terrain for the forced landing and fuel starvation.NTSB DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB DFW08CA007Accident · No injuriesData collectionFinal reportCessna 172R · New Braunfels, TXThe pilot's improper recovery from a bounced landing.NTSB DFW08CA014Accident · No injuriesData collectionFinal reportAir Tractor 402B · Taft, TXThe pilot's failure to maintain control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.NTSB DFW08IA002Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron 206L-1 · Galveston, TXThe loss of tail rotor control during initial takeoff climb due to the fracture of a tail rotor blade as result of impact with a foreign object.NTSB DFW08LA001Accident · Serious injuriesLimited investigationFinal reportIndus T211 Thorpedo · Denton, TXThe pilot's improper preflight planning and preparation which led to his getting lost on a local area flight and his failure to maintain clearance from the trees. Contributing to the accident were the prevailing dark night illumination and the pilot's lack of…NTSB DFW07IA212Incident · No injuriesIncident investigationFinal reportSchweizer 269D · Houston, TXThe fatigue failure during hover of the drive adapter between the engine and lower pulley drive shaft.NTSB DFW07CA211Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Navasota, TXThe hard landing as result of the pilot's improper landing flare.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.NTSB DFW07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Floydada, TXA leak in the outer ply of the BeCu bellows. This hole appeared to be the result of pitting corrosion, but the corroding agent was not determined.NTSB DFW07LA197Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Fort Stockton, TXThe failure of the v-belt drive system to the main rotor for undetermined reasons. Contributing to the accident was insufficient altitude to perform a successful autorotation.NTSB DFW07IA204Incident · No injuriesIncident investigationFinal reportMooney M20TN · Kerrville, TXThe incorrect wire labeling, resulting in the trim controls operating in the opposite direction of the pilot's input.NTSB DFW07CA195Accident · No injuriesData collectionFinal reportCessna 140 · Lubbock, TXThe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.NTSB DFW07LA191Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Borger, TXA loss of engine power while on approach due to fuel starvation. Contributing to the accident were a corroded carburetor fuel needle valve, inlet fuel screen and no suitable terrain for the forced landing.NTSB DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB DFW07CA186Accident · No injuriesData collectionFinal reportEurocopter Deutschland BK117 · Slaton, TXThe pilot's failure to maintain control of the hovering helicopter and the flight instructor's improper supervision of the flight.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB DFW07CA175Accident · Minor injuriesData collectionFinal reportMellema Bede 4 · Ennis, TXThe pilot's inability to maintain control of the airplane following the disconnect of the tailwheel steering chain while landing.NTSB DFW07LA173Accident · Serious injuriesLimited investigationFinal reportBell 206B · Grand Prairie, TXThe loss of engine power as result of the failure of one or more of the compressor blades for the 5th stage compressor for undetermined reasons. A contributing factor was the lack of suitable terrain for the pilot to execute a successful autorotation.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.NTSB DFW07CA177Accident · No injuriesData collectionFinal reportAeronca Champion · Kirbyville, TXThe pilot's inability to maintain directional control during takeoff roll as result of the failure of the airplane's tailwheel's steering arm.