# NTSB investigations: Mooney M20J, CT

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 NYC04FA127](https://openairdocs.org/ntsb/NYC04FA127.md): Mooney M20J · Oxford, CT · Accident · 1 fatal · Field investigation · Final report · May 24, 2004 · N5763W · Substantial damage
  > The pilot's failure to maintain altitude/clearance during an instrument approach, which resulted in a collision with trees prior to the runway. Factors were nighttime conditions and cloud cover.
- [NTSB NYC01LA052](https://openairdocs.org/ntsb/NYC01LA052.md): Mooney M20J · Danbury, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2000 · N4101H · Substantial damage
  > Water/ice in the fuel system and the pilot's inadequate preflight inspection.
- [NTSB NYC00LA054](https://openairdocs.org/ntsb/NYC00LA054.md): Mooney 20J · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1999 · N43TP · Substantial damage
  > Failure of 3 of the 4 connecting rods for an undetermined reason.
- [NTSB NYC98FA095](https://openairdocs.org/ntsb/NYC98FA095.md): Mooney M20J · Bridgeport, CT · Accident · 1 fatal · Field investigation · Final report · Apr 20, 1998 · N40HL · Destroyed
  > The pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…
- [NTSB NYC93LA108](https://openairdocs.org/ntsb/NYC93LA108.md): Mooney M20J · New Haven, CT · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 1993 · N1157B · Substantial damage
  > The loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lights

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

This list as a web page: https://openairdocs.org/ntsb?model=5870219&state=CT

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