NTSB investigations, 2010, TX

7 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2010, TX per year, 2008–2026: 147 cases
20085
20098
20107
20116
201212
20137
201414
201512
201610
20176
20189
201912
20204
20216
20224
20239
20246
20257
20263

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\") = 2010
    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\" = '096' 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 CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.Dec 21, 2010 · N9317G · Substantial damageNTSB CEN10CA328Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Arcola, TXThe student pilot’s failure to maintain directional control of the tailwheel-equipped airplane during the landing roll.Jun 16, 2010 · N72EB · Substantial damageNTSB CEN10CA176Accident · No injuriesData collectionFinal reportCessna 172S · Mckinney, TXThe student pilot's loss of directional control while landing with a crosswind.Mar 26, 2010 · N18563 · Substantial damageNTSB CEN10FA164Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Lewisville, TXThe pilot did not retract the landing gear before a water landing. Contributing to the accident was the pilot did not use a checklist.Mar 18, 2010 · N56489 · Substantial damageNTSB CEN10LA149Accident · Serious injuriesLimited investigationFinal reportStump Davis · Seguin, TXThe pilot's improper flare, which resulted in a bounced landing and noseover during a downwind landing.Mar 10, 2010 · N4384N · Substantial damageNTSB CEN10LA140Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Slaton, TXThe loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.Mar 5, 2010 · N2036Y · Substantial damageNTSB CEN10CA120Accident · No injuriesData collectionFinal reportAviat A1 · Austin, TXThe pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.Feb 13, 2010 · N741MA · Substantial damage