# NTSB investigations, MI: Equipment/furnishings

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 CEN24LA318](https://openairdocs.org/ntsb/CEN24LA318.md): Ayres S2R · Stanwood, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2024 · N4004K · Substantial damage
  > The pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…
- [NTSB DCA17FA076](https://openairdocs.org/ntsb/DCA17FA076.md): Mcdonnell Douglas MD80 · Ypsilanti, MI · Accident · Minor injuries · Class 1 · Field · Final report · Mar 8, 2017 · N786TW · Substantial damage
  > the jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…
- [NTSB CEN12FA601](https://openairdocs.org/ntsb/CEN12FA601.md): Aeronca 7AC · Brighton, MI · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2012 · N82383 · Substantial damage
  > The pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…
- [NTSB CEN12LA166](https://openairdocs.org/ntsb/CEN12LA166.md): Boeing 737-832 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2012 · N374DA · No damage
  > An in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.
- [NTSB CEN11CA498](https://openairdocs.org/ntsb/CEN11CA498.md): Piper J3C-65 · Williams Lake, MI · Accident · Serious injuries · Data collection · Final report · Jul 19, 2011 · N88000 · Substantial damage
  > A loss of control during approach due to the front seat passenger's belt buckle being wedged between the rear seat,the rudder pedal and floor board.

## 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" = 'MI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010225'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010225/cases?state=MI

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
