NTSB investigations, 2011, NY

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2011, NY per year, 2008–2026: 91 cases
20083
20095
20106
20118
201210
20136
20148
20154
20168
20176
20184
20192
20202
20214
20226
20234
20243
20252

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\" = '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\" = '440' 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 ERA11CA506Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Montgomery, NYA total loss of engine power due to fuel starvation as a result of the pilots’ inadequate fuel management.Sep 27, 2011 · N6800W · Substantial damageNTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…Aug 26, 2011 · N246CV · Substantial damageNTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.Jul 27, 2011 · N7365P · Substantial damageNTSB ERA11LA417Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Sagaponack, NYThe loss of engine power for undetermined reasons.Jul 24, 2011 · N2ER · Substantial damageNTSB ERA11LA395Accident · Minor injuriesLimited investigationFinal reportAndrew McKimmon DR-1 Triplane · Geneseo, NYA total loss of engine power due to carburetor icing.Jul 9, 2011 · C-GDRI · Substantial damageNTSB ERA11LA290Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Albion, NYA bearing failure in the engine’s supercharger section, which resulted in a total loss of engine power during flight. Contributing to the accident was the soft soil of the forced landing site.Apr 29, 2011 · N896X · Substantial damageNTSB ERA11CA217Accident · No injuriesData collectionFinal reportCessna 150F · Hannawana Falls, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Mar 26, 2011 · N8830G · Substantial damageNTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.Mar 22, 2011 · N259TW · Substantial damage