# Major NTSB investigations: Cessna 177B

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 SEA96MA079](https://openairdocs.org/ntsb/SEA96MA079.md): Cessna 177B · Cheyenne, WY · Accident · 3 fatal · Class 1 · Major · Final report · Apr 11, 1996 · N35207 · Destroyed
  > the pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…
- [NTSB CHI86MA052](https://openairdocs.org/ntsb/CHI86MA052.md): Cessna 177B · Brooklyn, MI · Accident · 6 fatal · Major investigation · Final report · Dec 22, 1985 · N34046 · Destroyed
  > The pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073708'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&model=2073708

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