# NTSB investigations, MN: Policy/procedure

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 CEN13IA059](https://openairdocs.org/ntsb/CEN13IA059.md): Fairchild SA227-AC · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Nov 10, 2012 · N619BA · Minor damage
  > Loose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…
- [NTSB OPS10IA574](https://openairdocs.org/ntsb/OPS10IA574.md): Airbus Industrie A320-214 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Sep 16, 2010 · N122US · 2 aircraft · No damage
  > The Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…
- [NTSB DCA08MA085](https://openairdocs.org/ntsb/DCA08MA085.md): Raytheon Corporate Jets BAE 125-800A · Owatonna, MN · Accident · 8 fatal · Class 1 · Major · Final report · Jul 31, 2008 · N818MV · Destroyed
  > The captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…

## 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" = 'MN' 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", '040210'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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