NTSB investigations, TX
11 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1993 | 1 |
| 1999 | 1 |
| 2002 | 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\" = 192)
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" = 192) 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 FTW02LA165Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Palestine, TXThe failure of the nose gear actuator aft attach point from the tube cluster on the engine mount assembly. A contributing factor was the owner's non-compliance with the service bulletin for inspection/replacement of the engine mount.NTSB FTW99LA184Accident · No injuriesLimited investigationFinal reportCessna T303 · Houston, TXThe collapse of the nose landing gear for an undetermined reason.NTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landingNTSB FTW90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tomball, TXCollapse of the nose gear for an undetermined reason.NTSB FTW87LA176Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Houston, TXAccording to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…NTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.NTSB FTW85LA218Accident · No injuriesLimited investigationFinal reportCessna 421 · Mckinney, TXAfter landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The…NTSB FTW85LA122Accident · No injuriesLimited investigationFinal reportCessna 310G · Austin, TXDuring takeoff, the plt heard a loud noise as the gear was retracted. He continued to the destination, but when he arrived, he was unable to get a safe nose gear indication. During the landing, the plt delayed lowering the nose & kept the weight on the main…NTSB FTW84LA410Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Kerrville, TXPlt stated that after failing to get a 'gear down' light, he cycled gear with no success in obtaining a light and received no response to call on UNICOM frequency for visual check from ground. Plt stated he elected to land anyway and that nose gear collapsed…NTSB FTW84LA053Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXThe plt was starting a flt to reposition the acft from the tradewind arpt to the Amarillo intl arpt. He reported that he had started to takeoff on rwy 17, then aborted to avoid a Cessna 182. He reported the Cessna 182 plt was crossing rwy 17, on his way to…NTSB FTW82DA292Accident · No injuriesFinal reportCessna 210K · Austin, TXDuring the landing roll, the nose gear collapsed and the aircraft was substantially damaged. The nose gear retraction-extension mechanism had been serviced just prior to this flight and on several other occasions for failing to properly extend or retract.…