NTSB investigations, TX
178 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 13 |
|---|---|
| 1983 | 10 |
| 1984 | 10 |
| 1985 | 8 |
| 1986 | 8 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 8 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 8 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 8 |
| 2006 | 9 |
| 2007 | 7 |
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\" = 200)
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" = 200) 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 DFW08CA033Accident · No injuriesData collectionFinal reportCessna 172R · Lufkin, TXThe pilot's improper recovery from a bounced landing.NTSB DFW08CA007Accident · No injuriesData collectionFinal reportCessna 172R · New Braunfels, TXThe pilot's improper recovery from a bounced landing.NTSB DFW07CA211Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Navasota, TXThe hard landing as result of the pilot's improper landing flare.NTSB DFW07IA204Incident · No injuriesIncident investigationFinal reportMooney M20TN · Kerrville, TXThe incorrect wire labeling, resulting in the trim controls operating in the opposite direction of the pilot's input.NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.NTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.NTSB DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07LA043Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Grand Prairie, TXThe flight instructor's inadequate remedial action which resulted in a hard landing. A contributing factor was the lack of suitable terrain for the practice autorotation.NTSB DFW07CA033Accident · No injuriesData collectionFinal reportStits Flut-R-Bug SA6B · Camerson, TXThe pilot's improper landing flare and inadequate recovery from a bounced landing which resulted in a hard landing. A factor was the delayed remedial action by the flight instructor.NTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.NTSB DFW07LA021Accident · No injuriesLimited investigationFinal reportPiper PA32-301XTC · San Marcos, TXThe pilot's improper recovery from a bounced landing.NTSB DFW06CA167Accident · Minor injuriesData collectionFinal reportAgin Jeffrey T RV-4 · Arlington, TXThe pilot's improper recovery from a bounced landing.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB DFW06LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Denton, TXThe flight instructor's failure to maintain rotor RPM, resulting in a hard landing.NTSB DFW06CA062Accident · No injuriesData collectionFinal reportEurocopter France AS-350-B2 · Port Isabel, TXThe pilot's failure to maintain rotor RPM and his improper touchdown during a simulated hovering autorotation. A contributing factor was the flight instructor's delayed remedial action.NTSB DFW06CA058Accident · No injuriesData collectionFinal reportBell 206L-4 · Fort Worth, TXThe flight instructors failure to maintain main rotor RPM and improper flare, which resulted in a hard landing.NTSB DFW05CA220Accident · No injuriesData collectionFinal reportRobinson R-44 · Odessa, TXThe pilot's failure to maintain main rotor RPM and the improper landing flare which resulted in a hard landing.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB DFW05CA223Accident · Serious injuriesData collectionFinal reportAerostar International RX-8 · Denton, TXThe passenger's failure to follow landing instructions, which resulted in serious injury. A contributing factor was the high wind.NTSB DFW05CA168Accident · No injuriesData collectionFinal reportHughes 269C · Bruceville, TXThe flight instructor's improper flare during autorotation, which resulted in a hard landing. Contributing factor was, the lack of suitable terrain.NTSB DFW05LA151Accident · Minor injuriesLimited investigationFinal reportBeaton RV-6A · Boerne, TXThe hard landing as a result of the pilot’s improper flare and his failure to recover from a bounced landing. A contributing factor was the pilot's diverted attention.NTSB DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.NTSB DFW05CA062Accident · No injuriesData collectionFinal reportCessna 310-J · Crosbyton, TXThe pilot's failure to maintain aircraft control, and his inadequate flare which resulted in a hard landing. A contributing factor was the pilot's diverted attention to the open cabin door.NTSB DFW05LA066Accident · No injuriesLimited investigationFinal reportBell 206B · Pinehurst, TXThe flight instructor's delay in taking remedial action, which resulted in a hard landing.NTSB DFW05CA042Accident · Minor injuriesData collectionFinal reportOhlemeier/Stratton RV-7A · Gordonville, TXThe pilot's misjudged flare. Contributing factors were the uphill slope of the runway and the soft condition of the landing area.NTSB DFW05CA005Accident · Minor injuriesData collectionFinal reportMurray DA5B · Odessa, TXThe pilot's improper recovery from a bounced landing. A contributing factor was the unsuitable terrain for landing.NTSB FTW04CA207Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Troy, TXThe flight instructor's improper flare, resulting in a hard landing. A contributing factor was the high density altitude.NTSB FTW04LA175Accident · No injuriesLimited investigationFinal reportAeronca/Bubeck Bubeck-Aeronca · Burleson, TXThe pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the night visual conditions, and the lack of suitable terrain for landing.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB FTW04CA161Accident · No injuriesData collectionFinal reportRuehle Glastar · Lancaster, TXThe pilot's improper flare resulting in a hard landing.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB FTW04CA039Accident · No injuriesData collectionFinal reportRobinson R22 · Spring, TXThe CFI's delay in taking remedial action which resulted in a hard landing. An excessive descent rate was a contributing factor.NTSB FTW03FA184Accident · 2 fatalField investigationFinal reportCessna 172M · McAllen, TXThe pilot's failure to recover from a bounced landing which resulted in a loss of control. Contributing factors were the gusty winds.NTSB FTW03LA172Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain rotor RPM and the improper landing flare resulting in a hard landing. A contributing factor was the prevailing high winds.NTSB FTW03LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conroe, TXthe student pilot's inadequate compensation for wind. A contributing factor was the gusting wind conditions.NTSB FTW03LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Hurst, TXThe improper flare by the pilot receiving instruction, which resulted in the hard landing. A contributing factor was the flight instructor's inadequate supervision.NTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.NTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.NTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.NTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB FTW02LA050Accident · Serious injuriesLimited investigationFinal reportHeard RV-6A · Comfort, TXthe pilot's inadequate recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW01LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · New Braunfels, TXthe pilot's inadequate flare of the airplane resulting in a hard landing. A contributing factor was the crosswind.NTSB FTW01LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Terrell, TXthe flying pilot's failure to maintain control of the airplane during the landing flare which resulted in a hard landing. A contributing factor was the wind shear weather condition.NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.NTSB FTW01LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bridgeport, TXthe non-certificated pilot's improper flare which resulted in a hard landing.NTSB FTW01LA154Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Celina, TXthe unsuitable landing area selected by the pilot-in-command which resulted in a hard landing. A contributing factor was the uneven/rough terrain.