# NTSB investigations, NY: Flight control sys malf/fail

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DCA22LA179](https://openairdocs.org/ntsb/DCA22LA179.md): Boeing 767-332 · New York, NY · Incident · No injuries · Class 4 · Limited · Final report · Jul 7, 2022 · N181DN · No damage
  > The failure of maintenance personnel to close the drain mast heater circuit breakers which resulted in the formation of ice in the forward drain mast, an improper flow of wastewater into the main landing gear wheel well, and the formation of ice on one or…
- [NTSB ERA20CA246](https://openairdocs.org/ntsb/ERA20CA246.md): Piper PA22 · Cortland, NY · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 13, 2020 · N2716P · Substantial damage
  > The mechanic’s incorrect rigging of the aileron control cables, which resulted in a reversal of aileron control inputs applied by the pilot during the takeoff. Also causal was the mechanic’s inadequate post-maintenance inspection and the pilot's inadequate…
- [NTSB ERA17LA292](https://openairdocs.org/ntsb/ERA17LA292.md): Hostein K/Hostein S Pietenpol · Albion, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 23, 2017 · N888MG · Substantial damage
  > Loss of directional control due to a restriction of rudder movement.
- [NTSB ERA16LA293](https://openairdocs.org/ntsb/ERA16LA293.md): Cessna 150G · Shirley, NY · Accident · No injuries · Class 3 · Limited · Final report · Aug 13, 2016 · N3666J · Substantial damage
  > Maintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = '333' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/333/sequence?state=NY

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
