NTSB investigations, NY
6 cases where NTSB found Aircraft handling/service.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2022 | 1 |
Where
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.
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
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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DCA09FA025Accident · No injuriesField investigationFinal reportEmbraer EMB145 · New York, NYThe tug driver's failure to comply with ramp safety procedures.