NTSB investigations, NY

6 cases where NTSB found Aircraft handling/service.

Cases per year

20082026
NTSB investigations, NY per year, 2008–2026: 6 cases
20081
20091
20101
20171
20201
20221

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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0101'))
  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 ERA22LA242Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7EC · Putnam Valley, NYA total loss of engine power during cruise flight due to fuel starvation resulting from obstructed forward and aft vent outlets in the left fuel tank.May 25, 2022 · N7410B · Substantial damageNTSB ERA20LA207Accident · 2 fatalClass 3 · LimitedFinal reportQuad City Challenger · Wurtsboro, NYA loss of control after takeoff due to the pilot’s improper use of ballast weight. Contributing was the pilot’s decision to operate the airplane above its maximum gross weight.Jun 5, 2020 · N850RW · Substantial damageNTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.Sep 27, 2017 · N38633 · Substantial damageNTSB ERA10CA382Accident · No injuriesData collectionFinal reportGulfstream GIV · New York, NYThe flight crew’s failure to maintain adequate wing tip clearance from a light pole during taxi.Jul 27, 2010 · N905LP · Substantial damageNTSB ERA10LA021Accident · No injuriesLimited investigationFinal reportPalen AVRO-504K · Rhinebeck, NYA loss of engine power due to the in-flight separation of the number 3 cylinder valve rocker arm attachment hardware. Contributing to the accident was the improper maintenance inspection of the engine.Oct 17, 2009 · N4929 · Substantial damageNTSB DCA09FA025Accident · No injuriesField investigationFinal reportEmbraer EMB145 · New York, NYThe tug driver's failure to comply with ramp safety procedures.Dec 31, 2008 · N844MJ · Substantial damage