NTSB investigations, 2012, NY

8 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2012, NY per year, 2008–2026: 82 cases
20084
20096
201014
20115
20128
20133
20142
20155
20166
20173
20184
20192
20206
20211
20234
20246
20252
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\" = '300' 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 ERA13CA051Accident · No injuriesData collectionFinal reportCessna 150L · Seneca Falls, NYThe pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.Oct 21, 2012 · N1791Q · Substantial damageNTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.Aug 18, 2012 · N343SF · Substantial damageNTSB 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 ERA12CA434Accident · Minor injuriesData collectionFinal reportJones Peter M Boeing/Jones 75 · Bayport, NYThe airplane’s encounter with a wind shift to a tailwind during takeoff, which resulted in the pilot’s decision to abort the takeoff and the airplane’s subsequent runway overrun.Jul 7, 2012 · N3993P · 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 ERA12CA313Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · Ghent, NYThe pilot's loss of directional control during takeoff, which resulted in a runway excursion.Apr 30, 2012 · N782MD · Substantial damage