NTSB investigations, TX
7 cases where NTSB found Oversight.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2022 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040320'))
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", '040320')) 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 CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…NTSB DCA16MA204Accident · 16 fatalClass 1 · MajorFinal reportKubicek BB85 · Lockhart, TXThe pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…NTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…NTSB CEN13IA563Incident · Minor injuriesIncident investigationFinal reportPilatus PC-12/47E · Austin, TXThe pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…NTSB OPS11IA476Incident · No injuriesIncident investigationFinal reportBeech 400 · Midland, TXInadequate planning and control instructions issued to the pilots involved by the trainee controller operating the local control position and inadequate supervision by the instructor responsible for the position.NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…NTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…