# Final NTSB investigations: Traffic pattern procedure

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 WPR21FA203](https://openairdocs.org/ntsb/WPR21FA203.md): Dassault Mirage F-1 · Las Vegas, NV · Accident · 1 fatal · Class 3 · Field · Final report · May 24, 2021 · N567EM · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…
- [NTSB WPR18CA172](https://openairdocs.org/ntsb/WPR18CA172.md): Dornier Alpha JET · Sacramento, CA · Accident · No injuries · Data collection · Final report · Jun 14, 2018 · N2165 · Substantial damage
  > The pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.
- [NTSB CEN15FA311](https://openairdocs.org/ntsb/CEN15FA311.md): Piper PA-46-310P · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Jul 22, 2015 · N4BP · Substantial damage
  > The pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…
- [NTSB CEN14FA467](https://openairdocs.org/ntsb/CEN14FA467.md): Piper PA 46 350P · Erie, CO · Accident · 5 fatal · Field investigation · Final report · Aug 31, 2014 · N228LL · Destroyed
  > The pilot's failure to maintain adequate airspeed and exceedance of the critical angle of attack during a go-around with a tailwind condition, which resulted in an aerodynamic stall. A contributing factor to the accident was the pilot's decision to continue…
- [NTSB WPR10FA068](https://openairdocs.org/ntsb/WPR10FA068.md): Schleicher ASW-27 · Middletown, CA · Accident · 2 fatal · Field investigation · Final report · Nov 28, 2009 · N127AL · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.
- [NTSB CEN09CA500](https://openairdocs.org/ntsb/CEN09CA500.md): Cessna P210N · Wheeling, IL · Accident · No injuries · Data collection · Final report · Jul 29, 2009 · N4648A · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during landing.
- [NTSB SEA08FA116](https://openairdocs.org/ntsb/SEA08FA116.md): Cessna 172N · McCall, ID · Accident · 3 fatal · Field investigation · Final report · May 3, 2008 · N75856 · 2 aircraft · Destroyed
  > The failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03014055'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03014055/cases?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.
