# Final NTSB investigations, 2010, NH

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 ERA11LA084](https://openairdocs.org/ntsb/ERA11LA084.md): Aeronca 7CCM · Rochester, NH · Accident · No injuries · Limited investigation · Final report · Dec 11, 2010 · N2053E · Substantial damage
  > The out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.
- [NTSB ERA10CA505](https://openairdocs.org/ntsb/ERA10CA505.md): Cessna 172S · Franconia, NH · Accident · No injuries · Data collection · Final report · Sep 25, 2010 · N5295Y · Substantial damage
  > The pilot’s delay in initiating a go-around, which resulted in an in-flight collision with a fence.
- [NTSB ERA10CA462](https://openairdocs.org/ntsb/ERA10CA462.md): Head Balloons AX9 118 · Hanover, NH · Accident · Serious injuries · Data collection · Final report · Sep 1, 2010 · N2267U · Minor damage
  > The balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.
- [NTSB ERA10CA144](https://openairdocs.org/ntsb/ERA10CA144.md): Piper PA-28-236 · Alton Bay, NH · Accident · No injuries · Data collection · Final report · Feb 14, 2010 · N236PR · Substantial damage
  > The pilot’s failure to maintain directional control while landing on an ice runway.

## 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") = 2010
  AND c."eventStateOrRegion" = 'NH' 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=NH&status=final&year=2010

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