# NTSB investigations, ID: Maximum weight

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 WPR22FA304](https://openairdocs.org/ntsb/WPR22FA304.md): Aviat A-1A · Yellow Pine, ID · Accident · 2 fatal · Class 3 · Field · Final report · Aug 15, 2022 · N26HV · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…
- [NTSB WPR13FA281](https://openairdocs.org/ntsb/WPR13FA281.md): Piper PA-30 · Idaho Falls, ID · Accident · 2 fatal · Field investigation · Final report · Jun 22, 2013 · N830SS · Substantial damage
  > A loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.
- [NTSB WPR11FA382](https://openairdocs.org/ntsb/WPR11FA382.md): Cessna P210N · Burley, ID · Accident · 4 fatal · Field investigation · Final report · Aug 14, 2011 · N7825K · Substantial damage
  > The pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.
- [NTSB WPR10FA295](https://openairdocs.org/ntsb/WPR10FA295.md): Kaman Aerospace K-1200 · Donnelly, ID · Accident · 1 fatal · Field investigation · Final report · Jun 16, 2010 · N134WC · Substantial damage
  > The collision of two counter-rotating main rotor blades for undetermined reasons, which resulted in a loss of control.

## 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" = 'ID' 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", '01061035'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01061035/cases?state=ID

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