# Final NTSB investigations, 2007, VT

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 DEN08CA026](https://openairdocs.org/ntsb/DEN08CA026.md): Cessna 140 · Poultney, VT · Accident · No injuries · Data collection · Final report · Nov 5, 2007 · N89120 · Substantial damage
  > The pilot's attempt to land on an unimproved airstrip resulting in a ground loop/swerve. Factors contributing to the accident were the pilot's poor judgement in attempting to land on an unsuitable runway and the unsuitable runway conditions.
- [NTSB MIA08CA011](https://openairdocs.org/ntsb/MIA08CA011.md): Smith Miniplane DSA-1 · Alburgh, VT · Accident · Serious injuries · Data collection · Final report · Nov 2, 2007 · N58MB · Substantial damage
  > The pilot's failure to maintain control of the airplane during aerobatic maneuvers which resulted in a loss of control and in-flight collision with trees.
- [NTSB NYC07CA186](https://openairdocs.org/ntsb/NYC07CA186.md): Schempp-Hirth Ventus-2C · Greensboro, VT · Accident · No injuries · Data collection · Final report · Aug 4, 2007 · N60LK · Substantial damage
  > The pilot's delayed decision to divert to a suitable landing area. Contributing to the accident was the uneven terrain of the forced landing site.
- [NTSB DEN07CA117](https://openairdocs.org/ntsb/DEN07CA117.md): Cessna 182R · Montpelier, VT · Accident · No injuries · Data collection · Final report · Jul 10, 2007 · N9890H · Substantial damage
  > The pilot's improper flare and subsequent hard landing.
- [NTSB NYC07CA151](https://openairdocs.org/ntsb/NYC07CA151.md): Let Super Blanik L-23 · Warren, VT · Accident · No injuries · Data collection · Final report · Jun 27, 2007 · N8022 · Substantial damage
  > The glider's inadvertent encounter with windshear. A factor was the outflow from a nearby thunderstorm.
- [NTSB DEN07CA103](https://openairdocs.org/ntsb/DEN07CA103.md): Piper PA-30 · Highgate, VT · Accident · No injuries · Data collection · Final report · Jun 22, 2007 · N8078Y · Substantial damage
  > The pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.
- [NTSB NYC07LA143](https://openairdocs.org/ntsb/NYC07LA143.md): Northwing Design Apache Quest · Springfield, VT · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 2007 · N425DW · Substantial damage
  > The non-certificated pilot's failure to maintain aircraft control, due to the installation of an alternate wing design.

## 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 year(c."eventDate") = 2007
  AND c."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=VT&status=final&year=2007

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