NTSB investigations, 2009, TX

10 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2009, TX per year, 2008–2026: 109 cases
20082
200910
20107
20117
20124
20136
20146
20154
201610
20177
20187
20195
20205
20214
20224
20233
20246
20257
20265

Latest 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 year(c.\"eventDate\") = 2009
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.Dec 11, 2009 · N172BJ · Substantial damageNTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.Sep 23, 2009 · N6040Y · Substantial damageNTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.Sep 11, 2009 · N2929N · Substantial damageNTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.Aug 4, 2009 · N401LP · Substantial damageNTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.Jul 25, 2009 · N11EN · Substantial damageNTSB CEN09CA458Accident · No injuriesData collectionFinal reportCessna 172M · New Braunfels, TXThe pilot's inadequate recovery from a bounced landing.Jul 18, 2009 · N5556S · Substantial damageNTSB CEN09CA394Accident · Minor injuriesData collectionFinal reportSidler Mike Rotorway · Waxahachie, TXThe pilot’s failure to control his rate of descent during autorotation, which required an aggressive recovery maneuver and resulted in a sudden loss of tail rotor effectiveness.Jun 27, 2009 · N1934 · Substantial damageNTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · Substantial damageNTSB CEN09CA336Accident · No injuriesData collectionFinal reportBeech F33A · Midland, TXThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the inadequate oversight of the flight by the instructor pilot.Jun 3, 2009 · N33UB · Substantial damageNTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.May 10, 2009 · N169PA · Substantial damage