# NTSB investigations, OK: 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 CEN23LA015](https://openairdocs.org/ntsb/CEN23LA015.md): Beech B-60 · Ardmore, OK · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2022 · N2889W · Substantial damage
  > The pilot did not ensure adequate clearance from construction vehicles during taxi.
- [NTSB GAA17CA160](https://openairdocs.org/ntsb/GAA17CA160.md): Cessna 152 · Madill, OK · Accident · No injuries · Data collection · Final report · Feb 26, 2017 · N6132Q · Substantial damage
  > The pilot’s failure to maintain clearance from a hangar while taxiing at night.
- [NTSB GAA16CA253](https://openairdocs.org/ntsb/GAA16CA253.md): Cessna 172 · Shawnee, OK · Accident · No injuries · Data collection · Final report · May 14, 2016 · N917CP · Substantial damage
  > The pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.
- [NTSB CEN16LA162](https://openairdocs.org/ntsb/CEN16LA162.md): Cessna 150J · Bixby, OK · Accident · No injuries · Limited investigation · Final report · Apr 21, 2016 · N51242 · Substantial damage
  > A total loss of engine power for reasons that could not be determined, as the fuel state of the airplane at the time of the accident could not be verified, and postaccident examination of the engine did not provide adequate information.
- [NTSB CEN09TA399](https://openairdocs.org/ntsb/CEN09TA399.md): Cessna 182 · Cookson, OK · Accident · No injuries · Final report · Jun 20, 2009 · N60HP · Substantial damage
  > The pilot's failure to maintain clearance with the building while taxiing on a road.
- [NTSB DFW08CA070](https://openairdocs.org/ntsb/DFW08CA070.md): Cessna 172S · Jenks, OK · Accident · No injuries · Data collection · Final report · Feb 3, 2008 · N766PD · Substantial damage
  > The owner of the parking surface's failure to ensure that the parking surface was clear of hazards to taxiing airplanes and the pilot's failure to ensure a safe taxi route in unfamiliar surroundings.

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

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