NTSB investigations, TX
8 cases where NTSB found Policy/procedure.
Cases per year
| 2012 | 1 |
|---|---|
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2026 | 1 |
Where
Latest 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\", '040210'))
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", '040210')) 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 CEN26LA304Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Hudson Oaks, TXThe pilot’s loss of directional control during the rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to abort the takeoff after the airplane had accelerated above its normal rotation speed. Also…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 CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.NTSB CEN18LA119Accident · Serious injuriesClass 2 · LimitedFinal reportCzech Sport Piper Sport · Addison, TXThe operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock.NTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.NTSB CEN16LA027Accident · No injuriesLimited investigationFinal reportBell 407 · San Antonio, TXThe failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…NTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…