NTSB investigations, 2012, NY

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

Cases per year

20082026
NTSB investigations, 2012, NY per year, 2008–2026: 78 cases
20081
20095
20106
20113
20126
20131
20142
20156
20168
20176
20187
20192
20205
20213
20222
20235
20248
20251
20261

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\") = 2012
    AND c.\"eventStateOrRegion\" = 'NY' 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 ERA12CA492Accident · No injuriesData collectionFinal reportFairchild M-62A · Albion, NYThe pilot’s failure to maintain directional control while taking off in gusting wind conditions.Jul 25, 2012 · N53953 · Substantial damageNTSB ERA12CA481Accident · No injuriesData collectionFinal reportCessna 172M · Hammond, NYThe pilot’s failure to maintain directional control of the airplane while landing in gusting wind conditions.Jul 21, 2012 · N6778H · Substantial damageNTSB ERA12CA460Accident · Minor injuriesData collectionFinal reportCessna T206H · Glens Falls, NYThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Jul 16, 2012 · N6200B · Substantial damageNTSB ERA12CA359Accident · No injuriesData collectionFinal reportBeech V35B · Norwich, NYThe pilot’s failure to maintain airplane control while landing in a crosswind.May 21, 2012 · N6658K · Substantial damageNTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.May 19, 2012 · N3956P · Substantial damageNTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…Mar 18, 2012 · N987KB · Substantial damage