# NTSB investigations: Lycoming 0-320 series, 2005, WI

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 CHI05CA241](https://openairdocs.org/ntsb/CHI05CA241.md): Piper PA-22-150 · Brodhead, WI · Accident · Minor injuries · Data collection · Final report · Aug 20, 2005 · N2373P · Substantial damage
  > The pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.
- [NTSB CHI05CA219](https://openairdocs.org/ntsb/CHI05CA219.md): American Champion 7GCBC · Watertown, WI · Accident · No injuries · Data collection · Final report · Aug 5, 2005 · N515KG · Substantial damage
  > The flightcrew's failure to maintain directional control during landing rollout.
- [NTSB CHI05FA194](https://openairdocs.org/ntsb/CHI05FA194.md): Cessna 172P · Jackson, WI · Accident · 1 fatal · Field investigation · Final report · Jul 20, 2005 · N65875 · Destroyed
  > The pilot not maintaining aircraft control for undetermined reasons while maneuvering.
- [NTSB CHI05LA086](https://openairdocs.org/ntsb/CHI05LA086.md): Piper PA-28-151 · Waunakee, WI · Accident · No injuries · Limited investigation · Final report · Apr 3, 2005 · N56715 · Destroyed
  > The pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.
- [NTSB CHI05CA075](https://openairdocs.org/ntsb/CHI05CA075.md): Cessna 172K · Portage, WI · Accident · Serious injuries · Data collection · Final report · Feb 26, 2005 · N7325G · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…

## 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") = 2005
  AND c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41508&state=WI&year=2005

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