NTSB investigations, TX
200 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 16 |
| 2010 | 19 |
| 2011 | 15 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 15 |
| 2015 | 14 |
| 2016 | 8 |
| 2017 | 14 |
| 2018 | 12 |
| 2019 | 16 |
| 2020 | 11 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 1 |
| 2025 | 2 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 CEN25LA352Accident · Minor injuriesClass 4 · LimitedFinal reportGlasair GlaStar · Hearne, TXThe inflight engine compartment fire for reasons that could not be determined.NTSB CEN25LA107Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Alvord, TXA total loss of engine power for a reason that could not be determined.NTSB CEN24LA147Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Bluff Dale, TXAn engine compartment fire for reasons that could not be determined due to extensive thermal damage.NTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…NTSB CEN23LA351Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft F21 · Holliday, TXA loss of engine power for reasons that could not be determined, which resulted in impact with terrain.NTSB CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.NTSB CEN23LA319Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Wallis, TXThe failure of the tail boom structure due to cyclic torsion overloading as of a result of flutter in the empennage. The reason for the flutter could not be determined.NTSB CEN23LA259Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Baytown, TXThe total loss of engine power for undetermined reasons and the subsequent impact with terrain.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB CEN23LA136AccidentClass 4 · LimitedFinal reportCessna 150F · Hillsboro, TXSubstantial damage for reasons undetermined based on the available evidence.NTSB WPR23LA104Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Gladewater, TXThe loss of engine power for undetermined reasons.NTSB CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.NTSB CEN23LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Waco, TXThe nose landing gear retract arm separation for reasons that could not be determined.NTSB CEN22LA429Accident · No injuriesClass 3 · LimitedFinal reportCommander 114TC · Savoy, TXA loss of engine power for reasons that could not be determined.NTSB CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.NTSB CEN22FA232Accident · 2 fatalClass 3 · FieldFinal reportCessna 182G · Kenedy, TXA loss of airplane control on final approach for reasons that could not be determined.NTSB CEN22LA259Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Mesquite, TXA collapse of the airplane’s landing gear during the landing roll for reasons that could not be determined based on the available information.NTSB CEN22FA168Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Marlin, TXThe pilot’s failure to maintain control of the airplane during landing for reasons that could not be determined based on available information.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.NTSB CEN21LA391Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 320 · Windthorst, TXA forced landing due to a loss of engine power on the right engine for a reason that could not be determined based on the available evidence.NTSB CEN21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Justin, TXThe loss of engine power for undetermined reasons based upon the available information.NTSB CEN21FA195Accident · 1 fatalClass 3 · FieldFinal reportCessna 340A · Tatum, TXThe pilot’s loss of airplane control for undetermined reasons.NTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.NTSB CEN21LA078Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Sadler, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Crystal Beach, TXThe partial loss of engine power for reasons that could not be determined.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB CEN20LA346Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 36 · San Benito, TXA loss of engine power for a reason that could not be determined.NTSB CEN20LA328Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Marathon, TXThe in-flight loss of helicopter control for reasons that could not be determined based on the available evidence.NTSB CEN20LA314Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Houston, TXThe loss of engine power for a reason that could not be determined based on available evidence.NTSB CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.NTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.NTSB CEN20LA134Accident · 1 fatalClass 3 · LimitedFinal reportMuse P51D · Mesquite, TXThe pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB CEN20FA108Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Port Isabel, TXThe pilot’s loss of control during the initial takeoff climb for reasons that could not be determined based on available evidence.NTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.NTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.NTSB CEN20LA005Accident · No injuriesLimited investigationFinal reportZenair Zenith CH 701 · Garden Ridge, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB CEN19LA245Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Water Valley, TXThe loss of helicopter performance for undetermined reasons.NTSB CEN19LA207Accident · Minor injuriesClass 3 · LimitedFinal reportMd Helicopter 369 · Houston, TXThe loss of control upon landing for undetermined reasons.NTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…NTSB CEN19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hawkins, TXA partial loss of engine power for undetermined reasons.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…