# NTSB investigations, 2020, AZ: Hard landing

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 WPR21LA053](https://openairdocs.org/ntsb/WPR21LA053.md): Air Creation Buggy · Benson, AZ · Accident · No injuries · Class 4 · Limited · Final report · Nov 13, 2020 · N2764N · Substantial damage
  > The non-rated pilot’s unstable approach and failure to maintain aircraft control, which resulted in a hard landing and collision with terrain.
- [NTSB WPR21LA005](https://openairdocs.org/ntsb/WPR21LA005.md): Cessna 150 · Rimrock, AZ · Accident · No injuries · Class 4 · Limited · Final report · Oct 5, 2020 · N22979 · Substantial damage
  > The pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.
- [NTSB WPR20LA333](https://openairdocs.org/ntsb/WPR20LA333.md): Ultramagic N500 · Peoria, AZ · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 18, 2020 · N500UM · No damage
  > The balloon's encounter with unexpected windshear, which resulted in a hard landing and serious passenger injuries.
- [NTSB WPR20CA293](https://openairdocs.org/ntsb/WPR20CA293.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Class 4 · Data collection · Final report · Aug 18, 2020 · N103VK · Substantial damage
  > The pilot's improper pitch attitude and landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructors delayed remedial action.
- [NTSB WPR20CA084](https://openairdocs.org/ntsb/WPR20CA084.md): Cessna 150 · Prescott, AZ · Accident · No injuries · Data collection · Final report · Jan 25, 2020 · N31ER · Substantial damage
  > The pilot's improper approach and landing flare, which resulted in a stall and a subsequent hard, bounced landing.

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

This list as a web page: https://openairdocs.org/ntsb-events/092/sequence?state=AZ&year=2020

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