Final NTSB investigations, NY

8 cases where the sequence of events included Unknown or undetermined.

Cases per year

20122026
Final NTSB investigations, NY per year, 2012–2026: 8 cases
20121
20211
20222
20233
20241

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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 ERA24LA277Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Fire Island, NYA total loss of engine power for undetermined reasons.Jun 24, 2024 · N890MA · Substantial damageNTSB ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.Aug 26, 2023 · N114DZ · Substantial damageNTSB ERA23LA354Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Fishers Island, NYThe loss of engine power for reasons that could not be determined. Contributing was the pilot’s misjudgment of airspeed and altitude during the forced landing.Aug 18, 2023 · N405WB · Substantial damageNTSB ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.Mar 17, 2023 · N5616S · Substantial damageNTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.Jul 30, 2022 · N1358K · Substantial damageNTSB ERA22LA287Accident · Serious injuriesClass 3 · LimitedFinal reportMantell Allan T Lightning · Canandaigua, NYThe pilot’s performance of an off-airport landing shortly after takeoff for reasons that could not be determined.Jun 21, 2022 · N51TM · Minor damageNTSB ERA22LA029Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Westhampton Beach, NYA total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.Oct 23, 2021 · N1188L · Substantial damageNTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…Oct 20, 2012 · N80823 · Substantial damage