NTSB investigations, TX
4 cases where the first occurrence was “Explosion”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1987 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 172)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 172) 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 FTW87LA217Accident · No injuriesLimited investigationFinal reportCessna 401A · Wichita Falls, TXThe pilot stated that the right engine quit after landing at the Wichita Falls, Texas airport. A witness stated that he attempted to start the engine several times when the right wing exploded during the last attempted engine restart. Damage was concentrated…NTSB FTW85IA221Incident · No injuriesIncident investigationFinal reportBoeing B767-232 · D/Fw Airport, TXThe B767 was on the takeoff roll. The pressure regulator and shutoff valve coupled with the high presure shutoff valve malfunctioned resulting in pressures being developed in the downstream aircraft ducting in excess of 300 psig. A coupling in the air…NTSB FTW83LA020Accident · No injuriesLimited investigationFinal reportPiper J-3 · Sweetwater, TXWhen the confederate air force failed to show up for an airshow the pilot was asked to make some low passes over the airport and explosive charges were to be set off to simulate bomb bursts. During one low pass the charges were exploded too soon. The…NTSB FTW82FRG20Accident · No injuriesFinal reportCurtis C46 · Laredo, TXWhile performing the exterior inspection the pilot noted that fuel was dripping from both wings inboard of the fuel tanks at the rear attach angle fairing plates. Just after starting the right engine an explosion occurred in the right wing. The crew shut down…