NTSB investigations, 2011, NM

7 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2011, NM per year, 2008–2026: 79 cases
20085
20095
20105
20117
20121
20135
20141
20155
20165
20179
20188
20195
20213
20223
20233
20246
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\") = 2011
    AND c.\"eventStateOrRegion\" = 'NM' 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\" = '230' 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 CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.Oct 16, 2011 · N415WW · Substantial damageNTSB CEN11CA423Accident · No injuriesData collectionFinal reportHendricks George David JR RV8 · Angel Fire, NMThe pilot's loss of directional control during landing.Jun 24, 2011 · N678VR · Substantial damageNTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.Jun 18, 2011 · N735JY · Substantial damageNTSB CEN11CA395Accident · No injuriesData collectionFinal reportNelson Dan H LONG-EZ · Moriarity, NMThe pilot's failure to maintain directional control during the landing.Jun 14, 2011 · N81DN · Substantial damageNTSB CEN11CA354Accident · No injuriesData collectionFinal reportHenry Slosing Lanceair · Albuqurque, NMThe pilot’s loss of directional control while landing in gusty conditions.May 21, 2011 · N79BC · Substantial damageNTSB CEN11CA233Accident · No injuriesData collectionFinal reportMaule M-4-220C · Albuquerque, NMThe pilot's failure to maintain control of the airplane during landing, which resulted in a runway excursion.Mar 17, 2011 · N4550R · Substantial damageNTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.Jan 2, 2011 · N8516R · Substantial damage