# Final NTSB investigations, WI: Nose over/nose down

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 CEN20CA194](https://openairdocs.org/ntsb/CEN20CA194.md): Cessna 140 · Appleton, WI · Accident · No injuries · Class 4 · Data collection · Final report · May 26, 2020 · N90023 · Substantial damage
  > The pilot's loss of control while landing a tailwheel airplane.
- [NTSB GAA17CA524](https://openairdocs.org/ntsb/GAA17CA524.md): Boeing A75N1(PT17) · Oshkosh, WI · Accident · Minor injuries · Data collection · Final report · Sep 3, 2017 · N52813 · Substantial damage
  > The pilot’s overapplication of the brakes, which resulted in the biplane coming to rest inverted.
- [NTSB GAA17CA420](https://openairdocs.org/ntsb/GAA17CA420.md): Costruzioni Aeronautiche Tecna P2008 · Lone Rock, WI · Accident · No injuries · Data collection · Final report · Jul 18, 2017 · N445X · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…
- [NTSB CEN17LA204](https://openairdocs.org/ntsb/CEN17LA204.md): Aviat A-1B · Tomahawk Lake, WI · Accident · Minor injuries · Limited investigation · Final report · May 26, 2017 · N71JA · Substantial damage
  > The pilot's failure to maintain a proper approach path, which resulted in the airplane’s hard landing and nose over after the water landing.
- [NTSB CEN15CA072](https://openairdocs.org/ntsb/CEN15CA072.md): Cubcrafters CC11-160 · Middleton, WI · Accident · Minor injuries · Data collection · Final report · Dec 6, 2014 · N471LS · Substantial damage
  > The pilot's failure to maintain control of the airplane while braking during landing rollout.
- [NTSB CEN13CA042](https://openairdocs.org/ntsb/CEN13CA042.md): Luscombe 8E · West Bend, WI · Accident · Minor injuries · Data collection · Final report · Nov 3, 2012 · N2368K · Substantial damage
  > The pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.

## 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" = 'WI' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '096')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/096/cases?state=WI&status=final

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