NTSB investigations, NY
20 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2010 | 3 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 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\" = '330' 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" = '330' 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 ERA26LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · East Farmingdale, NYA loss of brake effectiveness during taxi, which resulted in a collision with another airplane.NTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.NTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.NTSB ERA18TA076Accident · No injuriesFinal reportVertical Aviation Technologies 260L Hummingbird · Harrisville, NYThe failure of an electric fuel pump, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB ERA16LA296Accident · No injuriesLimited investigationFinal reportMantell Allan T Kitfox 4 1200 · Canandaigua, NYThe failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…NTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.NTSB ERA16LA255Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Rhinebeck, NYFailure of the gear strut mount nut due to wear.NTSB ERA16FA176Accident · 3 fatalField investigationFinal reportBeech V35 · Syosset, NYThe pilot's loss of airplane control while operating in instrument meteorological conditions with only a partial instrument panel due to a failure of the airplane's vacuum pump. Contributing to the accident were the pilot's spatial disorientation and the…NTSB GAA15CA118Accident · No injuriesData collectionFinal reportCessna 195 · Lancaster, NYA loss of directional control and subsequent ground loop due to an underinflated right tire, which was a result of foreign object debris puncturing the tire.NTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.NTSB ERA13LA221Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Hoosick Falls, NYThe failure of the left wing attachment bracket weld due to inadequate welding by unknown maintenance personnel.NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.NTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.NTSB ERA11LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · New York, NYThe improper rigging of the right main landing gear, which resulted in ovestress fractures of a bolt and aft lug on the trunnion assembly.NTSB ERA10LA330Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Freehold, NYThe failure of the nosegear fork assembly due to fatigue. Contributing to the accident was an inadequate recent annual inspection.NTSB ERA10LA128Accident · No injuriesLimited investigationFinal reportCessna 402C · Watertown, NYThe pilot's decision to continue the approach with a known anomaly with the left airspeed indicator. Contributing to the accident was an undetermined malfunction of the left airspeed indicator and the condition of the runway, resulting in decreased braking…NTSB ERA10LA118Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · New York, NYThe failure of maintenance personnel to properly secure one tail rotor pitch change link to its respective tail rotor blade resulting in an in-flight separation of the link from the blade. Contributing to the accident was the lack of an adequate…