NTSB investigations, NY
4 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2012 | 2 |
|---|---|
| 2018 | 1 |
| 2021 | 1 |
Where
Open the mapLatest 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '220' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '220' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA21LA262Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Swan Lake, NYThe pilot's failure to maintain adequate clearance from the power transmission tower structure during powerline maintenance work, which resulted in the helicopter's main rotor striking the lifeline support bracket for the tower catwalk and the subsequent loss…NTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.NTSB ERA13LA057Accident · 2 fatalLimited investigationFinal reportHughes 369D · Corning, NYThe pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.NTSB ERA12CA272Accident · Minor injuriesData collectionFinal reportWielt Great Lakes 2T-1A · Warwarsing, NYThe pilot’s failure to maintain airplane control during low level maneuvering flight.