Fatal NTSB investigations, TX
4 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1983 | 2 |
|---|---|
| 1992 | 1 |
| 2002 | 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 310)
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."highestInjuryLevel" = 'Fatal' 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" = 310) 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 FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.NTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.NTSB FTW83FA324Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Azle, TXDuring a landing in light wind conditions, the balloon touched down beside a power line. After touchdown, the balloon envelope collapsed over the power line which carried 7200 volts. The voltage traveled to the basket/gondola which overturned on the grass…NTSB FTW83FA303Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Houston, TXThe Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The…