# NTSB investigations, IN: 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 CEN18FA132](https://openairdocs.org/ntsb/CEN18FA132.md): Cessna 150 · Marion, IN · Accident · 2 fatal · Field investigation · Final report · Apr 2, 2018 · N5614E · 2 aircraft · Destroyed
  > The failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…
- [NTSB CEN13CA452](https://openairdocs.org/ntsb/CEN13CA452.md): Cessna 172N · Tell City, IN · Accident · No injuries · Data collection · Final report · Jul 25, 2013 · N3012E · Substantial damage
  > The pilot's failure to maintain adequate clearance from an obstruction while taxiing.
- [NTSB CEN12CA396](https://openairdocs.org/ntsb/CEN12CA396.md): Piper PA-28-161 · Valparaiso, IN · Accident · No injuries · Data collection · Final report · Jun 26, 2012 · N6183H · Substantial damage
  > The pilot’s failure to stop the airplane while taxiing to park, which resulted in a collision with a parked vehicle.
- [NTSB CEN11CA343](https://openairdocs.org/ntsb/CEN11CA343.md): Mooney M20J · Greenfield, IN · Accident · No injuries · Data collection · Final report · May 13, 2011 · N10143 · Substantial damage
  > The pilot's failure to maintain adequate clearance from a communications cart while taxiing.
- [NTSB CEN10CA468](https://openairdocs.org/ntsb/CEN10CA468.md): Piper J3C-85 · Auburn, IN · Accident · No injuries · Data collection · Final report · Aug 3, 2010 · N98022 · 2 aircraft · Substantial damage
  > The pilot of the other airplane failing to monitor the position this airplane.
- [NTSB CEN09CA017](https://openairdocs.org/ntsb/CEN09CA017.md): Cessna 172P · Delphi, IN · Accident · No injuries · Data collection · Final report · Oct 13, 2008 · N63366 · Substantial damage
  > The student pilot's failure to maintain separation from a hangar building while taxiing. Contributing to the accident was the hangar building.

## 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" = 'IN' 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=IN

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