# NTSB investigations, MA: Nose gear collapsed

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 NYC00LA018](https://openairdocs.org/ntsb/NYC00LA018.md): Piper PA-34-200 · Hopedale, MA · Accident · No injuries · Limited investigation · Final report · Oct 25, 1999 · N16397 · Substantial damage
  > The nose landing gear was not locked in the extended position.
- [NTSB NYC88LA038](https://openairdocs.org/ntsb/NYC88LA038.md): Grumman AA-1B · Tewksbury, MA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N8993L · Substantial damage
  > The student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…
- [NTSB NYC86LA120](https://openairdocs.org/ntsb/NYC86LA120.md): Beech BE-19 · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · May 5, 1986 · N624SK · Substantial damage
  > The acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…
- [NTSB NYC83LA043](https://openairdocs.org/ntsb/NYC83LA043.md): Piper PA-23-250 · Fall River, MA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N62635 · Substantial damage
  > On short final & aligned with the rwy lights the plt cancelled his IFR flt plan with approach control. The acft landed on the rwy which had the middle third of its width covered with 6-8 inches of snow. The outer thirds were plowed but icy.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=192&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.