# NTSB investigations, MA: Aircraft maintenance event

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 ERA22LA327](https://openairdocs.org/ntsb/ERA22LA327.md): Cessna 150 · Hanson, MA · Accident · No injuries · Class 4 · Limited · Final report · Jul 17, 2022 · N5859E · Substantial damage
  > The pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.
- [NTSB ERA15LA291](https://openairdocs.org/ntsb/ERA15LA291.md): Sontonastaso Mosquito · Winchendon, MA · Accident · No injuries · Limited investigation · Final report · Jul 29, 2015 · N285XE · Substantial damage
  > A partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.
- [NTSB ERA13IA036](https://openairdocs.org/ntsb/ERA13IA036.md): Cessna 560XL · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Oct 19, 2012 · N576QS · Minor damage
  > The incorrect installation of the left main gear aft trunnion pivot pin by maintenance personnel, which resulted in separation of the aft portion of the left main gear trunnion from the aft trunnion fitting and minor damage to the airplane.
- [NTSB ERA09IA267](https://openairdocs.org/ntsb/ERA09IA267.md): Cessna 402C · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Apr 27, 2009 · N769EA · Minor damage
  > Installation of an improper bearing in the landing gear actuator.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' 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/040/sequence?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.