# NTSB investigations, MN: Ground collision

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 DCA15CA012](https://openairdocs.org/ntsb/DCA15CA012.md): Embraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MN · Accident · No injuries · Data collection · Final report · Oct 23, 2014 · N622CZ · 2 aircraft · Substantial damage
  > the B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.
- [NTSB CEN10LA338](https://openairdocs.org/ntsb/CEN10LA338.md): Pilatus P3-05 · Canby, MN · Accident · No injuries · Limited investigation · Final report · Jun 20, 2010 · N831AS · 2 aircraft · Substantial damage
  > The North American's pilot's failure to maintain adequate visual lookout, which resulted in an on-ground collision with the Pilatus.
- [NTSB CEN10LA127](https://openairdocs.org/ntsb/CEN10LA127.md): Hawker Beechcraft 65-B80 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Feb 24, 2010 · N132BA · 2 aircraft · Minor damage
  > The pilot of the other airplane not setting the parking brake adequately while holding for departure. Contributing to the accident was the pilot of the other airplane being distracted while doing his paperwork.
- [NTSB CEN09CA357](https://openairdocs.org/ntsb/CEN09CA357.md): Aviat A1 · Garrison, MN · Accident · No injuries · Data collection · Final report · Jun 14, 2009 · N190BA · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.
- [NTSB CHI08CA265](https://openairdocs.org/ntsb/CHI08CA265.md): Piper PA-28-161 · New Ulm, MN · Accident · No injuries · Data collection · Final report · Aug 24, 2008 · N523PU · Substantial damage
  > The failure of airport personnel to correct a hazardous condition on the airport. A factor was the uncovered manhole.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/200/sequence?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.