NTSB investigations, TX
6 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 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\" = 194)
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" = 194) 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 FTW87LA204Accident · No injuriesLimited investigationFinal reportBeech F50 · Terlingua, TXThe owner, who occupied the right front seat, stated that he retracted the landing gear during the landing roll inadvertently instead of the flaps. The PIC never responded in writing concerning the actions he took during the accident.NTSB FTW85LA231Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Austin, TXThe plt stated he felt the gear extend and the corresponding decrease in airspeed when the gear was lowered during the apch. He stated he thought he observed a green gear down indication and he did observe the shadow of the extended gear on the ground as the…NTSB FTW85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Amarillo, TXDuring the lndg roll, all 3 lndg gear collapsed. The plt stated that on short final he inadvertantly retracted the gear instead of the flaps. He immediately cycled it back down butthe gear collapsed shortly after touchdown.NTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…NTSB FTW83LA385Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Catarina, TXThe acft was damaged when the landing gear was retracted during landing rollout at Catarina, TX. The plt identifed himself as larry day from chattanooga, TN. He claimed to have had engine trouble and was unable to extend the gear for landing. Post accident…NTSB FTW83LA022Accident · No injuriesLimited investigationFinal reportBeech H35 · Abilene, TXThe pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…