# NTSB investigations: Airspeed/mach indicating

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 WPR22LA233](https://openairdocs.org/ntsb/WPR22LA233.md): GMK Ventures AL18 · Moab, UT · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2022 · N17GK · Substantial damage
  > The pilot’s failure to maintain directional control during a landing attempt, which resulted in a ground loop and collision with terrain. Contributing to the accident was the absence of an airspeed indicator due to an alternator failure.
- [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 ERA09CA333](https://openairdocs.org/ntsb/ERA09CA333.md): Chatham Robert M RV6-A · Gilbert, SC · Accident · No injuries · Data collection · Final report · Jun 9, 2009 · N55EC · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during landing roll. Contributing to the accident was the airspeed indicator that became inoperative during the landing approach.
- [NTSB CEN09CA342](https://openairdocs.org/ntsb/CEN09CA342.md): Beech S35 · Decatur, TX · Accident · No injuries · Data collection · Final report · Jun 5, 2009 · N8636Q · Substantial damage
  > Both pilots' inadequate preflight inspection and failure to identify the presence of dirt and insect larvae in the pitot tube, and the owner-pilot's attempt to turn off the runway and onto the taxiway at an excessive speed during the aborted takeoff.
- [NTSB CEN09LA276](https://openairdocs.org/ntsb/CEN09LA276.md): Hawkins August E Aventura II · Griffith, IN · Accident · Serious injuries · Limited investigation · Final report · May 2, 2009 · N20GH · Substantial damage
  > The pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.
- [NTSB ERA09LA111](https://openairdocs.org/ntsb/ERA09LA111.md): Czech Aircraft Works SportCruiser · Emporia, VA · Accident · No injuries · Limited investigation · Final report · Dec 23, 2008 · N524SC · Substantial damage
  > The student pilot's failure to maintain directional control during the landing. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information.

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

This list as a web page: https://openairdocs.org/ntsb-findings/01023414/cases

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