# NTSB investigations: Piper PA-28-151, 2020

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 ERA20LA335](https://openairdocs.org/ntsb/ERA20LA335.md): Piper PA28 · Union, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 27, 2020 · N33859 · Destroyed
  > A total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.
- [NTSB CEN20CA405](https://openairdocs.org/ntsb/CEN20CA405.md): Piper PA28 · Huntley, IL · Accident · No injuries · Class 4 · Data collection · Final report · Sep 19, 2020 · N43020 · Substantial damage
  > The pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.
- [NTSB CEN20CA163](https://openairdocs.org/ntsb/CEN20CA163.md): Piper PA28 · Longmont, CO · Accident · No injuries · Class 4 · Data collection · Final report · Apr 28, 2020 · N41498 · Substantial damage
  > The pilot's loss of control during a go around.
- [NTSB ERA20LA163](https://openairdocs.org/ntsb/ERA20LA163.md): Piper PA28 · East Hampton, NY · Accident · No injuries · Class 3 · Limited · Final report · Apr 25, 2020 · N33005 · Substantial damage
  > The partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.
- [NTSB ERA20CA117](https://openairdocs.org/ntsb/ERA20CA117.md): Piper PA28 · Wilmington, DE · Accident · Serious injuries · Data collection · Final report · Feb 29, 2020 · N228JS · No damage
  > The pilot being struck in the head by the propeller before flight, which resulted in a serious injury.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102805', '7104223'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102805&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.