NTSB investigations, TX
17 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1987 | 4 |
| 1990 | 1 |
| 1995 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 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\" = 300)
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" = 300) 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 FTW01LA056Accident · No injuriesLimited investigationFinal reportNeely B D Kit Fox 4 · Cedar Park, TXthe pilot's excessive braking during the landing roll.NTSB FTW00LA177Accident · No injuriesLimited investigationFinal reportStarduster Too SA300 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the muddy terrain condition.NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.NTSB FTW00TA007Accident · No injuriesFinal reportBell 206B · Slaton, TXThe pilot's initiation of the simulated emergency procedure at a low altitude.NTSB FTW99LA157Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monaville, TXThe pilot's failure to touch down on the dry area of the landing strip. A factor was the soft terrain condition on the sides of the grass strip.NTSB FTW96LA015Accident · Minor injuriesLimited investigationFinal reportAdams Kitfox · Seminole, TXthe pilot's excessive braking.NTSB FTW96LA006Accident · No injuriesLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXthe pilot's improper braking technique.NTSB FTW90DPA04Accident · No injuriesFinal reportBoeing A75N1 · Longview, TXThe pilot's abrupt use of the wheel brakes during the landing roll.NTSB FTW87DPA04Accident · No injuriesFinal reportRoe/Pietenpol Aircamper · Arlington, TXAs the plt was landing, he applied excessively hard braking & the acft nosed over. No pre-acdnt part failure or malfunction was evident.NTSB FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.NTSB FTW87DPA01Accident · Serious injuriesFinal reportNorth American SNJ-5 · Mckinney, TXThe pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude.NTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.NTSB FTW84LA252Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Port Aransas, TXPlt stated an engine miss was experienced. Plt elected a precautionary landing on the beach during which main gear dug into sand and acft nosed over. During a helicopter recovery the acft was jettisoned from aprx 500 ft AGL. Impact damage resulting from the…NTSB FTW84LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Heidenheimer, TXThe plt landed in the field he was spraying to tell the flagman he was quitting for the day. During landing roll the right main gear dug into the soft dirt and the acft nosed over.NTSB FTW83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Midlothian, TXWhile on a local flt, the plt noticed fluctuating oil pressure & elected to make a precautionary landing in a field. He stated that after landing, he checked the oil & ran up the eng, but noted no malfunctions, so he elected to takeoff again. While attempting…NTSB FTW82DA242Accident · No injuriesFinal reportRockwell International S2R · Hart, TXThe pilot reported that immediately on landing, the right wheel skidded about 50 ft, then the aircraft went over on its back. He stated that the drive key of the goodyear brake assembly was the cause of the locked brake.NTSB FTW82DA166Accident · No injuriesFinal reportCessna 172N · Lubbock, TXDuring taxi a strong gust of wind lifted the tail of the aircraft and flipped it on its back. Thunderstorms were in the area with peak gusts to 53 knots.