# NTSB investigations, MA: Sys/Comp malf/fail (non-power)

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 ERA25LA100](https://openairdocs.org/ntsb/ERA25LA100.md): Consolidated Aeronautics Lake LA-4-200 · Orange, MA · Accident · No injuries · Class 4 · Limited · Final report · Jan 12, 2025 · N8BZ · Substantial damage
  > Failure of the left main landing gear to fully extend and lock for undetermined reasons as a functional test of the landing gear system could not duplicate the anomaly.
- [NTSB ERA24LA386](https://openairdocs.org/ntsb/ERA24LA386.md): Cessna 402 · Boston, MA · Accident · No injuries · Class 3 · Limited · Final report · Sep 17, 2024 · N18VV · Substantial damage
  > The failure of a solid hydraulic fluid line, which resulted in a loss of hydraulic fluid that prevented the landing gear extension process from completing normally. Contributing to the outcome was the pilot’s failure to fully activate the emergency landing…
- [NTSB ERA20CA100](https://openairdocs.org/ntsb/ERA20CA100.md): Cessna 402 · Barnstable, MA · Accident · No injuries · Data collection · Final report · Feb 12, 2020 · N409BK · Substantial damage
  > The pilot's failure to properly secure the crew hatch door before takeoff, which resulted in the door’s forward hinge assembly tearing from its fuselage mount point.
- [NTSB ERA12IA550](https://openairdocs.org/ntsb/ERA12IA550.md): Cessna 402C · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Aug 31, 2012 · N769EA · Minor damage
  > Company maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…
- [NTSB NYC79AA106](https://openairdocs.org/ntsb/NYC79AA106.md): Mcdonnell Douglas DC9 · Boston, MA · Accident · Minor injuries · Closed · Sep 17, 1979 · CF-TLU · Substantial damage
  > a fatigue fracture of the aft cabin pressure bulkhead which resulted in a rapid decompression of the aircraft's cabin area. This fracture initiated from a crack below the aft bulkhead access door which was discernible on the X-rays taken during the aircraft's…

## 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" = 'MA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '330')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/330/cases?state=MA

---
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.