# NTSB investigations: Lycoming 0-360-A1D, NM

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 WPR22LA059](https://openairdocs.org/ntsb/WPR22LA059.md): Robinson Helicopter R22 Beta · Hachita, NM · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 3, 2021 · N7116L · Substantial damage
  > The pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.
- [NTSB DFW08CA227](https://openairdocs.org/ntsb/DFW08CA227.md): Cessna 172RG · Almogordo, NM · Accident · No injuries · Data collection · Final report · Sep 4, 2008 · N9783B · Substantial damage
  > The pilot's failure to extend the airplane's landing gear before landing.
- [NTSB DEN06LA113](https://openairdocs.org/ntsb/DEN06LA113.md): Piper PA-23-160 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Aug 12, 2006 · N245TB · Substantial damage
  > the pilot's improper decision to continue the attempted takeoff when Vx airspeed was not obtained, and failure to abort the takeoff during ground roll which resulted in an impact on the remaining runway with the landing gear retracted. A contributing factor…
- [NTSB FTW02LA026](https://openairdocs.org/ntsb/FTW02LA026.md): Robinson R22 Beta II · Redrock, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 2001 · N8373T · Substantial damage
  > The pilot's failure to maintain clearance with terrain. Contributing factors were the mountainous terrain and high density altitude.
- [NTSB DEN72FQA22](https://openairdocs.org/ntsb/DEN72FQA22.md): Cessna 172 · Bernalillo, NM · Accident · No injuries · Closed · Oct 4, 1971 · N35485 · Substantial damage

## 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" = 'NM' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41504'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41504&state=NM

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