# NTSB investigations, IN: Dark

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 ERA19LA022](https://openairdocs.org/ntsb/ERA19LA022.md): Piper PA22 · Brownstown, IN · Accident · No injuries · Limited investigation · Final report · Oct 20, 2018 · N5581Z · Destroyed
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…
- [NTSB CEN18FA088](https://openairdocs.org/ntsb/CEN18FA088.md): Cessna 172F · Williamsport, IN · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2018 · N8559U · Destroyed
  > The pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.
- [NTSB CEN18FA053](https://openairdocs.org/ntsb/CEN18FA053.md): Cessna T210M · Oldenburg, IN · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2017 · N761YZ · Destroyed
  > A total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…
- [NTSB GAA16CA334](https://openairdocs.org/ntsb/GAA16CA334.md): Hubbard William H Lightning · Kokomo, IN · Accident · No injuries · Data collection · Final report · Jun 25, 2016 · N316H · Substantial damage
  > The pilot's failure to maintain directional control during the landing flare at night, which resulted in an impact with a runway light and runway sign.
- [NTSB CEN13FA085](https://openairdocs.org/ntsb/CEN13FA085.md): Piper PA 46-350P · Greensburg, IN · Accident · 4 fatal · Field investigation · Final report · Dec 2, 2012 · N92315 · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.
- [NTSB CEN12CA017](https://openairdocs.org/ntsb/CEN12CA017.md): Learjet 60 · Lafayette, IN · Accident · No injuries · Data collection · Final report · Oct 12, 2011 · N64MG · Substantial damage
  > The pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.
- [NTSB CEN11FA201](https://openairdocs.org/ntsb/CEN11FA201.md): Cessna 421C · Connersville, IN · Accident · 1 fatal · Field investigation · Final report · Feb 24, 2011 · N3875C · Substantial damage
  > The pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03036020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03036020/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
