# NTSB investigations, VA: Aircraft inspection event

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 ERA17LA280](https://openairdocs.org/ntsb/ERA17LA280.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VA · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2017 · N319TA · Substantial damage
  > The flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.
- [NTSB ERA15LA212](https://openairdocs.org/ntsb/ERA15LA212.md): Gates Lear Jet 35 · Newport News, VA · Accident · No injuries · Class 2 · Limited · Final report · May 12, 2015 · N80PG · Substantial damage
  > The flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…
- [NTSB ERA09LA370](https://openairdocs.org/ntsb/ERA09LA370.md): Michael J. Kohout Glassair III · Manassas, VA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 2009 · N2YT · Substantial damage
  > The pilot's failure to maintain aircraft control while attempting an emergency landing after takeoff. Contributing to the accident was the pilot's inadequate preflight inspection and distraction due to a separated fuel cap in flight.

## 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" = 'VA' 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" = '050' 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/050/sequence?state=VA

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